Tag - MySQL

Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care?

High Availability Solutions

High Availability Solutions. Shutterstock.com
In this series of blog posts, I’m going to look at some high availability reference architecture solutions over geographically distributed areas.
The Problem
Nowadays, when businesses plan a new service or application, it is very common for them to worry about ensuring a very high level of availability. 
It doesn’t matter if we […]

Read more

Maintenance Windows in the Cloud

maintenance windows cloud

Recently, I’ve been working with a customer to evaluate the different cloud solutions for MySQL. In this post I am going to focus on maintenance windows and requirements, and what the different cloud platforms offer.
Why is this important at all?
Maintenance windows are required so that the cloud provider can do the necessary updates, patches, and […]

Read more

CRITICAL UPDATE for Percona XtraDB Cluster users: 5.7.23-31.31.2 Is Now Available

Percona XtraDB Cluster 5.7

To resolve a critical regression, Percona announces the release of Percona XtraDB Cluster 5.7.23-31.31.2 on October 2, 2018 Binaries are available from the downloads section or from our software repositories.
This release resolves a critical regression in Galera’s wsrep library and supersedes 5.7.23-31.31
(more…)

Read more

Percona XtraDB Cluster 5.7.23-31.31 Is Now Available

Percona XtraDB Cluster 5.7

This release has been superseded by 5.7.23-31.31.2 after a critical regression was found. Please update to the latest release.
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.23-31.31 on September 26, 2018. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.7.23-31.31 is now the current release, based on the […]

Read more

Percona XtraDB Cluster 5.6.41-28.28 Is Now Available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.6.41-28.28 (PXC) on September 18, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.41-28.28 is now the current release, based on the following:

Percona Server for MySQL 5.6.41
Codership WSREP API Rrelease 5.6.41
Codership Galera library 3.24

Fixed Bugs

PXC-1017: Memcached API is now disabled […]

Read more

Fixing ER_MASTER_HAS_PURGED_REQUIRED_GTIDS when pointing a slave to a different master

gtid auto position

GTID replication has made it convenient to setup and maintain MySQL replication. You need not worry about binary log file and position thanks to GTID and auto-positioning. However, things can go wrong when pointing a slave to a different master. Consider a situation where the new master has executed transactions that haven’t been executed […]

Read more

Percona XtraDB Cluster 5.7.22-29.26 Is Now Available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.7.22-29.26 (PXC) on June 29, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.7.22-29.26 is now the current release, based on the following:

Percona Server for MySQL 5.7.22
Galera/Codership WSREP API Release 5.7.21
Galera Replication library 3.23

Deprecated
The following variables are deprecated starting from this […]

Read more

Percona XtraDB Cluster 5.6.40-26.25 Is Now Available

Percona XtraDB Cluster 5.7

Percona announces the release of Percona XtraDB Cluster 5.6.40-26.25 (PXC) on June 20, 2018. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.40-26.25 is now the current release, based on the following:

Percona Server for MySQL 5.6.40
Galera/Codership WSREP API Release 5.6.39
Galera Replication library 3.23

All Percona software is open-source and free.
New […]

Read more

PXC loves firewalls (and System Admins loves iptables)

PXC and setting firewalls using iptables

Let them stay together.
In the last YEARS, I have seen quite often that users, when installing a product such as PXC, instead of spending five minutes to understand what to do just run
iptables -F  and save.
In short, they remove any rules for their firewall.
With this post, I want to show you how easy […]

Read more