Tag - mysql-and-variants

Percona Customer Portal and Your New, Free User Account

Percona Customer Portal

Google, Microsoft, and Apple have it. So do open source organizations like MongoDB, Red Hat, and SUSE. What do all these companies provide? A customer portal that enables anyone to create an identity with the company. To date, Percona hasn’t had a customer portal with a free user account –  but that’s about to […]

Read more

How To Inject an Empty XA Transaction in MySQL

Inject an Empty XA Transaction in MySQL

If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction.

Shell

Last_Error: Error ‘XAER_NOTA: Unknown XID’ on query. Default database: ‘punisher’. Query: […]

Read more

How to Upgrade to MySQL 8.0 – Free Course at Percona University Online

upgrade to MySQL 8

MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been successfully upgraded to the new version. But many […]

Read more

Data Consistency for RDS for MySQL: The 8.0 Version

data consistency rds mysql 8

In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency.
Starting with 8.0.1, MySQL introduced something called “Dynamic Privileges” which is a solution to grant […]

Read more

How Much Memory Does the Process Really Take on Linux?

Memory Process takes on Linux

One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer activated, killing process altogether.
Before adjusting memory usage, either by […]

Read more