… data will be a very IO intense operation (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter Xtrabackup… target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue can arise… engine for the respective table on master databases. Also, if BINLOG_FORMAT is not consistent on master/slave db. 3. CREATE…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush… #####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
… spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup…. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger a bug if the… slave in replication) and binlog information wasn’t available. Fixed by not creating xtrabackup_binlog_info file when binlog isn’t available. Bug…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 24, 2013 By 15 Comments
… different MySQL configuration. Make sure you’re using the same innodb_* parameters and binlog settings (log-bin, binlog-format, sync-binlog, etc.)
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method…_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 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… be good if your async master can use ROW based binlog format as well to achieve better consistency, if you have…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with…. Percona XtraBackup now stores the GTID value in the xtrabackup_binlog_info when doing the backup of MySQL and Percona Server…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with…. Percona XtraBackup now stores the GTID value in the xtrabackup_binlog_info when doing the backup of MySQL and Percona Server… were not printed to stderr directly. Because of that all InnoDB error or diagnostic messages are never printed by xtrabackup_56…
