Kudos to the SkySQL Engineering team, who released the 3rd alpha version of MaxScale, a database proxy for MySQL, MariaDB and Percona servers, labeled MaxScale 0.6.
This version comes with two important additions:

• A feature-complete read/write splitting module, i.e. read and write operations are now balanced in a smarter way to master or slave servers.

• New client-based features, such as a version string that provides compatibility with the major MariaDB and MySQL connectors, the ability to connect through the root user and the use of the unix socket when MaxScale is co-located with a client application on the same server.

Binaries and source code are “hidden” here: http://downloads.skysql.com/files/SkySQL/MaxScale.
The project is on GitHub: https://github.com/skysql/MaxScale/
Other helpful links are:

• Bugs …

The combination of max_allowed_packet variable and replication in MySQL is a common source of headaches. In a nutshell, max_allowed_packet is the maximum size of a MySQL network protocol packet that the server can create or read. It has a default value of 1MB (<= 5.6.5) or 4MB (>= 5.6.6) and a maximum size of 1GB. This adds some constraints in our replication environment:

• The master server shouldn’t write events to the binary log larger than max_allowed_packet

• All the slaves in the replication chain should have the same max_allowed_packet as the master server

Sometimes, even following those two basic rules we can have problems.

For example, there are situations (also called bugs) where the master writes more data than the max_allowed_packet …

Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 13.1 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 13.1 server with PHP5 support (mod_php) and MySQL support.

MySQL is the proud Training Sponsor of PHPTek. This is a great event and I am speaking on Exploiting New MySQL Features on the morning of the 23rd. See you at training day on the 19th!

And do not forget the Chicago MySQL Users Group meeting on the 21st. Yes, there will be pizza at 6:30 but RSVP so we know how much to order.

Oracle Offices
233 South Wacker Dr.
45th Floor
Chicago, IL

Very happy to see this announcement “MySQL 5.6 now available in Cloud SQL: full text search, geospatial queries and online schema changes.”

Foreign Keys are often a mystery to new DBAs in the MySQL world. Hopefully this blog will clear some of this up.

In this example, we will have a table for employee data and a table for the data on offices. First we need the two tables.
CREATE TABLE employee (
-> e_id INT NOT NULL,
-> name CHAR(20),
-> PRIMARY KEY (e_id)
-> );

CREATE TABLE building (
-> office_nbr INT NOT NULL,
-> description CHAR(20),
-> e_id INT NOT NULL,
-> PRIMARY KEY (office_nbr),
-> FOREIGN KEY (e_id)
-> REFERENCES employee (e_id)
-> ON UPDATE CASCADE
-> ON DELETE CASCADE);


Those who do not use Foreign Keys will not be familiar with the last four lines of the building table. The trick is that there are two e_id columns, one in each table. In the employee table …

MariaDB 10.0 had a stable release last month. It is a good time to take a look and see how it compares to the stable version of MySQL, MySQL 5.6 (as for Percona Server, it doesn’t have its own optimizer features).
Changelogs and release notes have all the details, but it’s difficult to see the big picture. So I went for diagrams, and the result is a short article titled What is the difference between MySQL and MariaDB query optimizers. It should give one a clue about what are the recent developments in query optimizers in MySQL world.

In case you’re interested in details about optimizer features in MariaDB 10.0, I’ve shared slides from a talk about MariaDB 10.0 query optimizer.

There are a couple of posts about setting up Percona XtraDB Cluster on Vagrant and Percona Server on MySQL Sandbox – those are two of the top tools used by the Percona Support team for testing and bug processing among other things.

In this post, however, I will show you how to use Docker with Percona Server on Ubuntu 12.04.

As per Docker’s official site:

Docker is an open-source engine that automates the deployment of any application as a lightweight, portable, self-sufficient container that will run virtually anywhere.

Docker containers can encapsulate any payload, and will run …

#DBHangOps 05/15/14 -- MySQL Fabric!

You can watch the recording below:

Hello everybody!

Join in #DBHangOps this Thursday, May, 15, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

• MySQL Fabric!

Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!

See all of you on Thursday!

Show notes

Helpful Resources for MySQL Fabric

• Download fabric by going to http://dev.mysql.com/downloads/tools/utilities/ and clicking on the "Development" tab
• Get an appropriate connector for …

Choosing the right database to drive your business-critical applications can be a daunting task. Unlike several years ago when MySQL dominated the open-source market, companies today now have dozens of choices when it comes to open-source databases. MySQL is still one of the most popular options, but a new class of solutions has emerged—NoSQL—and it’s gaining popularity and delivering surprising results.

This white paper provides a high-level overview of the characteristics of relational (MySQL) versus non-relational (NoSQL) open-source databases along with a detailed comparison of how each one approaches scalability, performance, and data modeling. The purpose of this paper is to help companies understand the differences between the databases and know what to look for when choosing a solution best suited to their environment.

Please fill out the form to download this whitepaper.

The post …