8.0 wrong config files layout after upgrade from 5.7 on Ubuntu/Debian

Description

This was layout before upgrade (so just 5.7):

As you can see all the config is inside "percona-xtradb-cluster.conf.d" directory and it is included from my.cnf

This is after upgrade to 8.0:

As you can see now we have full new config in "mysql.conf.d" directory and the old one in "percona-xtradb-cluster.conf.d".

Both of these directories are included from my.cnf which is a bit messy and confusing since the options are duplicated with potentially different values.
In my case I will clear this by excluding import of "percona-xtradb-cluster.conf.d" from my.cnf, but it should probably be discussed what is the best option for the users.

Environment

None

Smart Checklist

Activity

Tomislav Plavcic April 23, 2020 at 8:50 AM

On Debian 10 the issue is also visible, what we get is my.cnf from MariaDB which includes "mariadb.conf.d" directory which is empty, so basically no config is set.

Tomislav Plavcic April 22, 2020 at 7:41 AM

I still think this is a big problem, you end up with mixed configuration - the old one is active and the new defaults are active too.
The my.cnf after upgrade includes all 3 subdirectories and same configuration options are available in multiple places:

If this is not going to be fixed, it needs to be documented that after upgrade on Ubuntu/Debian:

1. new defaults are available in /etc/mysql/mysql.conf.d/
2. the old configuration (unless user changed this before) is available in /etc/mysql/percona-xtradb-cluster.conf.d/
3. user should edit /etc/mysql/my.cnf to include only the directories that he really wants to use
^

Sami Ahlroos April 21, 2020 at 10:02 AM

Not only is the layout with included files somewhat messy and confusing. It contradicts what the upgrade docs at https://www.percona.com/doc/percona-xtradb-cluster/8.0/howtos/upgrade_guide.html state:

 

This only happens on Ubuntu, on a RPM system we got what the documentation says and what is in . The packages behaving differently is quite confusing and should at least be clearly documented. Preferably they should act the same way, I think.{{}}

David Bennett February 4, 2020 at 3:15 PM

   We need to add a note when upgrading from 5.7 to 8.0 that the configuration file layout has changed and configurations may need to be moved from old location to new.   If you have any questions,  ask

Evgeniy Patlan January 27, 2020 at 6:16 AM

Yes I think we just need to document this properly. The same behavior we have in PS. 

Done

Details

Assignee

Reporter

Needs Review

Yes

Time tracking

5h 10m logged

Components

Fix versions

Affects versions

Priority

Smart Checklist

Created January 21, 2020 at 1:42 PM
Updated March 6, 2024 at 9:51 PM
Resolved April 29, 2020 at 11:48 AM