Drizzle
Why SQL_MODE is important
Today was another example of where a correct SQL_MODE saved customer data from being corrupted. By default, MySQL does not enforce data integrity. It allows what is called silent truncations where the result of what you INSERT or UPDATE does not represent truth.
Read moreThe Drizzle Census
One thing I have often wondered is just how many MySQL instances exist in the world and what MySQL versions and architectures are in use. We hear of 50,000 windows downloads per day but this is misleading because MySQL is basically bundled with Linux by default or installed from various repositories.
Read moreHow to find MySQL developers?
Brian wrote recently Where did all of the MySQL Developers Go? , while over in Drizzle land they have been accepted for the Google Summer of code along with many other open source projects.
Read moreUnderstanding Drizzle user authentication options – Part 2
A key differentiator in Drizzle from it’s original MySQL roots is user based authentication. Gone is the host/user and schema/table/column model that was stored in the MyISAM based mysql.user table.
Read moreUnderstanding Drizzle user authentication options – Part 1
A key differentiator in Drizzle from it’s original MySQL roots is user based authentication. Gone is the host/user and schema/table/column model that was stored in the MyISAM based mysql.user table.
Read moreDrizzle’s Data Dictionary and Global Status
With the recent news by Brian about the Data Dictionary in Drizzle replacing the INFORMATION_SCHEMA, I was looking into the server status variables (aka INFORMATION_SCHEMA.GLOBAL_STATUS) and I came across an interesting discovery.
Read moreGetting started with Drizzle JDBC
In preparation for some Java work I wanted to configure and test the Drizzle JDBC Driver. Any chance to swing Drizzle into a MySQL discussion is worth the research. What I found was an issue compiling and an issue running on Ubuntu 9.
Read moreSQL Analysis with MySQL Proxy – Part 2
As I outlined in Part 1 MySQL Proxy can be one tool for performing SQL analysis. The impact with any monitoring is the art of monitoring will affect the results, in this case the performance.
Read moreSeeking public data for benchmarks
I have several side projects when time permits and one is that of benchmarking various MySQL technologies (e.g. MySQL 5.0,5.1,5.4), variants (e.g. MariaDB, Drizzle) and storage engines (e.g. Tokutek, Innodb plugin) and even other products like Tokyo Cabinet which is gaining large implementations.
Read moreSetting up sysbench with MySQL & Drizzle
Sysbench is a open source product that enables you to perform various system benchmarks including databases. Drizzles performs regression testing of every trunk revision with a branched version of sysbench within Drizzle Automation .
Read moreDrizzle Query logging
Currently Drizzle offers three (3) separate query logging plugins. These plugins offer an extensible means of gathering all or selected queries and provide the foundation for a query analyser tool. Additional filtering includes selecting queries by execution time, result size, rows processed and by any given regular expression via PCRE.
Read moreAn important Drizzle/MySQL difference
There are many features that are similar in MySQL and Drizzle. There are also many that are not. I’ve previously discussed topics like Datatypes and tables , SQL_MODE and SHOW .
Read moreBenchmarking Drizzle with MyBench(DBD::drizzle)
With thanks to Patrick Galbraith and his DBD::drizzle 0.200 I am now able to test client benchmarks side by side with MySQL and Drizzle. For simple benchmarking with clients, generally when I have little time, I use a simple Perl framework mybench .
Read moreProblems compiling MySQL 5.4
Seem’s the year Sun had for improving MySQL , and with an entire new 5.4 branch the development team could not fix the autoconf and compile dependencies that has been in MySQL for all the years I’ve been compiling MySQL.
Read more