…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… my colleagues (thanks Bill Karwin!), the cumbersome part of this process is the DISCARD/IMPORT TABLESPACE step as that is done…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… speed a lot faster and can contribute to the Development process a lot more effectively when I know the relationships between… 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: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… can write a script to listen on this socket and process the audit records as you wish. Performance-wise, I did… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…benefits: Backups that complete quickly and reliably Uninterrupted transaction processing during backups Savings on disk space and network … It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…. The other reason is because virtual machines tend to handle process scheduling and timing much differently than traditional hardware, and I… rules are processed. There are some informative flowcharts in addition to the textual explanation. Q: What is my recommendation for MySQL 5… mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… you want to upgrade, you cannot apply any rolling upgrade process. So like for Pacemaker 0.6.x to 1.0…: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2..._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…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… s0 to 10004 for s4. Scenario #1: All slaves have processed all the writes This is the easiest case, we will… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… the crash. 130528 09:53:56 mysqld_safe Number of processes running now: 0 130528 09:53:56 mysqld_safe WSREP…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… for failover during peak traffic. The standby server does not process query traffic except for replication. The buffer pool and adaptive…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
…, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special… and energy into development of MySQL with an engineering team of over 200 developers The release process is more agile, predictable, and effective than ever before thanks to adoption of the Oracle development discipline MySQL 5…
