I spotted this checklist attached to a Worklog for an upcoming change in MySQL 5.7.3 (not yet released). What it is, is a series of Yes/No questions to be answered by developers, which is used as part of the QA process.

1. Any new/modification in syntax introduced
2. Any change in existing behavior of SQL
3. Any change in mysql protocol
4. Any change in result formatting or data types
5. Any change in INFORMATION_SCHEMA and PERFORMANCE_SCHEMA
6. Concurrency testing Required
7. Any lock/deadlock testing required
8. Any multi user/client testing
9. Do you expect any data race, Data Corruption when multiple users request
10. Boundary value testing
11. Replication testing is needed
12. Any change in binary log formats
…

The term "bet the company" means that a company, large or small, puts everything it has in one big move. Betting the company when the company is small is one thing, this happens every day (you can say that MySQL did this, but they did it when they were small and and there wasn't really much to bet with). It is true that Henry Ford bet the company on the T-Ford, but at that time Ford really wasn't that big when Henry Ford started building the Model T using the Assembly Line which meant that the cars could be made much less expensive.

But how often do you see a major company betting itself on one single product line? Not that often I say, but that might be because I do not know industries outside IT and Cars that well, and also you tend to forget the failures and the associated companies.

One reasonably well-known failure was the Schlitz Brewing Company that went downhill in the early 1980's after betting on new …

This week we finish our 2-part series on xtrabackup. Ear Candy is changing the sorting behavior of GROUP BY and At the Movies is a talk on performance schema.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events

Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center, with a community dinner on the 11th.

read more …

In English there are very few words of Japanese origin but I think this one has a great future: mojibake. Mojibake is the garbage you see when MySQL or MariaDB has a column definition saying character set A, stores into it a string that's actually in character set B, then ships it to a client which expects everything to be in character set C.

For some DBMSs (Drizzle and NuoDB spring to mind) it's apparent that the developers decided that users could avoid mojibake, and developers could avoid a lot of extra trouble, if everybody had the same character set: UTF-8. Well, MySQL and MariaDB have web users and UTF-8 is popular on the web. According to Web Technology Surveys, 80% of web …

Tuesday, 29 October 2013Author: tcallwayHang out with the MariaDB Team
Drinks are on us!

To celebrate MariaDB's participation at Percona Live London, we invite you to join us for FREE drinks on Monday 11th of November from 4pm to 7pm at:

Hereford Arms
127 Gloucester Road
South Kensington
London SW7 4TE
United Kingdom

Join the MariaDB Team for free beer, wine and snacks at this beautiful traditional Victorian pub. Just show your Percona Live badge at the bar.

Show up and join our prize draw: win a copy of the brand new Getting started with MariaDB published in October 2013 by our very own Daniel Bartholomew, or a Logitech Boombox - a wireless speaker that connects by Bluetooth to your smartphone or laptop.

The Hereford Arms is only 2 mins walk away from Percona Live …

There is a bug report about missing YUM and APT repositories. So that’s mostly fixed now http://bugs.mysql.com/bug.php?id=60833

Congratulations to the MySQL team on this!

[…] I think most people will agree that downloading RPMs from a website is kind of old fashioned when there are yum repos. After a number of user requests, we have now launched the official yum repos for MySQL. […]

I think most people will agree that downloading RPMs from a website is kind of old fashioned when there are yum repos. After a number of user requests, we have now launched the official yum repos for MySQL.

Can’t wait? Neither can I. On a fresh install:

1. Download a setup package for your distribution from http://dev.mysql.com/downloads/repo
   
2. yum localinstall mysql-community-release-distro-release.noarch.rpm
3. yum update
4. yum install mysql-community-server

This works for fresh installs. If you’re upgrading from an older version, read about upgrading first.

…

The MySQL Engineering Team at Oracle is excited to announce availability of Yum repositories for MySQL, making new releases of MySQL Database and related products easily accessible using Yum.  This initial release is focused on EL6-based distros as well as Fedora 18 and 19, and provides easy access to the most recent GA releases of our most popular products:

• MySQL Database 5.6
• MySQL Workbench 6.0
• MySQL Connector/ODBC 5.2

We expect to expand this in the future to offer additional MySQL products and versions using these repositories, as well as repositories for additional Linux distributions.

This effort benefits both end users and Linux distributions.  Users will have additional choice in deploying specific versions of MySQL products using …