Not the answer you need?
Register and ask your own question!

VIP for XtraDB Cluster

onalliononallion EntrantInactive User Role Beginner
Hello dear experts.

I'm new here (and new in general to MySQL), so please be gentle.

For testing purposes, I have setup a 3-Node XtraDB cluster in a lab environment using the documentation here. Everything is working great.
I then installed the application (in this case it is Zabbix) on all 3 nodes, and using Pacemaker+Corosync I set up a simple HA for the application (one node is active, two others are standby in case it fails).

I'm now missing the final step: I need to point my application to a database. Obviously I'm gonna need some sort of floating IP address that represents all 3 nodes, and some way to perform load-balancing. I've looked at several solutions for this, but I've only become more confused. What is the simplest way to achieve this, preferably one with a good step-by-step guide for the scared newbie?

Thanks!

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.