view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

State of automated recovery via Pseudo-GTID & Orchestrator @

This post sums up some of my work on MySQL resilience and high availability at by presenting the current state of automated master and intermediate master recoveries via Pseudo-GTID & Orchestrator.

Orchestrator & Pseudo-GTID for binlog reader failover

One of our internal apps at audits changes to our tables on various clusters. We used to use tungsten replicator, but have since migrated onto our own solution.

Secrets of a happy Amazon hacker – IAM, MFA & locking down your account

If you’re still using a password to login to your AWS account it’s time you batten down the hatches. With a little work you can dramatically improve security. 1. install command line tools First get ahold of the aws comand line tools. They’re python based so you’ll need the package manager “pip” first.

Thoughts on MaxScale automated failover (and Orchestrator)

Having attended a talk (as part of the MariaDB Developer Meeting in Amsterdam) about recent developments of MaxScale in executing automated failovers, here are some (late) observations of mine.

I will begin by noting that the project is stated to be pre-production, and so of course none of the below are complaints, but rather food for thought, points for action and otherwise recommendations.

pt-online-schema-change and innodb_stats_persistent on MySQL 5.6

Recently we released an updated version of our Percona Toolkit with an important update for pt-online-schema-change if you use MySQL 5.6. A new parameter has been added, analyze-before-swap. What does it do? Let me explain it in more detail.

SQL mini hack of the day, inverted IN clause

We are used to issue queries with an IN clause of the form:

... where state in ('started', 'completed', 'failed') ...

However I've had a few cases where I used an inverted format. Here's one use case followed by an inverted IN clause.

Dynamic query building

Say we have this function:

GetLaggingSlaves(clusterName string)

Logical MySQL backup tool Mydumper 0.9.1 now available

The new Mydumper 0.9.1 version, which includes many new features and bug fixes, is now available.  You can download the code from here.

Oracle OpenStack leveraging MySQL Cluster and Docker

At Oracle Openworld this year, Oracle OpenStack Release 2 was announced. This Kilo based distribution included some new deployment features not see in other OpenStack distros including the use of Kolla, Docker and MySQL Cluster.

view counter