tag:blogger.com,1999:blog-31421954.post6570599176001425515..comments2023-10-30T08:23:12.960-07:00Comments on mySQL DBA, Architecture, Dev, Scale, HA, Code : BCP mySQL without loosing speedDathan Pattishallhttp://www.blogger.com/profile/00356367514107959723noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-31421954.post-31356964875075079682008-02-26T18:11:00.000-08:002008-02-26T18:11:00.000-08:00@smikybang.comEach data center has 2 masters. So s...@smikybang.com<BR/><BR/>Each data center has 2 masters. So setting up a slave to a master in another datacenter does not achieve BCP since a slave can have only one master.<BR/><BR/>An external process manages this layer.Dathan Pattishallhttps://www.blogger.com/profile/00356367514107959723noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-66381268652423491412008-02-26T14:20:00.000-08:002008-02-26T14:20:00.000-08:00Interesting, we use ssh tunnels to do inter-datace...Interesting, we use ssh tunnels to do inter-datacentre replication with the autossh command managing reconnects. This also allows us to use compression.<BR/><BR/>I may have the wrong end of the stick but can't you use log-slave-updates on either of your master-master pair and run your remote "master in waiting" from that? Not a ring but two masters and a complete slave.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-51268008891974012902008-02-26T09:02:00.000-08:002008-02-26T09:02:00.000-08:00I'd be very interested in more information about t...I'd be very interested in more information about this setup!Unknownhttps://www.blogger.com/profile/06368456392029735365noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-90234774144683253512008-02-25T20:17:00.000-08:002008-02-25T20:17:00.000-08:00Good stuff! At the 2007 MySQL conference, some pe...Good stuff! At the 2007 MySQL conference, some people had touched on this, but nobody went into the details. It would be cool if someone actually went into the details at this years conference during a session or BOF. Thanks for the post!Anonymousnoreply@blogger.com