Time for a new question in our blog poll series! This time, its about adding or upgrading to meet database needs.  Heres the question: In the last 24 months, how often have you added or upgraded database instances, added hardware to existing servers, or migrated to a new hosting/cloud provider? Last year, we asked you [&]

https://www.percona.com/blog/2019/10/08/blog-poll-adding-upgrading-instances-hardware-and-migration/

One thing that comes up often from working with a variety of clients at Percona is How can I achieve a Disaster Recovery (DR) solution with Percona XtraDB Cluster (PXC)?  Unfortunately, decisions are sometimes made with far-reaching consequences by individuals who often do not well understand the architecture and its limitations.  As a Technical Account [&]

https://www.percona.com/blog/2019/10/07/achieving-disaster-recovery-with-percona-xtradb-cluster/

As a Technical Account Manager (TAM), I have seen many of our clients adopt a decentralized DBA Team.  In many cases, this is an effort to better align the DBA Team with the Development Teams.  This is an admirable and logical goal.  As often happens, you often trade one set of challenges for another. Centralized [&]

https://www.percona.com/blog/2019/10/07/centralization-vs-decentralization-of-dba-teams/

It’s a wrap! Another Percona Live Europe is in the books and we want to thank everyone for making it an amazing event. A special shout-out to this year’s sponsors: AWS, PlanetScale, Altinity, Galera Cluster, MySQL, Shannon Systems, Tarantool, Booking.com, Free Software Foundation, MariaDB, Open Source Initiative, HPCwire, Datanami, and Enterprise AI. We saw lots [&]

https://www.percona.com/blog/2019/10/04/top-5-takeaways-from-percona-live-europe-2019/

Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use. mysqldump and rsync are no longer supported SST methods. Support for mysqldump was deprecated starting with PXC 5.7 and has now been completely removed. MySQL 8.0 introduced [&]

https://www.percona.com/blog/2019/10/04/percona-xtradb-cluster-8-0-experimental-release-sst-improvements/

The problem In PXC 5.6 and 5.7, when using xtrabackup-v2 as the SST method, the DBA must create a user with the appropriate privileges for use by Percona XtraBackup (PXB). The username and password of this backup user are specified in the wsrep_sst_auth variable. This is a problem because this username and password was being [&]

https://www.percona.com/blog/2019/10/03/percona-xtradb-cluster-8-0-new-feature-wsrep_sst_auth-removal/

Percona is happy to announce the first experimental binary of Percona XtraDB Cluster 8.0 on October 1, 2019. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This release combines the updated and feature-rich Galera 4, with substantial improvements made by our development team. Improvements and New Features [&]

https://www.percona.com/blog/2019/10/01/experimental-binary-of-percona-xtradb-cluster-8-0/

Percona Backup for MongoDB v1 is the first GA version of our new MongoDB backup tool. This has been custom-built to assist those users who don’t want to pay for MongoDB Enterprise and Ops Manager but do want a fully-supported community backup tool that can perform cluster-wide consistent backups in MongoDB. Please visit our webpage [&]

https://www.percona.com/blog/2019/09/30/avoid-vendor-lock-in-with-percona-backup-for-mongodb/

MySQL Shell is a pretty nice piece of software. Is not just another mysql client but it is also a tool that offers scripting capabilities for JavaScript and Python. And one of the coolest things you can do with it is to check if your MySQL 5.7 server is ready for an upgrade or not. [&]

https://www.percona.com/blog/2019/09/27/mysql-8-shell-upgrade-checker-utility/

Multiplexing Background Historically it’s a technique used in networking to integrate multiple analog and digital signals via a shared medium. The goal of multiplexing over the network was to enable signals to be transmitted more efficiently for a given communication channel, thus achieving cost efficiency.  Since the term Multiplexing comes from telecommunications, the industry has [&]

https://www.percona.com/blog/2019/09/27/multiplexing-mux-in-proxysql/

In a previous post, I showed you how to compile Percona Mysql 5.7 on Raspberry PI 3. Now, Ill show you how to compile and run the latest version of Percona XtraDB Cluster 5.7.26. We will need at least 3 RaspberryPi 3 boards, and I recommend you use an external SSD drive to compile and [&]

https://www.percona.com/blog/2019/09/26/running-percona-xtradb-cluster-on-raspberry-pi-3/

Summary On September 24, 2019, Percona’s IT and IT Security teams were made aware of a denial of service attack on www.percona.com/forums. We use vBulletin to host Percona Forums, which was subjected to a zero-day pre-authentication remote code execution. This vulnerability potentially allows an unauthenticated attacker to remotely execute code on, or possibly complete control [&]

https://www.percona.com/blog/2019/09/25/incident-involving-percona-forums-on-september-24-2019/

As the saying goes, a picture is worth 1000 words  and this is why we dont just talk about Percona Monitoring and Management (PMM) but also have a demo which allows you to explore many PMM features without having to install it. Though there is only so much you can do in a public [&]

https://www.percona.com/blog/2019/09/25/explore-percona-monitoring-and-management-on-your-own-with-linode/

If you have been around MySQL for any length of time, you are probably aware that choosing the correct data types and optimizing your schema are actually important tasks.  A few years back at Percona Live 2016, I gave an introductory talk on schema review and optimization. Heres the video:   I was thinking about [&]

https://www.percona.com/blog/2019/09/23/why-schema-optimization-matters/

If you have been around MySQL for any length of time, you are probably aware that choosing the correct data types and optimizing your schema are actually important tasks.  A few years back at Percona Live 2016, I gave an introductory talk on schema review and optimization. Heres the video:   I was thinking about [&]

https://www.percona.com/blog/2019/09/23/why-schema-optimization-matters/

Percona is happy to announce the GA release of our latest software product Percona Backup for MongoDB 1.0.0 on September 23, 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 [&]

https://www.percona.com/blog/2019/09/23/percona-backup-for-mongodb-1-0-0-ga-is-now-available/

Percona is happy to announce the GA release of our latest software product Percona Backup for MongoDB 1.0.0 on September 23, 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 [&]

https://www.percona.com/blog/2019/09/23/percona-backup-for-mongodb-1-0-0-ga-is-now-available/

Please join Percona Senior Support Engineer Carlos Tuttle as he presents his talk “Preparing for Disaster recovery on MySQL and PostgreSQL” on Tuesday, September 24th, 2019 at 11:00 AM PDT (UTC-7). Register Now Think for a moment what would happen if your company lost its current production data center; are you ready for that 3 [&]

https://www.percona.com/blog/2019/09/23/webinar-9-24-preparing-for-disaster-recovery-on-mysql-and-postgresql/

Please join Percona Senior Support Engineer Carlos Tuttle as he presents his talk “Preparing for Disaster recovery on MySQL and PostgreSQL” on Tuesday, September 24th, 2019 at 11:00 AM PDT (UTC-7). Register Now Think for a moment what would happen if your company lost its current production data center; are you ready for that 3 [&]

https://www.percona.com/blog/2019/09/23/webinar-9-24-preparing-for-disaster-recovery-on-mysql-and-postgresql/

We are glad to announce the 1.2.0 release of the  Percona Kubernetes Operator for Percona XtraDB Cluster. The Percona Kubernetes Operator for Percona XtraDB Cluster automates the lifecycle and provides a consistent Percona XtraDB Cluster instance. The Operator can be used to create a Percona XtraDB Cluster, or scale an existing Cluster, and contains the [&]

https://www.percona.com/blog/2019/09/20/percona-kubernetes-operator-for-percona-xtradb-cluster-1-2-0-now-available/