Please join Percona’s Information Security Architect, David Bubsy, as he presents his talk Web Application Security  Why You Should Review Yours on March 14th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now In this talk, we take a look at the whole stack and I dont just mean LAMP. [&]

https://www.percona.com/blog/2019/03/12/webinar-web-application-security/

Please join Percona’s Information Security Architect, David Bubsy, as he presents his talk Web Application Security  Why You Should Review Yours on March 14th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now In this talk, we take a look at the whole stack and I dont just mean LAMP. [&]

https://www.percona.com/blog/2019/03/12/webinar-web-application-security/

One of the great things about Percona Monitoring and Management (PMM) is its flexibility. An example of that is how one can go beyond the exporters to collect data. One approach to achieve that is using textfile collectors, as explained in  Extended Metrics for Percona Monitoring and Management without modifying the Code. Another method, which is [&]

https://www.percona.com/blog/2019/03/12/pmms-custom-queries-in-action-adding-a-graph-for-innodb-mutex-waits/

One of the great things about Percona Monitoring and Management (PMM) is its flexibility. An example of that is how one can go beyond the exporters to collect data. One approach to achieve that is using textfile collectors, as explained in  Extended Metrics for Percona Monitoring and Management without modifying the Code. Another method, which is [&]

https://www.percona.com/blog/2019/03/12/pmms-custom-queries-in-action-adding-a-graph-for-innodb-mutex-waits/

In my ongoing research to identify solutions and similarities between MySQL – PostgreSQL, I recently faced a simple issue. I needed to perform a slave shift from one IP to another and I did not want to have to restart the slave that is serving the reads. In MySQL, I can repoint the replication online [&]

https://www.percona.com/blog/2019/03/11/switch-postgresql-primary-for-read-replica-without-downtime/

In this blog post, I want to share a case we worked on a few days ago. Ill show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting. The customer had noticed a linear high CPU usage in one of their MySQL instances [&]

https://www.percona.com/blog/2019/03/07/reducing-high-cpu-on-mysql-a-case-study/

The concept of Linux HugePages has existed for quite a while: for more than 10 years, introduced to Debian in 2007 with kernel version 2.6.23. Whilst a smaller page size is useful for general use, some memory intensive applications may gain performance by using bigger memory pages. By having bigger memory chunks available to them, [&]

https://www.percona.com/blog/2019/03/06/settling-the-myth-of-transparent-hugepages-for-databases/

Join Percona Support Engineer, Vinicius Grippa, as he presents his talk Enhancing MySQL Security on Thursday, March 7th, 2019 at 7:00 AM PST (UTC-8) / 10:00 AM EST (UTC-5). Register Now Security is always a challenge when it comes to data. What’s more, regulations like GDPR add a whole new layer on top of it, [&]

https://www.percona.com/blog/2019/03/05/enhancing-mysql-security/

Over time, software evolves and it is important to stay up to date if you want to benefit from new features and performance improvements.  Database engines follow the exact same logic and providers are always careful to provide an easy upgrade path. With MySQL, the mysql_upgrade tool serves that purpose. A database upgrade process becomes [&]

https://www.percona.com/blog/2019/03/05/how-to-upgrade-amazon-aurora-mysql-from-5-6-to-5-7/

Percona is glad to announce the release of Percona XtraBackup 8.0.5 on March 4, 2019. Downloads are available from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source [&]

https://www.percona.com/blog/2019/03/04/percona-xtrabackup-8-0-5-is-now-available/

Join Percona CEO Peter Zaitsev as he presents MySQL High Availability and Disaster Recovery on Wednesday, March 6th, 2019, at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5). Register Now In this hour-long webinar, Peter describes the differences between high availability (HA) and disaster recovery (DR). Afterward, Peter will go through scenarios detailing how [&]

https://www.percona.com/blog/2019/03/04/mysql-high-availability-disaster-recovery/

A date for your diary. On Wednesday, April 17 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4) Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu and Senior Support Engineers, Fernando Laudares, Jobin Augustine and Nickolay Ihalainen, will demonstrate the upgrade of a legacy version of PostgreSQL to a newer version, using built-in as well as [&]

https://www.percona.com/blog/2019/03/04/postgresql-webinar-wed-april-17-upgrading-migrating-legacy-postgresql-newer-versions/

Percona is glad to announce the release of Percona XtraDB Cluster 5.6.43-28.32 on February 28, 2019. Binaries are available from the downloads section or from our software repositories. This release of Percona XtraDB Cluster includes the support of Ubuntu 18.10 (Cosmic Cuttlefish). Percona XtraDB Cluster 5.6.43-28.32 is now the current release, based on the following: Percona Server 5.6.43-84.3 Codership WSREP API release 5.6.42 Codership [&]

https://www.percona.com/blog/2019/02/28/percona-xtradb-cluster-5-6-43-28-32-is-now-available/

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.25-31.35 on February 28, 2018. Binaries are available from the downloads section or from our software repositories. This release of Percona XtraDB Cluster includes the support of Ubuntu 18.10 (Cosmic Cuttlefish). Percona XtraDB Cluster 5.7.25-31.35 is now the current release, based on the following: Percona Server for [&]

https://www.percona.com/blog/2019/02/28/percona-xtradb-cluster-5-7-25-31-35-is-now-available/

Percona announces the release of Percona Server for MongoDB 4.0.6-3 on February 28, 2019. Download the latest version from the Percona website or the Percona software repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 4.0 Community Edition. It supports MongoDB 4.0 protocols and drivers. Percona Server for MongoDB extends [&]

https://www.percona.com/blog/2019/02/28/percona-server-for-mongodb-4-0-6-3-is-now-available/

Last week I came across a bug in MySQL 8.0, which meant that the absence of mysql.user leads to auto-apply of skip-grant-tables (#94394) would leave MySQL running in an undesirable state. My colleague Sveta Smirnova blogged about the issue and it also caught the interest of Valeriy Kravchuk in Fun with Bugs #80  On [&]

https://www.percona.com/blog/2019/02/28/mysql-8-0-bug-94394-fixed/

Following my post MySQL 8 is not always faster than MySQL 5.7, this time I decided to test very simple read-only CPU intensive workloads, when all data fits memory. In this workload there is NO IO operations, only memory and CPU operations. My Testing Setup Environment specification Release | Ubuntu 18.04 LTS (bionic) Kernel | [&]

https://www.percona.com/blog/2019/02/27/charset-and-collation-settings-impact-on-mysql-performance/

InnoDB keeps hot data in memory on its buffer named InnoDB Buffer Pool. For a long time, when a MySQL instance needed to bounce, this hot cached data was lost and the instance required a warm-up period to perform as well as it did before the service restart. That is not the case anymore. Newer [&]

https://www.percona.com/blog/2019/02/26/percona-xtrabackup-now-supports-dump-of-innodb-buffer-pool/

In this post, I want to explore a way to establish 100,000 connections to MySQL. Not just idle connections, but executing queries. 100,000 connections. Is that really needed for MySQL, you may ask? Although it may seem excessive, I have seen a lot of different setups in customer deployments. Some deploy an application connection pool, [&]

https://www.percona.com/blog/2019/02/25/mysql-challenge-100k-connections/

We know youve been really looking forward to a glimpse of what to expect at Percona Live Austin, so here is the first sneak peek of the agenda! Our conference committee has been reviewing hundreds of talks over the last few weeks and is delighted to present some initial talks. New features in MySQL 8.0 [&]

https://www.percona.com/blog/2019/02/22/percona-live-2019-first-sneak-peek/