… the buffer pool. Note that this can be somewhat mitigated using innodb_old_blocks_time, but that is outside the scope of… data will be a very IO intense operation (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter Xtrabackup… < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the –export flag: innobackupex –apply…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables… as MYISAM) with innodb tables within the same transaction. The same issue can arise if slave host is using different storage engine for the respective table on master databases. Also, if BINLOG_FORMAT is not consistent…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup… use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… as if it were using SSD storage or to just use an optimized HDD …innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb…_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 24, 2013 By 15 Comments
… IO because of different MySQL configuration. Make sure you’re using the same innodb_* parameters and binlog settings (log-bin, binlog-format, sync-binlog, etc.)
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… ids(after load of data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… because before Galera can create writesets for the replicated events, binlog events must be generated for the transactions first. Under normal… so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM… additional structures used for certification. Having said that, it would be good if your async master can use ROW based binlog format as…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… available release, the current stable version should be used (currently 2.0.7 in the 2.0… files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6…. now stores the GTID value in the xtrabackup_binlog_info when doing the backup of MySQL and…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6…. now stores the GTID value in the xtrabackup_binlog_info when doing the backup of MySQL and…enabled. Example of how this information can be used to create/restore a slave can be found…
