by Peter Zaitsev | Jan 13, 2020 | MySQL, Storage Engine
A few days ago I wrote about how grossly outdated statistics returned through MySQL’s Information_Schema can be. In that post, Øystein Grøvlen suggested taking a look at mysql.innodb_table_stats and mysql.innodb_index_stats as a better source of information. Let’s do...
by David Quilty | Jan 13, 2020 | MySQL, Webinars
During this webinar, we will review the MySQL 8.0 upgrade process. In this deep dive session, we will review the latest version of MySQL 8.0, discuss upgrade challenges, bugs, gotchas and how to successfully upgrade to MySQL 8.0. Please join Percona Senior Technical...
by Alkin Tezuysal | Jan 13, 2020 | Cloud, Database Trends, Insight for DBAs, MySQL
In this blog post series, we will discuss an overview of Vitess technology. Vitess is a database clustering solution for horizontal scaling of data sets currently suitable to 250Gb – 300Gb in sizes*. It’s a proven technology used by several web-scale companies...
by Marco Tusa | Jan 10, 2020 | MySQL, Percona Software
In the many years we have used MySQL, we got accustomed to the fact that upgrades from MySQL 5.7.11 to 5.7.12 was a minor event. This meant that if something was going wrong, we could roll back the binaries and be happy again. From MySQL 8, this is no longer true....
by Walter Garcia | Jan 10, 2020 | MySQL, Percona Software, ProxySQL
If you are thinking of using ProxySQL in our Percona XtraDB Cluster environment, I’ll explain how to use ProxySQL 2 for failover tasks. How to Test ProxySQL uses the “weight” column to define who is the WRITER node. For this example, I’ll use...
by Daniel Guzmán Burgos | Jan 9, 2020 | MySQL, Percona Software
The importance of having periodic backups is a given in Database life. There are different flavors: binary ones (Percona XtraBackup), binlog backups, disk snapshots (lvm, ebs, etc) and the classic ones: logical backups, the ones that you can take with tools like...
by Peter Zaitsev | Jan 8, 2020 | MySQL
MySQL obviously got many things right, otherwise, it would not be the World’s Most Popular Open Source Database (according to DB-Engines). Sometimes, however, I run into some decisions or behaviors which are just plain bad designs. Many such designs have a lot of...
by Vinicius Grippa | Jan 8, 2020 | Monitoring, MySQL
Percona Monitoring and Management (PMM) has been on the road for a while now, and it brings exciting new features and improvements. For those who are not familiar with the tool, PMM allows deep insight into the performance of applications and databases. The most...
by Ananias Tsalouchidis | Jan 7, 2020 | MySQL, Security
The Case Securing MySQL is always a challenge. There are general best practices that can be followed for securing your installation, but the more complex setup you have the more likely you are to face some issues which can be difficult to troubleshoot. We’ve recently...
by Michael Patrick | Jan 6, 2020 | Database Trends, Insight for DBAs, Percona Services
So, what do you do when you love technology but are ready for a change in the day-to-day activities of a DBA? One consideration is to become a Technical Account Manager, or TAM for short. At Percona, a TAM is an account manager who is also technical (the big...
by Zsolt Parragi | Jan 6, 2020 | MySQL, Percona Software, Security
Starting with Percona Server for MySQL 8.0.17, Percona Server ships with a data masking plugin, using the same API as the MySQL Enterprise Masking and De-identification feature. This plugin was developed by MySQL Enterprise plugin. What is Data Masking? The data...
by Terri Schlosser | Jan 3, 2020 | Cloud, Monitoring, MySQL, Percona Software
Percona Monitoring and Management 2.2 (PMM) was released on December 24th with new features and updates designed to help you more easily manage and monitor your open source databases across your multi-cloud and hybrid-cloud environments. Let’s take a look at a few of...
by Peter Zaitsev | Jan 3, 2020 | MySQL, Open Source
In MySQL 8, Information Schema was basically re-written to utilize the all-New Data Dictionary which made it faster and better in many ways. Yet it also introduces some very counterintuitive behaviors when it comes to how actual and consistent data is. Here is a...
by David Ducos | Jan 2, 2020 | MySQL, ProxySQL
ProxySQL and Orchestrator are usually installed to achieve high availability when using MySQL replication. On a failover (or graceful takeover) scenario, Orchestrator will promote a slave, and ProxySQL will redirect the traffic. Depending on how your environment is...
by Evgeniy Patlan | Jan 2, 2020 | MySQL, Open Source
For Linux, the most common way to distribute software is binary packages in the rpm or deb format. Most packages are included in the official distribution repositories or 3rd party software repositories. Nevertheless, there are some cases where you need to...
by Sveta Smirnova | Jan 2, 2020 | MySQL
First I want to thank everyone who attended my December 19, 2019 webinar “Top 3 Features of MySQL“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide during the webinar. Q: When...
by Arunjith Aravindan | Dec 27, 2019 | MySQL, Percona Software
This blog discusses a few concepts about Docker and how we can use it to run a MySQL async replication environment. Docker is a tool designed to make it easier for developers and sysadmins to create/develop, configure, and run applications with containers. The...
by Carlos Tutte | Dec 26, 2019 | MySQL, Storage Engine
One of our support customers approached us with the following problem the other day: Shell mysql> CREATE TABLE child_table ( `id` int unsigned auto_increment, `column1` varchar(64) NOT NULL, parent_id int unsigned NOT NULL, PRIMARY KEY (`id`), CONSTRAINT FOREIGN...
by Mike Benshoof | Dec 23, 2019 | Cloud, MySQL
In an earlier post, I discussed the Shared Responsibility Model in the cloud and how it relates to databases. With either IaaS or DBaaS deployments, much of the operational and security burden is shifted away from the DBA to the cloud provider. I also noted that...
by Daniel Guzmán Burgos | Dec 20, 2019 | Insight for DBAs, MySQL, Storage Engine
In a high concurrency world, where more and more users->connections->threads are used, contention is a given. But how do we identify the contention point easily? Different approaches had been discussed previously, like the one using Perf and Flame graphs to...
