MySQL Performance Blog on SkySQL

17 4月

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 4月

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 4月

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 4月

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 4月


Dynamic columns came to my attention a few...

14 4月

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 4月


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

10 4月


We brought our finest to Percona Live this year!

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

08 4月

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

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

02 4月

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

02 4月

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 4月

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 4月

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...

31 3月

Since the idea was conceived, I have been part of designing the SkySQL Remote DBA service. I strongly believe the Remote DBA service is an incredible way for many companies to achieve their main...