|
Francois JEANMOUGIN wanted us to know:
>The current state of the artr for MySQL is to use an NBD cluster. You can use
>LVS to load-balance connections to your MySQL servers. You need a small
>management server to manage it.
We worked for a short while with NBD clustering and experienced huge
problems. It was probably more an issue with perl-DBD instead of NBD
itself, but it was enough that we had to go back to standard
replication.
Our current setup uses a homegrown DBI wrapper that does all reads from
the slave and directs all writes to the master (and for a short time
all reads in that session go to that master too). As read load
escalates, just add another slave and put it on an LVS VIP.
--
Regards... Todd
They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety. --Benjamin Franklin
Linux kernel 2.6.8.1-12mdkenterprise 1 user, load average: 0.00, 0.00, 0.00
|
