Bug #47854 | Replication not working when using database.table in statements | ||
---|---|---|---|
Submitted: | 6 Oct 2009 9:52 | Modified: | 6 Oct 2009 20:42 |
Reporter: | Kasper Sor | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
Version: | 5 | OS: | Linux (Debian 5) |
Assigned to: | CPU Architecture: | Any |
[6 Oct 2009 9:52]
Kasper Sor
[6 Oct 2009 10:30]
Valeriy Kravchuk
This behavior of binlog-do-db is clearly explained in the manual, http://dev.mysql.com/doc/refman/5.1/en/replication-options-binary-log.html#option_mysqld_b.... If you use 5.1.x, row-based logging may help. Ohterwise just log everything on master and use replicate-wild-do-table (http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replic...) on slave(s). This is not a bug, but intended and documented behavior.
[6 Oct 2009 20:42]
Kasper Sor
Im sorry to have wasted your time then. :(