Not the answer you need?
Register and ask your own question!

New install on Mysql Community Server 5.7 - Ubuntu 16.04

ajhallsajhalls EntrantCurrent User Role Beginner
I have an existing database that has about 8GB of data in it and wanted to set up a multi master cluster using XtraDB Cluster but am getting a lot of errors during install.

Doing the suggested way I get this error:
root@myserver /root apt-get install percona-xtradb-cluster-full-57
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 percona-xtradb-cluster-full-57 : Depends: percona-xtradb-cluster-server-5.7 (>= 5.7.23-31.31-2.xenial) but it is not going to be installed
                                  Depends: percona-xtradb-cluster-client-5.7 (>= 5.7.23-31.31-2.xenial) but it is not going to be installed
                                  Depends: percona-xtradb-cluster-test-5.7 (>= 5.7.23-31.31-2.xenial) but it is not going to be installed
                                  Depends: percona-xtradb-cluster-5.7-dbg (>= 5.7.23-31.31-2.xenial) but it is not going to be installed
                                  Depends: percona-xtradb-cluster-server-debug-5.7 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
root@myserver /root

I tried downloading the files, but got some more errors, got the common library to install, then more errors. Am I misunderstanding the installation process?
root@myserver /root dpkg -i percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb
Selecting previously unselected package percona-xtradb-cluster-client-5.7.
dpkg: regarding percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb containing percona-xtradb-cluster-client-5.7:
 percona-xtradb-cluster-client-5.7 breaks virtual-mysql-client
  mysql-community-client provides virtual-mysql-client and is present and installed.

dpkg: error processing archive percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb (--install):
 installing percona-xtradb-cluster-client-5.7 would break mysql-community-client, and
 deconfiguration is not permitted (--auto-deconfigure might help)
Errors were encountered while processing:
 percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb
root@myserver /root dpkg -i --auto-deconfigure percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb
dpkg: considering deconfiguration of mysql-community-client, which would be broken by installation of percona-xtradb-cluster-client-5.7 ...
dpkg: yes, will deconfigure mysql-community-client (broken by percona-xtradb-cluster-client-5.7)
dpkg: regarding percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb containing percona-xtradb-cluster-client-5.7:
 mysql-community-server conflicts with mysql-client-5.7
  percona-xtradb-cluster-client-5.7 provides mysql-client-5.7 and is to be installed.

dpkg: error processing archive percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb (--install):
 conflicting packages - not installing percona-xtradb-cluster-client-5.7
Errors were encountered while processing:
 percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb

root@myserver /root dpkg -i percona-xtradb-cluster-common-5.7_5.7.23-31.31-2.bionic_amd64.deb
(Reading database ... 156551 files and directories currently installed.)
Preparing to unpack percona-xtradb-cluster-common-5.7_5.7.23-31.31-2.bionic_amd64.deb ...
Unpacking percona-xtradb-cluster-common-5.7 (5.7.23-31.31-2.bionic) ...
Setting up percona-xtradb-cluster-common-5.7 (5.7.23-31.31-2.bionic) ...
 -------------
   *  The suggested mysql options and settings are in /etc/mysql/percona-server.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/mysql/my.cnf
 update-alternatives --install /etc/mysql/my.cnf my.cnf "/etc/mysql/percona-xtradb-cluster.cnf" 200

root@myserver /root dpkg -i percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb
dpkg: regarding percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb containing percona-xtradb-cluster-client-5.7:
 percona-xtradb-cluster-client-5.7 breaks virtual-mysql-client
  mysql-community-client provides virtual-mysql-client and is present and installed.


dpkg: error processing archive percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb (--install):
 installing percona-xtradb-cluster-client-5.7 would break mysql-community-client, and
 deconfiguration is not permitted (--auto-deconfigure might help)
Errors were encountered while processing:
 percona-xtradb-cluster-client-5.7_5.7.23-31.31-2.bionic_amd64.deb

root@myserver /root dpkg -i percona-xtradb-cluster-server-5.7_5.7.23-31.31-2.bionic_amd64.deb
Selecting previously unselected package percona-xtradb-cluster-server-5.7.
dpkg: regarding percona-xtradb-cluster-server-5.7_5.7.23-31.31-2.bionic_amd64.deb containing percona-xtradb-cluster-server-5.7:
 percona-xtradb-cluster-server-5.7 breaks virtual-mysql-server
  mysql-community-server provides virtual-mysql-server and is present and installed.

dpkg: error processing archive percona-xtradb-cluster-server-5.7_5.7.23-31.31-2.bionic_amd64.deb (--install):
 installing percona-xtradb-cluster-server-5.7 would break mysql-community-server, and
 deconfiguration is not permitted (--auto-deconfigure might help)
Errors were encountered while processing:
 percona-xtradb-cluster-server-5.7_5.7.23-31.31-2.bionic_amd64.deb

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    You are trying to install PXC over conflicting packages of MySQL Community. This is not going to work this way. You have to first uninstall mysql-community-server and similar packages. Best to backup the datadir before doing so. If you still have problems, check what's still installed:
    dpkg -l|egrep -i "mysql|maria|percona"
    
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.