In this blog post, we will walk through the internals of the election process in MongoDB®, following on from a previous post on the internals of the replica set. You can read Part 1 here. For this post, I am refer to the same configurations we discussed before. Elections: As the term suggests, in MongoDB there is [&]

https://www.percona.com/blog/2019/01/23/mongodb-replica-set-scenarios-and-internals-part-ii-elections/

Please join Percona’s Senior Technical Manager, Alkin Tezuysal, as he presents Databases Gone Serverless? on Thursday, January 24th, at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now Serverless computing is becoming more popular with developers. For instance, it enables them to build and run applications without needing to operate and manage servers. This [&]

https://www.percona.com/blog/2019/01/22/webinar-databases-gone-serverless/

Please join Percona’s Senior Technical Manager, Alkin Tezuysal, as he presents Databases Gone Serverless? on Thursday, January 24th, at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now Serverless computing is becoming more popular with developers. For instance, it enables them to build and run applications without needing to operate and manage servers. This [&]

https://www.percona.com/blog/2019/01/22/webinar-databases-gone-serverless/

A common challenge with continuously deployed applications is that new and modified SQL queries are constantly being introduced to the application. Many companies choose to use a database monitoring system (such as PMM) to identify those slow queries. But identifying slow queries is only the start  what about actually optimizing them? In this post [&]

https://www.percona.com/blog/2019/01/22/monitor-and-optimize-slow-queries-with-pmm-and-eversql-part-one/

A common challenge with continuously deployed applications is that new and modified SQL queries are constantly being introduced to the application. Many companies choose to use a database monitoring system (such as PMM) to identify those slow queries. But identifying slow queries is only the start  what about actually optimizing them? In this post [&]

https://www.percona.com/blog/2019/01/22/monitor-and-optimize-slow-queries-with-pmm-and-eversql-part-one/

We had a great response to our call for papers, thank you! However great we believe having the conference in Austin, TX will be, moving to a new area of the US is still a leap of faith until we see the numbers. So we’re thankful that so many of you continue to support and [&]

https://www.percona.com/blog/2019/01/21/percona-live-2019-committee-announced-and-a-short-extension/

  Percona announces the release of Percona XtraDB Cluster Operator  0.2.0 early access. The Percona XtraDB Cluster Operator simplifies the deployment and management of Percona XtraDB Cluster in a Kubernetes or OpenShift environment. It extends the Kubernetes API with a new custom resource for deploying, configuring and managing the application through the whole life cycle. Note: [&]

https://www.percona.com/blog/2019/01/18/percona-xtradb-cluster-operator-early-access-0-2-0-release-is-now-available/

Percona is glad to announce the release of Percona XtraBackup 2.4.13 on January 18, 2018. You can download it from our download site and 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. [&]

https://www.percona.com/blog/2019/01/18/percona-xtrabackup-2-4-13-is-now-available/

Some time ago I wrote a script to manage asynchronous replication links between Percona XtraDB clusters. The original post can be found here. The script worked well with Percona XtraDB Cluster but it wasnt working well with MariaDB®.  Finally, the replication manager works with MariaDB. First, lets review the purpose of the script. Managing replication [&]

https://www.percona.com/blog/2019/01/18/replication-manager-works-with-mariadb/

Percona announces the release of Percona Server for MySQL 8.0.13-4 on January 17, 2019 (downloads are available here and from the Percona Software Repositories). This release contains a fix for a critical bug that prevented Percona Server for MySQL 5.7.24-26 from being upgraded to version 8.0.13-3 if there are more than around 1000 tables, or if the maximum allocated InnoDB table ID is [&]

https://www.percona.com/blog/2019/01/17/percona-server-for-mysql-8-0-13-4-is-now-available/

Parallel query execution is my favorite, non-existent, feature in MySQL. In all versions of MySQL – at least at the time of writing – when you run a single query it will run in one thread, effectively utilizing one CPU core only. Multiple queries run at the same time will be using different threads and will [&]

https://www.percona.com/blog/2019/01/17/using-parallel-query-with-amazon-aurora-for-mysql/

Percona is glad to announce the release of Percona Server for MongoDB 3.2.22-3.13 on January, 16 2019. Download the latest version from the Percona web site 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 3.2 Community Edition. It supports MongoDB 3.2 protocols and drivers. [&]

https://www.percona.com/blog/2019/01/16/percona-server-for-mongodb-3-2-22-3-13-is-now-available/

If you have set up per-process metrics in Percona Monitoring and Management, you may have found yourself in need of tuning it further to not only group processes together, but to display some of them in isolation. In this blogpost we will explore how to modify the rules for grouping processes, so that you can [&]

https://www.percona.com/blog/2019/01/15/customizing-per-process-metrics-in-pmm/

Please join Percona’s Chief Technology Officer, Vadim Tkachenko, as he presents How to Rock with MyRocks on Thursday, January 17th at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now MyRocks is a new storage engine from Facebook and is available in Percona Server for MySQL. In what cases will you want to [&]

https://www.percona.com/blog/2019/01/14/webinar-rock-myrocks/

First of all, this post is not a recommendation but more like a what if story. What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. However, ClickHouse is super efficient for timeseries and provides [&]

https://www.percona.com/blog/2019/01/14/should-you-use-clickhouse-as-a-main-operational-database/

It’s a few weeks after AWS re:Invent 2018 and my head is still spinning from all of the information released at this year’s conference. This year I was able to enjoy a few sessions focused on Aurora deep dives. In fact, I walked away from the conference realizing that my own understanding of High Availability (HA), [&]

https://www.percona.com/blog/2019/01/11/aws-aurora-mysql-ha-dr-and-durability-explained-in-simple-terms/

Percona announces the first public release of Percona Backup for MongoDB 0.2.0-Alpha on January 10, 2019. Percona Backup for MongoDB is a distributed, low-impact solution for consistent backups of MongoDB sharded clusters and replica sets. This is a tool for creating consistent backups across a MongoDB sharded cluster (or a single replica set), and for restoring those [&]

https://www.percona.com/blog/2019/01/10/percona-backup-for-mongodb-0-2-0-alpha-is-now-available/

ProxySQL 1.4.13, 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/2019/01/10/proxysql-1-4-13-and-updated-proxysql-admin-tool/

Recently, one of our customers asked us how to minimize downtime when upgrading the database structure with changes that are not backwards-compatible. It’s an interesting question and I would like to visit some alternatives here. I will use PostgreSQL for this series of posts and walk through updatable views, INSTEAD OF Triggers, and the Rule [&]

https://www.percona.com/blog/2019/01/10/postgresql-updatable-views-performing-schema-updates-with-minimal-downtime/

Percona announces the release of Percona Toolkit 3.0.13 for January 9, 2019. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, [&]

https://www.percona.com/blog/2019/01/09/percona-toolkit-3-0-13-is-now-available/