Boost Your Replication Throughput with Parallel Apply, Prefetch, and Batching

8.5
Average: 8.5 (4 votes)

Slave lag is the bane master/slave replication. This talk will explain why slave lag occurs and show you three important ways that Tungsten Replicator can banish it for MySQL slaves. Parallel apply uses multiple threads to execute slave transactions. Prefetch uses parallel threads to read ahead of the slave position and fetch pages that will be needed by the slave. Batching uses CSV files to load row updates in extremely large transactions that bypass SQL completely. We will explain each technique, show you how to use it, and provide performance numbers that illustrate the gain you can expect. We will round the talk out with a discussion of non-Tungsten tools that offer similar benefits. With these techniques in hand, you'll be well-prepared to attack any replication performance problem.

Track: 
Replication and High Availability Strategies
Experience level: 
Intermediate

Schedule info

Time slot: 
12 April 14:00 - 14:50
Room: 
Ballroom G

Schedule Info

12 April 14:00 - 14:50 @
Ballroom G

Speakers

Senior Software Engineer, Continuent

Stephane Giron is a Senior Software Engineer at Continuent since 2005.
He is highly involved in Tungsten development, mainly around replication matters.

Robert Hodges's picture
CEO, Continuent

Robert has over 30 years of experience in database and application engineering. Prior to Continuent, he worked on object-relational databases and transaction processing at Sybase. He also held senior engineering positions at Portera and Exigen Group, where he designed and operated software-as-a-service applications. Robert is the original designer of Continuent's Tungsten solution.




Sponsored By