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
While it shares the same heritage with MySQL, MariaDB is a different database. Over the years as new versions of MySQL and MariaDB were released, both projects have differed into two different RDBMS platforms.
MariaDB becomes the main database distribution on many Linux platforms and it’s getting high popularity these days. At the same time, it becomes a very attractive database system for many corporations. It’s getting features that are close to the enterprise needs like encryption, hot backups or compatibility with proprietary …
[Read more]After upgrading the server many users start it with an unchanged config file only to find some deprecated options that they were using are no longer supported by the later server version, which causes the upgraded server to shutdown. In other cases modifying the server configuration file results in the server refusing to start when an invalid name is mistakenly entered in the configuration file.…
Facebook Twitter LinkedIn
The MariaDB Foundation is pleased to announce the availability of MariaDB 10.4.6, the first stable release in the MariaDB 10.4 series, and MariaDB Connector/J 2.4.2, the latest stable release in the MariaDB Connector/J 2.4 series. See the release notes and changelogs for details. Download MariaDB 10.4.6 Release Notes Changelog What is MariaDB 10.4? MariaDB APT […]
The post MariaDB 10.4.6, First Stable 10.4 Release, and MariaDB Connector/J 2.4.2 Now Available appeared first on MariaDB.org.
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]Just a reminder for the shows where you can find MySQL at this week, please find them below:
GigaCon - OS Business, Warsaw, Poland, Jun 18, 2019
MySQL 8.0 introduces many new features. We will have a look at the exciting histogram feature in MySQL 8.0
Histogram:
What is Histogram?
In General, a histogram is an accurate representation of the distribution of numerical data. In MySQL, It will be useful to collect data distribution for a specific column.
What problem it solves?
In general DB Optimizer gives us the best execution plan, But the stats make the execution plan better and better .The data distribution of values in columns can make good impact in optimiser in case of column with less distinct values.
We will see an example of how it helps optimizer in some cases.
I have used a production case. MySQL version is 8.0.15 installed in ubuntu 18.04 (32GB RAM,8 core) with optimal configuration. Let us try to optimise a …
[Read more]Welcome to our new blog series Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog). This series will discuss the features of SQL Diagnostic Manager for MySQL designed to enable organizations to scale their existing resources for database administration. This week, we focus on the challenges associated with MySQL and MariaDB database systems.
The MySQL and MariaDB database systems are rapidly becoming the de-facto choice for traditional enterprises as well as pioneering Web 2.0 companies. Webyog has been consistently delivering powerful tools exclusively on the MySQL and MariaDB platform for the last 15 years.
While the adoption rate of MySQL and MariaDB continues to grow in momentum, it poses some unique challenges for traditional database administrators and their organizations. Some of these challenges are:
MySQL 8.0 : Error Logging
Here I would like to explain, How MySQL 8.0 server can be
configured to log diagnosis messages inside the error log
file.
Generally, the error log contains:
Error Log Component Configuration MySQL 8.0 uses the MySQL error log component architecture that performs log …
[Read more]