Hi, another approach, not clustering, which might give you a distributed database: https://forge.continuent.org/projects/sequoia/ Gabriel --- Alexandre CONRAD <aconrad.tlv@xxxxxxxx> wrote: > Hello, > > I'm thinking about setting up a MySQL database > clustered (but not like > MySQL Cluster which kinda just does mirroring > AFAIK). > > I want it to be partionned on multiple > disks/servers. > > Here is my apporch: > > +-------------------+ > | Application (PHP) | > +-------------------+ > ^ > | > | > v > +--------------+ > | MySQL Server | > +--------------+ > ^ > | > | > v > +--------------- logical disk ----------------+ > | ^ | > | | | > | +----LAN-----+----LAN-----+ | > | | | | | > | v v v | > | +----------+ +----------+ +----------+ | > | | physical | | physical | | physical | | > | | server 1 | | server 2 | | server 3 | | > | +----------+ +----------+ +----------+ | > | | > +---------------------------------------------+ > > The idea is to split the data on 3 physical servers > when data is > written. So each server will have 1/3 of the data on > their disk. It > would work as a RAID 5 system. > > In case of full disk space, you would add a new > physical server (node) > and the data would be redistributed to all servers, > each getting 1/4 of > the data. > > In case of server failure, because of distributed > parity (RAID5), it > could keep going. > > Or alternativly think about a RAID0+1 configuration. > > Do you have any idea if this could be achived using > LVM, RH Cluster > Suite or any other clustering / partitioning system > ? > > Regards, > -- > Alexandre CONRAD - TLV > Research & Development > tel : +33 1 30 80 55 05 > fax : +33 1 30 80 55 06 > 6, rue de la plaine > 78860 - SAINT NOM LA BRETECHE > FRANCE > > -- > > Linux-cluster@xxxxxxxxxx > https://www.redhat.com/mailman/listinfo/linux-cluster > -- Linux-cluster@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/linux-cluster
