List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 4 2004 3:54pm
Subject:Re: [mysql] replication of database structure changes
View as plain text  
In the last episode (May 04), Jim said:
> Do changes in database structure replicate to the slaves from the
> master?  Is there a document somewhere in the manual (I have not
> found one) that explains what gets replicated and what does not? 
> Specifically, does an ALTER TABLE get replicated?  There is some
> mention that replication is for data and not for structure, but a
> formal explanation of what exactly that means is hard to find.

All commands that modify data, including CREATE|DROP TABLE|DATABASE,
replicated.

-- 
	Dan Nelson
	dnelson@stripped
Thread
[mysql] replication of database structure changesJim4 May
  • Re: [mysql] replication of database structure changesDan Nelson4 May