distributed database on multiple servers/disks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [Corosync Cluster Engine]     [GFS]     [Linux Virtualization]     [Centos Virtualization]     [Centos]     [Linux RAID]     [Fedora Users]     [Fedora SELinux]     [Big List of Linux Books]     [Yosemite Camping]

  Powered by Linux