Date: Wed, 15 Mar 2006 13:34:11 -0500 From: Cody Baker <cody@wilkshire.net> To: freebsd-isp@freebsd.org Subject: Re: MySQL Clustering Message-ID: <44185E23.1090809@wilkshire.net> In-Reply-To: <8eea04080603150915m18ff7c6cld9fdf761258759a3@mail.gmail.com> References: <44183340.4060903@infinityprosports.com> <8eea04080603150915m18ff7c6cld9fdf761258759a3@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
If you're database is simply read only then the load balancer situation should work fine. If your database is read/write then your load balancer could cause you problems under certain circumstances. If your updates are not time critical then it should be fine. If, however, your databases are used for a time critical updates (ex. session data for a web page) then it's important that your users always hit the same database server because the replication can become delayed at times. If the user has a random chance of hitting any of your database servers then for example your user may add something to their cart, and refresh the page connecting to another server, and find the item missing from their cart. Other no-nos for replicated databases especially on mysql < 5, are auto-incrementing fields in tables. 5.x has a solution for this ( http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html ). Thank You, Cody Baker cody@wilkshire.net http://www.wilkshire.net Jon Simola wrote: > On 3/15/06, James Ryan <james@infinityprosports.com> wrote: > >> Not sure if this is the right list for this (I apologize if its not), >> but has anybody ran a MySQL 2+ node cluster under FreeBSD 5.x behind a >> load balancer; and if so, could you offer any tips or warnings? >> > > If you're talking about the actual MySQL clustering server setup, I've > never had a chance to try it as our dataset is too large. > > I've run a pair of MySQL servers in a round-robin master setup (A > slaves from B, B slaves from A) and that worked rather well, > replication was impressively quick. > > -- > Jon Simola > Systems Administrator > ABC Communications > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44185E23.1090809>