The votes have been tallied, and were happy to fill you in on the Top 10 highest-rated talks at the Percona Live Open Source Database Conference 2019! A big thanks to everyone who voted, and if you didnt attend any of these at the conference, nows your chance to see what you missed. Percona Live [&]

https://www.percona.com/blog/2019/07/02/percona-live-2019-highest-rated-talks/

I’m sure you’ve seen it  you kick off an ALTER and you get the dreaded “waiting on metadata lock”.  In many cases, this is expected if you are actively working on the table. However, I recently had a case with a client where the table being altered was rarely updated and very small (<100 [&]

https://www.percona.com/blog/2019/07/02/alters-foreign-keys-and-metadata-locks-oh-my/

The CTO has issued the decree: “We are moving to the cloud!”  Great, so now what do we do? When it comes to migrating from on-premise to the cloud, there are many factors to consider and decisions that need to be made.  First (and probably most important) on that list: managed DBaaS or setup and [&]

https://www.percona.com/blog/2019/07/01/mysql-migrating-from-on-premise-to-the-cloud/

The CTO has issued the decree: “We are moving to the cloud!”  Great, so now what do we do? When it comes to migrating from on-premise to the cloud, there are many factors to consider and decisions that need to be made.  First (and probably most important) on that list: managed DBaaS or setup and [&]

https://www.percona.com/blog/2019/07/01/mysql-migrating-from-on-premise-to-the-cloud/

Its bad practice to provide world-writable access to critical files in Linux, though weve seen time and time again that this is done to conveniently share files with other users, applications, or services. But with Xtrabackup, preparing backups could go wrong if the backup configuration has world-writable file permissions. Say you performed a backup on [&]

https://www.percona.com/blog/2019/07/01/setting-world-writable-file-permissions-prior-to-preparing-the-backup-can-break-it/

I want to thank everybody who attended my session “Deep Dive in PostgreSQL Indexes” in Austin. It was quite a wonderful experience! To cover a bigger audience, I also did a webinar on the same topic. There were many questions in that webinar, but unfortunately, there was not enough time to cover each and every [&]

https://www.percona.com/blog/2019/07/01/deep-dive-into-postgresql-indexes-webinar-q-a/

Were counting down the top 10 most attended talks at the Percona Live Open Source Database Conference 2019! For those of you who attended, chances are that some of you were at a few of these talks.  Percona Live conferences provide the open source database community with an opportunity to discover and discuss the latest [&]

https://www.percona.com/blog/2019/06/27/percona-live-2019-10-most-attended-talks/

Were counting down the top 10 most attended talks at the Percona Live Open Source Database Conference 2019! For those of you who attended, chances are that some of you were at a few of these talks.  Percona Live conferences provide the open source database community with an opportunity to discover and discuss the latest [&]

https://www.percona.com/blog/2019/06/27/percona-live-2019-10-most-attended-talks/

Were counting down the top 10 most attended talks at the Percona Live Open Source Database Conference 2019! For those of you who attended, chances are that some of you were at a few of these talks.  Percona Live conferences provide the open source database community with an opportunity to discover and discuss the latest [&]

https://www.percona.com/blog/2019/06/27/percona-live-2019-10-most-attended-talks/

In my previous blog post, I explained the internals of the sorted index build process. The blog ended with saying there is one disadvantage. Beginning in MySQL 5.6, many DDLs including ALTER TABLE ADD INDEX became ONLINE. Meaning, when the ALTER is in progress, there can be concurrent SELECTS and DMLs. See the MySQL documentation [&]

https://www.percona.com/blog/2019/06/27/innodb-alter-table-add-index-and-insert-performance/

Please join Percona’s Principal Support Engineer Marcos Albe as he presents “Beyond Relational Databases: A Look Into MongoDB, Redis, and ClickHouse” on Thursday, June 27th, 2019 at 12:00 PM PDT (UTC-7). Register Now We all use and love relational databases& until we use them for purposes for which they are not a good fit: queues, [&]

https://www.percona.com/blog/2019/06/26/webinar-beyond-relational-databases-mongodb-redis-clickhouse/

Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.26-31.37 is now the current release, based on the following: Percona Server for MySQL 5.7.26-29 Codership WSREP API release 5.7.25 Codership Galera library 3.26 All Percona [&]

https://www.percona.com/blog/2019/06/26/percona-xtradb-cluster-5-7-26-31-37-is-now-available/

In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we arent cautious. For this example, I am only going to use the SLEEP function to demonstrate the issue, but you [&]

https://www.percona.com/blog/2019/06/26/stored-functions-and-temporary-tables-are-not-a-good-fit/

In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we arent cautious. For this example, I am only going to use the SLEEP function to demonstrate the issue, but you [&]

https://www.percona.com/blog/2019/06/26/stored-functions-and-temporary-tables-are-not-a-good-fit/

In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we arent cautious. For this example, I am only going to use the SLEEP function to demonstrate the issue, but you [&]

https://www.percona.com/blog/2019/06/26/stored-functions-and-temporary-tables-are-not-a-good-fit/

The Call for Papers for Percona Live Europe 2019 is now open!  This year’s conference will be held September 30  October 2, 2019 in Amsterdam, the Netherlands. Percona Live is the one conference for the entire open source database community, especially for MySQL, PostgreSQL, MongoDB, and MariaDB. The theme of the 2019 conference is [&]

https://www.percona.com/blog/2019/06/25/percona-live-europe-2019-call-for-papers-is-now-open/

Please join Percona’s Senior Support Engineer Adamo Tonete as he presents “MongoDB Data Security  Custom Rules and Views” on Wednesday, June 26th, 2019 at 11:00 AM PDT (UTC-7). Register Now In this presentation, we will discuss how to create custom rules when the default rules are not enough for the application. Have you ever [&]

https://www.percona.com/blog/2019/06/25/upcoming-webinar-6-26-mongodb-data-security-custom-rules-and-views/

Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In this blog post, we are going to discuss why. I am not going to go into the details of how Aurora works, as there are

https://www.percona.com/blog/2019/06/25/adaptive-hash-index-on-aws-aurora/

Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In this blog post, we are going to discuss why. I am not going to go into the details of how Aurora works, as there are

https://www.percona.com/blog/2019/06/25/adaptive-hash-index-on-aws-aurora/

Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In this blog post, we are going to discuss why. I am not going to go into the details of how Aurora works, as there are

https://www.percona.com/blog/2019/06/25/adaptive-hash-index-on-aws-aurora/