Differences

This shows you the differences between two versions of the page.

--- doc:appunti:linux:sa:mysql_replica_master_master [2011/09/08 12:52] – [Configurare la replica master-master (su un solo database)] niccolo
+++ doc:appunti:linux:sa:mysql_replica_master_master [2011/09/08 12:54] – [Sincronizzare il db] niccolo
@@ Line 54: / Line 54: @@
 <code>
 -- Su server1
 USE exampledb;
 FLUSH TABLES WITH READ LOCK;
@@ Line 71: / Line 70: @@
 -- Prendere nota dello status.
 UNLOCK TABLES;
-CHANGE MASTER TO MASTER_HOST='192.168.3.71', MASTER_USER='slave2_user', MASTER_PASSWORD='slave2_password', MASTER_LOG_FILE='mysql-bin.000001
+CHANGE MASTER TO MASTER_HOST='192.168.3.71', MASTER_USER='slave2_user',
-', MASTER_LOG_POS=106;
+    MASTER_PASSWORD='slave2_password', MASTER_LOG_FILE='mysql-bin.000001',
+    MASTER_LOG_POS=106;
 START SLAVE;
 SHOW SLAVE STATUS;
@@ Line 78: / Line 78: @@
 -- Su server1
 STOP SLAVE;
-CHANGE MASTER TO MASTER_HOST='192.168.3.73', MASTER_USER='slave1_user', MASTER_PASSWORD='slave1_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=2359;
+CHANGE MASTER TO MASTER_HOST='192.168.3.73', MASTER_USER='slave1_user',
+    MASTER_PASSWORD='slave1_password', MASTER_LOG_FILE='mysql-bin.000001',
+    MASTER_LOG_POS=2359;
 START SLAVE;
 SHOW SLAVE STATUS;