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...
by Daniel Guzmán Burgos | Dec 19, 2019 | Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is built upon the shoulder of giants like Prometheus and Grafana. And speaking of Grafana, one of the coolest features that come with it is the ability to customize the experience through 3rd party plugins. Plugins are an easy...
by Brian Sumpter | Dec 19, 2019 | Cloud, Insight for DBAs, MySQL
As the world’s most popular open-source database, MySQL has been around the block more than a few times. Traditionally installed in on-premise data centers, recent years have shown a major trend for MySQL in the cloud, and near the top of this list is Amazon RDS....
by Sveta Smirnova | Dec 19, 2019 | MySQL, Webinars
by Yves Trudeau | Dec 18, 2019 | Insight for DBAs, MySQL, Storage Engine
The innodb_io_capacity and innodb_io_capacity_max are often misunderstood InnoDB parameters. As consultants, we see, at least every month, people setting this variable based on the top IO write specifications of their storage. Is this a correct choice? Is it an...
by David Quilty | Dec 18, 2019 | MySQL, Percona Software, Webinars
This talk uncovers which tools/plugins/settings you need to use to comply with PCI/DSS when using MySQL. Gain a solid grasp of the possibilities, as well as the limitations, MySQL offers to someone looking to become PCI/DSS certified. Please join Percona Support...
by Mike Benshoof | Dec 18, 2019 | Cloud, Database Trends, MySQL
When we think about the cloud, often we consider many of the benefits: scalability, elasticity, agility, and flexible pricing. As great as these features are, security also remains a business-critical concern. In an on-premise environment, every aspect of security is...
by David Quilty | Dec 17, 2019 | MySQL, Percona Software, Webinars
MySQL has been ranked as the second most popular database since 2012 according to DB-Engines. Three features help it retain its top position: replication, storage engines, and NoSQL support. During this webinar, we’ll discuss the MySQL architecture surrounding...
by Robert Golebiowski | Dec 9, 2019 | MySQL, Percona Software, Security
It has been possible to enable Transparent Data Encryption (TDE) in Percona Server for MySQL/MySQL for a while now, but have you ever wondered how it works under the hood and what kind of implications TDE can have on your server instance? In this blog posts series, we...
