Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2142

Replacing PS with PXC causes broken etc-my.cnf

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.22
    • Component/s: None
    • Security Level: Public Bug
    • Labels:
      None

      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: 

      yum swap -- remove Percona-Server-shared-57 Percona-Server-server-57 -- install Percona-XtraDB-Cluster-shared-57 Percona-XtraDB-Cluster-server-57
      

      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.

        Attachments

          Expenses

            Activity

              People

              • Assignee:
                evgeniy.patlan Evgeniy Patlan
                Reporter:
                matthew.boehm@percona.com Matthew Boehm
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 5 hours
                  1d 5h