Resolving MySQL ODBC “architecture mismatch” Error
If you attempt to use ODBC to run a MySQL application and run into the following error: [Microsoft][ODBC Driver Manager] […]
Looking for Slave Consistency: Say Yes to –read-only and No to SUPER and –slave-skip-errors
The biggest concern with a slave is to ensure your data is consistent with the master! End of story! 3 […]
SQL or NoSQL? … Both with MariaDB 10
Dynamic columns came to my attention a few days back. Since then I read a little bit more in the […]
MariaDB 10.0.10 Overview and Highlights
MariaDB 10.0.10 was recently released, and is available for download here: https://downloads.mariadb.org/mariadb/10.0.10/ This is the first GA (“Generally Availability“, aka […]
Improve your Stored Procedure Error Handling with GET DIAGNOSTICS
In a previous post, I discussed debugging stored procedures with RESIGNAL, which is of great value when troubleshooting errors raised […]
Quickly Debugging Stored Procedures, Functions, Triggers, and Events with RESIGNAL
I was recently debugging a stored procedure and could not easily identify the underlying reason for why it was failing. […]
WebScaleSQL! Will it build?
There was an exciting announcement today about WebScaleSQL, the new “branch” (not a fork, they say!) of MySQL created by […]
MariaDB: The Differences, Expectations, and Future
For my new book, Learning MySQL and MariaDB, Monty Widenius, one of the founders of MySQL and MariaDB, graciously contributed […]
Multi-source replication in MariaDB 10.0
I have wanted multi-source replication in MySQL since 4.0, so I was delighted to see this feature appear in MariaDB […]
Countdown is on for Percona Live: MySQL Conference & Expo
Will we see you at Percona Live? The Percona Live MySQL Conference and Expo is right around the corner and […]