EmergencyEMERGENCY? Get 24/7 Help Now!

Quest for Better Replication in MySQL: Galera vs. Group Replication

 | February 24, 2017 |  Posted In: Group Replication, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster, Replication

Group Replication

UPDATE: Some of the language in the original post was considered overly-critical of Oracle by some community members. This was not my intent, and I’ve modified the language to be less so. I’ve also changed term “synchronous” (which the use of is inaccurate and misleading) to “virtually synchronous.” This term is more accurate and already used by both […]

Read More

Group Replication: Shipped Too Early

 | February 15, 2017 |  Posted In: Group Replication, High-availability, MySQL, Percona XtraDB Cluster

Group Replication

This blog post is my overview of Group Replication technology. With Oracle clearly entering the “open source high availability solutions” arena with the release of their brand new Group Replication solution, I believe it is time to review the quality of the first GA (production ready) release. TL;DR: Having examined the technology, it is my […]

Read More

Percona Live Featured Tutorial with Frédéric Descamps — MySQL InnoDB Cluster & Group Replication in a Nutshell: Hands-On Tutorial

 | January 26, 2017 |  Posted In: High-availability, MySQL, Percona Live

Percona Live Featured Tutorial

Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read More

Setup ProxySQL for High Availability (not a Single Point of Failure)

 | January 19, 2017 |  Posted In: High-availability, Keepalived, MySQL, open source databases, OpenSource Databases on big machines, Percona Live, Percona MySQL Consulting, Percona Software, Percona XtraDB Cluster, ProxySQL

ProxySQL for High Availability

In this blog post, we’ll look at how to set up ProxySQL for high availability. During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting MySQL: ProxySQL. ProxySQL is becoming more flexible, solid, performant and used […]

Read More

Webinar Wednesday January 18, 2017: Lessons from Database Failures

 | January 17, 2017 |  Posted In: High-availability, MySQL, Technical 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 discussion about such topics as high availability (HA), geographical redundancy and automatic failover. […]

Read More

MongoDB PIT Backups: Part 2

 | January 9, 2017 |  Posted In: Cloud and NoSQL, High-availability, MongoDB, open source databases, Solutions Engineering

MongoDB PIT Backups

This blog post is the second in a series covering MongoDB PIT backups. You can find the first part here. Sharding Makes Everything Fun(ner) The first blog post in this series looked at MongoDB backups in a simple single-replica set environment. In this post, we’ll look at the scale-out use case. When sharding, we have exactly […]

Read More

MongoDB PIT Backups In Depth

 | December 16, 2016 |  Posted In: Cloud and NoSQL, High-availability, Insight for DBAs, Insight for Developers, MongoDB, open source databases, Percona Server, Solutions Engineering

MongoDB PIT Backups

In this blog is an in-depth discussion of MongoDB PIT backups. Note: INTIMIDATION FREE ZONE!! This post is meant to give the reader most of the knowledge that is needed to understand the material. This includes basic MongoDB knowledge and other core concepts. I have tried to include links for further research where I can. […]

Read More

Percona Live 2017 Sneak Peek Schedule Up Now! See the Available Sessions!

 | December 16, 2016 |  Posted In: Apache Spark, Big Data, Cloud and MySQL, Cloud and NoSQL, Database Monitoring, Docker, Events and Announcements, Group Replication, High-availability, InnoDB, MariaDB, MongoDB, MySQL, Orchestrator, Percona Live

Percona Live Featured Tutorial

We are excited to announce that the sneak peek schedule for the Percona Live 2017 Open Source Database Conference is up! The Percona Live Open Source Database Conference 2017 is April 24th – 27th, at the Hyatt Regency Santa Clara & The Santa Clara Convention Center. The Percona Live Open Source Database Conference 2017 is […]

Read More

Database Solutions Engineer FAQs

 | December 12, 2016 |  Posted In: Cloud and MySQL, Database Monitoring, High-availability, MySQL, Percona Monitoring and Management, Percona MySQL Consulting, Percona XtraDB Cluster, PMM, Solutions Engineering

Database Solutions Engineer

In this blog series, I will discuss common questions I receive as a database Solutions Engineer at Percona. In this role, I speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments. Typically we are contacted when the customer is about to embark […]

Read More

Managing Replication with Percona XtraDB Cluster

 | December 1, 2016 |  Posted In: GTID, High-availability, Percona XtraDB Cluster, Replication

Managing Replication

This blog post discusses managing replication with Percona XtraDB Cluster. Recently a customer asked me to setup replication between two distinct Percona XtraDB Clusters located in geographically separate data centers. The customer goal was to use one of the clusters only in case of disaster recovery. They tried extending the cluster, but because of the […]

Read More