by Marco Tusa | Jan 19, 2017 | Insight for DBAs, MySQL, ProxySQL
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...
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 Jon Tobin | Jan 9, 2017 | Cloud, Insight for DBAs, MongoDB, Open Source
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,...
by Alexey Zhebel | Dec 15, 2016 | MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona XtraDB Cluster 5.7.16-27.19 on December 15, 2016. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.16-27.19 is now the current release, based on the following: Percona...
by Krunal Bauskar | Nov 22, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog I will provide answers to the questions and queries that some of you have raised during the webinar on Nov 17th. I would like to say thank you to all of the audience who attended the talk on November 17, 2016. You can also check the recording and slides...
by Dave Avery | Nov 15, 2016 | Insight for DBAs, MySQL, Percona Software, Webinars
Join Percona’s Percona XtraDB Cluster Lead Software Engineer Krunal Bauskar for a webinar on Thursday, November 17, 2016, at 7:30 am PST on MySQL High Availability with Percona XtraDB Cluster 5.7. Percona XtraDB Cluster 5.7 is our brand new MySQL 5.7 compatible...
by Tibor Korocz | Nov 9, 2016 | Insight for DBAs, MySQL, ProxySQL
In this blog post, I am going to show you how can you use Orchestrator and ProxySQL together. In my previous blog post, I showed how to use bash scripts and move virtual IPs with Orchestrator. As in that post, I assume you already have Orchestrator working. If not,...
by Tibor Korocz | Nov 3, 2016 | Insight for DBAs, MySQL
In this post, I’ll discuss how to moving VIPs during a failover using Orchestrator. In our previous post, we showed you how Orchestrator works. In this post, I am going to give you a proof-of-concept on how Orchestrator can move VIPs in case of failover. For...
by Colin Charles | Sep 26, 2016 | Insight for DBAs, Percona Live
This blog will review some of the high availability topics featured at this year’s Percona Live Europe, Amsterdam conference. The topic of high availability MySQL is always hot, because beyond just being available, you also want efficient database manageability....
by Nik Vyzas | Sep 16, 2016 | MySQL
When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are: “What are the best tools to provide HA and Load...
by Marco Tusa | Sep 15, 2016 | Insight for DBAs, MySQL, Percona Software, ProxySQL
In this post, we’ll discuss how an integrated ProxySQL and Percona XtraDB Cluster (Galera) helps manage node states and failovers. ProxySQL is designed to not perform any specialized operation in relation to the servers with which it communicates. Instead, it...
by Dave Avery | Aug 2, 2016 | Insight for DBAs, Insight for Developers
This blog reports the results of Percona’s high availability poll. High availability (HA) is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost of downtime...
by Dave Avery | Jun 20, 2016 | Insight for DBAs, MySQL
Please join Percona, Technical Account Manager, Michael Patrick on Thursday, June 23, 2016 at 10 AM PDT (UTC-7) as he presents “
by Dave Avery | May 23, 2016 | Insight for DBAs
Wondering what high availability (HA) solutions are most popular? Take our high availability poll below! HA is always a hot topic. The reality is that if your data is not available, your customers cannot do business with you. In fact, estimates show the average cost...
by Dave Avery | Apr 20, 2016 | Percona Live
Percona Live 2016 had a great first day, with an impressive number of speakers and topics. I was able to attend a session in the afternoon with Luis Soares, Principal Software Engineer at Oracle, on High Availability Using MySQL Group Replication. MySQL Group...
by Jay Janssen | Sep 14, 2015 | Insight for DBAs, MySQL
Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability. This blog is for me to address the extra questions I didn’t have time to answer on the stream. What do you think about using Galera Cluster but writing to a...
by Kortney Runyan | Jul 20, 2015 | MySQL, Percona Events, Percona Live
The Percona Live Data Performance Conference in Amsterdam is just two months away and it’s going to be an incredible event. With a new expanded focus on MySQL, NoSQL, and Data in the Cloud, this conference will be jam-packed with talks from some of the industry’s...
by Stephane Combaudon | Jun 12, 2015 | MySQL
Percona XtraDB Cluster (PXC) has become a popular option to provide high availability for MySQL servers. However many people are still having a hard time understanding what will happen to the cluster when one or several nodes leave the cluster (gracefully or...
by Michael Coburn | Jun 4, 2015 | Insight for DBAs, MySQL
Next Wednesday (June 10) I’ll be co-presenting a webinar on using MySQL in the cloud for High Availability (HA). Joining me will be 451 Research analyst Jason Stamper and together we’ll talk about the realities of HA using MySQL in the cloud and how...
by Stephane Combaudon | Nov 17, 2014 | Insight for DBAs, MySQL
Even if a Galera node looks like a regular MySQL server, the underlying replication mechanism is very different. This implies some changes in the way you have to configure the Galera nodes. Here are some of the most common misconceptions about Galera when using this...