MYSQL

• Réaliser des dumps

mysqldump --extended-insert=FALSE --add-drop-table --user=$USER --password=$PASS $DATABASE > dump.sql
mysqldump --extended-insert=FALSE --add-drop-table --no-data --user=$USER --password=$PASS $DATABASE > dump_schema.sql

• Basculer un slave en master et le master en slave

1 - mettre en lecture seule le master

mysql -u root -p 
mysql> use database;
mysql> flush tables with read lock;

2 - stopper le slave

mysql -u root -p
mysql> stop SLAVE;

3 - noter la position du serveur en slave

mysql -u root -p
mysql> show master status\G

4 - sur le master (passage en slave)

mysql> CHANGE MASTER TO MASTER_HOST=, MASTER_USER='replic', MASTER_PASSWORD='PASSWORD', MASTER_PORT=3306 ,MASTER_LOG_FILE='FILE', MASTER_LOG_POS=POS;

• Documentation sur MySQL