The full keynotes schedule for Percona Live ONLINE 2021, taking place on May 12-13, is now live online! Attracting thousands of attendees from around the globe, Percona Live is the longest-running, largest, independent conference dedicated to the vast ecosystem of open source database technologies. The conference keynote sessions are split over two days. They will [&]

https://www.percona.com/blog/2021/04/22/percona-live-online-keynotes-now-live/

MySQL databases keep getting larger and larger. And the larger the databases get, the harder it is to backup and restore them.  MyDumper has changed the way that we perform logical backups to enable you to restore tables or objects from large databases. Over the years it has evolved into a tool that we use [&]

https://www.percona.com/blog/2021/04/21/back-from-a-long-sleep-mydumper-lives/

Percona Kubernetes Operators support various options for storage: Persistent Volume (PV), hostPath, ephemeral storage, etc. In most of the cases, PVs are used, which are provisioned by the Operator through Storage Classes and Persistent Volume Claims. Storage Classes define the underlying volume type that should be used (ex. AWS, EBS, gp2, or io1), file system [&]

https://www.percona.com/blog/2021/04/20/change-storage-class-on-kubernetes-on-the-fly/

MySQL Group Replication is a plugin that helps to implement highly available fault-tolerant replication topologies. In this blog, I am going to explain the complete steps involved in the below two topics. How to convert the group replication member to an asynchronous replica How to convert the asynchronous replica to a group replication member Why [&]

https://www.percona.com/blog/2021/04/19/mysql-group-replication-conversion-of-gr-member-to-async-replica-and-back-in-the-same-cluster/

Percona Monitoring and Management 2.13 (PMM) introduced the Integrated Alerting feature as a technical preview. It adds a user-friendly way to set up and manage alerts for your databases. You can read more about this feature usage in our announcement blog post and in our documentation, while in this article we will be focusing on [&]

https://www.percona.com/blog/2021/04/16/integrated-alerting-design-in-percona-monitoring-and-management/

The Microsoft Azure SQL Database is among the most popular databases of 2020, according to DB-Engines DBMS of the Year award. Also, its steadily climbing up in DB-Engines Ranking. The ranking is updated monthly and places database management systems according to their popularity. In case you didnt know, DB-Engines is an initiative to collect and [&]

https://www.percona.com/blog/2021/04/16/add-microsoft-azure-monitoring-within-percona-monitoring-and-management-2-16-0/

This week we release Percona Monitoring and Management 2.16 (PMM), which brings some exciting new additions we’d like to highlight! Amazon RDS PostgreSQL Monitoring AWS monitoring in PMM now covers PostgreSQL RDS and PostgreSQL Aurora types. PMM will include them in a Discovery UI where they can be added which will result in node-related metrics [&]

https://www.percona.com/blog/2021/04/16/percona-monitoring-and-management-2-16-brings-microsoft-azure-monitoring-via-a-technical-preview/

The End Of Support date for Ubuntu 16.04 LTS is coming soon. According to the Ubuntu Release Life Cycle, it will be at the end of April 2021. With this announcement comes some implications to support for Percona software running on these operating systems. So we will no longer be producing new packages and binary [&]

https://www.percona.com/blog/2021/04/15/platform-end-of-support-announcement-for-ubuntu-16-04-lts/

While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how online DDL is executed inside a Group Replication cluster. The online DDL feature provides support for instant and in-place table alterations and concurrent DML. Checking the Group Replication (GR) official documentation, I [&]

https://www.percona.com/blog/2021/04/15/online-ddl-with-group-replication-in-percona-server-for-mysql-8-0-22/

You can earn Percona swag by writing a short technical review about Percona software by May 30, 2021!  The keyword here is technical. Percona is seeking reviews that describe Percona software use in particular environments or in solving particular issues, and why! This means being specific about your Percona environment, architecture, and problem-solving. Usage of [&]

https://www.percona.com/blog/2021/04/14/win-percona-swag-for-technical-product-reviews/

https://www.percona.com/blog/2021/04/14/what-you-can-do-with-auto-failover-and-percona-distribution-for-mysql-8-0-x/

This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on our best practices. Every architecture and deployment depends on the customer requirements and application demands for high availability and the estimated level of usage. For example, using high read or high write applications, or both, with a [&]

https://www.percona.com/blog/2021/04/14/percona-distribution-for-mysql-high-availability-with-group-replication-solution/

The full conference schedule for Percona Live ONLINE 2021, taking place on May 12-13, is now live!  This year we see a strong focus on how organizations successfully managed the technology challenges of the past 12 months. Register and attend for FREE! A number of presentations demonstrate the key role databases played in achieving company [&]

https://www.percona.com/blog/2021/04/14/percona-live-online-focus-on-unprecedented-demand-for-scale/

Chasing bugs can be a tedious task, and multi-threaded software doesnt make it any easier. Threads will be scheduled at different times, instructions will not have deterministic results, and in order for one to reproduce a particular issue, it might require the exact same threads, doing the exact same work, at the exact same time. [&]

https://www.percona.com/blog/2021/04/12/replay-the-execution-of-mysql-with-rr-record-and-replay/

Its release roundup time again here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Todays [&]

https://www.percona.com/blog/2021/04/12/latest-version-of-pg_stat_monitor-in-percona-distribution-for-postgresql-bug-fix-in-percona-server-for-mongodb-release-roundup-april-12-2021/

Recently, I needed to set up a Proof of Concept (POC) and wanted to do it on Google Cloud Platform (GCP).  After documenting the process, it seemed it might be helpful for others looking for the most basic guide possible to get a Mongo server up and running on GCP.  The process below will set [&]

https://www.percona.com/blog/2021/04/09/deploying-a-mongodb-proof-of-concept-on-google-cloud-platform/

So your MySQL server has crashed.  What do you do now?  When a server is down, in my opinion, there are two steps that are essential and both are extremely important and neither should be neglected: Save diagnostic information for determining the root cause analysis (RCA). Get the server back up and running. Too many [&]

https://www.percona.com/blog/2021/04/07/mysql-101-basic-mysql-server-triage/

Percona Kubernetes Operators allow users to simplify deployment and management of MongoDB and MySQL databases on Kubernetes. Both operators allow users to store backups on S3-compatible storage and leverage Percona XtraBackup and Percona Backup for MongoDB to deliver backup and restore functionality. Both backup tools do not work with Azure Blob Storage, which is not [&]

https://www.percona.com/blog/2021/04/07/percona-kubernetes-operators-and-azure-blob-storage/

Percona Live ONLINE is a community-focused event for database developers, administrators, and decision-makers to share their knowledge and experiences. We would love you to join us on May 12-13 for this year’s event. Register and attend for FREE! This year Percona Live is going to be our biggest and best event yet!  Free, just like [&]

https://www.percona.com/blog/2021/04/06/whats-new-at-percona-live-online-2021/

I try to use Open Source when a good solution exists, so for my home firewall, I’m using OPNSense   a very powerful FreeBSD-based firewall appliance with great features along with a powerful GUI. One of the plugins available with OPNSense is  node_exporter, which exposes a lot of operating system metrics through the Prometheus protocol. [&]

https://www.percona.com/blog/2021/04/06/monitoring-opnsense-firewall-with-percona-monitoring-and-management/