Some old data were missingon db slave server<\/p>\n
copy data from master db01.lalife.net to slave db02.lalife.net and reset slave<\/p>\n
On Master:<\/p>\n
Lock table<\/p>\n
mysql> FLUSH TABLES WITH READ LOCK;<\/p>\n
mysql> show master status;<\/p>\n
+——————+———-+————–+——————+<\/p>\n
| File \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 | Position | Binlog_Do_DB | Binlog_Ignore_DB |<\/p>\n
+——————+———-+————–+——————+<\/p>\n
| db01-bin.000901 | 84861692 | \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|<\/p>\n
+——————+———-+————–+——————+<\/p>\n
cd \/var\/lib<\/p>\n
tar cvfz\u00a0 TARFILE_NAME.tgz mysql\/<\/p>\n
mysql > unlock tables;<\/p>\n
On Slave:<\/p>\n
cd \/var\/tmp\/<\/p>\n
tar -zxvf db01_bk.tar.gz<\/p>\n
service mysql stop<\/p>\n
##backup old db<\/p>\n
mv \/www\/mysql \/www\/mysql0603<\/p>\n
mv \/var\/tmp\/www\/mysql\/ \/www\/<\/p>\n
service mysql start<\/p>\n
mysql>STOP SLAVE;<\/p>\n
mysql>RESET SLAVE;<\/p>\n
mysql> CHANGE MASTER TO MASTER_HOST=’db001.lalife.net’, MASTER_USER=’replication’, MASTER_PASSWORD=’xxxxx’, MASTER_LOG_FILE=’db01-bin.000900′, MASTER_LOG_POS=13482116;<\/p>\n
mysql>START SLAVE;<\/p>\n
How to get master bin file and position:<\/p>\n
On master server<\/p>\n
mysql> show master status;
\n+——————+———–+————–+——————+
\n| File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Position\u00a0 | Binlog_Do_DB | Binlog_Ignore_DB |
\n+——————+———–+————–+——————+
\n| db01-bin.000900 | 437292441 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————+———–+————–+——————+<\/p>\n","protected":false},"excerpt":{"rendered":"
Some old data were missingon db slave server copy data from master db01.lalife.net to slave db02.lalife.net and reset slave On Master: Lock table mysql> FLUSH TABLES WITH READ LOCK; mysql> show master status; +——————+———-+————–+——————+ | File \u00a0 \u00a0 \u00a0 \u00a0 … Continue reading