Hi Dan,
I've read into Sequoia's Partial replication (RAIDb-2) and see that it
can replicate tables across 1 or more nodes. Is it possible, however,
using RAIDb-2 (or another method) to divide a single table across
multiple nodes?
No this is not currently possible.
If this is possible, how is this accomplished, and is it a viable way
to go?
An option would be to use MySQL partitioned tables
(http://dev.mysql.com/doc/refman/5.1/en/partitioning-types.html) but you
can use Sequoia on top to replicate multiple MySQL partitioned databases.
For example you distribute DB1 on 3 nodes using MySQL partitioned
tables. You can have a second cluster where you distribute the same
database according to some other partition as you see fit. You can use
Sequoia to replicate data between the 2 clusters (each cluster partition
will be seen as a single MySQL database backend from Sequoia).
I hope this helps,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
