Date: Wed, 7 Apr 2010 15:11:23 +0200 From: "Marek 'Buki' =?iso-8859-2?Q?Kozlovsk=FD?=" <dev@null.cz> To: freebsd-stable@freebsd.org Subject: Re: fault tolerant web servers on freebsd Message-ID: <20100407131123.GO53727@dev.null.cz> In-Reply-To: <4BBC362A.9010306@infracaninophile.co.uk> References: <4BBA05A2.40706@intertainservices.com> <4BBA1823.1090305@gausus.net> <4BBA4334.1020506@interazioni.it> <4BBA4478.7030302@gausus.net> <20100405164306.hmy4n8pvs4goc8ks@www.goldsword.com> <4BBA51B9.6010803@gausus.net> <4BBC20BA.6090604@ish.com.au> <4BBC2DAB.2050704@icyb.net.ua> <p2h33c6b0bc1004070015iab9d7e22xf40361329eb81d53@mail.gmail.com> <4BBC362A.9010306@infracaninophile.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
--O/sh2HmV2lEgPixT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Apr 07, 2010 at 08:37:14AM +0100, Matthew Seaman wrote: [snip] > >> Out of curiosity: have you considered MySQL Cluster: > >> http://en.wikipedia.org/wiki/MySQL_Cluster > >> http://www.mysql.com/products/database/cluster/faq.html > >> > >> If yes, can you share your evaluation results? > >> Thanks! >=20 > You need at least three machines to build a MySQL cluster; preferably > more like 6 or 7. All of your data has to fit in RAM on those machines > and you need at least two copies of each item of data for resilience, so > don't bother trying this with anything other than a well populated 64bit > box. Also, if /all/ of your servers crash at the same time (power > problems tend to have this result) then your data has gone *poof* and > you'll be restoring from backup. You did remember to set up a regular > job to create snapshots of the clustered data didn't you? two machines will suffice. Of course, prefferably more :) Data no longer need to fit into memory, IIRC. Only indexes must. We were running MySQL cluster in production few years back (with 4.x MySQL - when the data had to fit in mem) and it was quite usable. > Cluster tends to be slower than what you can achieve with straight MySQL > on the same hardware. unfortunately, I didn't perform any test. > Cheers, >=20 > Matthew >=20 > --=20 > Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard > Flat 3 > PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate > Kent, CT11 9PW more on the topic at http://www.mysql.com/products/database/cluster/ Regards, Buki --=20 PGP public key: http://dev.null.cz/buki.asc /"\ \ / ASCII Ribbon Campaign X Against HTML & Outlook Mail / \ http://www.thebackrow.net --O/sh2HmV2lEgPixT Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (FreeBSD) iD8DBQFLvIR7PzhIkpLLm08RAn53AJ4zDxZnK6/DpQ/Hlst6F67+5mpdrgCZAUzW ezTLJrSsHIA57OtgWy32sZE= =Kloh -----END PGP SIGNATURE----- --O/sh2HmV2lEgPixT--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20100407131123.GO53727>