Sysadmin tips
1.9K views | +0 today
Follow
Sysadmin tips
Tips and Tricks that we have to know and abuse every day. sysadmin, sysops and network.
Curated by stephane gault
Your new post is loading...
Scooped by stephane gault
Scoop.it!

Better Parallel Replication for MariaDB and MySQL | MariaDB

Better Parallel Replication for MariaDB and MySQL | MariaDB | Sysadmin tips | Scoop.it
Parallel replication is a much-expected feature of MySQL. It’s available in MariaDB 10.0 and in MySQL 5.7. Yet, both lose efficiency when replicating through intermediate masters. In this post, we’ll explain how parallel replication works and why it does not play well with intermediate masters. We’ll also offer a solution (hint: it involves Binlog Servers).
stephane gault's insight:

Parallel replication taking advantage of the binary log group commit optimization. Well expected feature !

No comment yet.
Scooped by stephane gault
Scoop.it!

Query Optimization with MySQL 5.7 and MariaDB 10: Even newer tricks

Tutorial delivered at Percona Live London 2014, where we explore new features and techniques for faster queries with MySQL 5.6 and 5.7 and MariaDB 10, includin…
stephane gault's insight:
Query Optimization with MySQL 5.7 and MariaDB 10
No comment yet.