…_RESKEY_test_passwd_default=”mysql” OCF_RESKEY_enable_creation_default=0 OCF_RESKEY_additional_parameters_default=”" OCF_RESKEY_replication_port_default…_CHECK_LEVEL=”1” \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1” primitive reader_vip_1 ocf:heartbeat:IPaddr2 \ params ip=”192.168.163…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…=5029 column=date_id mapper=hash gearman=127.0.0.1:7000 inlist=* between=* [shard1] host=192.168.56.102 Scale-out In addition to… gearman=127.0.0.1:7000 inlist=* between=* [shard1] host=192.168.56.101 db=ontime [shard2] host=192.168.56.102 db=ontime [shard3] host=192.168.56.103 db=ontime [shard4] host=192.168.56…
Post: Timezone and pt-table-checksum
September 25, 2012 By 1 Comment
… dst_dsn:h=192.168.1.46,p=…,u=percona lock:1 transaction:1 changing_src:percona.checksums replicate:percona.checksums bidirectional:0 pid:1821 user… dst_dsn:h=192.168.1.46,p=…,u=percona lock:1 transaction:1 changing_src:percona.checksums replicate:percona.checksums bidirectional:0 pid:1821 user…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
…:heartbeat:IPaddr \ params ip=”192.168.2.200″ \ operations $id=”failover-ip-operations” \ op monitor start-delay=”0” interval=”2″ \ meta …” \ expected-quorum-votes=”2″ \ stonith-enabled=”false” \ dc-version=”1.1.6-3.el6-a02c0f19a00c1eb2527ad38f146ebc0834814558″ \ no-quorum-policy=”ignore” \ cluster-…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 0 1 row in set (0.00 sec) mysql> select * from information_schema.client_STATISTICS\G *************************** 1. row *************************** CLIENT: 192.168.10.174 TOTAL_CONNECTIONS: 10 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 0…
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
… for this purpose, we have 3 prerequisites: use XtraBackup >= 2.0.1 the backup needs to be performed with –galera-info (option… ist.recv_addr (ex: wsrep_provider_options = “ist.recv_addr=192.168.70.2;”) if you don’t use yet the magic…:03 [Note] WSREP: async IST sender starting to serve tcp://192.168.70.2:4568 sending 24-27 120802 13:05:15…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… 0.1 0.1 2.9 0.1 1678.6 | 1341.6 0.1 74.4 1584.6 87.0 | 337.0 0.1 0.1 1.1 0.0 1670.9 | 1334.9 0.1 75.0 1567.0 88.0 | 336.0 0.1 0.1 1.0 0.0… 0.1 0.1 1.5 0.0 [root@udbqa006.sf2p ~]# lvcreate –size 60g –snapshot –name snap /dev/VolGroup20/mysqldata Logical volume “snap” created 626.7 | 502.0 0.1 168.7 2581.4 192.8 | 124.7 0.1 121.5 2471.1 203.7 310.3 | 248.7…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 130221 17:59:05 [Note] WSREP: wsrep_start_position var…_host = 192.168.14.150; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache…_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 1, 2012 By 22 Comments
…) requested state transfer from ‘*any*’. Selected 0 (ubuntu-server-128)(SYNCED) as donor. Apr 1 14:14:26 ubuntu-server-129 mysqld…: success, donor: 0 Apr 1 14:14:27 ubuntu-server-129 mysqld: 120401 14:14:26 [Warning] IP address ‘192.168.210.128′ could not be resolved: Name or service not known Apr 1 14:14:27 ubuntu…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… Position: 98 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.00 sec) If you’re backing up from the…. mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.10.171 Master_User…_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 1 row in set (0.00 sec) As you can see in this output…
