Percona is glad to announce the release of Percona XtraDB Cluster 5.6.44-28.34 on June 19, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.6.44-28.34 is now the current release, based on the following:
All Percona software is open-source and free.
Bugs Fixed
The Question Recently, a customer asked us:
We were wondering if the Connectors would be able to bind to
localhost/127.0.0.1 instead of
0.0.0.0:3306? Since the Connector is installed on
the application servers, all of the connections are coming from
localhost. We would like to limit this exposure so
that the 3306 port is not exposed externally. We ask
because we are failing PCI checks that are able to access the
database port externally.
The Answer YES!
You may set the IP address for the Connector to listen on by
using the tpm command option:
property=server.listen.address={IP_ADDRESS}
To force the Connector to listen on the localhost only use the following example:
shell> tools/tpm configure alpha --property=server.listen.address=127.0.0.1 shell> tools/tpm update --replace-release
Use the IP …
[Read more]ProxySQL is a great tool. It’s one of the most recommended technologies in our Open Source Database practice.
Many of our clients are running it or are migrating towards it, but we’ve seen that it is pretty CPU-intensive. We’ve also seen strange behavior in the connection handling when reaching the CPU saturation point.
At this point, we noticed that the frontend_connections counter in the stats_mysql_users table was not decreasing even after the connections were no longer present at the network level. This counter is used to check the max_connections value in the mysql_users configuration table, causing frontend connections to receive a “Too many connections” error. So we determined that the key element here is to scale it properly. Obviously, all the major cloud providers can help us here as they all have features like auto-scaling groups.
Jervin Real of Percona has recently …
[Read more]Overview The Skinny
In this blog post we will discuss how to use the Tungsten Connector keep-alive feature to ensure long-running MySQL & MariaDB/Percona Server client sessions stay connected in a Tungsten Cluster.
Agenda What’s Here?
Tungsten Connector: A Primer A Very Brief Summary
The Tungsten Connector is an intelligent MySQL database proxy located between the clients and the database servers, providing a single connection point, while routing queries to …
[Read more]We were pleased to sponsor the Percona Live Conference in Austin this year: many thanks to the Percona Team for organising a smooth conference yet again!
This is the recap of our week in Texas!
At The Conference
This year’s conference was the first one not taking place in Santa Clara, CA, but rather in Austin, TX. This turned out to be a nice choice by Percona, as it meant that open source database users who may not have travelled to California in the past, were attracted to the new location; and Austin being the new hot spot for (tech) companies at the moment, a lot of “locals” seemed to have made the choice to attend the conference. It was great to meet many new faces as a result.
As Diamond Sponsors of the conference we were of course present
with a booth in the exhibition hall, as well as with three
talks.
And while the hotel looked slightly dystopian at night, it was in fact a nice and …
[Read more]Overview The Skinny
When it comes to zero downtime, proxies are the first line components of a cluster.
In order to achieve High Availability (HA) for MySQL, MariaDB and Percona Server, a commonly deployed setup consists of configuring load balancers (hardware or software) on top of those proxies.
A Strong Architecture How is Maintenance Made Possible?
With this proxy + load balancer architecture, server maintenance is made possible on any of the proxy hosts, as follows:
The Problem What Happens to Existing Sessions?
But wait… even though new connections are re-routed correctly, what happens …
[Read more]Background The Skinny
Performing schema changes often requires extended downtime for
applications. This is due to MySQL needing to rebuild tables for
common schema change operations. Tools like
pt-online-schema-change have been written to try to
overcome the downtime associated with schema changes, however
they are complex and put a high load on the database. Amazon’s
Aurora improves some schema changes operations, but still
requires a table rebuild for common operations like adding a
column using before or after, or simply
to add a column with a default value. Rebuilding a
table with millions of rows can take hours and prevent writes to
that table the entire time.
How Can Tungsten Clustering Keep Applications Running? How Does It All Work?
…
[Read more]PALO ALTO, Calif., June 6, 2019 – ScaleGrid, the Database-as-a-Service (DBaaS) leader in the SQL and NoSQL space, has announced the expansion of their fully managed MySQL Hosting services to support Amazon Web Services (AWS) cloud. The platform allows MySQL AWS administrators to automate their time-consuming database operations in the cloud and improve their performance with high availability, disaster recovery, polyglot persistence, and advanced monitoring and analytics.
Over the years, migrating data to the cloud has become a top priority for organizations looking to modernize their infrastructure for improved security, performance, and …
[Read more]Presentation of some of the new features of MySQL 8.0.16 released on April 25, 2019
Today we’re happy to announce that we’ll be partnering with Datavail to provide solutions for continuous & highly available MySQL, Percona Server & MariaDB database operations based on Tungsten Clustering & Datavail Database Services.
Datavail is a renowned, tech-enabled data management, applications, business intelligence, and software solutions provider with a team of 700+ DBAs that look after customers’ database environments.
What are we aiming for?
Together we’re looking to continue to drive momentum in supporting rapid MySQL & MariaDB based application deployments as well as highly available and scalable database implementations for existing and future customers.
This new …
[Read more]
