I'm looking forward to presenting, along with Peter Boros, Jim
Cooley and Vipul Sabhaya, at the Percona Live Conference the week
of April 22nd where I will be giving two talks about the
management of MySQL using Chef (http://www.percona.com/live/mysql-conference-2013/sessions/managing-mysql-chef
24 April 4:30pm - 5:20pm @ Ballroom A) and Red Dwarf, the
Openstack project that HPCS is using for DBaaS (http://www.percona.com/live/mysql-conference-2013/sessions/reddwarf-database-service-openstack-project
25 April 11:00am - 11:50am @ Ballroom C).
I wanted to do a Chef talk, despite my on-again, off-again
love/hate relationship with Chef (AKA learning process) because
for the past year or so, I have …
Apr
10
2013
Apr
10
2013
Stick around one more day for the 2nd Annual MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB
Apr
10
2013
Apr
10
2013
Drew Blas (System Engineer, Chargify.com) talks about their data center migration and how they use Continuent Tungsten, at Mountain West Ruby Conference 2013.
Apr
10
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 …
[Read more]
Apr
10
2013
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!
Apr
10
2013
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. …
[Read more]
Apr
10
2013
MySQL steps up to #2, passing SQL Server.
Apr
10
2013
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 …
Apr
10
2013
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 …