Marc Delisle
-
2015-02-15
- Priority: 5 --> Normal
Phpmyadmin queries are not aware of the cross-database replication. When you use
report-host=master.codeone
replicate-rewrite-db = db->db_slave
replicate-do-db = db_slave
replicate-do-table = db_slave.table1
in mysql config and try to add/delete/update record using pma, you are toasted - your replication goes nuts.
It's because pma creates queries in format a such:
" insert (...) into db.table1 " and since there is no database db on slave machine your query is not replicated - you get error on slave machine.
The same applies to cross-database replication on the same machine.