Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).

MariaDB is based on MySQL and is available under the terms of the GPL v2 license.

It's developed by the MariaDB community with Monty Program Ab as its main steward.

MariaDB is kept up to date with the latest release from the same branch.

In most respects will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB. There is no need to convert databases to switch to MariaDB. MariaDB is a true drop in replacement of MySQL! Additionally, MariaDB has a lot of nice new features that you can take advantage of.

See the MariaDB FAQ for more information.

See also:

776 questions
5
votes
1 answer

fail to enable mysqld service but after reboot the service is running on centos 7

After I installed, I run systemctl enable mysqld.service. Then, the output is: Failed to execute operation: Too many levels of symbolic links After this error, I reboot my service, and I check the status of mysqld.service. systemctl status…
Tony
  • 51
  • 1
  • 1
  • 3
5
votes
3 answers

CentOS 7 MariaDB Error "Failed to start mariadb.service: Unit not found."

I am somewhat new to Linux, testing various LAMP setups in Virtualbox on Windows. Currently I have a Centos 7 VM that I am trying to install MariaDB on. I am following instructions here: http://www.tecmint.com/install-lamp-in-centos-7 I ran # yum…
B-and-P
  • 209
  • 1
  • 2
  • 8
5
votes
2 answers

MariaDB / MySQL galera cluster nodes won't join

I'm setting up a MariaDB Galera cluster and I can’t seem to get the nodes to join each other. They both start up without errors but never seem to join, the status is always disconnected: MariaDB [(none)]> show status like…
bwizzy
  • 1,265
  • 4
  • 14
  • 17
5
votes
2 answers

mytop: least privileges required to run it?

What is the minimum set of privileges that mytop requires in order to work, without actually requiring super-user privileges. I feel uncomfortable with the fact that I have to save the password in the configuration file (the less desirable…
0xC0000022L
  • 1,456
  • 2
  • 20
  • 41
5
votes
3 answers

High availability MariaDB only two servers

I'm not worried about split brain since the connection between the two servers is solid (and because I don't have a third machine) I want to have some MariaDB replication with automatic failover so even if one database dies, it continues working.…
forkwasher
  • 75
  • 1
  • 4
5
votes
1 answer

Why isn't there a character-set-client-handshake RDS parameter for MariaDB 10.2 or 10.3?

MariaDB has a parameter, --character-set-client-handshake, that can allow you to specify that the server should ignore the character set being specified by a client connecting. On RDS, when you create a parameter group for a MariaDB v10.1 instance,…
ilasno
  • 236
  • 1
  • 3
  • 16
4
votes
2 answers

Mariadb 10.3 high disk write rates

With the help of some other fine people here, I have found the high loads we have been experiencing lately are related to mysqld high disk write rate seen in iotop. With a load average now 3-6 where it used to stay around one. I installed mytop to…
rwfitzy
  • 223
  • 5
  • 15
4
votes
2 answers

Setup wordpress container in subdirectory with nginx and mariadb

Ok guys here is the problem: i have my webserver serving a website, a cms and mobile app api using a subdirectory approach like this localhost -> site localhost/cms localhost/api everything is built using docker compose services: server: …
javal88
  • 143
  • 1
  • 7
4
votes
1 answer

Force Postfix to use TLS for MySQL Connection?

The Problem I cannot figure out how to force Postfix to use a TLS connection to MySQL. I can manually connect from the Postfix server to the MySQL server with TLS as the postfix user, so there's nothing broken with MySQL authentication. The…
seWilliam
  • 81
  • 7
4
votes
1 answer

Can't install MySQL with error "Transition check error"

I'm running on CentOS 7 and at the first MySQL installation it failed, so I shutdown the power (the plug so not properly) and at the second time installation I get the following error: Downloading…
Andrew.Wolphoe
  • 145
  • 1
  • 5
4
votes
2 answers

What is the safest way to reinstall MySQL / MariaDB?

After installing a LAMP stack on Debian Stretch I encountered all sorts of issues with MySQL / MariaDB (couldn't log in as root from my normal user and then root had no privileges). I thought the easiest solution would be to reinstall MariaDB: #…
rkhff
  • 201
  • 1
  • 2
  • 5
4
votes
3 answers

How to install mariadb on amazon linux

I referred to the link https://blog.adminfactory.net/mariadb-and-galera-on-aws-amazon-linux.html to install the mariadb on my amazon linux, since I did not find any other resource related to amazon linux. This instructs to add maria.repo. When I…
Harish Ninge Gowda
  • 153
  • 1
  • 2
  • 6
4
votes
2 answers

CentOS 7.2, PHP 5.4 - MySQL extension is missing

I'm trying to install a Wordpress blog on my Linux server (CentOS 7.2), using PHP 5.4 and MariaDB, but I keep running into this error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress. Have been…
Sayem Khan
  • 239
  • 1
  • 3
  • 8
4
votes
2 answers

MariaDB Galera Cluster falls out of sync easily

We're trying to debug an issue with a MariaDB cluster. We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty). There are three machines clustered together, replicating fine (we can run create database foo;…
Cera
  • 533
  • 3
  • 6
  • 12
4
votes
1 answer

Can't login to remote MariaDB server with phpMyAdmin, but works in shell

I recently configured two servers. The first to use Apache and phpMyAdmin. On the other server I have a maria-DB server correctly configured. phpMyAdmin it's reading the config file, but I can't connect to MariaDB server and PMA is throwing #2002…
Rafael
  • 155
  • 1
  • 1
  • 13
1 2
3
…
51 52