AFAIK All data modification operations get replicated. That includes alter table, adding
users/setting permissions (if you're replicating the mysql database) and even optimize
statements.
Learned that last one the hard way as I ran an optimize table on the master and then went
to the slave to do the same... replication got really messed up!
Good luck
Luis
----- Original Message ----
From: "Volk, Peter Benjamin" <PeterBenjamin.Volk@stripped>
To: replication@stripped
Sent: Wednesday, October 11, 2006 12:19:44 AM
Subject: RE: alter table not replicated?
Hi Ray,
Actually Alter should also be replicated. Have you checked your slave
status before doing it manually?
Peter
-----Original Message-----
From: Ray Charles [mailto:raycharles_man@stripped]
Sent: Dienstag, 10. Oktober 2006 17:56
To: replication@stripped
Subject: alter table not replicated?
Hi,
I ran an alter table command on my master thinking it would be
replicated on the slave but it didn't, i had to run it manually on the
slave. Are there certain cases, such as a schema change, that don't
replicate?
TIA-
Ray
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe:
http://lists.mysql.com/replication?unsub=1
n.com
--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe: http://lists.mysql.com/replication?unsub=1
