Bug #3454

RAIDb style support on database

Details

Request #3454	RAIDb style support on database
Submitted	2005-02-13 16:48 UTC
From	jason at dden dot ca
Assigned	danielc
Status	Wont fix
Package	DB
PHP Version	Irrelevant
Roadmaps	(Not assigned)

Comments

[2005-02-13 16:48 UTC] jason at dden dot ca

Description:
------------
This is as good as a place as anywhere. I have been looking for similar support in PHP as is currently available in the c-jdbc (c-jdbc.objectweb.org) library for jdbc. This module creates a support to providing redundancy through the use of multiple in expensive databases (they term it RAIDb)

(Document to explain the idea - http://c-jdbc.objectweb.org/current/doc/RR-C-JDBC.pdf)
RAIDb-0 - Database striping where tables for a database is across multiple databases

RAIDb-1 - Database is fully replicated
RAIDb-1ec - Adds Error Checking

RAIDb-2 - Partial Replication
RAIDb-2ec - Adds Error Checking

For most people I think the option of RAIDb-1 and possibly 0, would be the most useful, just the option of spreading the workload over a larger number of servers, would be helpful, as well as if one system goes away, it's not an emergency to repair.

[2005-02-14 15:13 UTC] smith at backendmedia dot com

Indeed this is best handled inside the DMBS itself. You could try to write something up with a single master server for all manipulation queries that replicates using a debug handler in MDB[2], but I dont think that this is adviseable and it would also not work with prepared queries.