Thanks to all attendees of the webinar yesterday! If you missed it, you can watch the video recording. Here are some questions that remained unanswered due to time constraints. Q: Are there any technical considerations or best practice tips to have a replicated slave in the cloud, for example on Amazon AWS? Hardware resources are [...]
How to STOP SLAVE on Amazon RDS read replica
December 20, 2012 By 4 Comments
We are doing a migration from Amazon RDS to EC2 with a customer. This, unfortunately, involves some downtime – if you are an RDS user, you probably know you can’t replicate an RDS instance to an external server (or even EC2). While it is annoying, this post isn’t going to be a rant on how [...]
Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 6 Comments
Well, it happened again… Another lengthy EBS outage in the US-East region impacted several sites across the net. While failures like this are rare, they can be quite costly and translate into headaches for the operations team when impact production systems for any length of time. At Percona, we routinely help clients architect and deploy [...]
News Flash: SQL Injection Still a Problem
July 18, 2012 By 3 Comments
The threat of SQL injection has appeared prominently in the news recently: An SQL injection vulnerability resulted in an urgent June bugfix release of Ruby on Rails 3.x. Make sure you upgrade if you use Rails 3.0, 3.1, or 3.2! Also you should disable mass assignment in any Rails project. Yahoo! Voices was hacked in July. The [...]
Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment. They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other. Test Environment The test environment included AWS EC2 nodes in US-East and US-West (Oregon). The ping RTT latency [...]
Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
One of the more common questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means I should advise something that is stable, reliable, easy to manage and has plenty of resources available online. It should also allow running MySQL without too [...]
Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
Percona Live London starts on Monday, so this is the last in the series of free-Percona-Live tickets we’ll give away. But first — have you ever wondered what servers are in your MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication [...]
MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
A while ago I started a series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t add anything to this discussion, I got sidetracked, and then time passed, and I no longer think it’s a good idea to publish those blog posts [...]
Announcing Training for Operations Teams
August 18, 2010 By 3 Comments
We’re opening up registration for our new training courses today. In short: we are moving from two days to a new four-day format. The new additions are created by: Splitting our current InnoDB day in half. We now have one day for DBAs, and one day just on InnoDB topics. A new Operations Day – covering [...]
Terms of Use
May 17, 2006 By 17 Comments
Would you like to republish our articles? This blog is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License. If you republish an article, You must provide a direct link to original article on this site Information about author and original source must be retained You must provide access to the content free of charge [...]
