… switchover when master is dying/dead. Yes, there are wrappers/scripts around this to make life easier, however, wouldn’t it… is used with xinetd on the node along with a script which checks PXC for its sync status. As referenced in…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… (currently a blueprint in innobackupex). He also included this helpful script to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl.sql SELECT CONCAT(‘ALTER…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…. If you google a bit with “zfs snapshot script” you’ll many scripts ready for the task. Snapshots work best with InnoDB…
Comment: Migrating between MySQL schemas with Percona Xtrabackup
June 11, 2013 By 2 Comments
Is there a way to modify the discard script so that it deals with foreign key constraints?
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…’s see this effect in action. I have a simple script that outputs the network throughput on an interface every second…
Comment: Experiences with the McAfee MySQL Audit Plugin
May 29, 2013 By 4 Comments
Peter: The docs say these are offsets in the mysqld binary to some data structures. By looking at the offset extraction script it seems these are query_id, thread_id, main_security_ctx, command and lex from THD, and comment from LEX.
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… to a unix socket, which means you can write a script to listen on this socket and process the audit records…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
i would appreciate your comments on this script: taken from: http://phptechnicalgroups.blogspot.co.il/2013/05/simple-…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… Debian installation. Bug fixed #1032139 (Alexey Bychko). The mysqld_safe script would fail to retrieve the Galera replication position on Ubuntu…). Fixed the wrong path in the /etc/xinetd.d/mysqlchk script. Bugs fixed #1000761 and #1132934 (Raghavendra D Prabhu). When upgrading the Percona-XtraDB-Cluster-server package, /usr/bin/clustercheck script would get overwritten, and any changes (such as username and…
