MySQL management, tutorials, scripts, coding, programming and tips for database administrators

MySQL

Data Driven Subscription in SSRS 2008 R2 01/23

Learn how to acquire data or parameter values required during the execution of a report from a database query, using Data-Driven Subscription in SQL Server Reporting Services (SSRS).

Achieving Five Nines Availability Using Synchronous Cluster Replication for MySQL 11/23

SchoonerSQL can help you achieve five nines availability for your MySQL database.

Thoughts on Improving DBA Productivity 11/18

Lockwood Lyon offers ideas for how database administrators can react less, think more and find lasting solutions.

Database Buyer's Guide Conclusion: Which Database Is Best for You? 10/27

Desktop databases, server databases, the Cloud or open source – which route is the right one for your organization?

Database Buying Guide: Open Source Databases 09/23

MySQL and PostgreSQL are worthy alternatives to the major commercial databases.

Oracle Expands MySQL for Windows 09/07

MySQL isn't just for the LAMP stack anymore.

Should You Move Your MySQL Database to the Cloud? 05/19

Is a cloud database service for you? Here's what to consider if you're thinking about a cloud database solution.

Beyond the LIKE Operator: Advanced Pattern Matching with MySQL 05/17

The MySQL LIKE operator is great for finding words or phrases within strings, but you'll be happy to learn that it provides a form of advanced pattern matching based on UNIX utilities.

Three Ways to Identify Non-matching Records in MySQL 05/06

There are many times as a database developer and administrator that you'll want to know what entities are being excluded from a straight table join; fortunately, MySQL gives you not one but three options.

Schooner Releases Active Cluster for MySQL 03/31
New clustering system promises fully synchronous replication for MySQL databases.

Xeround Brings MySQL to Heroku 03/17
The MySQL in the cloud vendor extends its platform for Ruby developers.

MySQL Data Fragmentation - What, When and How 03/11

Fragmentation can leave large holes in your table, blocks which must be read when scanning the table. Optimizing your table can make full table scans and range scans more efficient.

Converting between MySQL Date and Time Formats 03/09
MySQL's thorough and flexible date handling allows you to switch between internal and external date/time formats with relative ease.

MySQL InnoDB File Formats 03/02
Versions of MySQL now come equipped with the powerful and stable InnoDB plugin. We will cover file formats in this article, a very important part of the InnoDB plugin feature set.

Using MySQL's Analysis Tools to Improve Query Performance 02/18
One nice feature added to the EXPLAIN statement in MySQL 4.1 is the EXTENDED keyword which provides you with some helpful additional information on query optimization.