Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Replacing PS with PXC causes broken etc-my.cnf

Description

CentOS 7. Remove any pre-existing /etc/my.cnf*. Install Percona-Server-server-57.x86_64 Percona-Server-client-57.x86_64. Notice that /etc/my.cnf is now symlinked to /etc/alternatives/my.cnf

 

Now execute: 

Notice now that /etc/my.cnf is a bad/broken symlink. You should also notice this error:

 

Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : qpress-11-1.el7.x86_64 1/11
Installing : socat-1.7.3.2-2.el7.x86_64 2/11
Installing : lsof-4.87-5.el7.x86_64 3/11
Installing : libev-4.15-7.el7.x86_64 4/11
Installing : percona-xtrabackup-24-2.4.11-1.el7.x86_64 5/11
Installing : Percona-XtraDB-Cluster-client-57-5.7.21-29.26.1.el7.x86_64 6/11
Installing : Percona-XtraDB-Cluster-shared-57-5.7.21-29.26.1.el7.x86_64 7/11
Installing : Percona-XtraDB-Cluster-server-57-5.7.21-29.26.1.el7.x86_64 8/11
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
/var/tmp/rpm-tmp.FP6Vhv: line 18: [: too many arguments
-------------

  • The suggested mysql options and settings are in /etc/percona-xtradb-cluster.conf.d/mysqld.cnf

  • If you want to use mysqld.cnf as default configuration file please make backup of /etc/my.cnf

  • Once it is done please execute the following commands:
    rm -rf /etc/my.cnf
    update-alternatives --install /etc/my.cnf my.cnf "/etc/percona-xtradb-cluster.cnf" 200
    -------------
    Percona XtraDB Cluster is distributed with several useful UDFs from Percona Toolkit.

Environment

None

Smart Checklist

Activity

Krunal Bauskar June 25, 2018 at 5:19 AM

Maybe you can describe the issue 2 lines for end-user about what has changed. Accordingly, RN needs to be updated.

Evgeniy Patlan June 22, 2018 at 6:28 AM

please pay attention that we need to recheck how it works if my.cnf is a link

Evgeniy Patlan June 20, 2018 at 9:27 AM

the issue appeared only in case of `yum swap` command. So I will try to fix this

Krunal Bauskar June 20, 2018 at 3:01 AM

Please take a look at this issue

Done

Details

Assignee

Reporter

Time tracking

1d 5h logged

Components

Fix versions

Priority

Smart Checklist

Created June 19, 2018 at 11:08 PM
Updated July 22, 2024 at 3:19 PM
Resolved June 22, 2018 at 6:28 AM