server_id missing in my.cnf

[Paul Halmos]

Server_id needs to be set in my.cnf to each infra nodes unique ID.

server_id = N (i.e. server_id = 3 on infr003, server_id=2 on infra002, etc.)

[Paul Halmos (paul-halmos)]

This is needed as described in this MySQL documentation:

https://dev.mysql.com/doc/refman/5.0/en/replication-howto-existingdata.html

This needs to be set under [mysqld] in my.cnf as described here:

https://dev.mysql.com/doc/refman/5.0/en/replication-howto-slavebaseconfig.html

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/209404

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/209404
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible/commit/?id=9ae6eeca8b592e345202c2fbf697ce2089718ac9
Submitter: Jenkins
Branch: master

commit 9ae6eeca8b592e345202c2fbf697ce2089718ac9
Author: Darren Birkett <email address hidden>
Date: Wed Aug 5 09:42:57 2015 +0100

    set unique galera server-id

    Each slave in a mysql replication cluster needs to have a unique
    'server-id' set. This is an arbitrary integer, and often people select
    1,2,3 etc. For easy deterministic uniqueness without needing to look at
    what you've already used, a simple filter has been created to allow for
    the hostname to be converted into an integer.

    The server ID variable has been added to the my.cnf.j2 template
    and the galera_server defaults/main.yml file. The generation of the
    server-id variable happens within the `galera-install.yml` play making
    it so there is no future impact in role requires.

    Change-Id: Id15149e59cb03ab268bb3b7eeaf391334dfc0c01
    Fixes-Bug: #1479484

[Bjoern (bjoern-t)]

Personally I don't see the need for juno anymore, considering how long open this issue is already.
This issue needs to be fixed for kilo since major workload is and will run for quite some time.,

[Jesse Pretorius (jesse-pretorius)]

Kilo review: https://review.openstack.org/267054

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/267054
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible/commit/?id=d0bb38042e1367d53d3fce206ed1d26bcbc9d432
Submitter: Jenkins
Branch: kilo

commit d0bb38042e1367d53d3fce206ed1d26bcbc9d432
Author: Darren Birkett <email address hidden>
Date: Wed Aug 5 09:42:57 2015 +0100

    set unique galera server-id

    Each slave in a mysql replication cluster needs to have a unique
    'server-id' set. This is an arbitrary integer, and often people select
    1,2,3 etc. For easy deterministic uniqueness without needing to look at
    what you've already used, a simple filter has been created to allow for
    the hostname to be converted into an integer.

    The server ID variable has been added to the my.cnf.j2 template
    and the galera_server defaults/main.yml file. The generation of the
    server-id variable happens within the `galera-install.yml` play making
    it so there is no future impact in role requires.

    Conflicts:
     playbooks/plugins/filters/osa-filters.py

    Change-Id: Id15149e59cb03ab268bb3b7eeaf391334dfc0c01
    Closes-Bug: #1479484
    (cherry picked from commit 9ae6eeca8b592e345202c2fbf697ce2089718ac9)

[Jesse Pretorius (jesse-pretorius)]

Setting Juno series target to "Won't Fix" as there will be no more adjustments going into the Juno branch unless they are Critical bugs.

[Davanum Srinivas (DIMS) (dims-v)]

This issue was fixed in the openstack/openstack-ansible 11.2.11 release.

[Doug Hellmann (doug-hellmann)]

This issue was fixed in the openstack/openstack-ansible 11.2.12 release.

[Davanum Srinivas (DIMS) (dims-v)]

This issue was fixed in the openstack/openstack-ansible 11.2.14 release.

[Doug Hellmann (doug-hellmann)]

This issue was fixed in the openstack/openstack-ansible 11.2.15 release.