…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA… pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… more the bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to each, so… mysql]# service mysql start [root@node3 mysql]# service mysql start We can see that a multicast node still needs to bind to the Galera replication…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
…-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at some other layer of…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…, I’ve used Xtrabackup simply to clone a server (for replication or migration) or migrate an existing schema to a new…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to staging with different…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an incorrect… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities… regular replication and GTID replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific… if you’re not using GTID-based replication. If you are using GTID-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… than with file-based replication. We will see how to change the replication topology when using GTID-based replication. That will show where…; mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication… with GTIDs, you cannot totally forget old-style replication positioning. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you …, additional requirements will appear like hot backups, online schema changes, replication based high availability (which has some caveats). Also, because of asynchronous replication, you can end up having inconsistent data on the nodes…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY… statements http://mysqlopt.blogspot.co.uk/2013/06/restrictions-on-replication-with-gtids.html
