Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : how efficient is mysql server clustering?

[deras]

would two clustered servers with frequently changing databases be as fast as
two servers with identical static databases?

my big question is does the clustering take up a lot of resources when database content gets changed alot (for example a 100mb database, 2-5% gets changed in a day). my options are to mirror my one database every 24 hours on another server OR to cluster two servers which would give me dynamic mirroring. i am trying to figure out how much less efficient clustering would be compared to the static back up alternative (to figure out if dynamic mirroring is worth it).

[PerfTuner]

Are you sure you mean MySQL Clustering? Not replication?

[netserve]

Replication would be fine where 5% of the traffic is insert/update and the rest simply select assuming you've got site software that you can recode to handle reads from two db servers and writes to just the one.

Mysql clustering is the new Mysql5 product, that seems to need twice as much ram as the size of your database for a 2 server cluster. Now where did I put that 20Gb stick of SDRAM :-)

[deras]

what does clustering offer over replication?

[sehe]

http://en.wikipedia.org/wiki/Clustering vs. http://en.wikipedia.org/wiki/Replica...ter_science%29