MySQL Performance Blog on SkySQL

23 Apr

The conference season has begun for us here at SkySQL. It seems like the almost all linux and MySQL shows are in the next four months. This is the time of year that we get to collect those...

17 Apr

If you are installing MySQL ODBC Driver and encounter the following error:

Error 1918. Error installing ODBC driver MySQL ODBC 5.1 Driver, 
ODBC error 13: The setup routines for the...
17 Apr

If you attempt to use ODBC to run a MySQL application and run into the following error:

[Microsoft][ODBC Driver Manager] The specified DSN contains an 
architecture mismatch between the...
16 Apr

The biggest concern with a slave is to ensure your data is consistent with the master! End of story!

3 of the biggest things I see when dealing with out-of-sync slaves:

  1. Many...
16 Apr

Warning: it turned out that I used a full debug build instead of a release one, and that seems to make a hell of a difference ... most numbers have been updated now, the old...

14 Apr


Dynamic columns came to my attention a few...

14 Apr

I've had my own set of autotool macros for building against different MySQL client and server APIs for quite a while. Originally created as part of my code generator projects (...

11 Apr


Trade show season is in full swing again for SkySQL: The MariaDB Company. Next week we will be attending the...

10 Apr


We brought our finest to Percona Live this year!

Like most of you who attended Percona Live this year...

08 Apr

MariaDB 10.0.10 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10...

02 Apr

In a previous post, I discussed debugging stored procedures with RESIGNAL, which is of great value when troubleshooting errors raised by your...

02 Apr

I was recently debugging a stored procedure and could not easily identify the underlying reason for why it was failing.

It had a standard exit handler catch-all for SQLEXCEPTION, which was...

02 Apr

MariaDB replication in general works as follows: on a master server, all updates to the database are written into the binary log as binlog events, a slave server connects to the master and reads...

01 Apr

It is now 3 months since we put MaxScale out in the public domain in GitHub, we have not been sitting idle during that time, rather we have been adding some new features and fixing some bugs. We...