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:

837 questions
3
votes
4 answers

mariaDB can't connect from remote host

MariaDB [(none)]> show variables like '%skip_networking%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | skip_networking | OFF | +-----------------+-------+ 1 row in set (0.00 sec) When I try mysql -uroot…
Koda
  • 57
  • 1
  • 1
  • 6
3
votes
1 answer

Galera cluster - cannot start MariaDB (CentOS7)

I'm trying to install a Galera cluster with 3 mariadb VM's (all of them CentOS 7). I've never done this before, so I was following this guide: http://tunnelix.com/mariadb-galera-cluster-installation/ The problem is that after I enter my settings on…
João Santos
  • 39
  • 3
3
votes
1 answer

MariaDB ignores root password completely

I just installed MariaDB (mysqld) on a fresh Ubuntu downloaded yesterday. Then I ran the script /usr/bin/mysql_secure_installation and set new root password and disabled passwordless login. However this didn't work so I tried form the command…
Nulik
  • 284
  • 1
  • 4
  • 14
3
votes
1 answer

MariaDB always show SSL not in use when I start mysqld with --ssl

CentOS 7.2.1511 Linux 3.10.0-123.9.3.el7.x86_64 MariaDB: 10.1.11 /etc/my.cnf # # This group is read both both by the client and the server # use it for options that affect everything # [client-server] # # include all files from the config…
bitdancer
  • 143
  • 1
  • 7
3
votes
1 answer

Vagrant provision : shell script install mariadb-server on Debian prompt error

I'm looking for provisioning a Debian 8.2 Virtualbox VM with MariaDB 10. I use the following : sudo export DEBIAN_FRONTEND=noninteractive sudo debconf-set-selections <<< "mariadb-server mariadb-server/root_password password $ROOTDBPWD" sudo…
Erick Loitiere
  • 33
  • 5
3
votes
0 answers

MySQL user suddenly loses some permissions

On CentOS 7, I have a MySQL (actually MariaDB) database user that needs all server privileges from a remote IP (to be able to use Navicat Premium to manage the database). Somehow every once in a while this user loses its 'Create temporary tables'…
Dylan
  • 181
  • 1
  • 4
3
votes
3 answers

MariaDB replication lag

I'm trying to get replication working between 2 servers running MariaDB 10.1.7 64 bit. The database I'm trying to replicate is huge, 520G and the export/import on the slave with disabled autocommits took 5 days. When I initially started the…
Mugurel
  • 903
  • 1
  • 9
  • 17
3
votes
6 answers

Cant read dir of /etc/my.cnf. (Errcode: 2)

I am running MariaDB (libmysql - 5.5.41-MariaDB) and today I noticed that I couldn't go to mysql via command line to create a dump file. It would throw an error: mysql: Can't read dir of '/etc/my.cnf.' (Errcode: 2) Fatal error in defaults…
user3186337
  • 85
  • 1
  • 3
  • 10
3
votes
1 answer

HAProxy but still single point of failure

I'm setting up a test cluster - Maria Galera Cluster on 3 physical nodes with HAProxy. Its working, but I've made some kind of beginner error which I can't seem to resolve - so hopefully someone can cast an expert eye and help me out please?! I have…
user3566845
  • 33
  • 1
  • 4
3
votes
1 answer

Galera: Run slow ALTER without locking entire server

I have a 3-node galera cluster with a few hundred databases servicing various clients. I'm only using galera as an easy way to handle replication and fallover. I'm not actually using multiple masters at once. I need to run a rather expensive ALTER…
chroder
  • 664
  • 2
  • 8
  • 17
3
votes
1 answer

Failed at step EXEC spawning /usr/libexec/mariadb-prepare-db-dir

a bit of a newbie here so mind my obliviousness. I'm trying to install mariadb on a fresh Centos 7 server, though upon running "systemctl start mariadb.service" I get this malarkey: Job for mariadb.service failed. See 'systemctl status…
Joseph
  • 31
  • 1
  • 2
3
votes
2 answers

Installing MariaDB + Galera via yum fails with "No package MariaDB-Galera-server available"

I'm spun up a brand new Cento OS 7 virtual machine and I'm following this tutorial to install a MariaDB + Galera cluster. I've added the MariaDB repos as follows: vi /etc/yum.repos.d/MariaDB.repo then filled it with [mariadb] name = MariaDB baseurl…
sabbour
  • 196
  • 2
  • 6
3
votes
2 answers

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should suffice to dump the table: mysqldump -u root -p…
tony_perkis666
  • 243
  • 2
  • 12
3
votes
1 answer

MariaDB, Galera, xtrabackup - do I need the binary log?

We are using a MariaDB Galera Cluster with 3 nodes. For the state transfer we are using xtrabackup. We have some problems with the binary logs - they got too big and crashed the server. We can remove them manually with the purge binary logs…
bernhardrusch
  • 175
  • 1
  • 9
3
votes
2 answers

apt-get purge mariadb leaving traces which stop mysql install

I'm trying to bug test a database issue with a website I'm working on. I would like to see if switching between mariadb and MySQL fixes the issue (however unlikely that is). I thought this would be a simple processes on a dev machine (I don't have…
AlexLordThorsen
  • 147
  • 1
  • 6
1 2 3
…
55 56