… ports. Why 4? Two of those NICs should be directly connected from one machine to another and configured with Linux network… you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to… privilege; a user with SUPER will always be able to connect, and that may not accurately report what your application servers…
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
…”] Alexei Rodriguez presenting at PLMCE13[/caption] During the Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday… Begins Monday, June 17, 2013 , 9am – 5pm Eastern Moving to MySQL 5.6 – Manchester, UK Begins Monday, June 17, 2013 , 9am…, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins Thursday, August 8, 2013 , 9am…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code:…=user:pass@localhost test.test # Source on localhost: … connected. $ pt-duplicate-key-checker –tables test.test # …
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…. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to the correct master with master_auto_position…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… Could not establish cib_ro connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2... [root@percona3 ~]# /etc/init.d/pacemaker start We can now connect crm_mon to the cluster and check its status: [root…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… introduced with the fix for bug #710799. This regression caused mysql schema to be missing after the clean RPM installation. Bug… #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: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb… to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var…
