To download rpms for using them in an offline environment, install first yumdownloader:

yum install yum-utils

Create a directory to store the rpm's:

mkdir /tmp/rpms

Download the rpms:

yumdownloader --destdir=/tmp/rpms --resolve MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common