RE: alter table not replicated?

[Rick James]

In older versions of Mysql, certain commands did not get replicated (IIRC).

"mees up"?  OPTIMIZE would keep the slaves busy, making replication get
behind; but I would not expect any data errors.  Same goes for any
long-running UPDATE, etc.

> -----Original Message-----
> From: Luis Torres [mailto:al1629608@stripped] 
> Sent: Wednesday, October 11, 2006 3:33 PM
> To: replication@stripped
> Subject: Re: alter table not replicated?
> 
> 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
> mtc-dresde
> n.com
> 
> 
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:    
> http://lists.mysql.com/replication?unsub=1
> 
>