The Web And PHP Magazine just published an article describing Percona XtraDB Cluster written by Liz van Dijk and Kenny Gryp. It is a pretty high-level introduction to the technology, so definitely give it a read if you’ve been wanting to give it a closer look.
Go to their website http://www.webandphp.com and download Issue number 9 for free!
On Monday I will deliver with Seppo Jaakola from Codership a tutorial on Percona XtraDB Cluster (Percona Server + Galera).
Already in London and you don’t know how to consume the hotel’s bandwidth ? If you attend this tutorial, you can download the Virtual Box appliance we will use during the session.
Two versions are available:
How to test them:
If you are interested by a great and revolutionary HA solution for MySQL or even if you already have some experience with PXC and/or Galera, I invite you to attend the tutorial I will deliver in Percona Live MySQL Conference London 2012 (PLUK2012), December 3rd : Percona XtraDB Cluster in a nutshell.
Small amount of theory and a lot of exercises and examples to really tame the beast that PXC is !
A Codership engineer will also be present and happy to help me answering your questions.
Note to attendees: please bring your laptop with a recent Virtual Box installed and enough free space to store 3 VMs (+/-2G per VM). As said …
[Read more]The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.6. This is the sixth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools.
The complete list of changes is on the Launchpad milestone for 2.1.6, but here are some highlights the release:
Remember that if you need help with Percona Toolkit, we provide flat-fee, unlimited support services with rapid 24×7 response on a …
[Read more]
The idea to use SSD/Flash as a cache is not new, and there are
different solutions for this, both OpenSource like L2ARC for ZFS
and Flashcache from Facebook, and proprietary, like
directCache from Fusion-io.
They all however have some limitations, that’s why I am
considering to have L2 cache on a database level, as an extension
to InnoDB buffer pool.
Fortunately, there is a project in progress Flash_Cache_For_InnoDB by David which
implements this.
David helped us to port his work to the latest Percona Server and
you can get it from our launchpad Percona Server 5.5.28 …
Percona is glad to announce the release of Percona XtraBackup 2.0.3 on October 1st, 2012. Downloads are available from our download site here and Percona Software Repositories.
This release is the current GA (Generally Available) stable release in the 2.0 series.
New Features:
Bugs Fixed:
The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.4. This is the fifth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools.
The complete list of changes is on the Launchpad milestone for 2.1.4, but here are some highlights the release:
All in all, a solid bug-fix release, with the addition of some new features too.
Remember that if you need …
[Read more]I recently worked through an issue with a client trying to detect data drift across some servers that were located in different timezones. Unfortunately, several of the tables had timestamp fields and were set to a default value of CURRENT_TIMESTAMP. From the manual, here is how MySQL handles timezone locality with timestamp fields:
Values for TIMESTAMP columns are converted
from the current time zone to UTC for storage, and from UTC to
the current time zone for retrieval.
This can result in every row being deemed out of sync when each server is using in it’s own timezone. Fortunately, there is a workaround for this as a result of how pt-table-checksum/pt-table-sync calculate their …
[Read more]
Not so long ago Fusion-io announced an SDK which provides direct
API access to Fusion ioMemory(tm) in addition to providing a
native filesystem (directFS) with a goal to avoid overhead from
kernel and regular Linux filesystems: ext4 and xfs. This requires
a support from application, it should use special calls for IO.
With help from Fusion-io, we provide source code of Percona
Server which uses direct API access. The main idea that with this
functionality you can disable “innodb-doublewrite”, retain ACID
compliance by using atomic writes, and in IO intensive workloads
gain an additional 30-50% in throughput when compared to
workloads on the same ioMemory™ device using an unmodified
Percona Server. Further benchmarking results on latency
variability reduction expected soon.
Percona Server 5.5.27 with Fusion-io atomic writes is available
from Launchpad repository: …
Yesterday, over at my personal blog, I blogged about the impact of the MySQL slow query log. Since we’re working on Percona Server 5.6, I did wonder if this was a good opportunity to re-examine how we could provide slow query log type functionality to our users.
The slow query log code inside the MySQL server does several things that aren’t good for concurrency on modern systems. For starters, it takes a mutex while both doing formatting of what to write and while doing the write(2) system call itself. This is, in fact, entirely unneccesary.
From the man page for the write system call:
If the file was open(2)ed with O_APPEND, the file offset is first set to the end of the file before writing. The adjustment of the file offset and the write operation are performed as an atomic step.
So we can …
[Read more]