Lessons Learned  Learning from those who blazed the trail! Another cool thing I like about attending conferences is learning from how other companies and people overcame problems, how they run their systems, and figure out problems that I may run into in the future. Secretly I also want to validate how I have done [&]

https://www.percona.com/blog/2021/05/10/war-stories-and-learning-from-others-percona-live/

The new MyDumper 0.10.5 version, which includes many new features and bug fixes, is now available.  You can download the code from here. For this release, we focused on fixing some old issues and testing old pull requests to get higher quality code. On releases 0.10.1, 0.10.3, and 0.10.5, we released the packages compiled against [&]

https://www.percona.com/blog/2021/05/07/mydumper-0-10-5-is-now-available/

I love learning from others and exploring the implementation details other database engines provide. Percona Live has no shortage of new databases, tools, and discussions on interesting new features or ways of tackling old problems. I went through the agenda and wanted to highlight a few new databases and tools (new to me or new [&]

https://www.percona.com/blog/2021/05/07/cool-new-projects-technology-and-broadening-my-horizons-at-percona-live/

Considering a move to the cloud, but unsure which provider is right for you? According to the results of our 2020 Open Source Data Management Software Survey, AWS continues to dominate the public cloud provider market, with 50% of respondents using its cloud platform in 2020, with Microsoft Azure quickly gaining market share with 23% adoption [&]

https://www.percona.com/blog/2021/05/07/webinar-june-8-the-pros-and-cons-of-aws-azure-and-google-cloud-which-cloud-provider-is-right-for-your-business/

We are in the “home stretch” for Percona Live and I am continuing to highlight some of the great content out there!  Today I would like to focus on content I think will be very interesting to the developers and contributors who are working on the core elements of open source database projects.  We have [&]

https://www.percona.com/blog/2021/05/06/percona-live-sessions-for-engineers-working-on-building-and-developing-databases/

AKA Cluster Error Voting& What is Cluster Error Voting (CEV)? “Cluster Error Voting is a new feature implemented by Alexey Yurchenko, and it is a protocol for nodes to decide how the cluster will react to problems in replication. When one or several nodes have an issue applying an incoming transaction(s) (e.g., suspected inconsistency), this [&]

https://www.percona.com/blog/2021/05/04/inconsistent-voting-in-percona-xtradb-cluster/

There is a common pattern in life, you often discover or understand things by accident. Many scientific discoveries fit such a description. In our database world, I was looking to see how BLOB/TEXT columns are allocated using overlay pages and I stumbled upon something interesting and unexpected. Let me present to you my findings, along [&]

https://www.percona.com/blog/2021/05/04/innodb-file-growth-weirdness/

Percona Monitoring and Management has been available for single-click deployment from AWS Marketplace for several years now, and we have hundreds of instances concurrently active and growing rapidly due to unparalleled ease of deployment. Today we’re announcing we are changing pricing for Percona Monitoring and Management on AWS Marketplace. Currently, Percona Monitoring and Management (PMM) [&]

https://www.percona.com/blog/2021/05/03/changes-to-percona-monitoring-and-management-on-aws-marketplace/

Nothing lasts forever, including hardware running your EC2 instances. You will usually receive an advance warning on hardware degradation and subsequent instance retirement, but sometimes hardware fails unexpectedly. Percona Monitoring and Management (PMM) currently doesnt have an HA setup, and such failures can leave wide gaps in monitoring if not resolved quickly. In this post, [&]

https://www.percona.com/blog/2021/04/29/improving-percona-monitoring-and-management-ec2-instance-resilience-using-cloudwatch-alarm-actions/

The latest schedule for Percona Live ONLINE 2021, taking place on May 12-13, allows you to filter by track to identify the sessions that interest you most! The conference takes place May 12-13 and features more than 150 expert speakers and over 160 hours of content across 200 sessions, representing dozens of projects, communities, and [&]

https://www.percona.com/blog/2021/04/29/percona-live-online-how-companies-manage-customer-data-volume-rises-while-staying-performant/

This blog post will show how to compile the Percona XtraBackup (PXB) tool for ARM. For this, we are going to use an AWS EC2 ARM instance with Ubuntu 20.04(Focal Fossa). The motivation for this was born in my interest in the new generation of ARM processors and if this is a viable option for [&]

https://www.percona.com/blog/2021/04/28/compiling-percona-xtrabackup-for-arm/

Multi-writer replication has been a challenge in the MySQL ecosystem for years before truly dedicated solutions were introduced  first Galera (and so Percona XtradDB Cluster (PXC)) replication (around 2011), and then Group Replication (first GA in 2016). Now, with both multi-writer technologies available, do we still need traditional asynchronous replication, set up in active-active [&]

https://www.percona.com/blog/2021/04/28/resolving-the-mysql-active-active-replication-dilemma/

One way to run Percona Monitoring and Management (PMM) v2 on Windows is using the Virtual Appliance installation method. It works well but requires you to run extra software to run Virtual Appliances, such as Oracle VirtualBox, VMWare Workstation Player, etc. Or, you can use Docker. Docker is not shipped with Windows 10, though you [&]

https://www.percona.com/blog/2021/04/28/running-percona-monitoring-and-management-v2-on-windows-with-docker/

Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you [&]

https://www.percona.com/blog/2021/04/27/percona-monthly-bug-report-april-2021/

We’re leveling up  would you like to join us on Discord? There we chat about databases, open source, and even play together. On May 6th at 11 am EST, the Percona Community is talking about Percona Monitoring and Management (PMM). Our experts are also there to live tune and optimize your database  come [&]

https://www.percona.com/blog/2021/04/27/percona-monitoring-and-management-meetup-on-may-6th-join-us-for-live-tuning-and-roadmap-talk/

DBAs are important cogs in the availability, performance, and security of your data. Getting a great DBA is one of the most important things any company can do to ensure their database operations continue working without a problem.  So how do you find great DBAs? In this post I’m going to show you some of [&]

https://www.percona.com/blog/2021/04/27/mysql-101-10-great-mysql-dba-interview-questions-and-answers/

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/26/tons-of-new-features-in-percona-monitoring-and-management-2-16-0-updated-percona-distribution-for-mongodb-release-roundup-april-26-2021/

Apologies for the silly title, but the issue is a real one, even though it is not a new thing. Schema upgrades are not an ordinary operation in Galera. For the subject at hand, the bottom line is: under the default Total Order Isolation (TOI) method, “the cluster replicates the schema change query as a [&]

https://www.percona.com/blog/2021/04/23/yearly-reminder-ddls-that-fail-to-propagate-may-cause-percona-xtradb-cluster-inconsistencies/

A few years ago, I wrote about how to add information about processes to your Percona Monitoring and Management (PMM) instance as well as some helpful ways you can use this data. Since that time, PMM has released a new major version (PMM v2) and the Process Exporter went through many changes, so it’s time [&]

https://www.percona.com/blog/2021/04/22/understanding-processes-running-on-linux-host-with-percona-monitoring-and-management/

These scripts demonstrate the command line interface, CLI, pg_rewind re-provisioning a formerly deprecated PRIMARY host, pg1, into a viable STANDBY. Although the scripts have been written expressly for a custom-made set of two Linux containers using CENTOS7, it has been written in a form that is hopefully clear and concise enough that they can be [&]

https://www.percona.com/blog/2021/04/22/demonstrating-pg_rewind-using-linux-containers-in-postgresql/