Here are the slides for my talk at MySQL connect, 

Backing up the MySQL Database.

• Fact: MySQL 5.6 was released as GA in February 2013
• Fact: MySQL 5.6 has been available with its complete set of features since September 2012
• Fact: On September 21st, Oracle has released MySQL 5.7.2, which is the de facto major release after MySQL 5.6 (5.7.1 was just a token “we’re-still-in-business” release).
• Fact: As of today, there is no GA-ready fork of MySQL 5.6.

Percona Server is still in RC state, while MariaDB, with its runaway version 10, is still in alpha state. Of these releases, Percona Server seems the one in the better shape. Their problem was to adapt Percona Server to the enhanced codebase for 5.6, and the merging problems were bigger than the ones encountered in 5.1 and 5.5. Percona Server is a business oriented fork. It includes specific features for …

Although, hosting the event on a weekend, which is an inconvenience to those who have family, and ignoring the fact that it's Oracle's third MySQL Connect event, I would have to say that this year's Oracle MySQL Connect conference was the best one yet.

This past year, I have been mostly heads-down working at +LinkedIn so I haven't been paying close attention to what Oracle has been doing for +

On September 21st, during the opening keynote at MySQL Connect 2013, Tomas Ulin disclosed the release of MySQL 5.7.2. This is a milestone release that includes several new features. Unlike the Previous one, which was just a point of pride, where Oracle was stating its continuous commitment to releasing new versions of MySQL. In MySQL 5.7.2, we see several new features:

• First and foremost, performance. The announcement slides say MySQL 5.7.2 is 95% faster than MySQL 5.6 and 172% faster than MySQL 5.5. I don’t know yet in which circumstances these numbers hold true, but I am sure someone at Percona will soon prove or disprove the claim.
• Performance Schema tables for several aspects:
  • …

Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).

I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_ol63uek01-LogVol01
                      7.1G  5.7G  1.1G  85% /

As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.

fdisk -l

Will be able to identify the new & unused partition:

[root@ol63uek01 ~]# fdisk -l
Disk /dev/sda: 8589 MB, 8589934592 bytes
 255 heads, 63 sectors/track, 1044 cylinders
 Units = cylinders of 16065 * 512 = 8225280 bytes
 Sector size (logical/physical): 512 bytes / 512 bytes
 I/O size (minimum/optimal): 512 bytes / 512 bytes
 Disk identifier: …

Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).

I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.

Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_ol63uek01-LogVol01
                      7.1G  5.7G  1.1G  85% /

As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.

fdisk -l

Will be able to identify the new & unused partition:

[root@ol63uek01 ~]# fdisk -l
Disk /dev/sda: 8589 MB, 8589934592 bytes
 255 heads, 63 sectors/track, 1044 cylinders
 Units = cylinders of 16065 * 512 = 8225280 bytes
 Sector size (logical/physical): 512 bytes / 512 bytes
 I/O size (minimum/optimal): 512 bytes / 512 bytes
 Disk identifier: …

MySQL Fabric was officially introduced during Tomas his keynote at MySQL Connect 2013. MySQL Fabric will help you managing lots of MySQL server supporting both high-availability and sharding. Just like Connector/J, MySQL Connector/Python v1.1.1 Alpha has support for MySQL Fabric on MySQL Labs. Note that the MySQL Fabric as well as support for it in Connector/Python is Alpha.

When you download MySQL Connector/Python from MySQL Labs, you will also see a ZIP archive containing the MySQL Utilities documentation …

As Tomas announced in his keynote at MySQL Connect 2013, we are working on a brand new product called MySQL Fabric. Along with this release of MySQL Fabric, we are releasing Connector/J 5.1.26 with Fabric support on labs.mysql.com. This is an alpha-quality release that adds support for scalability features in MySQL Fabric. Sharding and read/write splitting are the initial features supported by Connector/J.
In a setup involving read/write splitting or customized sharding, we generally have to duplicate knowledge of this configuration in the client applications. This is done in connection strings specified in configuration files or directly in code. With MySQL Fabric, we can express our system-wide configuration of database servers in a way that it can be accessed by client applications. In cases where this needs to change (and it always does..), the configurations affecting client applications no longer need to be changed. The connector will …

Oracle OpenWorld 2013 is just days away, and Pythian is once again everywhere at OOW. Pythian’s famous Annual Oracle Bloggers Meetup — one of your top favorite events of OpenWorld, is once again here at OOW.

Oracle:

As this year is heading to a close, it will complete 21 years of partnership between Intel and Oracle.

Have you started to pay closer attention to social, cloud, mobile, and/or big data technologies and trends?

NetBeans IDE 7.4 RC 1, released today, has a long list of features, including support for …

MySQL 5.6 introduced the TTS(transportable table spaces) feature which enables moving a table from one server to another. This feature coupled with MEB 3.9 enables backing up a set of tables matching (regex specified with) the –include option.

The backup of selective tables using transportable tablespaces feature of innodb is referred as tts/selective backup in the remainder of the section.

The difference between a regular partial backup and with using tts is that the regular partial backups are stand alone and cannot be plugged into a another server where as the tts backups in contrast enables the tables to be plugged into another server instance

The …