… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
…’t have to export databases, you can use the existing mysql data dir. But check http://www.percona.com/doc/percona…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… large innodb database, do I have to export databases from mysql and import them in Percona server or can I use…? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS for my servers but i…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
…’s the url: http://www.percona.com/forums/questions-discussions/mysql-and-percona-server I’ll sure someone from our community…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys…
Comment: GROUP_CONCAT useful GROUP BY extension
June 6, 2013 By 49 Comments
I just wrote up a tiny example to demonstrate the group_concat function. I´m just posting this here since it might be useful for you : http://www.giombetti.com/2013/06/06/mysql-group_concat/
Comment: How to change innodb_log_file_size safely
June 6, 2013 By 17 Comments
I followed the article, mysql is working fine now, but i dont see any innodb tables in phpmyadmin, when “check table” it says table does not exist
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql]# service mysql…
Comment: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
The ERD tools I use are MySQL Workbench and SchemaSpy. The anomalies tab of SchemaSpy has been quite helpful. However both tools can’t really cope with really large schemas.
