by Jeff Mace, Director of Professional Services at Continuent:
How do you find one users’ data when it is located in one of a hundred schemas? Build a global index table that allows you to identify the home data center and schema for any user. Sharding data across many schemas is the lifeblood of highly-scalable websites. Multiple data centers are the key to maintaining availability and performance around the globe. You can use Tungsten Replicator to combine key data from all of these schemas into a central table in real-time. Jeff's talk will show examples of doing this in MySQL or MongoDB.
Tungsten Replicator is a high performance, open source, data replication engine for MySQL. It offers a set of features that surpass any open source replicator available today: global transaction IDs to support failover, flexible transaction filtering, extensible transaction metadata, sharding, multiple replication services per process, high performance, and simple, well-documented operation.
Track: Replication and High Availability Strategies