• notice
  • Congratulations on the launch of the Sought Tech site

MySQL master is synchronized, read and write separation configuration steps

The two servers used now have MySQL installed, all of which are packaged in rpm, and can be used normally.
In order to avoid unnecessary troubles, the MySQL version of the master and slave servers should be kept as consistent as possible;
Environment: 192.168.0.1 (Master)
192.168.0.2 (Slave)
MySQL Version:Ver 14.14 Distrib 5.1.48, for pc-linux-gnu (i686) using readline 5.1
1.Log in to the Master server, modify my.cnf, and add the following content;
server-id=1//Database ID number, which means 1 Master, where master_id must be 1 to 232

Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

buy generic lipitor 10mg & lt;a href="https://lipiws.top/"& gt;atorvastatin 10mg drug& lt;/a& gt; order lipitor 20mg generic

Vcttbn

2024-03-08

Leave a Reply

+