If there is only one galera node, it should bootstrap automatically

Bug #1624327 reported by Jesse Pretorius
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack-Ansible
Fix Released
Wishlist
Jimmy McCrory

Bug Description

In small environments, usually for testing or for very small production environments, there may only be one galera node in the environment. The environment may grow over time to have more nodes.

Ideally if there is only one host in the 'galera_all' group, the cluster should automatically be bootstrapped if the galera host/container is rebooted.

Changed in openstack-ansible:
importance: Undecided → Wishlist
Changed in openstack-ansible:
assignee: nobody → Jimmy McCrory (jimmy-mccrory)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to openstack-ansible-galera_server (master)

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

Changed in openstack-ansible:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to openstack-ansible-galera_server (master)

Reviewed: https://review.openstack.org/382683
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-galera_server/commit/?id=21885c1f37fd28290f5fc04f40d5ad3581a80ed1
Submitter: Jenkins
Branch: master

commit 21885c1f37fd28290f5fc04f40d5ad3581a80ed1
Author: Jimmy McCrory <email address hidden>
Date: Wed Oct 5 15:59:11 2016 -0700

    On single nodes use an empty cluster address

    When there is only one galera node, configure galera with an empty
    cluster address. Each time the mysql service starts on this node it will
    automatically create a new cluster.

    Closes-Bug: #1624327
    Change-Id: If653b1aacbd446a4ea5bb806a839dad40011b5b8

Changed in openstack-ansible:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to openstack-ansible-galera_server (stable/newton)

Fix proposed to branch: stable/newton
Review: https://review.openstack.org/382739

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to openstack-ansible-galera_server (stable/newton)

Reviewed: https://review.openstack.org/382739
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-galera_server/commit/?id=91ab40e9a3d51121e79f291772624c7481a80dfc
Submitter: Jenkins
Branch: stable/newton

commit 91ab40e9a3d51121e79f291772624c7481a80dfc
Author: Jimmy McCrory <email address hidden>
Date: Wed Oct 5 15:59:11 2016 -0700

    On single nodes use an empty cluster address

    When there is only one galera node, configure galera with an empty
    cluster address. Each time the mysql service starts on this node it will
    automatically create a new cluster.

    Closes-Bug: #1624327
    Change-Id: If653b1aacbd446a4ea5bb806a839dad40011b5b8
    (cherry picked from commit 21885c1f37fd28290f5fc04f40d5ad3581a80ed1)

tags: added: in-stable-newton
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/openstack-ansible-galera_server 14.0.0.0rc3

This issue was fixed in the openstack/openstack-ansible-galera_server 14.0.0.0rc3 release candidate.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to openstack-ansible-galera_server (stable/mitaka)

Fix proposed to branch: stable/mitaka
Review: https://review.openstack.org/394545

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to openstack-ansible-galera_server (stable/mitaka)

Reviewed: https://review.openstack.org/394545
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-galera_server/commit/?id=528bb2271cdb2c222f65df14fbded53f27415bd2
Submitter: Jenkins
Branch: stable/mitaka

commit 528bb2271cdb2c222f65df14fbded53f27415bd2
Author: Jimmy McCrory <email address hidden>
Date: Wed Oct 5 15:59:11 2016 -0700

    On single nodes use an empty cluster address

    When there is only one galera node, configure galera with an empty
    cluster address. Each time the mysql service starts on this node it will
    automatically create a new cluster.

    Closes-Bug: #1624327
    Closes-Bug: #1595143
    Change-Id: If653b1aacbd446a4ea5bb806a839dad40011b5b8
    (cherry picked from commit 21885c1f37fd28290f5fc04f40d5ad3581a80ed1)

tags: added: in-stable-mitaka
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix merged to openstack-ansible-galera_server (master)

Reviewed: https://review.openstack.org/395118
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-galera_server/commit/?id=ff4e9c6ece0849d08f36dda93315181fe5a75339
Submitter: Jenkins
Branch: master

commit ff4e9c6ece0849d08f36dda93315181fe5a75339
Author: Jesse Pretorius <email address hidden>
Date: Tue Nov 8 18:51:39 2016 +0000

    Allow a single-node MariaDB cluster to restart properly

    With the implementation of https://review.openstack.org/382683 a single
    MariaDB node has no peers configured, so there's no need to bootstrap
    the cluster on restart.

    This patch removes the condition in the handler which previously was
    needed to handle the re-bootstrap during a single node cluster service
    restart.

    Closes-Bug: #1595143
    Closes-Bug: #1639900
    Related-Bug: #1624327
    Change-Id: I599bbf0efa4e3d5abdf6d95c95d7983c464b3ae5

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix proposed to openstack-ansible-galera_server (stable/newton)

Related fix proposed to branch: stable/newton
Review: https://review.openstack.org/397764

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix merged to openstack-ansible-galera_server (stable/newton)

Reviewed: https://review.openstack.org/397764
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-galera_server/commit/?id=cc58790ebefff19133b8114ad7d263409fe1ccc5
Submitter: Jenkins
Branch: stable/newton

commit cc58790ebefff19133b8114ad7d263409fe1ccc5
Author: Jesse Pretorius <email address hidden>
Date: Tue Nov 8 18:51:39 2016 +0000

    Allow a single-node MariaDB cluster to restart properly

    With the implementation of https://review.openstack.org/382683 a single
    MariaDB node has no peers configured, so there's no need to bootstrap
    the cluster on restart.

    This patch removes the condition in the handler which previously was
    needed to handle the re-bootstrap during a single node cluster service
    restart.

    Closes-Bug: #1595143
    Closes-Bug: #1639900
    Related-Bug: #1624327
    Change-Id: I599bbf0efa4e3d5abdf6d95c95d7983c464b3ae5
    (cherry picked from commit ff4e9c6ece0849d08f36dda93315181fe5a75339)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix proposed to openstack-ansible-galera_server (stable/mitaka)

Related fix proposed to branch: stable/mitaka
Review: https://review.openstack.org/398385

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix merged to openstack-ansible-galera_server (stable/mitaka)

Reviewed: https://review.openstack.org/398385
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible-galera_server/commit/?id=a9627447c0d5504d717b63f6677ba254fc86f421
Submitter: Jenkins
Branch: stable/mitaka

commit a9627447c0d5504d717b63f6677ba254fc86f421
Author: Jesse Pretorius <email address hidden>
Date: Tue Nov 8 18:51:39 2016 +0000

    Allow a single-node MariaDB cluster to restart properly

    With the implementation of https://review.openstack.org/382683 a single
    MariaDB node has no peers configured, so there's no need to bootstrap
    the cluster on restart.

    This patch removes the condition in the handler which previously was
    needed to handle the re-bootstrap during a single node cluster service
    restart.

    Closes-Bug: #1595143
    Closes-Bug: #1639900
    Related-Bug: #1624327
    Change-Id: I599bbf0efa4e3d5abdf6d95c95d7983c464b3ae5
    (cherry picked from commit cc58790ebefff19133b8114ad7d263409fe1ccc5)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/openstack-ansible-galera_server 15.0.0.0b1

This issue was fixed in the openstack/openstack-ansible-galera_server 15.0.0.0b1 development milestone.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/openstack-ansible-galera_server 13.3.9

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.