Percona announces the release of Percona XtraDB Cluster Operator 0.3.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. You can [&]

https://www.percona.com/blog/2019/04/02/percona-xtradb-cluster-operator-0-3-0-early-access-release-is-now-available/

Distributed systems are hard – I just want to echo that. In MySQL, we have quite a number of options to run highly available systems. However, real fault tolerant systems are difficult to achieve. Take for example a common use case of multi-DC replication where Orchestrator is responsible for managing the topology, while ProxySQL takes [&]

https://www.percona.com/blog/2019/04/02/simple-stonith-proxysql-orchestrator/

Percona announces the release of Percona Server for MongoDB 3.4.20-2.18 on March 29, 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 3.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. [&]

https://www.percona.com/blog/2019/03/29/percona-server-for-mongodb-3-4-20-2-18-is-now-available/

Database management systems are meant to house data but, occasionally, they may need to talk with another DBMS. For example, to access an external server which may be hosting a different DBMS. With heterogeneous environments becoming more and more common, a bridge between the servers is established. We call this bridge a “Foreign Data Wrapper” [&]

https://www.percona.com/blog/2019/03/29/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/

In this blog post, we will explore  [crayon-5c9f268607e08619748415-i/] / [crayon-5c9f268607e0d273694159-i/], one of the most commonly used options for performing a PostgreSQL upgrade. It is important to understand the scenarios under which [crayon-5c9f268607e0e656611773-i/] and [crayon-5c9f268607e0f571713937-i/] utilities will be helpful. This post is the second of our Upgrading or Migrating Your Legacy PostgreSQL to Newer PostgreSQL Versions [&]

https://www.percona.com/blog/2019/03/27/postgresql-upgrade-using-pg_dump-pg_restore/

We started hosting Percona University a few years back with the aim of sharing knowledge with the open source database community. The events are held in cities across the world. The next Percona University days will visiting Uruguay, Argentina, and Brazil, in a lightning tour at the end of April. Montevideo, Tuesday, April 23 2019 [&]

https://www.percona.com/blog/2019/03/27/percona-university-travels-to-south-america/

Please join Percona’s Product Manager, Michael Coburn, as he presents his talk Monitoring PostgreSQL with Percona Monitoring and Management (PMM) on March 27th, 2019 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now In this webinar, learn how to monitor PostgreSQL using Percona Monitoring and Management (PMM) so that you can: Gain greater [&]

https://www.percona.com/blog/2019/03/26/postgresql-percona-monitoring-management/

Percona announces the availability of the Percona Server for MongoDB Operator 0.3.0 early access release. The Percona Server for MongoDB Operator simplifies the deployment and management of Percona Server for MongoDB 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 [&]

https://www.percona.com/blog/2019/03/25/percona-server-for-mongodb-operator-0-3-0-early-access-release-is-now-available/

If you are using Galera replication, you know that schema changes may be a serious problem. With its current implementation, there is no way even a simple ALTER will be unobtrusive for live production traffic. It is a fact that with the default TOI alter method, Percona XtraDB Cluster (PXC) cluster suspends writes in order [&]

https://www.percona.com/blog/2019/03/25/how-to-perform-compatible-schema-changes-in-percona-xtradb-cluster-advanced-alternative/

ARM processors have been around for a while. In mid-2015/2016 there were a couple of attempts by the community to port MongoDB to work with this architecture. At the time, the main storage engine was MMAP and most of the available ARM boards were 32-bits. Overall, the port worked, but the fact is having MongoDB [&]

https://www.percona.com/blog/2019/03/20/mongodb-on-arm-processors/

In this blog post, I’m going to show you how to test Kubernetes locally on OSX/macOS. Testing Kubernetes without having access to a cloud operator in a local lab is not as easy as it sounds. I’d like to share some of my experiences in this adventure. For those who have already experienced in Virtualbox [&]

https://www.percona.com/blog/2019/03/19/how-to-test-and-deploy-kubernetes-operator-for-mysqlpxc-in-osx-macos/

Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents MySQL Performance Schema in 1 hour on Thursday, March 21st, 2019, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Register Now MySQL 8.0 Performance Schema is a mature tool, used by humans and monitoring products. It was born in 2010 as a [&]

https://www.percona.com/blog/2019/03/19/mysql-performance-schema-one-hour/

There are several approaches to assess when you need to upgrade PostgreSQL. In this blog post, we look at the option for upgrading a postgres database using pg_dumpall. As this tool can also be used to back up PostgreSQL clusters, then it is a valid option for upgrading a cluster too. We consider the advantages [&]

https://www.percona.com/blog/2019/03/18/postgresql-upgrade-using-pg_dumpall/

Percona announces the release of Percona Server for MySQL 8.0.15-5 on March 15, 2019 (downloads are available here and from the Percona Software Repositories). This release includes fixes to bugs found in previous releases of Percona Server for MySQL 8.0. Incompatible changes In previous releases, the audit log used to produce time stamps inconsistent with the ISO 8601 standard. Release 8.0.15-5 of Percona Server [&]

https://www.percona.com/blog/2019/03/15/percona-server-for-mysql-8-0-15-5-is-now-available/

Percona announces the release of Percona Server for MongoDB 3.6.11-3.1 on March 15, 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 3.6 Community Edition. It supports MongoDB 3.6 protocols and drivers. Percona Server for [&]

https://www.percona.com/blog/2019/03/15/percona-server-for-mongodb-3-6-11-3-1-is-now-available/

Just about a month ago, Pavel Ivanov released Ripple under the Apache-2.0 license. Ripple is a MySQL binlog server: software which receives binary logs from MySQL or MariaDB servers and delivers them to another MySQL or MariaDB server. Practically ,this is an intermediary master which does not store any data, except the binary logs themselves, [&]

https://www.percona.com/blog/2019/03/15/mysql-ripple-first-impression-of-mysql-binlog-server/

Click Here to Complete our New Survey! Last year we informally surveyed the open source community and our conference attendees. The results revealed that: 48% of those in the cloud choose to self-manage their databases, but 52% were comfortable relying on the DBaaS offering of their cloud vendor. 49% of people said “performance issues” when [&]

https://www.percona.com/blog/2019/03/14/perconas-open-source-data-management-software-survey/

Tutorials and initial sessions are set for the Percona Live Open Source Database Conference 2019, to be held May 28-30 at the Hyatt Regency in Austin, Texas! Percona Live 2019 is the premier open source database conference event for users of MySQL®, MariaDB®, MongoDB®, and PostgreSQL. It will feature 13 tracks presented over two days, plus [&]

https://www.percona.com/blog/2019/03/13/discount-ends-17-march-for-percona-live-2019/

Recently, we had an edge case where a MySQL slave went out-of-sync but it couldnt be rebuilt from scratch. The slave was acting as a master server to some applications and it had data was being written to it. It was a design error, and this is not recommended, but it happened. So how do you [&]

https://www.percona.com/blog/2019/03/13/live-mysql-slave-rebuild-with-percona-toolkit/

Recently, we had an edge case where a MySQL slave went out-of-sync but it couldnt be rebuilt from scratch. The slave was acting as a master server to some applications and it had data was being written to it. It was a design error, and this is not recommended, but it happened. So how do you [&]

https://www.percona.com/blog/2019/03/13/live-mysql-slave-rebuild-with-percona-toolkit/