…votes 7 Resources configured. ============ Online: [ percona1 percona2 percona3 ] reader_vip_1 (ocf::heartbeat:IPaddr2): Started percona3 reader_vip_2 (… Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2 percona…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…release” means. In MySQL 5.7 the checks will be…-prefix of col2_2 # Key definitions: # KEY `col2` (`col2`), # KEY `col2_2` (`col2`,`col3`) #… # Key redundant ends with a prefix of the clustered index # Key definitions: # KEY `redundant` (`…
Comment: Percona XtraBackup 2.1.2 for MySQL available for download
May 22, 2013 By 4 Comments
… bug in the 2.1.1 and 2.1.2 version (see http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/10198-can-not-get-percona-xtradb-cluster-to-link-up-start-mysql-its-a-cluster-f). When I update i could not start my second and third node. I must rollback on 2.0.7…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available….user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used when…-30.2 including all the bug fixes in it and on Codership wsrep API 5.5.30-23.7.4, Percona XtraDB Cluster…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase … need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file …138836 7216444 0 4080 53400 53714 18422 16234 2 7 72 18 0 Fri Mar 22 10:03:38…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.2
February 13, 2013 By Leave a Comment
…”] Percona XtraDB Cluster[/caption] Percona is glad to announce the release of Percona XtraDB Cluster 5.5.29-23.7.2 on February 13th… all the bug fixes in it, Percona XtraDB Cluster 5.5.29-23.7.2 is now the current stable release. All of…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…_index_size | 2 | | wsrep_cluster_conf_id | 4 | | wsrep_cluster_size | 2 | | wsrep_cluster_state_uuid | 8dccca9f-d4b8-11e1-0800-344f6b618448 | | wsrep_cluster_status | …0,’percona1′,’vadim’); Query OK, 1 row affected (7.77 sec) percona1 mysql> insert into percona values (0,’percona1′,’miguel’); Query…
Comment: Announcement of Percona XtraDB Cluster (alpha release)
January 11, 2012 By 30 Comments
… and may stall cluster. Later, the support of DDL will be improved, but will always require special treatment. EG: MySQL cluster 7.2 supports join-push down with adaptive query localization. Is that supported by xtradb cluster? Also, what is…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
…=/usr/local/mysql-cluster-gpl-7.0.8a/lib/mysql ./ndbapi_scan /usr/local/mysql-cluster-gpl-7.0.8a/mysql.sock 127.0.0.1 MySQL Cluster already has example table: GARAGE. Dropping it… MySQL Cluster… Pink 1 Mercedes Blue 13 Toyota Pink 6 BMW Black 2 Mercedes Blue 4 Mercedes Blue 8 BMW Black scan_print…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… MySQL Replication Latency in Percona XtraDB Cluster[/caption] I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL replication…: mysql> set global wsrep_causal_reads=1; Query OK, 0 rows affected (0.00 sec) When this option is enabled the cluster… XtraDB Cluster (GPL), wsrep_23.7.2.r3843 wsrep_node_address=10.9.9.1 wsrep_provider=/usr/lib/libgalera_smm.so wsrep_cluster…
