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

Here we use 2 um, 4 pm to run a group of clusters, operating system Centos6.8, the original MariaDB ColumnStore GA version 1.0.6.

# 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

Use root users to log in to um1, um2 and pm1 to create files / root/.my.cnf (note that the files are hidden files) on these three machines as follows:

[mysqladmin]

User = root

Password = password

(password is the real password of the database user root, which is modified according to the actual situation)

# chmod 600 / root/.my.cnf

After the upgrade is completed, .my.cnf can be deleted.

Upload mariadb-columnstore-1.0.7-1-centos6.x86_64.bin.tar.gz to the / root/ directory of the pm1 machine

Shut down the database:

# mcsadmin shutdownsystem y

Uninstall old software:

# / usr/local/mariadb/columnstore/bin/pre-uninstall

Decompress:

# tar-zxvf mariadb-columnstore-1.0.7-1-centos6.x86_64.bin.tar.gz-C / usr/local/

Install software:

/ usr/local/mariadb/columnstore/bin/post-install

Execute postConfigure to use the upgrade option-u:

# / usr/local/mariadb/columnstore/bin/postConfigure-u

The lift is completed as shown in the figure:

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.