Come see Percona at AWS re:Invent from November 26-30, 2018 in booth 1605 in The Venetian Hotel Expo Hall. Percona is a Bronze sponsor of AWS re:Invent in 2018 and will be there for the whole show! Drop by booth 1605 in The Venetian Expo Hall to discuss how Perconas unbiased open source databse experts can [&]

https://www.percona.com/blog/2018/11/26/percona-at-aws-reinvent-2018/

Join Percona CEO Peter Zaitsev at AWS re:Invent as he presents MySQL High Availability and Disaster Recovery on Tuesday, November 27, 2018, in the Bellagio Resort, Level 1, Gaugin 2 at 1:45 PM. In this hour-long session, Peter describes the differences between high availability (HA) and disaster recovery (DR), and then moves through scenarios detailing [&]

https://www.percona.com/blog/2018/11/25/see-percona-ceo-peter-zaitsevs-keynote-at-aws-reinvent-mysql-high-availability-and-disaster-recovery/

Percona announces the release of Percona Server for MongoDB 3.4.18-2.16 on November 23, 2018. Download the latest version from the Percona website or the Percona Software Repositories. Percona Server for MongoDB 3.4 is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. Percona Server for MongoDB extends [&]

https://www.percona.com/blog/2018/11/23/percona-server-for-mongodb-3-4-18-2-16-is-now-available/

Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data as possible in MySQL. As you will see, there are quite a few different ways. Of course things like compression ratio matters a lot but, other items like performance of inserts, selects and updates, along [&]

https://www.percona.com/blog/2018/11/23/compression-options-in-mysql-part-1/

As per the documentation, pt-table-checksum is a tool to perform online replication consistency checks by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master. The master and each slave insert checksums into the percona.checksums table, and these are later compared for differences. It’s fairly obvious that [&]

https://www.percona.com/blog/2018/11/22/caveats-pt-table-checksum-using-row-based-replication-and-filters/

Percona announces the release of Percona Server for MySQL 5.7.23-25 on November 21, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-25 is now the current GA release in the 5.7 series. All of Percona’s software is [&]

https://www.percona.com/blog/2018/11/21/percona-server-for-mysql-5-7-23-25-is-now-available/

Percona announces the release of Percona Server for MySQL 5.5.62-38.14 on November 21, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.5.62, including all the bug fixes in it. Percona Server for MySQL 5.5.62-38.14 is now the current GA release in the 5.5 series. All of Percona’s software is open-source [&]

https://www.percona.com/blog/2018/11/21/percona-server-for-mysql-5-5-62-38-14-is-now-available/

Like MySQL, having too many indexes on a MongoDB collection not only affects overall write performance, but disk and memory resources as well. While MongoDB holds predictably well in scaling both reads and writes options, maintaining a heathly schema design should always remain a core character of a good application stack. Aside from knowing when [&]

https://www.percona.com/blog/2018/11/21/identifying-unused-indexes-in-mongodb/

Grafana Labs has released an important security update, and as youre aware PMM uses Grafana internally. Youre probably curious whether this issue affects you.  CVE-2018-19039 File Exfiltration vulnerability Security fix covers a recently discovered security flaw that allows any Grafana user with Editor or Admin permissions to have read access to the filesystem, performed with the same [&]

https://www.percona.com/blog/2018/11/20/how-cve-2018-19039-affects-percona-monitoring-and-management/

Percona Monitoring and Management 1.17.0 (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. You can run Percona Monitoring and Management 1.17.0 in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL®, MongoDB®, and PostgreSQL® servers to ensure that your data works as efficiently [&]

https://www.percona.com/blog/2018/11/20/percona-monitoring-and-management-pmm-1-17-0-is-now-available/

Just-in-time (JIT in PostgreSQL) compilation of SQL statements is one of the highlighted features in PostgreSQL 11. There is great excitement in the community because of the many claims of up to a 30% jump in performance. Not all queries and workloads get the benefit of JIT compilation. So you may want to test your workload against this new [&]

https://www.percona.com/blog/2018/11/19/installing-and-configuring-jit-in-postgresql-11/

In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings. Previous blogs in the migrating to Amazon Aurora series: Migrating to Amazon Aurora: Reduce the Unknowns Migrating to Amazon Aurora: [&]

https://www.percona.com/blog/2018/11/19/migrating-to-amazon-aurora-design-for-flexibility/

Perconas very own Michael Benshoof posted an article called Supercharge your Amazon RDS for MySQL deployment with ProxySQL and Percona Monitoring and Management on the AWS Database blog. In this article, Michael looks at how to maximize the performance of your cloud database Amazon RDS deployment. He shows that you can enhance performance by using ProxySQL to handle [&]

https://www.percona.com/blog/2018/11/16/percona-on-the-aws-database-blog/

In this blog post well look at what the newly-released PostgreSQL minor versions contain. You probably want to update your current versions and use these updates. You might already have seen that they released the updates for supported PostgreSQL versions on November 8, 2018. PostgreSQL releases minor versions with several bug fixes and feature enhancements [&]

https://www.percona.com/blog/2018/11/16/newly-released-postgresql-minor-versions-time-to-update/

In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings. In our previous article, we discussed the importance of continuous query performance analysis, especially in Amazon Aurora where there is [&]

https://www.percona.com/blog/2018/11/16/migrating-to-amazon-aurora-optimize-for-binary-log-replication/

Lets talk about MySQL high availability (HA) and synchronous replication once more. Its part of a longer series on some high availability reference architecture solutions over geographically distributed areas. Part 1: Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care? Part 2: MySQL High Availability On-Premises: A Geographically Distributed Scenario The Problem [&]

https://www.percona.com/blog/2018/11/15/how-not-to-do-mysql-high-availability-geographic-node-distribution-with-galera-based-replication-misuse/

In this article, well look at an example of an on-premises, geographically distributed MySQL high availability solution. Its part of a longer series on some high availability reference architecture solutions over geographically distributed areas. Part 1: Reference Architecture(s) for High Availability Solutions in Geographic Distributed Scenarios: Why Should I Care? Percona consultings main aim is to identify [&]

https://www.percona.com/blog/2018/11/15/mysql-high-availability-on-premises-a-geographically-distributed-scenario/

ProxySQL 1.4.12, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Perconas proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. Ren'e Canna`o created [&]

https://www.percona.com/blog/2018/11/13/proxysql-1-4-12-and-updated-proxysql-admin-tool/

Percona announces the release of Percona Server for MySQL 5.7.23-24 on November 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-24 is now the current GA release in the 5.7 series. All of Percona’s software is [&]

https://www.percona.com/blog/2018/11/12/percona-server-for-mysql-5-7-23-24-is-now-available/

An Oracle engineer thanked two Percona engineers by name, along with engineers from Facebook and elsewhere, for their recent MySQL 8.0 source code contributions. Oracle incorporated their work into its latest MySQL production release (8.0.13). Percona’s Zsolt Parragi authored a patch for a rare replication bug that left locked mutexes in production builds following debug [&]

https://www.percona.com/blog/2018/11/08/oracle-recognizes-percona-fixes-in-mysql-8-0/