Home > Multi-Threaded Replication in MySQL

Multi-Threaded Replication in MySQL

For years, people lamented that MySQL’s replication was single-threaded. Peter, Vadim, and I griped about this in High Performance MySQL for two whole editions, as well as a bunch of blog posts. The problem with single-threaded replication is that a master server can do lots of work on many cores in parallel, so a single-threaded replica has very little hope of keeping up. Poor guy. Then one day a couple of years ago, MySQL replication got multi-threading, and not many people have really said much about it since then. Why not? It’s the bee’s knees! We’ve been using it with SolarWinds Database Performance Monitor (DPM) in production and it works great. Granted our workload is what it’s best at (multi-tenanted, highly shared, with each tenant in separate databases and/or servers), but this is exactly the use case where you want multi-threaded replication the most anyway. Many thanks to the replication team for this great feature.
Baron Schwartz
Baron is a performance and scalability expert who participates in various database, open-source, and distributed systems communities. He has helped build and scale many large,…
Read more

Tweets

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

What is AIOps? Learn more in this article "What is "AIOps"? The Importance of Artificial Intelligence in IT Operati… t.co/9gQ6xWmrtd

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

@itech_live Hi there, thanks for reaching out. If you have any follow-up questions or concerns, feel free to send t… t.co/AOrN0ATcN9

SolarWinds's Twitter avatar
SolarWinds
@solarwinds

We're looking forward to a great year ahead. Tell us which 'IN' you're most looking forward to in the comments belo… t.co/udwB3vP5U0