我尝试在我的 percona 集群上对 ubuntu 服务器进行 dist-upgrade,但失败并显示以下消息
The following packages have unmet dependencies:
libmysqlclient18 : Depends: libmariadbclient18 (= 5.5.33a+maria-1~precise) but it is not installable
这是包装清单
# dpkg --list | grep -E 'percona|mysql'
ii libdbd-mysql-perl 4.020-1build2 Perl5 database interface to the MySQL database
iU libmysqlclient18 5.5.33a+maria-1~precise Virtual package to satisfy external depends
ii mariadb-common 5.5.33a+maria-1~precise MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii percona-xtrabackup 2.1.5-680-1.precise Open source backup tool for InnoDB and XtraDB
ii percona-xtradb-cluster-client-5.5 5.5.31-23.7.5-438.precise Percona Server database client binaries
ii percona-xtradb-cluster-common-5.5 5.5.33-23.7.6-496.precise Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-xtradb-cluster-galera-2.x 157.precise Galera components of Percona XtraDB Cluster
ii percona-xtradb-cluster-server-5.5 5.5.31-23.7.5-438.precise Percona Server database server binaries
ii php5-mysql 5.3.10-1ubuntu3.8 MySQL module for php5
在安装服务器期间,首先安装了 mariadb 和 galera 集群。然后删除它们并替换为 percona XtraDBCluster。所以我认为这是问题的根源。但我如何在不重新安装所有内容的情况下解决这个问题?
更新 1
# apt-cache policy libmariadbclient18
libmariadbclient18:
Installed: (none)
Candidate: (none)
Version table:
5.5.32+maria-1~precise 0
100 /var/lib/dpkg/status
答案1
请验证您的软件存储库列表是否正常工作。在我看来,APT 无法访问您提到的软件包。
根据这,它在 APT 必须知道的 Maria DB PPA 中。
因此输入如下内容/etc/apt/sources.list.d/mariadb.list
:
http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu precise main
然后运行
apt-get update
apt-get -d install libmysqlclient18
dpkg -i /var/cache/apt/archives/libmysqlclient18*.deb
dpkg --configure --pending
apt-get install -f
答案2
我终于找到了解决办法。
# wget http://www.percona.com/redir/downloads/Percona-XtraDB-Cluster/LATEST/deb/precise/x86_64/libmysqlclient18_5.5.33-23.7.6-496.precise_amd64.deb
# dpkg -i libmysqlclient18_5.5.33-23.7.6-496.precise_amd64.deb
# apt-get install -f
# apt-get upgrade
现在一切都好。