….schema.sql Create the new target database: mysqladmin create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.schema... snapshot to the new instance: cp /tmp/snapshot/2013-06-03_11-30/orig/*[.exp|.ibd] /var/lib/mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…term basis which has given me time to explore new tools using their environments. One tool that I …, and which are candidates for dropping (why keep old data if you don’t need to?). I …Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… all the operations are straightforward: #For s2 (the new master), we remove its configuration as a …For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And … event and use mysqlbinlog with the good old –start-position option! Even with GTIDs, you …
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 … automatically pick the correct binlog position when switching to a new master. Old-style replication will work. That being said, I agree… MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction ID, I would very much like…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… great learning venue for me. I learn about new technologies in the MySQL space as well as how these technologies can be… MySQL practitioners as speakers as well as attendees who all share their deep technical insights, holding back no secrets. Reconnect with Old… for me to stay attuned to the new companies, products and other developments in the MySQL ecosystem – both to drive Percona’s…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
….4 for MySQL on April 17, 2013. Binaries are available from the downloads area or from our software repositories. New Features: Percona… definitions. Bug fixed #1100496 (Seppo Jaakola). Debian packages included the old version of innotop. Fixed by removing innotop and its InnoDBParser… leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will…removed. Bug fixed #710799 (Alexey Bychko). Debian packages included the old version of innotop. Fixed by removing innotop and its …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…2 — New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will…removed. Bug fixed #710799 (Alexey Bychko). Debian packages included the old version of innotop. Fixed by removing innotop and its …
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
…, it feels like a MySQL Renaissance. All of the major MySQL players are coming to the Percona Live MySQL Conference and Expo 2013… give a tutorial titled, “Percona XtraBackup: Old and New Features.” I actually traded my other talk, “MySQL 5.6 improvements from InnoDB internals prospective,” with Oracle’s Sunny Bains and his talk, MySQL 5.6: What’s New in…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… structure from .frm files or take it from some old backup. A new tool sys_parser can recover the table structure from… need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila/actor’; +————–+—–+——–+——+——–+———+————–+——-+ | NAME | ID… of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS…
