tag:blogger.com,1999:blog-18337119.post113997663576018094..comments2024-01-22T07:09:30.574-05:00Comments on MySQL Consulting and NoSQL Consulting: MySQL DBA: Best way to ensure 100% data mirroring?Unknownnoreply@blogger.comBlogger7125tag:blogger.com,1999:blog-18337119.post-1140051821433083092006-02-15T20:03:00.000-05:002006-02-15T20:03:00.000-05:00Thank you James for your insightful comment.FrankThank you James for your insightful comment.<BR/><BR/>FrankFrankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1140046694145873072006-02-15T18:38:00.000-05:002006-02-15T18:38:00.000-05:00Slaves falling behind often happens when they are ...Slaves falling behind often happens when they are too highly loaded. Also happens because slaves update in a single thread and master in multiple, so slaves can't keep their disk systems as busy as a master. Single-threaded means that a single query which takes a while to run causes all others to lag until it completes. This also blocks InnoDB's ability to commit multiple concurrent transactions with a single fsync, so slave transaction commit rate may be lower for this reason.<BR/><BR/>James DayAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1140028343053072992006-02-15T13:32:00.000-05:002006-02-15T13:32:00.000-05:00Hello Brian and Jim,Thank you for confirming that ...Hello Brian and Jim,<BR/><BR/>Thank you for confirming that MySQL cannot use UDP and for pointing me to federated tables direction.<BR/><BR/>So what's the verdict in your opinion? I am tending to believe that clustering is the best option, followed by replication.<BR/><BR/>Do you agree?<BR/><BR/>Thanks<BR/>FrankFrankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1140027897380433122006-02-15T13:24:00.000-05:002006-02-15T13:24:00.000-05:00Hello Lenz,Thank you for your comment and giving t...Hello Lenz,<BR/>Thank you for your comment and giving the tip for DRBD. I will check it out.<BR/><BR/>The application for which I am inquiring has heterogenous operating systems that will all send data that needs to be replicated.<BR/><BR/>FrankFrankhttps://www.blogger.com/profile/04086666898806120300noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1140020209952471222006-02-15T11:16:00.000-05:002006-02-15T11:16:00.000-05:00mysql can not use udp for replication. you wouldn'...mysql can not use udp for replication. you wouldn't really gain anything -- it would just need to reimplement all the stuff that tcp gives you over udp. there's value to that overhead.<BR/><BR/>and i bet you could use triggers to update a table on a foreign database by using the federated storage engine.jimhttps://www.blogger.com/profile/02942997556144039112noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1139989028424706422006-02-15T02:37:00.000-05:002006-02-15T02:37:00.000-05:00Hi!1) Circular yes. One master used by many slaves...Hi!<BR/><BR/>1) Circular yes. One master used by many slaves, yes.<BR/><BR/>2) 5.1 will have on disk operations. RAM is cheap I might point out.<BR/><BR/>3) When I have seen slaves fall behind, most of the time it had to do with changes in configuration between master and slave. <BR/><BR/>4) No UDP support.<BR/><BR/>5) Yes they can, through federated tables.<BR/><BR/>Cheers,<BR/> -BrianAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-1139988587955235892006-02-15T02:29:00.000-05:002006-02-15T02:29:00.000-05:00If you are on Linux and you use a cold standby ser...If you are on Linux and you use a cold standby server, you should also take a look at <A HREF="http://www.drbd.org/" REL="nofollow">DRBD</A>, which provides mirroring a block device via the network to another machine. This replication is done on a block device level, so you may have perform a check of the table files for integrity before you can failover to the standby system, in case your primary node fails.Anonymousnoreply@blogger.com