… run of chef-client is done to update the cnf files with IP address of members (excluding itself). The rationale behind… PXC so that any latter modifications like these to cnf files are not required and preset it during cluster startup itself… blocked for a shorter while). By using Xtrabackup for SST, you also get its benefits like compression, parallel streaming, encryption, compact…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… jar file (5.0.0 at time of writing) Make sure you have latest copy of Java JRE for your platform You will… whether you need to provide a hint or not. Running SchemaSpy (with Foreign Keys) When you run schemaSpy without a metadata file, you will… to see if you have any implicit constraints that you might have missed and can then write into your metadata file. Donate – This…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… DRBD. When you run a virtual machine, in most cases your virtual disk is basically nothing more than a file on the host filesystem rather than an actual physical volume. So, in effect, you‘re adding performance… world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…=10002; mysql> start slave; Those of you who have already done these operations with file-based replication know that it is usually… and that proper recording of binlog file/binlog position needs to be done with care if you don’t want to break… binlog file/position of the last executed event and use mysqlbinlog with the good old –start-position option! Even with GTIDs, you…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… supports writing it directly to a file, or to a unix socket, which means you can write a script to listen on… plugin to work (plus one commented line for switching between file and socket for output): plugin-load=AUDIT=libaudit_plugin.so audit_offsets=6464, 6512, 4072, 4512, 104, 2584 audit_json_file=1 audit_json_socket_name=/tmp/audit.sock #audit_json…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… a quick refresher, Xtrabackup works by copying the dirty tablespace files while streaming the redo-logs to ensure that all transactions…-logs phase and then re-import those files to a running server. However, you need to have existing table structures in place…: ALTER TABLE tblname DISCARD TABLESPACE Copy the .exp and .ibd files from the snapshot to the new instance: cp /tmp/snapshot…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… there is approximately 12GB of data in the largest table. You can find the individual SSB query definitions in my previous… user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…/corosync/authkey” transport=”udpu” Let’s check if the configuration file is OK: [root@percona1 ~]# ccs_config_validate -f /etc/cluster/cluster.conf Configuration validates We can now copy the configuration file on all nodes: [root@percona1 ~]# scp /etc/cluster/cluster.conf… expected and you should be ready for the next distro upgrade! INFO: If you have the file /etc/corosync/service.d/pcmk you need…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
It seems that in 5.5 the second log file is touched even if a rotation has not occurred, that … you kept the size of your redo log files artificially low because recovery took a long time, you can consider increasing the file size…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… to small amount of ram prevents double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which l2arc and deduplication both need plenty of) You need to sacrifice…
