…) through Xtrabackup SST (state snapshot transfer). Node3 subsequently joins the cluster with node1 and node2 in its gcomm:// (since by this… to cnf files are not required and preset it during cluster startup itself. The only caveat is that the node information…, you can refer a post by Peter Boros (“Percona XtraDB Cluster reference architecture with HaProxy”) for details. In their setup they…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26
June 18, 2013 By Leave a Comment
Percona XtraDB Cluster (PXC) was released over a year ago and since then …. As such, I’m giving a webinar entitled Percona XtraDB Cluster Operations on June 26th 2013 from 10-11AM PDT. Topics will include: Backups from the cluster Avoiding SST Flow Control What and How to Monitor Tuning…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… -f /etc/cluster/cluster.conf –addfenceinst pcmk percona3 pcmk-redirect port=percona3 Encrypt the cluster: [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –setcman keyfile… nodes: [root@percona1 ~]# scp /etc/cluster/cluster.conf percona2:/etc/cluster/ [root@percona1 ~]# scp /etc/cluster/cluster.conf percona3:/etc/cluster/ Enable CMAN at startup on…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
Bandwidth multiplication and synchronous clusters I’ve seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps… message is sent to other node in the cluster. The more nodes in your cluster, the more the bandwidth required for replication…]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also somewhat similar… Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going to be talking to the same set… give it a shot. I set up a 3 node cluster in AWS, got the volume mounted, and went to try…
Comment: Percona XtraBackup 2.1.2 for MySQL available for download
May 22, 2013 By 4 Comments
…/questions-discussions/percona-xtradb-cluster/10198-can-not-get-percona-xtradb-cluster-to-link-up-start-mysql-its-a-cluster-f). When I…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… that the illumos base currently lacks a potent open source clustering solution. RSF-1 costs a lot. So OmniOS should only… get Galera working on OmniOS to solve our lack of clustering problem on illumos?
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… # ######################################################################## # test.test # ######################################################################## # Key redundant ends with a prefix of the clustered index # Key definitions: # KEY `redundant` (`col2`,`id`) # PRIMARY KEY (`id…` int(11) not null auto_increment # To shorten this duplicate clustered index, execute: ALTER TABLE `test`.`test` DROP INDEX `redundant`, ADD…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
… see anyone wanting to try to run a mixed replication cluster of MySQL 5.6 and MariaDB 10 using GTID. You… to get even a pure MySQL 5.6 gtid replication cluster working …
Comment: Minimizing Downtime from Lengthy AWS Outages
June 12, 2013 By 7 Comments
Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.
