[wplug] MySQL Mirror/Clustering

[Christopher DeMarco]

On Mon, Jul 11, 2005 at 01:12:08PM -0400, Shane Liesegang wrote:

> In your experience, is having the DB in memory a serious liability?
> Obviously a power outage would cause problems, but are there other
> things I'm not thinking of at the moment?

Simply that you need enough physical memory to hold the entire
database - e.g. a 2GB database (du -hs /var/lib/mysql) requires 2GB
dedicated to JUST the database.


> about setting up clusters. Is MySQL Cluster something I should be
> able to pick up relatively quickly, or do you think I would be
> better using the additional data layer and controlling the mirroring
> programatically?

These are two separate questions!

(a) The cluster is pretty easy to setup.

(b) MySQL Cluster vs. application-level multiplexing is an evaluation
which will be driven by the various criteria of your project.  In a
nutshell, the tradeoff is increased system resource usage (RAM,
network, bus bandwidth) with MySQL Cluster vs. increased application
development overhead to build the multiple-datasource functionality
into your code.


-- 
Christopher DeMarco <cmd at alephant.net>
Alephant Systems (http://alephant.net)
PGP public key at http://pgp.alephant.net
+1 412 708 9660
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://www.wplug.org/pipermail/wplug/attachments/20050711/504c026f/attachment.bin