{"id":783,"date":"2020-08-09T15:06:15","date_gmt":"2020-08-09T15:06:15","guid":{"rendered":"http:\/\/www.linuxauthority.com\/wordpress\/?p=783"},"modified":"2020-08-09T15:32:37","modified_gmt":"2020-08-09T15:32:37","slug":"upgrading-mariadb-cluster-lab","status":"publish","type":"post","link":"https:\/\/www.linuxauthority.com\/wordpress\/?p=783","title":{"rendered":"Upgrading mariadb cluster lab"},"content":{"rendered":"\n\n\n

Step 1: Back up your data.<\/p>\n\n\n\n

Step 2: BACK UP YOUR DATA.<\/p>\n\n\n\n

Step 3: BACK UP YOUR FRACKING DATA (Never watched the new Battlestar Galactica this is an f-word replacement). You might lose your data.<\/p>\n\n\n\n

Read the procedure and process and RELEASE notes on Mariadb web site.<\/p>\n\n\n\n

link as of this publish date: https:\/\/mariadb.com\/kb\/en\/upgrading-from-mariadb-104-to-mariadb-105\/<\/a><\/p>\n\n\n\n

There are equally good documents for any Mariadb 10.x database to 10.5.<\/p>\n\n\n\n

Why did do the lab upgrade? I think Oracle database is a big rip off and since version 10.3 Mariadb can run workloads requiring Oracle pl\/sql code.<\/p>\n\n\n\n

Yes you can run Oracle workloads without paying for an Oracle database.<\/p>\n\n\n\n

I think this is a multi-billion market opportunity. If you would like to explore equity partnership in this idea: https:\/\/newdatacloud.com<\/a><\/p>\n\n\n\n

Click on our investor presentation<\/a>: <\/p>\n\n\n\n

The upgrade:<\/strong><\/p>\n\n\n\n

It is actually scripted.<\/p>\n\n\n\n

systemctl stop mariadb<\/p>\n\n\n\n

rc=$?<\/p>\n\n\n\n

### make sure the database shutdown actually succeeds check the return code. 0 is good. Anything else: Do not pass go, do not collect $200. Get that database down cleanly and back up your data.<\/p>\n\n\n\n

if [ ${rc} = 0 ]<\/p>\n\n\n\n

then<\/p>\n\n\n\n

  echo “DBshutdown succesfull. Performing the upgrade.”<\/p>\n\n\n\n

else<\/p>\n\n\n\n

  echo “DB shutdown failed. Was it running? Exit 1”<\/p>\n\n\n\n

  exit 1<\/p>\n\n\n\n

fi<\/p>\n\n\n\n

### get a list of mariadb and galera packages and remove them not the dozens of packages that depend on Mariadb. Mariadb will be back in 10 minutes and all dependencies will be happy. Take note of the messages and make sure all shared libraries are present on the system.<\/p>\n\n\n\n

rpm -qa | egrep -i “mariadb|galera” | while read -r pn<\/p>\n\n\n\n

do<\/p>\n\n\n\n

   rpm -e –nodeps ${pn}<\/p>\n\n\n\n

   echo $? ##Checking return code is always a good thing. Feel free to insert the exit on non-zero return code logic here.<\/p>\n\n\n\n

done
<\/p>\n\n\n\n

## Edit \/etc\/yum.repos.d\/mariadb.repo and change 10.X to 10.5<\/p>\n\n\n\n

## The following scp command copies in a pre-prepared version of the new repository. Mine lives on instance-8.<\/p>\n\n\n\n

scp instance-8:\/etc\/yum.repos.d\/mariadb.repo \/etc\/yum.repos.d\/<\/p>\n\n\n\n

yum -y install MariaDB-compat galera-4 MariaDB-shared MariaDB-client MariaDB-server MariaDB-common MariaDB-devel<\/p>\n\n\n\n

## A new nonclustered server.cnf file is in place. Start the database.<\/p>\n\n\n\n

mysql_upgrade<\/p>\n\n\n\n

systemctl stop mariadb<\/p>\n\n\n\n

### cd \/etc\/my.cnf.d\/<\/p>\n\n\n\n

## mv *.cnf \/root\/<\/p>\n\n\n\n

## move the .rpmsave files to .cnf . Read the release notes and comment out questionable or deprecated parameters.<\/p>\n\n\n\n

## galera_recovery;galera_new_cluster on the master node, Make certain the safe_to_bootstrap parameter is set to 1 in \/var\/lib\/mysql\/grastate.dat<\/p>\n\n\n\n

## Run for 2-4 weeks in the lab with application testing before upgrading production<\/p>\n\n\n\n

Script output:<\/p>\n\n\n\n

Loaded plugins: fastestmirror, langpacks, priorities
\nLoading mirror speeds from cached hostfile
\nepel\/x86_64\/metalink | 14 kB 00:00 <\/p>\n\n\n\n