Mariadb Columnstore 當(dāng)pm1 down了的時(shí)候數(shù)據(jù)庫(kù)將阻塞

發(fā)布時(shí)間：2020-07-22 22:59:19 來(lái)源：網(wǎng)絡(luò) 閱讀：981 作者：澎湃2017 欄目：數(shù)據(jù)庫(kù)

如題，Mariadb Columnstore版本為：Server version: 10.1.21-MariaDB Columnstore 1.0.7-1

#cat /etc/hosts

192.168.75.33 um1

192.168.75.34 um2

192.168.75.35 pm1

192.168.75.36 pm2

192.168.75.37 pm3

192.168.75.38 pm4

a.依次關(guān)掉pm4->數(shù)據(jù)庫(kù)正常訪問(wèn)->關(guān)掉pm3->數(shù)據(jù)庫(kù)正常訪問(wèn)->關(guān)掉pm2->數(shù)據(jù)庫(kù)訪問(wèn)不到數(shù)據(jù)

b.只關(guān)掉pm1->數(shù)據(jù)庫(kù)執(zhí)行select阻塞

阻塞（后面用ctrl+c殺死了）：

MariaDB [test]> select * from test1;

^CCtrl-C -- query killed. Continuing normally.

并且報(bào)錯(cuò)：

mcsadmin> getsysteminfo

getsysteminfo Wed Feb 22 12:52:46 2017

System columnstore-1

System and Module statuses

Component Status Last Status Change

------------ -------------------------- ------------------------

**** printSystemStatus Failed = API Failure return in getSystemStatus:MessageQueueClient-Error API

綜上：目前Mariadb Columnstore版本故障切換還有些不健全，至少要保證pm1是好的，并且有兩臺(tái)以上pm存活。

向AI問(wèn)一下細(xì)節(jié)

Mariadb Columnstore 當(dāng)pm1 down了的時(shí)候 數(shù)據(jù)庫(kù)將阻塞