Monthly Archives - December 2016

Make MySQL 8.0 Better Through Better Benchmarking

MySQL 8.0 innodb_dedicated_server

This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general.
Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL community, I would like to see MySQL 8.0 perform better. Better performance […]

Read more

Managing Replication with Percona XtraDB Cluster

Percona XtraDB Cluster Operator

This blog post discusses managing replication with Percona XtraDB Cluster.
Recently a customer asked me to setup replication between two distinct Percona XtraDB Clusters located in geographically separate data centers. The customer goal was to use one of the clusters only in case of disaster recovery. They tried extending the cluster, but because of the […]

Read more

Database Daily Ops Series: GTID Replication and Binary Logs Purge

GTID replication

This blog continues the ongoing series on daily operations and GTID replication.
In this blog, I’m going to investigate why the error below has been appearing in a special environment I’ve been working with on the last few days:

MySQL

Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log:
‘The slave is connecting […]

Read more