Earlier this week we pushed to Github the eighth iteration of Twitter MySQL. Here are some of the highlights. But, before that, a quick plug. If you are looking for a new opportunity and enjoy working on database internals, we should talk!

Bugs Fixed

• Bug#67433: Using SET GLOBAL SQL_LOG_BIN should not be allowed Earlier in MySQL 5.5 development cycle, the SQL_LOG_BIN variable was made to be both global and session-scoped, instead of only session as it was in previous releases. We believe that usage of SQL_LOG_BIN at the global scope can be quite dangerous and offers little to no benefit, hence we made SQL_LOG_BIN once again a session-only variable, generating an error if it is used with SET GLOBAL.
• Bug#67476: …

A few years ago I wrote a tool to extract a subset of data from a production database for use in QA and development environments. My goal was to have some real data for functional testing, but to make the data set small enough that a developer could easily download it and install it on their laptop in a few minutes.

I implemented the tool using mysqldump. As I have maintained the tool over the years I've employed a couple of different approaches, each of which I will describe in more detail below.

The first step was to identify the records I wanted to include in my subset. I created a couple of tables to store the ids of the records I wanted, and then some queries to populate those tables based on various criteria.

For example, say I want to dump the data for the 10 shortest PG rated movies in the sakila database. Here's an example of …

A few years ago I wrote a tool to extract a subset of data from a production database for use in QA and development environments. My goal was to have some real data for functional testing, but to make the data set small enough that a developer could easily download it and install it on their laptop in a few minutes.

I implemented the tool using mysqldump. As I have maintained the tool over the years I've employed a couple of different approaches, each of which I will describe in more detail below.

The first step was to identify the records I wanted to include in my subset. I created a couple of tables to store the ids of the records I wanted, and then some queries to populate those tables based on various criteria.

For example, say I want to dump the data for the 10 shortest PG rated movies in the sakila database. Here's an example of …

A few years ago I wrote a tool to extract a subset of data from a production database for use in QA and development environments. My goal was to have some real data for functional testing, but to make the data set small enough that a developer could easily download it and install it on their laptop in a few minutes.

I implemented the tool using mysqldump. As I have maintained the tool over the years I've employed a couple of different approaches, each of which I will describe in more detail below.

The first step was to identify the records I wanted to include in my subset. I created a couple of tables to store the ids of the records I wanted, and then some queries to populate those tables based on various criteria.

For example, say I want to dump the data for the 10 shortest PG rated movies in the sakila database. Here's an example of …

Percona is glad to announce the release of Percona XtraDB Cluster on November 15th, 2012. Binaries are available from downloads area or from our software repositories.

Features:

• Percona XtraDB Cluster has ported Twitter’s MySQL NUMA patch. This patch implements improved NUMA support as it prevents imbalanced memory allocation across NUMA nodes.
• Number of binlog files can be restricted when using Percona XtraDB Cluster with the new …

We have released SQLyog MySQL GUI 10.4. The 2 major new features are:

* Autocomplete speed/performance is drastically increased. This is the 3rd time we do this actually since autocomplete was introduced in SQLyog 5+ years ago. Our autocomplete implementation is one of the highest appreciated features of SQLyog according to a survey we did among registered users recently. However some slugginess could occur with a very large number (tens of thousands) databases on the server or a similar number of  tables or other objects in a database. Also a number of small bugs in autocomplete were fixed.

* Also when having a lot of databases, tables or other objects, operating a GUI tool may be tedious to work with (you may need to do a lot of scrolling, for instance). In this release we have implemented a filter in the Object Browser. It works like this: Database objects, where the typed …

We've introduced a default my.cnf / my.ini file for MySQL Server that you can now see in the 5.6.8 release candidate:

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

# basedir = .....

# datadir = .....

# port = .....

# socket = …

SkySQL™ Cloud Data Suite now comes with 4 nodes system on AWS Plus: AWS tips & tricks, updated administration console, new video tour & more

As with all new open source software products, updates are a continuous process and we’ve been busy since the launch of the SkySQL™ Cloud Data Suitelast September! Here is a snapshot of the latest developments with our Cloud Data Suite, a collection of software components that provides a highly available database solution in a cloud environment, based on MySQL & MariaDB, deployable in the Amazon Cloud, i.e. AWS.

read more

I may not work on many MySQL related things any more but there are some MySQL ecosystem events that I am participating in.

First there is Percona Live London.  This event is on the 3rd and 4th of December at The Millennium Gloucester Conference Centre.  At this event I will be giving a talk on MySQL Compatible Open Source Connectors.  This will cover alternatives to the standard connectors and how to use them, it will be useful if you find the licensing behind the standard connectors prohibiting.  There is also a 40% off discount code you can use when registering, simply enter the promo code "Come2mytalk".

On the 2nd and 3rd of February is FOSDEM.  At …

The M of the LAMP stack and the #1 database for Web-based applications, MySQL is also an extremely popular choice as embedded database.

Access our Resource Kit to discover the top reasons why:

• 3,000 ISVs and OEMs rely on MySQL as their embedded database
• 8 of the top 10 software vendors and hundreds of startups selected MySQL to power their cloud, on-premise and appliance-based offerings
• Leading mobile and SaaS providers ensure continuous service availability and scalability with lower cost and risk using MySQL Cluster.

Learn how you can reduce costs and accelerate time to market while increasing performance and reliability. Access white papers, webinars, case studies and other resources in our …