MySQL Bugs: #5697: DDL is not replicated

Bug #5697	DDL is not replicated
Submitted:	22 Sep 2004 13:26	Modified:	25 Oct 2004 21:49
Reporter:	Hervé Boulnois	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.12	OS:	Windows (Windows XP)
Assigned to:	Bugs System	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
On a pool of MySQL servers (4.0.20 standard), with a master and 4 slaves, if you create a table with MySQL Administrator, the table will not be created on slaves.
If you alter a table (create an index, add a column), changes won't be replicated. If you run the query in Query Browser, fortunately, changes are replicated.

How to repeat:
Everytime you will try ...

Suggested fix:
DON'T create or alter table in MySQL Administrator on a master in a replicated database, use Query Browser instead.

Hi,

Thank you for the report, but I wasn't able to repeat it with MySQL Administrator 1.0.13.