How to get MySQL 5.6 parallel replication and Percona XtraBackup to play nice together
MySQL 5.6 introduces a new “multi-threaded slave” feature (aka “parallel replication”) that turns the “slave SQL thread” into a number […]
The latest MaxScale version is out – what has been done since 1.0 beta?
The MaxScale team have been working hard fixing bugs and improving performance. On Friday we released a update of MaxScale, […]
I’m speaking about MaxScale and MariaDB tonight in Chicago
Tonight I will give a presentation on Max Scale (An Advanced Proxy for MySQL) for the Chicago MySQL Meetup MaxScale […]
Deciphering Galera Version Numbers
It’s important to understand which Galera version you are running, for proper compatibility of MariaDB with the Galera replication library, and also […]
Introducing the MariaDB Audit Plugin
Auditing is an essential task for monitoring your database environment. Auditing information can help you troubleshoot performance or application issues, […]
Using resource monitoring to avoid user service overload
With MariaDB, as with any service, you must monitor user resource usage to ensure optimal performance. MariaDB provides detailed statistics […]
Which SQL queries take all the time? Using MaxScale to answer that age old question.
Here we take a look at how one of the example filters supplied with the MaxScale 1.0 beta can answer […]
Putting Virtual Columns to good use
We all know that in general it’s a bad idea to have columns values contain too much “hidden” information, and […]
Scale Out Reads With MaxScale 1.0
Let’s assume you want to start an automatically expanding and shrinking MySQL replication cluster with up-to seven database servers. This […]
Reporting with Pandas and Seals and Pythons, Oh My
I spend perhaps too much time generating and reviewing numbers and charts and reports, but the right combination of tools […]