Examples of MySQL Database Synchronization

Source: Internet
Author: User

Today, we will share with you an example of MySQL Database Synchronization. The main purpose of this experiment is to configure master-slave synchronization for MySQL (the best combination with PHP) databases, the following is a description of the specific operation content. I hope it will be helpful for your future study.

In this test, MySQL (the best combination with PHP) versions are 4.1.7-standard-log, the master operating system is redhat 9.0, And the slave operating system is redhat 7.3.

1. modify my. cnf on the master end and add the configuration parameters:

[MySQL (the best combination with PHP) d]

 
 
  1. log-bin  
  2. server-id=1 

2. modify my. cnf on the slave side and add the configuration parameters:

 
 
  1. log-bin  
  2. mastermaster-host=master  
  3. master-user=rep 
  4. master-password=rep 
  5. master-port=3306 
  6. server-id=2 

The above parameters are the most basic configuration, so I will not explain them much. I will undo it to initialize the data.

1. Clear all binlogs on the master. If the existing binlogs are useful, back up them first. Then, pack all data files on the master, including ibdata files.

2. A similar method is used to clear all binlogs on the slave and copy the data file compressed package on the master to its own data file directory.

Start master and add a rep user, "grant all privileges on *. * to rep @ % identified by 'rep '; flush privileges ;".

Start slave and check whether the synchronization is successful.

In the example of MySQL database synchronization, the failure is generally caused by the failure of locating the binlog after the slave connects to the master node. In this case, both binlogs must be set to the same, then stop slave; start slave.

The above content is the description of the MySQL Database Synchronization instance, hoping to help you in this regard.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.