We have some mysql servers that we would like to function as a cluster. The
mysql servers house a database that a cluster of webservers will access to
display product information, accept orders, etc.
From the reading I have done on mysql, it would appear that (according to
the mysql website) they don't really support "clustering". They don't REALLY
seem to support replication either, other than there is some notes about how
to replicate one way via moving the transaction log around.
Since spread/wackamole seems to offer such a nice solution for clustering
webservers, I'm wondering if anyone has tried to use spread/wackamole for
mysql servers? The idea is that when a website updates a database record,
the update needs to be replicated across all the mysql servers in the
cluster. I am well aware of the basic setup of wackamole to do this, but I'm
more concerned about the backend - the mysql configuration side of this.
Has anyone done this, and could they share some ideas or point me in the
right direction? And yes, by the way, the websites both read AND write to
the database.
THANKS!
Jay West
---
[This E-mail scanned for viruses by Declude Virus]
mysql servers house a database that a cluster of webservers will access to
display product information, accept orders, etc.
From the reading I have done on mysql, it would appear that (according to
the mysql website) they don't really support "clustering". They don't REALLY
seem to support replication either, other than there is some notes about how
to replicate one way via moving the transaction log around.
Since spread/wackamole seems to offer such a nice solution for clustering
webservers, I'm wondering if anyone has tried to use spread/wackamole for
mysql servers? The idea is that when a website updates a database record,
the update needs to be replicated across all the mysql servers in the
cluster. I am well aware of the basic setup of wackamole to do this, but I'm
more concerned about the backend - the mysql configuration side of this.
Has anyone done this, and could they share some ideas or point me in the
right direction? And yes, by the way, the websites both read AND write to
the database.
THANKS!
Jay West
---
[This E-mail scanned for viruses by Declude Virus]