This week we discuss features of Percona Server 5.6 compared to MySQL 5.6. Ear Candy is about pt-upgrade, and At the Movies is a set of lightning talks.
Events
DB Hangops -
every other Wednesay at noon Pacific time
Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center
Training
SkySQL Trainings
Extreme performance is the key to excellence. One example of it is the winning of 34th America Cup by Team Oracle USA, another example is the Pythian’s legendary love of data, and this Log Buffer edition loves the blogs again, as it does weekly.
Oracle:
The 10 commandments of being a good DBA manager.
Oracle ADF Mobile #{row.index} is Not Supported After Installing Upgrade Patch
With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted.
The …
[Read more]Percona is glad to announce the release of Percona Monitoring Plugins 1.0.5 for MySQL. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.
Changelog:
* Added mysql-ca option to ss_get_mysql_stats.php (bug
1213857)
* Added user info to the idle_blocker_duration check of
pmp-check-mysql-innodb (bug 1215317)
* Extended pmp-check-mysql-processlist with more locking states
(bug 1213859)
* ss_get_mysql_stats.php did not work with custom mysql port (bug
1213862)
* ss_get_mysql_stats.php silently failed when a query returns too
many rows (bug 1225070)
* Wrong description of percona-cacti-templates deb package (bug
1217782)
A new tarball is available from …
[Read more]Since I joined the company in late 2010, I have known that one of the strong points of Tungsten Replicator is its ability of setting filters. The amazing capabilities offered by Tungsten filters cannot be fully grasped unless we explain how stage replication works.
There are several default stages in the replication stream. Every stage has an extraction task and an apply task. The extraction task will get data from the previous step repository and the apply task will save the data to the next repository, which can be either a temporary storage (memory queue, THL file) or the final destination (slave database server). Consider that the architecture allows developers to add stages, and you will appreciate its full power. For every stage, we can insert one or more filter between the two tasks. …
[Read more]
I recently had a case where replication lag on a slave was caused
by a backup script. First reaction was to incriminate the
additional pressure on the disks, but it turned out to be more
subtle: Percona XtraBackup was not able to execute FLUSH
TABLES WITH READ LOCK due to a long-running query, and the
server ended up being read-only. Let’s see how we can deal with
that kind of situation.
In short
Starting with Percona XtraBackup 2.1.4, you can:
lock-wait-threshold,
lock-wait-query-type and
lock-wait-timeout options
kill-long-queries-timeout and
kill-long-query-type settings
Full documentation is …
[Read more]Over a year ago now, I announced the first Percona Server 5.6 alpha on the Percona MySQL Performance Blog (Announcing Percona Server 5.6 Alpha). That was way back on August 14th, 2012 and it was based on MySQL 5.6.5 released in April.
I’m really happy now to point to the release of the first GA release of Percona Server 5.6 along with some …
[Read more]It’s getting close to time to head to Auckland for OSDC and a few days ago I blogged about how I’m speaking there). I’ll be speaking on MySQL In the Cloud, As A Service and all of the challenges that can entail as well as on The Agony and Ecstasy of Continuous Integration. Both of these talks draw heavily on the experience of Percona (my employer) and with experience from helping customers with all sorts of MySQL deployments and in our experience in producing our own high quality software.
I was in Auckland earlier this year, so thought I’d share some pictures of the wonderful city in which OSDC is being held.
Firstly, New Zealand has some pretty awesome wildlife. This is …
[Read more]For those of you wishing to capitalize on your hard-earned MySQL skills, there are two new MySQL certifications based on MySQL version 5.6:
Are you unsure of the steps needed to get your Continuent Tungsten cluster up-and-running? In this virtual course, we teach you how to get from a single database server to a scalable cluster, or from a brittle MySQL replication system to a transparent, manageable Tungsten cluster.
We discuss the benefits of leveraging Continuent Tungsten clustering with MySQL, and walk you through the steps