Drew Blas (System Engineer, Chargify.com) talks about their data center migration and how they use Continuent Tungsten, at Mountain West Ruby Conference 2013.

We just released our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt backups on the fly (full documentation here). This feature is different than simply piping the backup stream through the openssl or gpg binaries, which is what some people have used in the past. A big benefit of using the built-in encryption is that multiple CPU cores can be used for encryption (with the --encrypt-threads option). You can also combine compression and encryption, each using multiple CPU cores.

One advantage of …

MariaDB is very happy to be accepted as a project in the Google Summer of Code 2013. This will be our first year participating and we’re stoked that we’re one of the accepted organizations. We have an ideas list as always, and we’re expecting to get some great mentors & students to hack on some new code for the MariaDB project (which now comprises not just the server, but Galera Cluster as well as the connectors). Watch this space for more information, but if you’re interested in hacking on MySQL, MariaDB, Galera Cluster or some of the Percona toolkit, and it’s a summer’s worth of work, this should be a lot of fun!

MySQL 5.6 includes a host of enhancements to replication, enabling DevOps teams to reliably scale-out their MySQL infrastructure across commodity hardware, on-premise or in the cloud.

One of the most significant enhancements is the introduction of Global Transaction Identifiers (GTIDs) where the primary development motivation was:

- enabling seamless failover or switchover from a replication master to slave

- promoting that slave to the new master

- without manual intervention and with minimal service disruption.

You can download the new MySQL Replication High Availability Guide to learn more. …

MySQL steps up to #2, passing SQL Server.

This year I have two sessions and one panel discussion.

- Practical failover design - automated, semi-automated and manual failover (24 April 11:10am - 12:00pm)
- Practices for reducing MySQL database size (25 April 12:50pm - 13:40pm)
- MySQL at Facebook: lots and lots of small data (25 April 1:50pm - 2:40pm, together with Mark, Harrison and Domas)

At HA session I'll speak about lessons learned at DeNA and Facebook.. I have used …

This article was inspired by problems on low level workloads initially reported by Peter Zaitsev (Is MySQL 5.6 is slower than 5.5?, and then Why mysql performance at low concurrency is important) and Mark Callaghan (MySQL 5.6 single-threaded read-only, MySQL 5.6 single-thread update-only, MySQL 5.6 - incomplete perf-guide..)..

Sorry, it'll be long.. :-)

Of course the …

The April DB Engines rank show that MySQL has passed SQL Server to become the second highest ranked database management system.

MySQL overtakes SQL Server

Congratulations to my fellow MySQL-ers at Oracle — your hard work is being noticed.

In case you missed it, MySQL Utilities 1.3.0 (alpha) was released last week.  MySQL Utilities is a component of MySQL Workbench, but it’s been broken out into a separate download allowing command-line users access unencumbered by a pretty GUI interface.  Plus, it has some new features – most importantly to me, a utility (mysqlfrm) which can read .FRM files and produce CREATE TABLE statements as a result.  This will be very useful for recovery processes, in conjunction with InnoDB transportable tablespaces in situations where the InnoDB system tablespace is corrupted, and you don’t know the exact table definition.

…

This week, we take a lighter topic and talk about the many uses and meanings of "binary". Ear candy is a but about SET GLOBAL SQL_BIN_LOG, and At the Movies is Ariel Weisberg of VoltDB explaining sharding and elastic clustering.

Events
DBA Hangops - an every-other-week hangout for dba's (right now it's mostly MySQL) - The DB hangops sessions for April and May are April 10th, April 24th, May 8th and May 22nd.

Upcoming MySQL tech tours

Call for Papers for MySQL Connect is open! The call closes Friday, April 12th.

read more