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