Replica restore [BeCloud Internal Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Replica restore ======

=== First thing ===
Verify on the sysmgmt wich server is affected (if master or slave) on the "Hosts & Components" section; it will be marked as "down" or "out of sync", in the former case verify first that the machine is up and running.

For both MySQL and MongoDB there is always a "Master" and "Slave", make sure to check who is who before proceeding.

\\

==== MySQL ====
This works for both Config(Config1/Config2) and Reporting(DB1/DB2) DBs.


\\

  - Login to both machines (SSH)
  - On Slave login into mysql interface: <code>mysql -u super -p*password*</code>
  - On Slave show slave status with the following myslq command: <code>SHOW SLAVE STATUS;</code>
  - On Master stop all BP services with: <code>/usr/lib/servicepattern/setup/sp_servers.sh stop</code>
  - On Slave stop slave with the following mysql command and exit: <code>STOP SLAVE;
EXIT;</code>
  - Choose a proper position for this file: it's very big, mind to check disk space before a mysqldump:
'df -h' -> this is to check disk utilization and where a disk is mounted,
    
for example, if we see the following situation:
    
<code>    
Filesystem      Size  Used Avail Use% Mounted on
    
Disk1           100G  73G  27G   73%  /
Disk2           300G  30G  270G  10%  /mnt
    
    
Is much better to put the backup in the second disk, so anywhere in the /mnt folder.
(**This is only an example, you will not see those disks in the actual machines**)
</code>
  - Make a mysql backup of Master (the "healthy" one) **on Slave** (this way is much faster, in alternative you would have to make the backup on Master, download it and re-upload it on Slave, this operation could take **several hours** instead of a couple of minutes) with the following command: <code>mysqldump -u super -p*password* --host=*DB1 hostname* --all-databases > /*path*/*to*/*file*.sql</code>
  - Reconnect to mysql console on Slave (command from step 2)
  - See wich dbs exist and drop everything except "information_schema", "performance_schema" and "mysql" with the following commands: <code>SHOW databases;
DROP DATABASE *database name*;</code>
  - Exit from mysql and load the backup you have done previously of Master in Slave with the following command: <code>mysql -u super -p*password* < /*path*/*to*/*file*.sql</code>
  - Login to mysql on both Master and Slave (command from step 2)