LINUX.ORG.RU
ФорумAdmin

Вопрос по MySQL Galera.

 , , wresp


0

1

Настраиваю MySQL Galera. И у меня все прекрасно получилось по ману http://www.percona.com/doc/percona-xtradb-cluster/howtos/ubuntu_howto.html .

Ну вот читаю официальный ман http://www.codership.com/wiki/doku.php?id=info и там написано что использовать пустой «wsrep_cluster_address=gcomm://» а нужно делать по-новому «mysqld --wsrep_new_cluster».

Bootstrapping a new cluster

To bootstrap a new cluster you need to start the first mysqld server with an empty cluster address URL specified either in my.cnf or on the command line:

$ mysqld --wsrep_new_cluster
This implies to the server that there is no existing cluster to connect to and it will create a new history UUID.

Restarting the server with the same setting will cause it to create new history UUID again, it won't reconnect to the old cluster. See next section about how to reconnect to existing cluster.

>>>Older versions used empty gcomm:// address to create a cluster. This behaviour is deprecated. Never put empty gcomm address in my,cnf! Use –wsrep-_new_cluster option on the command line instead.

Adding another node to a cluster

Once you have a cluster running and you want to add/reconnect another node to it, you must supply an address of one of the cluster members in the cluster address URL. E.g. if the first node of the cluster has address 192.168.0.1, then adding a second node would look like

$ mysqld --wsrep_cluster_address=gcomm://192.168.0.1  # DNS names work as well
The new node only needs to connect to one of the existing members. It will automatically retrieve the cluster map and reconnect to the rest of the nodes.

Once all members agree on the membership, state exchange will be initiated during which the new node will be informed of the cluster state. If its state is different from that of the cluster (which is normally the case) it will request snapshot of the state from the cluster 5) and install it before becoming ready for use.

Я же так пробовал и у меня ничего не подключалось к первой ноде (смотрел по статусу в mysql). Т.е. я взял первую ноду и запустил там

$ mysqld --wsrep_new_cluster

На следующих:

$ mysqld --wsrep_cluster_address=gcomm://192.168.0.1

(192.168.0.1 - первая нода)

Что же я делал не так?

★★★★★

А с авторизацией на 192.168.0.1 у подчиненных нод нет проблем?
Покажите my.cnf на главной и подчиненных нодах

teamfighter
()
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.