by Stephen Thorn | Jan 6, 2021 | Cloud, Insight for DBAs, MySQL, Webinars
Earlier in November, we had a chance to present the “Google Cloud Platform: MySQL at Scale with Reliable HA.” We discussed different approaches to hosting MySQL in Google Cloud Platform with the available options’ pros and cons. This webinar was recorded and can...
by Marcelo Altmann | Dec 28, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
A lot of elements take part in a good backup strategy. Two of them are: Where to store your backups – Never on the same server. Preferable not in the same datacenter. Ideally far enough so you can restore in case of a natural disaster (region flood, extended...
by Marcelo Altmann | Dec 22, 2020 | Insight for DBAs, MySQL, Percona Software
MySQL 5.7, alongside other many improvements, brought bulk load for creating an index (WL#7277 to be specific), which made ADD INDEX operations much faster by disabling redo logging and making the changes directly to tablespace files. This change requires extra care...
by Ivan Groenewold | Dec 21, 2020 | Cloud, Insight for DBAs, MySQL, Percona Services
As mentioned in the AWS discussion forum back in October, Amazon has started the end of life (EOL) process for RDS MySQL version 5.5. What this means is: AWS will upgrade RDS instances to MySQL 5.7 starting February 9 2021 00:00 UTC during your next defined...
by Sri Sakthivel | Dec 16, 2020 | Insight for DBAs, MySQL, Open Source
MySQL Shell is an advanced client tool that has many features and is easy to use. The recent MySQL release (MySQL 8.0.22) has the utility “exportTable()”, which supports exporting the data into a file from a table using MySQL shell. The exported data file can be...
by Peter Zaitsev | Dec 7, 2020 | MySQL, Open Source, Security
As you may know, MySQL 5.6 will reach EOL (“End of Life”) in February 2021. This means in about two months, there will be no more updates, and more importantly, no more security fixes for discovered vulnerabilities. You may be well ahead of the curve...
by Charly Batista | Dec 4, 2020 | MySQL, Open Source, Security
Getting MySQL working with self-signed SSL certificates is pretty simple. Having it working with a certificate signed by a trusted authority is also very simple, we just need to set the correct path and privileges to the file. The problem comes when we need to make...
by Vinicius Grippa | Dec 2, 2020 | Insight for DBAs, MySQL, Percona Software
The benefits of jemalloc versus glibc memory allocator for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) there is less memory fragmentation, and thus more efficient resource management of the server memory. For...
by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How scheduler and script stand in supporting failover (Percona and Marco example) In part one of this series, I had illustrated how simple scenarios may fail or have problems when using Galera native support inside ProxySQL. In this post, I will repeat the same...
by Peter Zaitsev | Nov 23, 2020 | Insight for DBAs, Insight for Developers, MySQL
If I ask you if running EXPLAIN on the query can change your database, you will probably tell me NO; it is common sense. EXPLAIN should show us how the query is executed, not execute the query, hence it can’t change any data. Unfortunately, this is the case where...
by Sergey Pronin | Nov 23, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster serves the purpose, but also provides users the flexibility to fine-tune their MySQL and proxy services configuration....
by Fernando Laudares Camargos | Nov 17, 2020 | Cloud, MySQL, Open Source, Percona Software
Kubernetes has been a big trend for a while now, particularly well-suited for microservices. Running your main databases on Kubernetes is probably NOT what you are looking for. However, there’s a niche market for them. My colleague Stephen Thorn did a great job...
by Sergey Pronin | Nov 13, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Our recent survey showed that many organizations saw unexpected growth around cloud and data. Unexpected bills can become a big problem, especially in such uncertain times. This blog post talks about how Kubernetes scaling capabilities work with Percona Kubernetes...
by Mani Paluru | Nov 6, 2020 | Insight for DBAs, Insight for Developers, MySQL
Mysqlpump is a client program that was released with MySQL 5.7.8 and is used to perform logical backups in a better way. Mysqlpump supports parallelism and it has the capability of creating compressed output. Pablo already wrote a blog about this utility (The...
by Ivan Groenewold | Nov 5, 2020 | MongoDB, Monitoring, MySQL, Percona Software, PostgreSQL
Normally it is quite easy to deploy Percona Monitoring and Management (PMM) Server as a Docker container as per the official documentation. However, when working in very restrictive environments, it is possible the server doesn’t have access to the public...
by Sergey Pronin | Nov 4, 2020 | Cloud, MySQL, Percona Software, Security
Kata containers are containers that use hardware virtualization technologies for workload isolation almost without performance penalties. Top use cases are untrusted workloads and tenant isolation (for example in a shared Kubernetes cluster). This blog post describes...
by Matthew Boehm | Nov 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
So you’ve just added some more memory to your MySQL server; now what? If you’ve been around the MySQL block for a while, you know that nothing is automatically changed to take advantage of this new system RAM. Let’s have a look at a few parameters...
by Peter Zaitsev | Nov 2, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected memory usage, i.e. when you have MySQL Server using a lot more than you would expect based on your configuration settings. Early in MySQL...
by David Busby | Oct 30, 2020 | Insight for DBAs, MySQL, Percona Software
Galera replication technology, a key component of Percona XtraDB Cluster, suffered from a remote code execution vulnerability. Percona has been working with the vendor since early September on this issue and has made releases available to address the problem....
by Marcelo Altmann | Oct 28, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
In a perfect world, we expect all software to run flawlessly and never have problems such as bugs and crashes. We also know that this perfect world doesn’t exist and we better be as prepared as possible to troubleshoot those types of situations. Historically,...
