Home CentOS CentOS 7 Upgrading MariaDB 10.2 to 10.3 on CentOS 7

Upgrading MariaDB 10.2 to 10.3 on CentOS 7

How to Upgrade

Remove old MariaDB Repository

rm -rf /etc/yum.repos.d/mariadb.repo

Add New MariaDB Repository

vi /etc/yum.repos.d/mariadb.repo

Add

[mariadb]
name = MariaDB Server
baseurl = https://downloads.mariadb.com/MariaDB/mariadb-10.3/yum/rhel/$releasever/$basearch
gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1
enabled = 1

Remove old version

yum remove MariaDB-server -y

Install MariaDB

yum install MariaDB-server MariaDB-shared MariaDB-client MariaDB-common galera -y

Start MariaDB

systemctl start mysql

Check MariaDB Status

systemctl status mysql

Upgrade Mysql tables

mysql_upgrade

Login to MySQL shell

mysql

Must Read

Routing Domain Name in Haproxy

I hope you are following the below guide. Now suppose you want to route domain name to open specific backend that have...

Enable Logging in Haproxy

HAProxy can emit log message for processing by a syslog server. This is compatible with familiar syslog tools like Rsyslog, as well...

Getting real IP in Nginx when behind cloudflare Haproxy

Create a file named cloudflare_ips.ls and in that add all the cloudflare IP's vi /etc/haproxy/cloudflare_ips.ls 173.245.48.0/20 103.21.244.0/22 103.22.200.0/22 103.31.4.0/22 141.101.64.0/18 108.162.192.0/18 190.93.240.0/20 188.114.96.0/20 197.234.240.0/22 198.41.128.0/17 162.158.0.0/15 104.16.0.0/12 172.64.0.0/13 131.0.72.0/22 2400:cb00::/32 2606:4700::/32 2803:f800::/32 2405:b500::/32 2405:8100::/32 2a06:98c0::/29 2c0f:f248::/32

Getting Real IP in HaproxyNginx configuration

Well its a little configuration can get real to nginx when haproxy is set as reverse proxy. Follow this...

Haproxy as Single Point to Failure Node With Glusterfs and MariaDB Maxscale Cluster

HAProxy is a free, very fast and reliable solution offering high availability, load balancing, and proxying for TCP and HTTP-based applications. It...