[Spread-users] Need advices

Sam Przyswa samp at arial-concept.com
Fri Sep 6 11:12:43 EDT 2002


I need and advice before to start a Spread project.

Ce goal of this project is to permit to run several MySQL servers in clustering
mode to get high availability and high performances. The problem is MySQL is the
multi-threading and the shared memory, at this time none clustring system can run
multi-threading and shered memory apps.

MySQL has a db replication feature but only in one way master-->slave then if the
master go down the whole cluster system down too, an second problem we store files
up to 10Mb in the DB and replicate a such insert on 10 servers will overload the

What we are thinking: use Spread to multicast the insert, update, delete, alter,
commands on all other nodes on the cluster but only once, then each node listening
the spread messages replicate their base as soon as the message are passed. With
this system we espect to got a realtime replication between 10 or more MySQL
servers through the network with a minimum network overload.

My question is it possible to do that with Spread and to spread a message up to
10Mb ?

Thanks in advance for your help.

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: Info at arial-concept.com

More information about the Spread-users mailing list