Comments on: MySQL High Availability With Percona XtraDB Cluster (Percona MySQL Training) https://www.percona.com/blog/public-training-mysql-high-availability-percona-xtradb-cluster/ Wed, 07 Aug 2019 13:33:01 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Phil Stracchino https://www.percona.com/blog/public-training-mysql-high-availability-percona-xtradb-cluster/#comment-8597310 Tue, 02 Sep 2014 15:25:35 +0000 https://www.percona.com/blog/?p=23073#comment-8597310 In reply to Jay Janssen.

Thanks for the prompt response, Jay. đŸ™‚

]]>
By: Jay Janssen https://www.percona.com/blog/public-training-mysql-high-availability-percona-xtradb-cluster/#comment-8597067 Tue, 02 Sep 2014 14:59:55 +0000 https://www.percona.com/blog/?p=23073#comment-8597067 >>First, I have occasionally run into problems in which a joining node will try to connect to *itself*, and fail, if its address is the first in wsrep_cluster_address. Since this variable is fully maintained in memory by the cluster once the node joins, I have taken to omitting each node’s own address from wsrep_cluster_address. Do you see any problem with this practice, or any reason why it should not be done, other than convenience in setting up the config file?

That’s a bug and it should be reported as such here: https://bugs.launchpad.net/percona-xtradb-cluster/+filebug
It’s likely something special with your config. I don’t like having a special config per host just because it complicates things operationally.

>> Secondly, since XtraDB Cluster already uses its own internal transaction UUIDs, it seems to me that using MySQL 5.6 GTIDs within XtraDB Cluster would be redundant. What is your viewpoint on this?

If you are using async replication with PXC, then GTIDs for that may be of some value for you: https://www.percona.com/blog/2014/02/14/changing-async-slave-pxc-cluster-new-master-using-5-6-gtid/

>> And third, do you see any problem with using innodb_buffer_pool_dump_at_shutdown and innodb_buffer_pool_load_at_startup with XtraDB Cluster? Do you have an opinion on whether it should or should not be used?

No, it should generally be fine.

]]>
By: Phil Stracchino https://www.percona.com/blog/public-training-mysql-high-availability-percona-xtradb-cluster/#comment-8597018 Tue, 02 Sep 2014 14:54:51 +0000 https://www.percona.com/blog/?p=23073#comment-8597018 Jay, I attended your XtraDB Cluster training class in July, and I have come up with a few questions.

First, I have occasionally run into problems in which a joining node will try to connect to *itself*, and fail, if its address is the first in wsrep_cluster_address. Since this variable is fully maintained in memory by the cluster once the node joins, I have taken to omitting each node’s own address from wsrep_cluster_address. Do you see any problem with this practice, or any reason why it should not be done, other than convenience in setting up the config file?

Secondly, since XtraDB Cluster already uses its own internal transaction UUIDs, it seems to me that using MySQL 5.6 GTIDs within XtraDB Cluster would be redundant. What is your viewpoint on this?

And third, do you see any problem with using innodb_buffer_pool_dump_at_shutdown and innodb_buffer_pool_load_at_startup with XtraDB Cluster? Do you have an opinion on whether it should or should not be used?

]]>