15.
Fusion-IO page compression
● Atomic writes gives a
performance increase of about
30%. By enabling fast checksum
for XtraDB it’s 50%
● By using page compression the
compression ratio is leading to
better performance and there
are less writes to disk.
● Multi-threaded flush provides
better throughput and
decreases operation latencies
delivering a performance boost
https://blog.mariadb.org/significant-performance-boost-with-new-mariadb-page-compression-on-fusionio

16.
Group Commit
● binlog_commits
● Total number of
transactions committed to
the binary log
● binlog_group_commits
Total number of groups of
transactions committed to
the binary log
When sync_binlog=1 it is the
number of fsync()’s

18.
Parallel Slave Thread Replication
● Sponsored by Google
● Transactions are applied in parallel if they have been executed in parallel on the
master.
● It works beyond the boundaries of MySQL 5.6 parallel slave
● Parallel threads apply to:
● Queries that are run on the master in one group commit.
● Queries that are from different domains.
● Queries from different masters
(when using multi-source
replication).
● slave_parallel_threads
● Number of parallel threads on
the slave node
● slave_parallel_max_queued
● Memory used to read ahead
in relay log

19.
Multi-source Replication
● Data partitioned over many
masters can be pulled
together onto one slave for
analytical queries
● Many masters can replicate to
the same slave and a complete
backup can be done on the slave
● Newer hardware usually provides more
performance. Usually all hardware isn’t upgraded at
once and multi-source can be used for replicating
many masters to a powerful new slave.
● Up to 64 masters