Comments - Installing MariaDB with yum/dnf

While upgrading from 10.1 to 10.2 I was asked for a missing package dependency: --> Processing Dependency: libboost_program_options.so.1.53.0()(64bit) for package: galera-25.3.29-1.rhel7.el7.centos.x86_64 --> Finished Dependency Resolution Error: Package: galera-25.3.29-1.rhel7.el7.centos.x86_64 (mariadb) Requires: libboost_program_options.so.1.53.0()(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest

So I installed it directly using RPM from: https://centos.pkgs.org/7/centos-x86_64/boost-program-options-1.53.0-28.el7.x86_64.rpm.html

Aditionally if you get No package MariaDB-Galera-server available. Check file /etc/yum.conf, if my case there was a string: exclude=ansible1.9,mysql,mariadb,mariadb-*,Percona-XtraDB-*,Percona-*-55,Percona-*-56,Percona-*-51,Percona-*-50 Just comment this string and install goes well.

If You get

No package MariaDB-server available.

1. check the correct Repository. I incorrectly added Centos 7 ppc64) repos instead of x86_64 2. When I fixed correct repo addresses, I needed to run

yum clean all

only then MariaDB installed correctly.

Downloading packages: MariaDB-10.1.30-centos7-x86_64 FAILED http://yum.mariadb.org/10.2/centos7-amd64/rpms/MariaDB-10.1.30-centos7-x86_64-server.rpm: [Errno 14] HTTP Error 404 - Not Found Trying other mirror. To address this issue please refer to the below knowledge base article

https://access.redhat.com/articles/1320623

If above article doesn't help to resolve this issue please create a bug on https://bugs.centos.org/

MariaDB-10.1.30-centos7-x86_64 FAILED http://yum.mariadb.org/10.2/centos7-amd64/rpms/MariaDB-10.1.30-centos7-x86_64-shared.rpm: [Errno 14] HTTP Error 404 - Not Found Trying other mirror. MariaDB-10.1.30-centos7-x86_64 FAILED http://yum.mariadb.org/10.2/centos7-amd64/rpms/MariaDB-10.1.30-centos7-x86_64-client.rpm: [Errno 14] HTTP Error 404 - Not Found Trying other mirror.

Error downloading packages: MariaDB-server-10.1.30-1.el7.centos.x86_64: [Errno 256] No more mirrors to try. MariaDB-shared-10.1.30-1.el7.centos.x86_64: [Errno 256] No more mirrors to try. MariaDB-client-10.1.30-1.el7.centos.x86_64: [Errno 256] No more mirrors to try.

You trying to download 10.1 from a 10.2 repo - try http://yum.mariadb.org/10.1/centos7-amd64/rpms/MariaDB-10.1.30-centos7-x86_64-shared.rpm

http://yum.mariadb.org/10.1/centos7-amd64/rpms/MariaDB-10.1.21-centos7-x86_64-client.rpm: [Errno 12] Timeout on http://yum.mariadb.org/10.1/centos7-amd64/rpms/MariaDB-10.1.21-centos7-x86_64-client.rpm: (28, 'Operation too slow. Less than 1000 bytes/sec transferred the last 30 seconds') Trying other mirror. http://yum.mariadb.org/10.1/centos7-amd64/rpms/MariaDB-10.1.21-centos7-x86_64-server.rpm: [Errno 14] curl#56 - "Recv failure: Connection reset by peer" Trying other mirror.

Error downloading packages: MariaDB-server-10.1.21-1.el7.centos.x86_64: [Errno 256] No more mirrors to try.

Is there a fastest mirror for Asia? or Indonesia?

i have try many times, and always got those result

yum.mariadb.org is hosted in Canada at OVH, so there must be some sort of routing issue between your ISP and OVH.

That said, we do have some mirrors in Indonesia that have the yum repository mirrored. Change the baseurl line in your MariaDB yum repo configuration file from:

baseurl = http://yum.mariadb.org/10.1/centos7-amd64

...to one of the following:

baseurl = http://suro.ubaya.ac.id/mariadb/yum/10.1/centos7-amd64/
baseurl = http://kodeterbuka.beritagar.id/mariadb/yum/10.1/centos7-amd64/
baseurl = http://mariadb.biz.net.id/yum/10.1/centos7-amd64/

I receive an error when instaling on RHEL6

yum install MariaDB-Galera-server MariaDB-client galera

Error: Package: galera-25.3.9-1.rhel6.el6.x86_64 (mariadb) Requires: nc

I have /usr/bin/nc installed. Is there a reason this is happening?

running

yum install MariaDB-Galera-server MariaDB-client galera

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

It's not finding the server package:

No package MariaDB-Galera-server available.

I just tried running the yum command and using the MariaDB.repo file you have on a new CentOS 7 VM and it worked. You might try issuing a yum clean all to force yum to redownload the repository metadata.

With yum priority plug-in activated (is also a good practice), we get:

--> MariaDB-Galera-server-5.5.39-1.el6.x86_64 from mariadb excluded (priority) --> MariaDB-client-5.5.39-1.el6.x86_64 from mariadb excluded (priority) --> MariaDB-compat-5.5.39-1.el6.x86_64 from mariadb excluded (priority) --> MariaDB-devel-5.5.39-1.el6.x86_64 from mariadb excluded (priority) --> MariaDB-server-5.5.39-1.el6.x86_64 from mariadb excluded (priority) --> MariaDB-shared-5.5.39-1.el6.x86_64 from mariadb excluded (priority) --> MariaDB-test-5.5.39-1.el6.x86_64 from mariadb excluded (priority) --> MariaDB-Galera-test-5.5.39-1.el6.x86_64 from mariadb excluded (priority) 8 packages excluded due to repository priority protections

A conflict was found for mysql-libs.x86_64 (5.1.73-3.el6_5), probably resolved forcing removal of this libs, replaced with mariadb version, but can you tell us how correct priority and mysql-libs issue ?

Thank you

I installed MariaDB 10 on CentOS 6.5 64 bit.

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

It successfully installed. But the installation process didn't let me configure user name, password, database instance name, and port.

What should I do that after installation? How to check that on CentOS?

Thanks in advance.

On yum-based distributions, the only MariaDB user set up is root, and there is no password. You can use the mysql_secure_installation script to set the root password.

For compatibility, the service name and port are by default the same as MySQL: mysql and 3306. Binaries are also named the same: mysqld for the server and mysql for the client.

After installation you can start MariaDB with sudo /etc/init.d/mysql start or sudo service mysql start