We use 2 sets of Um, 4 sets of PM 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 |
With the root user respectively landed Um1, um2, PM1 respectively on the three machines to establish the file/root/.my.cnf (note file as hidden file) content:
[Mysqladmin] user = root Password = password |
(Password is the real password of the database user root, modified according to the actual situation)
#chmod 600/root/.my.cnf
After the upgrade is complete. MY.CNF can be erased.
Upload the mariadb-columnstore-1.0.7-1-centos6.x86_64.bin.tar.gz to the/root/directory of the PM1 machine.
To close the database:
#mcsadmin Shutdownsystem y
Uninstall old software:
#/usr/local/mariadb/columnstore/bin/pre-uninstall
Extract:
#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
Perform postconfigure using the Upgrade Option-U:
#/usr/local/mariadb/columnstore/bin/postconfigure-u
Hoist complete
650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/8D/D4/wKioL1isBxbwtY1hAACkp9QuNP8993.png-wh_500x0-wm_ 3-wmp_4-s_279965375.png "title=" 7.png "alt=" Wkiol1isbxbwty1haackp9qunp8993.png-wh_50 "/>
650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/8D/D4/wKioL1isB4OjDbZdAAB6R_BCC70168.png-wh_500x0-wm_ 3-wmp_4-s_515596351.png "title=" 8.png "alt=" Wkiol1isb4ojdbzdaab6r_bcc70168.png-wh_50 "/>
Upgrade mariadb ColumnStore from 1.0.6 to 1.0.7