Re: MySQL Clustering

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@xxxxxxxxxxxxx
http://www.wilkshire.net
Jon Simola wrote:
On 3/15/06, James Ryan <james@xxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to "freebsd-isp-unsubscribe@xxxxxxxxxxx"


_______________________________________________
freebsd-isp@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to "freebsd-isp-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: hitting the limits
    ... relatively straight forward MySql database. ... 10K visitors a month and an 80Mb database are nothing. ... heavily loaded server. ... But the connection will hang around until the garbage ...
    (comp.lang.php)
  • Re: Database connection error (re-post)
    ... MySQL is a database server, it is not a desktop database like Access, you have to work with directly ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Re: Confusion about database updates
    ... all connecting to the same database server. ... MySQL can easily handle many simultaneous clients. ... AlphaCluster all open multiple connections to a MySQL server running on ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)
  • Re: Using MySQL as the backend
    ... I need to learn MySQL, ... > the impression you're not familiar with the concept of a server DB. ... > doesn't need to have Access installed to access the database, ... >> install the server or maybe I have it installed but I just don't know how to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: MySQL Insert Unicode Problem
    ... I'm trying to insert some data from an XML file into MySQL. ... The database server has to support Unicode, ...
    (comp.lang.python)