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
Changed in trove:
assignee: nobody → Gaëtan Trellu (goldyfruit)
Changed in trove:
status: New → In Progress
Revision history for this message
Gaëtan Trellu (goldyfruit) wrote :
Revision history for this message
Pierre Blanc (pierreblanc75) wrote :

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

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.

Other bug subscribers