… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… you working with MySQL or its variants at the code level? Share your perspective about the internals or explain how specific features work in depth. These stories are gold! And you owe it to the MySQL community to share…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… about MHA for MySQL High Availability in the Cloud Matt Yonkovit, our VP of Consulting, will explain how to work with BigData effectively Justin Swanhart, our Senior MySQL Instructor, will continue the topic of… verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government data. The…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… child_B it is explicit. This has an impact on how SchemaSpy identifies the relationship, and whether you need to provide…. Running SchemaSpy The syntax below if specific for MySQL, but note that SchemaSpy works for pretty much all the popular RDBMS out there. java -jar schemaSpy_5.0.0.jar -t mysql -u…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…before the update, see bellow how to perform this action [root@...MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql… cluster is fixed and everything works again as expected and …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… for MySQL 5.6, based on what I have seen so far (admittedly, not that much – I have personally only worked with… wait for the next release of MHA. Q: How do you monitor MySQL to determine when it’s not responsive? A: The…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the… last executed event is 219be3a9-c3ae-11e2-b985-0800272864ba:1. How can I instruct mysqlbinlog to start reading from there? Unfortunately… mysqlfailover from the MySQL Utilities (this will be the topic of a future post). Unfortunately, this will not work for every use…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…a production setup. The manual describes very nicely how to switch to GTID-based replication, I … simple tests answer the first two questions: replication works only if all servers have the same value…slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you…try writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL … the primary key solution for random selection only work when the IDs for movies are distributed …
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
You can replicate from MySQL 5.6 to MariaDB 10.0 or vice versa. You …-style replication will work. That being said, I agree that compatibility is good. If you have any suggestion of how to make MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
In a previous post I explained how to repair MySQL 5.6 GTID replication using two different methods. I didn’… Percona MySQL University @Toronto about GTID. It includes an overview of MySQL 5.6 GTID that can help people to start working with this new feature in MySQL 5.6. Here…
