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. This talk will show examples of doing this in MySQL or MongoDB.
Tungsten Replicator (http://tungsten-replicator.org) 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
2 October 14:30 - 15:20 @
Director of Professional Services, Continuent, Inc.
Jeff Mace, Director of Professional Services, has 10 years of experience developing internet applications and managing database servers. He joined Continuent in June 2010 after having a chance to work with Tungsten and the Continuent team. Jeff started his career using DB2 at Penn State University. Since that time he has built event management software at AetherQuest Solutions and participated on eCommerce and CMS projects as an independent contractor.