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

Cluster with floating IP

sonhakarisonhakari EntrantCurrent User Role Beginner
Hello,

I am testing XtraDB Cluster. I see that when we first install it for three nodes cluster, We set wsrep_cluster_address null for node1, and set wsrep_cluster_address as node1 for nodes node2 and node3.

If I want to add new node or failed node again, I should set wsrep_cluster_address to one of healthy nodes.

My question is; does XtraDB cluster supports floating IP by own? If yes,How can I implement it?

I only set the wsrep_cluster_address parameter to floating IP, and never change it again. By this, I can add node only starting mysql.

Thanks.

Comments

  • lefredlefred Contributor Inactive User Role Beginner
    No, there is no floating ip by default.
    If you add a new node (or restart the first one in your case) you need to change the value of wsrep_cluster_address to a different running node.
  • ayurchenayurchen Contributor Inactive User Role Beginner
    The idea seems to be brilliant. However

    1) mysqld by default does not have enough privileges to configure network interfaces
    2) this most likely won't work in the cloud and WAN (so it is suitable only for a user-controlled LAN)

    Any thoughts on how to resolve these?
  • vinnyrodyvinnyrody Entrant Inactive User Role Beginner
    I f you are using MY Sql then it have predefine libraries in order to interface with the system.It is always better to use predefine libraries .
  • lexandlexand Entrant Inactive User Role Beginner
    <cite>sonhakari wrote on Fri, 13 April 2012 17:11</cite>
    Hello,
    If I want to add new node or failed node again, I should set wsrep_cluster_address to one of healthy nodes.

    just need some confimation

    If primary node in cluster is down, how can I add it again?
    Do I understand correctly that former primary node can be added to any healthy (synced) node?
  • ayurchenayurchen Contributor Inactive User Role Beginner
    In Galera cluster there is no "primary" node, all nodes are of the same rank, but may differ by the state they are currently in (SYNCED, JOINED, etc.).
    Moreover, it does not matter which node you initially connect to as long as it is a part of the primary cluster component: Galera cluster is a full undirectional graph.
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.