Developer Articles 

The New MySQL Server Release Model

By Robin Schumacher | June 26, 2009

When I joined MySQL back in June of 2005, one of the first “MySQL Truths” I learned and repeated often when discussing MySQL with others was “release early, release often.” If you’ve been using MySQL for any length of time, you know what that statement means – it meant that MySQL was: (1) dedicated to getting new features and enhancements into the hands of its community so the software’s quality could be validated; (2) eager to take early feedback on those features so the input could rapidly be incorporated back into the product allowing everyone to benefit; (3) committed to very frequent releases of the software so helpful new features and/or external contributions that were ready for action could quickly be put into play and not sit idle on the shelf. And if you’ve been around Open Source for a while now, you know this is the spirit in which most providers of Open Source software operate.

MySQL Developer, meet “Quan” (aka the MySQL Query Analyzer)

By Rob Young | May 15, 2009

The MySQL Query Analyzer ("Quan") is designed to save development time on query coding and tuning by expanding on all of the good things found in the Slow Query Log, SHOW PROCESSLIST; EXPLAIN plan, and 5.1 profiler all with no dependence of any of these atomic things. To this end, we integrated Quan into the Enterprise Monitor so developers can monitor security, performance, availability AND all of their queries across all their MySQL servers from a single, consolidated view.

Why Move to MySQL from Microsoft SQL Server?

By Robin Schumacher | May 4, 2009

Before we get started, let me say that I always liked being a SQL Server DBA. My database experience started with DB2, then Teradata, followed by Oracle, and then SQL Server (and then a little bit of Sybase after that, followed by MySQL). Coming from the other databases, I found SQL Server the easiest and quickest to learn at the time, but of course, a lot of that had to do with the fact that Microsoft was really the only database vendor around then (I started with version 4.2 of SQL Server) that shipped any decent GUI management tools with their server. Take the tools away, and you basically had Sybase on Windows with the ISQL command line tool, which was not pretty by any means.

A Quick Look at MySQL 5.4

By Robin Schumacher | April 21, 2009

Although MySQL 5.1 was released in December of 2008, Sun Microsystems isn't wasting any time moving forward with a number of new and exciting enhancements for its next release, MySQL 5.4. The first item of note is that the MySQL Server will be returning to a release early/often paradigm. So, instead of waiting on a full set of previously agreed upon features to be ready, the goal will now be to adhere to time-controlled releases that include all features that are ready by an agreed-upon beta date, with any features not fully 'baked' simply rolling to the next release. This being the case, MySQL 5.4 won't include some large new features like the Falcon transactional storage engine and the new backup utility, but it will include a number of very desirable enhancements that help your database-driven systems scale better and run faster in many cases. Let's take a look at what's included...

Developing Database Applications Using MySQL Connector/C++

By Giri Mandalika | April 15, 2009

The MySQL Connector/C++ provides an object-oriented application programming interface (API) and a database driver for connecting C++ applications to the MySQL Server. Connector/C++ implemented a significant percentage of the industry standard JDBC 4.0 specification in C++ world. This technical article shows the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Application developers who are new to MySQL Connector/C++ but not to C++ programming and MySQL database, are the target audience.

More Developer Articles »

• Online Shop
• Site Map
• About MySQL
• Legal
• Privacy Policy
• Contact Us
• Job Opportunities