… what I did. 1) Backup up the database as specified with –export option with the “innodb_import_table_from_xtrabackup=1” turned ON. 2) Then deleted some records from one of the tables. 3) Prepared the backup with…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… (for incremental): ‘3:763362037′ >> log scanned up to (3 845737724) xtrabackup: Stopping log copying thread. xtrabackup: Transaction log of lsn (3 763355707) to (3 845737724) was…. xtrabackup: xtrabackup_logfile detected: size=92684288, start_lsn=(3 763355707) xtrabackup: Temporary instance for recovery is set as followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb…. On new server we run set global innodb_expand_import=1; to put XtraDB into extended import mode, and now we…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…=xtrabackup wsrep_node_name=ip-10-112-39-98 log_slave_updates innodb_locks_unsafe_for_binlog=1 …wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | +——————–+——-+ | wsrep_cluster_size | 3 | +——————–+——-+ 1 row in set (0.00 sec) When all …
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… ones love, and ones hate) 1) do backup of specific tables on sources server with xtrabackup (server can run InnoDB or XtraDB… of test/img_out59 InnoDB: import: 3 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10… just need to shutdown instance with innodb_fast_shutdown=1 (done in xtrabackup –prepare –export call). The more complex problem was that…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…. If you are using ntp servers stratum should be 3 or less, you can monitor it with echo sysinfo |… use it? Does xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since…is faster then writing only to 1, the reason for this is that only 1 node has to parse SQL,…
Comment: xtrabackup-0.3, binaries and stream backup
March 20, 2009 By 11 Comments
…/lib/mysql … #>innobackupex-1.5.1 –databases=saturn –user=root –password=******* –slave-info /tmp InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009… closed 090321 00:41:00 innobackupex: Starting ibbackup with command: xtrabackup –backup –suspend-at-end –target-dir=/tmp/2009-03-21… file ‘/tmp/2009-03-21_00-40-56/xtrabackup_suspended’ xtrabackup Ver alpha-0.3 for 5.0.77 unknown-linux-gnu (x86…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… whenever application can see any stale reads. My setup is 3 Percona XtraDB Cluster nodes talking through dedicated 1Gbit cluster network… fully synchronous replication behavior: mysql> set global wsrep_causal_reads=1; Query OK, 0 rows affected (0.00 sec) When this….9.1,10.9.9.2,10.9.9.3 #wsrep_cluster_address=gcomm:// wsrep_slave_threads=8 wsrep_sst_method=xtrabackup wsrep…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… = ‘percona-xtradb-cluster’ +project_name = ‘percona-xtradb-cluster’ #project_name = ‘xtrabackup‘ -project_name = None +#project_name = None defaults = get_defaults(qp….3.r3683 Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. mysql> select * from t1; +—-+ | a | +—-+ | 1… it as follows: server_requests = {‘join_cluster’:[(0,1), (0,2), (0,3)]} When you are done, you may use mode=cleanup…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… generator to produce 50 tables, with sizes from 1 row to 50 rows. 3) Specify the server options. We wanted the server… server used –innodb_file_per_table and that we used Xtrabackup‘s –parallel option. I also wanted to create multiple schemas… same steps we use in our basic_test from the xtrabackup suite. We just copied and modified the test case to…
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
… use a backup for this purpose, we have 3 prerequisites: use XtraBackup >= 2.0.1 the backup needs to be performed with –galera… have your backup, you should now see a file called xtrabackup_galera_info. The file contains the local node state at… fetched during the backup. For example, if we have in xtrabackup_galera_info the following content: 5f22b204-dc6b-11e1-0800-7a9c9624dd66…
