[MDEV-4434] DDL statements do not replicate when replicate-rewrite-db is set Created: 2013-04-24 Updated: 2013-05-01 Resolved: 2013-05-01 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.2 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Mike Ashton (Inactive) | Assignee: | Elena Stepanova |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Create a replication from server A db1 to Server B db2 using replicate-rewrite-db=db1->db2 Create a table in db1 on server A called tbl1, the table is not created on server B in db2. |
| Comments |
| Comment by Elena Stepanova [ 2013-04-25 ] |
|
Works all right for me. Here is the test case, you can use it literally in MTR or interpret as "steps to reproduce": --source include/master-slave.inc --connection slave --connection master --sync_slave_with_master SHOW DATABASES;
Output: [connection master]
Are you sure you are setting the default database to db1 before trying to replicate, i.e. you do "USE db1"? That's the mandatory condition for this option, if you instead do something like it's not supposed to work, by the definition of the option. |
| Comment by Elena Stepanova [ 2013-05-01 ] |
|
If the notes above do not explain the problem you were experiencing, please comment and we will re-open the report if necessary. |