May 21, 2013

Using MySQL Sandbox with Percona Server

February 16, 2013 By 3 Comments

One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use MySQL Sandbox in its most basic way and it will work:

However [...]

Filed Under: MySQL Tagged With: , ,

Replication checksums in MySQL 5.6

February 15, 2013 By 3 Comments

MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many people misunderstand the real added value of this new feature. I heard people think that with replication checksums, data integrity between the master and its replicas is now enforced. As we’ll see, it’s not that [...]

Filed Under: MySQL Tagged With: , , ,

How to create/restore a slave using GTID replication in MySQL 5.6

February 8, 2013 By 7 Comments

MySQL 5.6 is GA! Now we have new things to play with and in my personal opinion the most interesting one is the new Global Transaction ID (GTID) support in replication. This post is not an explanation of what is GTID and how it works internally because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html One [...]

Filed Under: MySQL

Read/Write Splitting with PHP Webinar Questions Followup

January 23, 2013 By 4 Comments

Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars.  If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as I could during the session, but here are [...]

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Webinar on Read/Write Splitting with PHP

January 17, 2013 By 2 Comments

I’ll be presenting a webinar next Wednesday, January 23 at 10 a.m. (Pacific Time), about issues application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair. Specifically, about the care we have to take because replication is asynchronous.  This means the slave  may not have current data [...]

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , , , , ,

How does MySQL Replication really work?

January 9, 2013 By 9 Comments

While we do have many blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really works on the high level. Or it’s been so long ago I can’t [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Serious build and testing automation

January 2, 2013 By Leave a Comment

Here at Percona we’ve spent a lot of time improving our development and testing practices. Why? Because constant innovation keeps us ahead and more productive. We want to work smarter, not harder. One of the tools we use is the Jenkins Continuous Integration server. We use Jenkins pretty heavily to help with out development processes [...]

Filed Under: MySQL Tagged With: , , , , , ,

Announcing Percona XtraBackup 1.6.7

December 21, 2012 By Leave a Comment

Percona is glad to announce the latest stable release of Percona XtraBackup 1.6.7 on December 20th, 2012 (Downloads are available here). This release is purely composed of bug fixes to the previous stable release of Percona XtraBackup. New users should head for Percona XtraBackup 2.0 rather than 1.6. Bugs Fixed: xtrabackup_binary was not included in tar [...]

Filed Under: Percona Software Tagged With: ,

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 [...]

Filed Under: Insight for DBAs, MySQL Tagged With: , , , , ,

Percona Toolkit Webinar followup Q&A

December 19, 2012 By 1 Comment

First, a thank you to everyone who attended the webinar Today, I appreciate your time and nice comments. As promised, here are answers to questions that couldn’t be answered during the talk:   Q: How do you install the tools? The manual has full details, but it’s important to know that the latest release for [...]

Filed Under: Insight for DBAs, MySQL Tagged With: ,
« Older Posts
Newer Posts »