mysql replication resync

2010-08-28  来源:本站原创  分类:Database  人气:54 

As an old system does not use LVM partitions, resulting in mylvmbackup not be used. In order to re-sync the whole amount of the database and found that rsync can use, and lock the database will not be long.

1, first update the database to a file

flush tables with read lock;

unlock tables;

2 Executive rsync for database synchronization

/ Usr / bin / rsync-a - progress - delete 10.0.0.60: / var/lib/mysql/3302 / / var/lib/mysql/3302 /

3 repeat 1 and 2, observe the time-consuming can tolerate.

4 lock table and view the status of MASTER

flush tables with read lock;

show master status;

Maintain the mysql client does not exit

5 In another ssh window to Step 2 to complete the latest data synchronization

6. Release the lock unlock tables;

7 In the new slave changes in the above master.info (3.22.x) or to perform change master command

相关文章
  • mysql replication resync 2010-08-28

    As an old system does not use LVM partitions, resulting in mylvmbackup not be used. In order to re-sync the whole amount of the database and found that rsync can use, and lock the database will not be long. 1, first update the database to a file flus

  • MySQL replication configuration steps document (master from a backup mechanism) 2010-03-30

    This document on a main server, one from the server (the one from a master) replication configuration steps are explained, a major multi-configuration method is actually from the same, only need to add more from the server, increasing from server set

  • mysql replication checker mk-table-checksum replicate option 2010-05-24

    Original: http://www.maatkit.org/doc/mk-table-checksum.html # replicate Chinese description: http://www.bigheaddba.net/article/y2009/387_mysql% E7% AE% A1% E7% 90% 86% E5% BF% 85% E5% A4% 87% E5% B7% A5% E5 % 85% B7maatkit% E8% AF% A6% E8% A7% A3% E4

  • Mysql replication functions 2010-07-10

    Mysql replication function mainly by two threads to complete, IO thread and the SQL thread. IO threads for read from the Master command to be executed, SQL thread to perform backup operations. Slave-side management in the following several major comm

  • Implementation principle of MySQL Replication 2010-10-26

    To make good use of a system, understand its principle is very important to achieve something, only to understand the principles of its realization, we can exceed and rational use, to be able to build the most suitable system of our application envir

  • mysql replication principle, mysql master-slave configuration principle 2010-10-28

    1, the replication process Mysql replication (Replication) is an asynchronous replication, from a Mysql instace (called Master) to another Mysql instance (call it Slave). Implement the copy operation completed mainly by three processes, two processes

  • [Transfer] mysql replication principle, mysql master-slave configuration principle 2010-11-13

    mysql replication principle, mysql master-slave configuration principle 1, the replication process Mysql replication (Replication) is an asynchronous replication, from a Mysql instace (called Master) to another Mysql instance (call it Slave). Impleme

  • MySQL Replication (copying) the basic principles of 2010-11-15

    1, the replication process Mysql replication ( Replication ) is an asynchronous replication, from a Mysql instace (called Master) to another Mysql instance (call it Slave). Implement the copy operation completed mainly by three processes, two process

  • mysql replication principle 2010-11-25

    1, the replication process Mysql replication (replication) is an asynchronous replication, from a Mysql instace (called Master) to another Mysql instance (call it Slave). Implement the copy operation completed mainly by three processes, two processes

  • Mysql Replication and structure of the table 2010-11-26

    Mysql Replication and structure of the table 1. Create a new table create table new table select * from old table only table structure create table new table select * from old table where 1 <> 1 2. Be built into the existing table table statements s

  • The isolated read and write Mysql Replication 2010-12-28

    Replication Mysql's principle: Mysql for Replication is an asynchronous replication process, from a Mysql instace (we call Master) to another Mysql instance (we call it Slave). Master and Slave in the realization of the entire replication process bet

  • Configure MySQL Replication 2011-01-05

    Excerpt from: http://www.ningoo.net/html/2007/mysql_replication_configuration.html MySQL supports one-way, asynchronous replication, replication of a server acting as the master server (Master), and one or more other servers act as the server (Slave)

  • How to create SSH encrypted MySQL replication 2011-05-04

    Database administrator, MySQL lot of attractions, such as its free and open source, and has extensive documentation, and built-in support for data replication. But the security administrator will be quick to point out a flaw in it: encryption. Govern

  • MySQL Replication, master-slave and dual master configuration 2011-04-08

    MySQL, MySQL Replication is a database of more than one simultaneous call the shots from the program, characterized by asynchronous, widely used in a variety of MySQL has higher performance, higher reliability requirements of the occasion. Another te

  • MySQL Replication of the principle of cluster structures to achieve 2010-10-26

    The realization of the principle MySQL Replication To make good use of a system, understand its principle is very important to achieve something, only to understand its implementation principle, we can exceed and reasonable use to be able to build th

  • mysql replication basic principles, mysql master-slave configuration principle 2010-10-28

    1, the replication process Mysql replication (Replication) is an asynchronous replication, from a Mysql instace (called Master) to another Mysql instance (call it Slave). Entire copy operation completed mainly by three processes, two processes in the

  • [Transfer] mysql replication basic principles, mysql master-slave configuration principle 2010-11-13

    mysql replication basic principles, mysql master-slave configuration principle 1, the replication process Mysql replication (Replication) is an asynchronous replication, from a Mysql instace (called Master) to another Mysql instance (call it Slave).

  • [Turn] to achieve the MySQL Replication 2010-11-13

    Implementation of MySQL Replication After release in MySQL 3.23.15, MySQL provides database replication capabilities, real-time synchronization can be achieved two databases, the MySQL database to enhance the stability, but also in enterprise applica

  • MySQL Replication (copying) the basic principles 2010-11-15

    1, the replication process Mysql replication ( Replication ) is an asynchronous replication, from a Mysql instace (called Master) to another Mysql instance (call it Slave). Entire copy operation completed mainly by three processes, two processes in t

  • Separation of read and write Mysql Replication 2010-12-28

    Mysql Replication principles of: Mysql's Replication is an asynchronous replication process from a Mysql instace (we call Master) to another Mysql instance (we call it Slave). Between Master and Slave in the entire replication process consists of thr