asked on

upgrade of MariaDB and maxscale.

hi,

any procedure to upgrade MariaDB and maxscale ?

do you know if latest edition of mariaDB and maxscale can do transaction level failover so that when DB is failover and slave DB becoming primary, executing queries is not going to drop off ?

David Favor

Normal procedure is this...

1) Setup the correct repository using https://downloads.mariadb.org/mariadb/repositories instructions.

2) Then just run normal updates. For example, to do this on Ubuntu for MariaDB 10.3.x would be something like the following, which also includes setting up PPAs for latest Apache, PHP, NGINX, OpenSSL...

# Setup latest stable
LC_ALL=C.UTF-8 add-apt-repository ppa:ondrej/apache2 </dev/null
LC_ALL=C.UTF-8 add-apt-repository ppa:ondrej/php </dev/null
LC_ALL=C.UTF-8 add-apt-repository ppa:ondrej/nginx </dev/null

# Setup latest stable
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
echo "deb http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.3/ubuntu $(lsb_release -sc) main" > /etc/apt/sources.list.d/mariadb-$(lsb_release -sc).list

apt-get update

apt-get install mariadb-server mariadb-client libmariadb-dev-compat

Open in new window

Once you have the correct repository setup, just use your normal apt-get or yum commands for updates.

To install Ubuntu updates, you'll just do this...

apt-get upgrade

Open in new window

marrowyung

ASKER

How about I have local repositories and what command I should use ?

if I have internet connection and I can do this:

"yum -y update."

but I don't have internet connection for that linux box.

for upgrading MariaDB I can do if I use local repository:

yum -y localinstall <MariaDB tar ball>

Open in new window

marrowyung

ASKER

any more update for me ?

marrowyung

ASKER

hi,

Today I tried to upgraded maxscale and it works fine, but when I upgrade the MariaDB it shows me bad result. can't upgrade DB part, therefore.

what I have done is :

1) 1. uninstall MariaDB 10.2
systemctl stop mariadb
rpm -qa | grep -i mariadb | xargs rpm -e --nodeps

but result seems not what I want, :

2) install MariaDB xx.xx.xx with yum localinstall

tar xvf <MariaDB tar ball>
e.g. tar xvf mariadb-10.3.9-rhel-7-x86_64-rpms.tar

cd mariadb-10.3.9-rhel-7-x86_64-rpms

install all necessary rpm files:

yum -y localinstall MariaDB-<version>-centos73-x86_64-compat.rpm
MariaDB-<version>-centos73-x86_64-common.rpm MariaDB-<version>-centos73-x86_64-client.rpm MariaDB-<version>-centos73-x86_64-server.rpm

it gives error message:

ASKER CERTIFIED SOLUTION

marrowyung

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marrowyung

ASKER

hi,

Sorry for late credit award, but one thing here, it seems MariaDB upgrade locally is just update the mariaDB RPM ?

how about the new MariaDB we want in another VM box ?