Hi,

We have a MySQL+InnoDB server on Linux-Debian as ISP mail solution in conjunction
with Postfix and DBmail and a Webmail in PHP/MySQL. The mail database is now 4.8Gb
size for about 210 users on IMAP and POP3. The database have to grow to more than
1000 or perhaps 2000 users.

We must in a next future migrate the database in clustering mode, first to load
balance the large amount of queries on several server to keep an high level of
performance, and second to have an high availability system, this is critical for
us.

We have explored several solutions but we need some advises:

1- We don't agree with the standard MySQL (>4.O) replication system because it's a
one way replication, master-->slave(s).

2- Does the LinuxDirector(load balancer) with several MySQL servers and Coda
distributed filesystem can work safely ?

3- We look the OpenMosix + oMSF http://openmosix.sourceforge.net/ (CC Cluster) but
at this time there is a problem with the shared memory, a DSM is in development,
does the right way to explore ?

4- We have take a look at a Spread solution (www.spread.org) for MySQL as the
Backhand project for Apache (www.backhand.org) to replicate the changes on whole
servers and balance the queries with LinuxDirector. This solution have to be
developed, if there is some volunteer :-)

Or perhaps have you others propositions, otherwise we have to look PostgreSQL and
DBBalancer :-(

Since MySQL-Max and the future stable 4.x versions, MySQL become a major database
server for critical applications and the need of high availability and high
performance offer by cluster will be more and more useful.

Thanks in advance for your comments.

Sam.
--
Sam Przyswa - Chef de projet
Arial Concept - Intégrateur Internet
36, rue de Turin - 75008 - Paris
Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01
Web: http://www.arial-concept.com - Email: [EMAIL PROTECTED]




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to