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