With the addition of the new tables to implement crash-safe replication we also get access to replication information through the SQL interface. This might not seem like a big advantage, but it should not be taken lightly. To demonstrate the power of using this approach, I will show how to implement a multi-source round-robin replication described at other places (including our book). However, compared to the other implementations—where the implementation requires a client to parse the output of SHOW SLAVE STATUS—the twist is that the implementation is entirely done in the server, using pure SQL.

If you're familiar with replication, you know that a slave can just …

This is the first GA release in a new major branch of the SQLyog MySQL GUI.

This release introduces an easy way to look up proper values for values inserted to columns that have a Foreign Key CONSTRAINT.  Foreign Key CONSTRAINTs can be difficult to handle for a human user because when updating a ‘child’ table valid values for columns that have such CONSTRAINTs  in the  ‘child’ table will often be ‘just a code’ ( an autoincrement integer or some very ‘compressed’ and ‘symbolic’ values (like item numbers, order numbers etc.).

This SQLyog release provides a direct way to look up in ‘parent’ what should be inserted in child. It works like this: In both GRID and FORM mode a ‘…’ symbol will display if the actual column has a Foreign key CONSTRAINT. If you enter some value in the cell and next click this button SQLyog will find all matches for what you have …

This morning at the MySQL User Conference and Expo, we’re excited to be included in Brian Aker’s keynote “The State of Drizzle” as one of the first organization to offer support for Drizzle now that it has reached GA with the release of Drizzle 7.  Brian Aker is the CTO of Data Differential and is the lead developer for the Drizzle Project.

Blue Gecko will offer operational support via our remote DBA model for Drizzle environments in the same manner and with the same stellar support team as has grown to support MySQL since we added service for it in 2003.  Our team can augment a company’s operational DBAs or can help a small installation move from a developer managed database to a more scalable 24×7 follow the sun operational model.  We provide operational remote DBA support to organizations from the startup to divisions of Fortune 500 …

Download PDF
Presentation Part I
Download PDF
Presentation Part 2

Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Learn what subtle differences between Oracle and MySQL are essential to understand in order to maximize the benefits of MySQL. We will be covering the ideal means for writing SQL statements, documenting your SQL, analyzing your SQL, MySQL software installation, configuration and maintenance best practices.

This new …

In our 5.6 release, we introduced a new feature – “InnoDB Metrics Table” as part of our effort to extend InnoDB diagnostic and monitoring capability. The “Metrics Table” feature consolidates all InnoDB related Performance and Resource related counters (as of today, 176 counters) and makes them available through an information schema table. In addition, it gives the user the ability to control these counters for their monitoring need.

In following sections, we will go over the feature in detail and focus on its usage to get you started with “metrics counters”.

1) The user interface – InnoDB Metrics Table

Before this feature, InnoDB already had dozens of performance counters. They are exposed to the user through “MySQL System Variables”. These counters are permanent counters, and there are no external controls on them. However, they had become important probes that allow users to peek into …

One of the many new things that is being introduced this week are some great new external tools for managing MySQL servers. These are available in MySQL Workbench under the name MySQL Workbench Utilities.

It is a package of easy-to-use utilities for maintenance and administration of MySQL servers. These utilities encapsulate a set of primitive commands bundling them so that you can perform macro operations with a single command.

Some of the key features of MySQL Workbench Utilities are:

• Plugin for MySQL Workbench 5.2.31
• Available under the GPLv2 license
• Written in Python
• Easily to extend using the supplied library

How Does It Work?
There are two ways to access the utilities from within the MySQL Workbench.

You can click on the drop down arrow icon to the right of the …

I chatted today about VMware's Cloud Foundry with Roger Bodamer, the EVP of products and technology at 10Gen. 10Gen's MongoDB is one of three back-ends (along with MySQL and Redis) supported from the start by Cloud Foundry.

If I understand Cloud Foundry and VMware's declared "Open PaaS" strategy, it should fill a gap in services. Suppose you are a developer who wants to loosen the bonds between your programs and the hardware they run on, for the sake of flexibility, fast ramp-up, or cost savings. Your choices are:

An IaaS (Infrastructure as a Service) product, which hands you an emulation of bare metal where you run an appliance (which you may need to build up yourself) combining an operating system, application, and related services such as DNS, firewall, and a …

Today at the MySQL User Conference in Santa Clara, SkySQL unveiled the SkySQL™ Reference Architecture for simplifying MySQL® deployments.
The SkySQL Reference Architecture offers users a logical framework for organizing IT systems around the MySQL® and MariaDB® databases. It is aimed at reducing the complexity of many of the most common data infrastructure applications for high availability, Web scalability, data warehousing/business intelligence, and the cloud.
At the heart of this initiative is SkySQL Provisioning v0.1 - a Web-based GUI for selecting, configuring and tuning best-of-breed software that has been tested and validated by SkySQL to be highly scalable, available, and cloud-ready.
In this first release, SkySQL has partnered with Calpont, Canonical, Data Differential, Linbit, Monty Program, Schooner, ScaleDB, Webyog, and Zimory to deliver its reference architecture.
The architecture came about as a result …

O'Reilly MySQL Application of the Year 2011 This award is given typically to an application that uses MySQL, but could also be a useful utility or other "associated" software. ("Application" naturally counts websites too.)http://code.google.com/p/tungsten-replicatorWatch awards on YouTube.

This is the 5th part of the MySQL 5.6 Performance Notes started from here.

Adaptive Flushing implementation is maybe one of the hottest topics discussed around MySQL 5.5 and InnoDB performance (and even way before 5.5) - if you will "google" for "furious flushing" you'll find many interesting things.. But well, the problem is still here for the moment, in 5.6 too, even if 5.6 is looking much more better facing it.. But well, it'll be great to fix it and then forget about.. - I think it's a time now, no?.. :-))

Fixing Adaptive Flushing in MySQL 5.6.2
Honestly, it's a pity to see Adaptive Flushing to be not so "adaptive" within MySQL 5.5 and 5.6 for the moment.. I very hope this situation will change very soon ;-)) And as there will be many versions of the "fix" to consider, here is …