# https://mariadb.com/docs/operations/upgrades/upgrade-multi-node-from-5-to-6/#uninstall-the-old-version ### Setup CS 5.6 ### yum update -y yum install wget jq epel-release -y wget https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup chmod +x mariadb_es_repo_setup ./mariadb_es_repo_setup --token="ca9d5fe2-ef44-438f-87ee-784ecc4fb9b0" --apply --mariadb-server-version="10.5" yum install jq epel-release -y yum install python2 python2-PyMySQL python2-pip -y yum install -y MariaDB-server MariaDB-backup MariaDB-shared MariaDB-client MariaDB-columnstore-engine MariaDB-columnstore-cmapi systemctl restart mariadb systemctl enable mariadb systemctl restart mariadb-columnstore systemctl disable mariadb-columnstore systemctl restart mariadb-columnstore-cmapi systemctl enable mariadb-columnstore-cmapi mcsSetConfig HashJoin AllowDiskBasedJoin Y mcsSetConfig RowAggregation AllowDiskBasedAggregation Y echo "server_id= 1" >> /etc/my.cnf.d/server.cnf echo "max_connections=5000" >> /etc/my.cnf.d/server.cnf mcsGetConfig -a | grep AllowD curl -k -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/node --header 'Content-Type:application/json' --header 'x-api-key:19bb89d77cb8edfe0864e05228318e3dfa58e8f45435fbd9bd12c462a522a1e9' --data '{"timeout":120, "node": "127.0.0.1"}' systemctl restart mariadb mcsShutdown mcsStart ll /var/log/mariadb/* # Notice most owned by mysql:mysql # Notice we made 2 customizations - maxconnections and Allow hash joins and disk agg ### upgrade ### mcsShutdown sudo systemctl stop mariadb-columnstore-cmapi sudo systemctl stop mariadb sudo yum remove "MariaDB-*" sudo yum remove galera-enterprise-4 sudo yum remove galera rpm --query --all | grep -i -E "mariadb|galera" ./mariadb_es_repo_setup --token="ca9d5fe2-ef44-438f-87ee-784ecc4fb9b0" --apply --mariadb-server-version="10.6" sudo yum install MariaDB-server \ MariaDB-backup \ MariaDB-shared \ MariaDB-client \ MariaDB-columnstore-engine \ MariaDB-columnstore-cmapi sudo systemctl start mariadb-columnstore-cmapi sudo systemctl start mariadb mariadb-upgrade --write-binlog mcsStart mcsGetConfig -a | grep AllowD mariadb -e "show variables like '%max_connection%'" ll /var/log/mariadb/* # Notice nothing happens because the Columnstore.xml was reset # Notice server_id is lost and max_connections customization # Log permissions seem the same as when first installed drwxr-xr-x. 2 mysql mysql 6 Jan 19 19:56 archive -rw-r--r--. 1 root root 6927 Jan 19 20:11 cmapi_server.log drwxr-xr-x. 2 mysql mysql 6 Jan 19 19:56 corefiles drwxrwxrwx. 2 mysql mysql 6 Jan 19 19:56 cpimport -rw-------. 1 root root 832 Jan 19 20:11 crit.log drwxrwxrwx. 3 mysql mysql 18 Jan 19 19:56 data -rw-------. 1 mysql mysql 39539 Jan 19 20:11 debug.log -rw-------. 1 root root 11202 Jan 19 20:11 err.log -rw-------. 1 mysql mysql 13315 Jan 19 20:11 info.log drwxrwxrwx. 2 mysql mysql 151 Jan 19 20:11 install drwxr-xr-x. 2 mysql mysql 16 Jan 19 19:56 trace -rw-------. 1 root root 11202 Jan 19 20:11 warning.log # Work around cp /etc/columnstore/Columnstore.xml.rpmsave /etc/columnstore/Columnstore.xml cp /etc/columnstore/storagemanager.cnf.rpmsave /etc/columnstore/storagemanager.cnf cp /etc/columnstore/cmapi_server.conf.rpmsave /etc/columnstore/cmapi_server.conf systemctl restart mariadb-columnstore-cmapi mcsStart # Notes es 10.5 repo includes cmapi 1.6 so i couldnt try to reproduce any issues of two cmapi installs