Featured
Percona Products
Percona Services
Use Cases
Fernando MatteraThis blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper way of doing things without the need to run a test when in doubt. That said, I must emphasize that, as always, testing everything before deploying to production is essential. Let’s dive into the story: […]
Hello friends, In Managed Services, we have the opportunity to see different technologies and various topologies, which makes the work fascinating and challenging at the same time. This time, I’m going to tell you about a particular case: a client with a dual-primary topology plus a replica, as detailed below:
1 2 3 | PS-primary-1=192.168.0.14 [RW] |___ PS-primary-2=192.168.0.59 [RW] (Slave_delay: 0) |___ PS-replica-1=192.168.0.99 [R] (Slave_delay: 0) |
[RW] means Read/Write access. […]
Hello friends! If you plan to migrate your database from on-prem servers to RDS (either Aurora or MySQL RDS), you usually don’t have much choice but to do so using logical backups such as mysqldump, mysqlpump, mydumper, or similar. (Actually, you could do a physical backup with Percona XtraBackup to S3, but given that it […]
Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem. In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. A comment worth clarifying is […]
Hello friends, at Percona Managed Services, we usually do different types of things every day, including routine tasks, monitoring, and, very frequently, answering questions that are not always easy to answer. A few days ago, a client asked us the following question: “Hey Percona, I have a question and a problem simultaneously: I want to […]
Hey folks, This blog is straightforward but, at the same time, handy. At Percona, we know that the audience of our blogs is not limited to DBAs but includes a broader range of IT professionals, such as sysadmins, help desk employees, NOC operators, and developers as well. Sometimes people (and also some DBAs, why not?) […]
Hello folks, we all know the benefits of table compression in MySQL, with current technology, processing speed, and compression disks, and in most cases, it is a benefit. Now, what happens when that doesn’t happen? In this simple blog, I’m going to show you something interesting that happens when you try to transition from a […]
Today we are going to present you with another way to make a database copy between servers using our Percona XtraBackup utility. What is the difference with many others existing on the web? Not many, but they are interesting in terms of performance and availability. We will combine the xbstream utility with the power of […]