Page History

...

The database that is out of sync is on Server-2Server2, therefore, you are going to take a snapshot of the database from Server-1Server1, then restore the snapshot onto Server-2 and restart the replicationServer2 and restart the replication.

Obtain Channel Names

Depending on how your replication was set up, channel names may have been included per node.  Usually your primary server will have the channel name 'server-1' and the secondary server will have the name 'server-2'  However if you are not sure this can be easily identified by login onto MySQL on each server and using the show slave status command..

mysql -u root -p

(Enter your password at prompt)

mysql> show slave status\G

You will see something like this..

Image Added

You can see the channel name at the bottom, which corresponds with the Master Host IP at the top.  Please take a note of this before continuing.

Stop Replication between both servers

...

On both Server1 and Server2 machines, open a command prompt and change directory to C:\Program Files\Deepnet DualShield\mysql\bin

Log into MySQL console on both machines, and stop the slave service:

mysql -u root -p

(Enter your password at prompt)

mysql> stop slave;

Take a snapshot of the database on Server1

Open an elevated command prompt and change directory to C:\Program Files\Deepnet DualShield\mysql\bin

Copy and paste in the following command:

mysqldump -uroot -p --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=2 dualshield > c:\path-to\backup.sql

(The path and backup file name can be modified as required)

Hit return and enter the password when prompted.  Hit return again.  The process may take a few minutes, but when you see the cursor again, it means the snapshot has been taken.

Copy the snapshot over to server2

Type the following to reset slave on server1 only

mysql> reset slave;

Restore the snapshot to Server2

Stop the DualShield Server Service (server-2 only)

Image Added

Type the following query in the MySQL console to delete the current dualshield database: 

mysql> drop database dualshield;

Create a new database:

mysql> create database dualshield CHARACTER SET utf8 COLLATE utf8_general_ci;

Import the database you copied over from Server1.

Open an elevated command prompt and change directory to C:\Program Files\Deepnet DualShield\mysql\bin

Type the command:

mysql -u root -p DualShield < c:\path-to\backup.sql

You now ned to obtain the Master binary log file and log position from server1.  Luckily this will have also been recorded in the backup file.

Open a command and prompt and CD to the directory you saved 'backup.sql'

Run the following command:

more backup.sql

The result will show the first few lines of the file, including the 'CHANGE MASTER TO...' query, which will be commented out. Use it as the command to change the slave status.

For example,

Image Added

You can literally copy and paste this CHANGE MASTER TO query statement to but you should also add the 'FOR CHANNEL statement at the end.  Hopefully you will have already obtained the channel names using the show slave status command, as instructed earlier in this wiki guide.

For example the CHANGE MASTER TO statement here would be.

mysql> CHANGE MASTER TO MASTER_LOG_FILE='DAS111.000017', MASTER_LOG_POS=154 FOR CHANNEL 'Server-1';

The final thing to do on server2 is to reset master:

...

mysql> usereset dualshield;

mysql> stop slave;master;

Restart Replication between both servers

Start slave on both servers:

mysql> start slave;

Check slave status on both servers:

mysql> show slave status\G

 Make sure There are no errors and it is very important to check that Slave_IO and Slave_SQL are both running.

Image Added

If this is the case then you may start the Dualshield Server Service on server2

Image Added

Once Dualshield has fully restarted on the second server, run the show slave status command on both servers, one more time.