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