by Jaime Sicam | Jul 2, 2018 | Insight for DBAs, MySQL
GTID replication has made it convenient to setup and maintain MySQL replication. You need not worry about binary log file and position thanks to GTID and auto-positioning. However, things can go wrong when pointing a slave to a different master. Consider a situation...
by Lorraine Pocklington, Community Manager | Jun 27, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, PostgreSQL, Security, Webinars
Please join Percona’s Chief Evangelist Colin Charles on Thursday, June 28th, 2018, as he presents Securing Database Servers From External attacks at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now A critical piece of your infrastructure is the database...
by Robert Golebiowski | Mar 8, 2018 | Insight for DBAs, Monitoring, MySQL, Percona Software, Security
In this blog post, we’ll look at how to turn on binlog encryption in Percona Server for MySQL. Why do I need this? As you probably know, Percona Server for MySQL’s binlog contains sensitive information. Replication uses the binlog to copy events between...
by Sveta Smirnova | Aug 23, 2017 | Cloud, MySQL
In this blog post, we’ll discuss migrating data from encrypted Amazon MySQL RDS to encrypted Amazon Aurora. One of my customers wanted to migrate from an encrypted MySQL RDS instance to an encrypted Aurora instance. They have a pretty large database, therefore...
by Yves Trudeau | Aug 22, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll look at some of the MySQL high availability solution options. In the previous post of this series, we looked at the MySQL high availability (HA) solutions that have been around for a long time. I called these solutions “the...
by Juan Arruti | Jul 19, 2017 | Insight for DBAs, MySQL
In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file. MySQL version 5.6 and later allows you to execute replicated events using parallel threads. This feature is called Multi-Threaded Slave (MTS), and to enable it...
by Yves Trudeau | Jun 20, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog, we’ll look at different MySQL high availability options. The dynamic MySQL ecosystem is rapidly evolving many technologies built around MySQL. This is especially true for the technologies involved with the high availability (HA) aspects of MySQL....
by Dave Avery | Apr 25, 2017 | Insight for DBAs, Percona Live
It looks like the first day of the Percona Live Open Source Database Conference 2017 is coming to a close. Before we shut it down for today, we’ll look at a presentation on Real-Time Data Loading from MySQL and Oracle into Analytics/Big Data. In this session,...
by Vlad Lesin | Apr 14, 2017 | MySQL
TokuDB Hotbackup is a solution that allows you to do backups on the fly. It works as a library that intercepts certain system calls that duplicate data written to already copied parts of files, so that at the end of the backup process the copied files contain the same...
by Sveta Smirnova | Feb 16, 2017 | MySQL
In this blog post, we’ll look at a workaround for MySQL bug 72804. Recently I worked on a ticket where a customer performed a point-in-time recovery PITR using a large set of binary logs. Normally we handle this by applying the last backup, then re-applying all...
by Przemysław Malkowski | Feb 1, 2017 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency Problem Our customers often ask us for help or advice with WAN clustering problems. Historically, the usual solution for MySQL WAN...
by Dave Avery | Jan 17, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Chief Evangelist Colin Charles on Wednesday, January 18, 2017, at 7:00 am (PST) / 10:00 am (EST) (UTC-8) as he presents “Lessons from Database Failures.” MySQL failures at scale can teach a great deal. MySQL failures can lead to a...
by Wagner Bianchi | Nov 10, 2016 | Insight for DBAs, MySQL, Percona Services
This post discusses ways of fixing broken GTID replication. This blog series is all about the daily stories we have in Managed Services, dealing with customers’ environments (mostly when we need to quickly restore a service level within the SLA time). One of the...
by Marcelo Altmann | Nov 8, 2016 | MySQL
In this blog post, we will discuss how we can verify if an application transaction executed on the master has been applied to the slaves. In summary, is a good practice to alleviate the load on the master by doing reads on slaves. It is acceptable in most of the cases...
by David Ducos | Oct 21, 2016 | MySQL, Percona Software
In this blog post, we’ll look at how replication triggers a Performance Schema issue on Percona XtraDB Cluster. During an upgrade to Percona XtraDB Cluster 5.6, I faced an issue that I wanted to share. In this environment, we set up three Percona XtraDB Cluster...
by Sveta Smirnova | Sep 8, 2016 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the MySQL Replication Troubleshooting webinar. First, I want to thank everybody for attending the August 25 webinar. Below is the list of your questions that I wasn’t able to answer during the webinar, with...
by Przemysław Malkowski | May 24, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are...
by Nik Vyzas | Mar 30, 2016 | Cloud, Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll discuss some of the basics regarding Docker MySQL replication. Docker has gained widespread popularity in recent years as a lightweight alternative to virtualization. It is ideal for building virtual development and testing environments....
by Tom Diederich | Jul 9, 2015 | MySQL, Percona Events, Percona Live
The conference and tutorial schedule for Percona Live Europe 2015, September 21-23 in Amsterdam, was published this morning and this year’s event will focus on MySQL, NoSQL and Data in the Cloud. Conference sessions, which will follow each morning’s keynote addresses,...
by Francisco Bordenave | May 4, 2015 | Insight for DBAs, MariaDB, MySQL
MySQL replication isn’t perfect and sometimes our data gets out of sync, either by a failure in replication or human intervention. We are all familiar with Percona Toolkit’s pt-table-checksum and pt-table-sync to help us check and fix data inconsistencies...
