A common way to implement point in time recovery capability is:
to regularly do a full backup of a database, and to save the binary logs of that database (or from its master if doing backups on a slave).
When point in time recovery is required you need to:
restore a backup, and apply the binary logs up to the point of recovery.
(Step # 2 and # b above are the ones that will be simplified
This Log Buffer edition works it way through some of the coolest blog posts from Oracle, SQL Server and MySQL of the past week.
Oracle:
On September 21st, we released Percona XtraDB Cluster 5.6.25. This is the first PXC release supporting proxy-protocol that has been included in Percona Server since 5.6.25-73.0.
With this blog post, I want to promote a new feature that you may have ignored.
Let’s start with a description of the use case:
Architecture Overview:
HAProxy is configured like this:
listen 3307-active-passive-writes 0.0.0.0:3307
mode tcp
balance …[Read more]
Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on October 15th 2015. Binaries are available from downloads area or from our software repositories.
Based on Percona Server 5.6.26-74.0 including all the bug fixes in it, Galera Replicator 3.12, and on …
[Read more]Update 2016-01-30: restarting the IO_THREAD might be considered useful in some situations (avoiding MDEV-9138). Look for "in contrast, if the IO thread was also stopped first" in MDEV-6589 for more information.
In a previous post, I listed some sequences of commands that you should not run on a MariaDB slave that is lagging and which is using the GTID protocol. Those are the following (do not
After seeing that several blogs discuss storage of UUID values into MySQL, and that this topic is recurrent on forums, I thought I would compile some sensible ideas I have seen, and also add a couple new ones.
Different techniques
Say we have a table of users, and each user has a UUID.…
It's Oracle OpenWorld time, and MySQL
Cluster will be in San Francisco again along with the rest of
the MySQL team.
The session agenda is online, but can be tricky to navigate given
the breadth of the conference, but it's possible to narrow down
to those sessions in the MySQL track.
From a MySQL Cluster perspective, there two conference sessions
from the Cluster development team, a Hands-On Lab from our
Cluster Support team and most …
With the recent media attention Volkswagen has gotten, a lot of folks are wondering, how could that happen? Aren’t there checks & balances? Join 32,000 others and follow Sean Hull on twitter @hullsean. Then I ran across this observation on Todd Hoff’s brilliant blog High Scalability Is what Volkswagen did really any different that what … Continue reading Are software benchmarks to blame for Volkswagens woes? →
Release Notes Changelog What is MariaDB 5.5?
MariaDB APT and YUM Repository Configuration Generator
The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.46. This is a Stable (GA) release.
See the Release …
[Read more]In the spirit of sharing war stories and avoiding others to do the same mistakes as I did, here are some sequences of commands that you should avoid to run on a MariaDB slave that is lagging and which is using the GTID protocol. Remember, do not run those because...
So, those bad commands are the following:
"STOP SLAVE; START SLAVE UNTIL ...;", or "STOP SLAVE; START SLAVE;" (to remove an
