8.0 wrong config files layout after upgrade from 5.7 on Ubuntu/Debian
Description
Environment
is duplicated by
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.
Details
Assignee
UnassignedUnassignedReporter
Tomislav PlavcicTomislav PlavcicNeeds Review
YesTime tracking
5h 10m loggedComponents
Fix versions
Affects versions
Priority
Medium
Details
Details
Assignee
Reporter

Needs Review
Time tracking
Components
Fix versions
Affects versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist

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.