Allow configuration of mysql percona sst through xtrabackup-v2

Bug #1507054 reported by Joseph Davis on 2015-10-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
tripleo
Undecided
Unassigned

Bug Description

Currently, tripleo delivers a cluster.cnf for MySQL clustering which defines the wsrep-sst-method as "rsync". While this is simple and works, it can be slow on really large databases.

https://github.com/openstack/tripleo-image-elements/blob/master/elements/mysql-common/os-apply-config/mnt/state/etc/mysql/conf.d/cluster.cnf

The Percona documentation, such as https://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html, recommends using xtrabackup-v2.

The downside to xtrabackup-v2 is it also requires a user, specified as wsrep_sst_auth, be created in the MySQL database with the correct privileges. This is pretty simple:
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sst'@'localhost' IDENTIFIED BY 'secret';

We should provide a way to select the xtrabackup-v2 method of SST replication per-cluster, and have the MySQL element create the user with the right privileges and a fresh, random password.

This password is not to be used by a customer at any time, so it doesn't need to be exposed/configurable through a UI. Also be warned, it appears the password is logged in the MySQL logs, so the password should not be reused from any other, more secure accounts in the cloud.

(thanks to Kyle Smith who reported this issue to me)

description: updated
description: updated
tags: added: mysql
description: updated
description: updated
Ben Nemec (bnemec) wrote :

I'm afraid tripleo-image-elements is effectively an abandoned project at this point. All of the people who were actively maintaining the elements have left the project, and the current focus is on a puppet-based deployment method. While I suppose we would take a patch for this, I think it's unlikely to be fixed.

Changed in tripleo:
status: New → Won't Fix
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers