Shulou(Shulou.com)06/01 Report--

For example, the Mariadb Columnstore version is: 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. Turn off pm4- > normal database access-> turn off pm3- > normal database access-> turn off pm2- > database access no data

b. Just shut down the pm1- > database and perform select blocking

Blocking (later killed with ctrl+c):

MariaDB [test] > select * from test1

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

And report an error:

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

To sum up: the current Mariadb Columnstore version of failover is not sound, at least to ensure that the pm1 is good, and there are more than two pm survive.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.