Percona Server for MySQL version 5.1.68-14.5

Percona is glad to announce the release of Percona Server for MySQL 5.1.68 -14.5 on March 15, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68 -14.5 is now the current stable release in the 5.1 series. All of Percona‘s software is open source and free, all the details of the release can be found …

There have been many articles about the downtime issue with Cloudflare last week, so I won’t get into the technical details of that. However, there’s the fine print to remember. Consider this a subtle reminder that core Internet infrastructure services like Cloudflare’s DNS-based “Always Online” caching and packet inspection security services do not come with Service Level Agreements even at the “Pro” account level. Even with a Pro account you are paying for a service with no uptime guarantee and you must only hope that it resolves your sites the majority of the time. This is fine, this is what the contract says: no SLA unless you pay for the Business account. An odd naming convention given that most Professionals are using their websites for business and would want the SLA, but I digress.

So, the SLA is not really the issue if you look at the architectural alternatives to building an architecture that desires availability when …

I really don’t like running my database in “I Love Garbage” mode, so I set the following SQL_MODE:

STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO, NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE, NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY

Guess what WordPress does with that? It doesn’t install. If you set the SQL_MODE to empty and install WordPress, then restore the SQL_MODE, WordPress will run, but if you try to create a post you’ll see an error page that says “You are not allowed to edit this post.”

This problem was reported to WordPress at least 7 years ago. Lessons learned:

• There is a huge amount of software that was built to work with MySQL 3.23′s irritating habit of …

We are raffling six (6) full conference passes to Percona Live: MySQL Conference & Expo (April 22-25 in Santa Clara, CA) to our valued customers. A $1,599 value.How to win? Simply send us a brief description of how you use Tungsten, how Tungsten helps you meet your clustering and replication needs, and how Continuent's support has treated you. Please give us your honest and direct feedback -- all

I haven't written in a while. Some of the reason is that life has been incredibly busy with two young children. The other reason is that I've been busy at work with my team developing HP Cloud DNS, a service that runs in the cloud, as do the various other applications within the Platform as a Service group that I am part of. After a period of rapid development and deployment, Cloud DNS recently went into private beta . The ability to build an cloud application such as this was primarily that I have a great team (Kiall Mac Innes, Simon McCartney and a great product manger Josh Barry) as well as having chosen the right tools and software solutions. For the deployment side of things, Chef, despite frustrations that I have had before getting my mind around it, was a solution that I knew would make it so we could deploy anywhere, as well as being what HPCS uses for their deployments for …

Congratulations to the openSUSE community on a successful release of openSUSE 12.3. A highlight worth mentioning is that MariaDB is now the default as opposed to MySQL. What are you waiting for, download it!

From the features list, here’s an excerpt focusing on MariaDB & MySQL:

openSUSE has moved from MySQL to MariaDB as default. MariaDB was first shipped with openSUSE 11.3 back in 2010. Over the years it proved itself and starting with 12.3 openSUSE is replacing default MySQL implementation with MariaDB. This means that whole distribution is compiled against MariaDB and in ‘M’ in LAMP means MariaDB from now. As MariaDB is a drop-in …

This is just for testing purposes, but you might want to play around with MariaDB 5.5.29 coming via the CentOS 6 repositories as mentioned in this post. Please test it out and report bugs if required. The process was simple on a fresh install:

yum update
cd /etc/yum.repos.d/
wget http://dev.centos.org/centos/6/mariadb/mariadb.repo
yum list mariadb\*
yum install mariadb-server mariadb
/etc/init.d/mysqld start

That’s it, it just works. It comes with MEMORY, CSV, MRG_MYISAM, BLACKHOLE, MyISAM, PERFORMANCE_SCHEMA, ARCHIVE, FEDERATED, InnoDB (XtraDB) and Aria.

Remember this replaces mysql-libs, and is set to replace MySQL in your install. Here’s hoping it hits mainline CentOS soon.

Related posts:

1. …

Have a look at some MySQL reference architectures

Percona’s Kenny Gryp leads a recent MySQL workshop

Percona will be in Chicago and London the week of April 8th delivering two 2-day MySQL workshops. For our MPB readers, we are offering a 15% discount. Just use MPB15A when purchasing your tickets to one or both MySQL workshops.

• Scaling and Optimization for MySQL on Monday & Tuesday, April 8 & 9
  • This MySQL workshop will cover:
    • Apply architecture scaling strategies that make the most sense, including caching, …

I will be speaking Sunday morning at the Northeast Gnu/Linuxfest in Cambridge, MA. And this year the OpenDB Camp is being held in conjunction. Plus it is a chance to meet those in the MySQL Marinate virtual class.