OpenStack DBaaS (Trove)

MySQL/MariaDB/Percona replication brakes is Guest agent runs as root

Bug #1744165 reported by Gaëtan Trellu
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
In Progress
Undecided
Gaëtan Trellu

Bug Description

The MySQL/MariaDB and Percona replication doesn't work anymore since this commit: https://github.com/openstack/trove/commit/36926f39e6ced5b6e5da5201975ff0194f4ed52a

The replication is created using "os_admin" user via innobackupex command. The previous commit override /root/.my.cnf (with the "os_admin" credential) by the "root" credentials.

The reason is these block of code: https://github.com/openstack/trove/blob/master/trove/guestagent/datastore/mysql_common/service.py#L681-L686

The way to preserve the "root" credentials without overriding the "os_admin" credentials is to change the "/root/.my.cnf/ path to "/root/.my_root.cnf".

Tags: trove
Gaëtan Trellu (goldyfruit)
Changed in trove:
assignee: nobody → Gaëtan Trellu (goldyfruit)
OpenStack Infra (hudson-openstack)
Changed in trove:
status: New → In Progress
Revision history for this message
Gaëtan Trellu (goldyfruit) wrote :

https://review.openstack.org/535498

Revision history for this message
Pierre Blanc (pierreblanc75) wrote :

This issue appears when the guest agent is started by the root user.

Gaëtan Trellu (goldyfruit)
summary: - MySQL/MariaDB/Percona replication is broken because of wrong user usage
+ MySQL/MariaDB/Percona replication brakes is Guest agent runs as root
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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