… 4.0K Apr 1 12:08 . dr-xr-x—. 4 root root 4.0K Apr 1 12:03 .. -rw-r–r–. 1 root root 1.2K Apr 1 12:08 cert.pem -rw-r–r–. 1… 4.0K Apr 1 12:12 .. -rw-r—–. 1 mysql mysql 1.2K Apr 1 12:08 cert.pem -rw-r—–. 1 mysql mysql 1.7K Apr 1…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
….0.0.1 Master_User: test Master_Port: 3306 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log….0.0.1 Master_User: rsandbox Master_Port: 35301 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log….0.0.1 Master_User: rsandbox Master_Port: 18675 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… st Fri Mar 22 10:03:22 UTC 2013 2 1 291992 224892 138848 7254284 0 0 148504 476 24190 24233… 5 0 Fri Mar 22 10:03:28 UTC 2013 1 4 291992 219104 138832 7262820 0 0 174854 160 18893 17002… 0 Fri Mar 22 10:03:38 UTC 2013 0 4 395888 355136 138844 7197992 0 47872 3350 125712 24148 21633… 23 0 Fri Mar 22 10:03:40 UTC 2013 4 4 495212 450516 138864 7208188 0 49664 2532 164356 30539 21120…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
…_info mysql-bin.000002 1232 c777888a-b6df-11e2-a604-080027635ef5:1-4 Now it contains both, binary log coordinates and GTID information….000002′, position 1232, gtid_executed c777888a-b6df-11e2-a604-080027635ef5:1-4 2- Apply the logs to the backup: # innobackupex –apply-log…_purged=”c777888a-b6df-11e2-a604-080027635ef5:1-4“; slave1 > CHANGE MASTER TO MASTER_HOST=”10.0.1.1“, master_user=”msandbox”, master_password=”msandbox…
Comment: Using Flexviews - part two, change data capture
April 13, 2013 By 26 Comments
… | c3 ————————— 3 | 6 | 1960 ————————— 8 | 8 | 1958 ————————— 13 | 4 | 1960 ————————— 5 | 2 | 1960 ————————— 4 | 7 | 1954 if you try to write the…_uow_id, 999,242,3,6,1960)(-1, @fv_uow_id, 999,243,13,4,1960)(-1, @fv_uow_id, 999,244,5…_uow_id, 999,242,3,6,1960),(-1, @fv_uow_id, 999,243,13,4,1960),(-1, @fv_uow_id, 999,244,5…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… because of an error: Last_SQL_Error: Error ‘Duplicate entry ‘4‘ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert… Executed_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-4 There are different ways to find the failed transaction. You … example. This slave server has retrieved transactions 1 to 5 but has only executed 1 to 4. That means that transaction 5 is…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… again. However, this was recently modified to a default of 1.0 to allow replication to resume as soon as possible…_limit=500; gcs.fc_master_slave=YES; gcs.fc_factor=1.0″; Working with flow control What happens during flow control…: wsrep_flow_control_paused – the fraction of time (out of 1.0) since the last SHOW GLOBAL STATUS that flow control… myclu P 3 3 node3 Sync T/T 0 4 0 3 0 4.3K 0.0 0 109 0 0 09…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release modules I received…_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group…_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid = 101…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… KEY (hid,mid,id) ). Also please note the transaction produces 4 INSERTs and workload is very write intensive. So what are… options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not… #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… out an important use case for PARTITIONing (“uneven reads”, Re: #1); let me rephrase the use case — * The entire table is… in 5.6; not sure about Percona or MariaDB. (Re #4) There are _no_ parallel queries (within a single connection) anywhere… UNIQUE/PRIMARY key and it can prune, the delete involves (1) find partition (if partitioned), (2) drill down the BTree, (3…
