has the option for --master-data but couldn't find anything like this in pump
You need to manually Read lock and get master information before taking musqlpump
1. FLUSH TABKE WITH READ LOCK ; 2. SHOW MASTER STATUS; 3. mysqlpump backup 4. UNLOCK TABLES; 5. Move backup to replica 6. Restore it 7. Change master to on replica using step 2 information
Обсуждают сегодня