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
9
votes
6 answers

Can't Install MariaDB - Dependency Error?

I'm running Ubuntu 14.04 on a Digital Ocean VM. I'm trying to install MariaDB 10.1. When doing so, I get the following error: Setting up mariadb-server-10.1 (10.1.8+maria-1~trusty) ... dpkg: error processing package mariadb-server-10.1…
Zach Russell
  • 277
  • 1
  • 3
  • 13
9
votes
1 answer

MySQL (MariaDB) crashes frequently

I recently migrated an old server running MySQL to a new VPS running MariaDB 5.5. I don't have too much running on the server (just a few PHP sites) and free memory seems to be OK, but the DB keeps crashing--sometimes every few days, other times…
Matt Hamann
  • 193
  • 1
  • 1
  • 8
9
votes
3 answers

Anyone used MySQL Forks in Production

Now that MySQL is owned by Oracle many are starting to consider using some of the popular forks such as MariaDB and Drizzle. Has anyone used these in production for any extended periods of time? If so have the features been stable and has the…
Kyle Brandt
  • 83,619
  • 74
  • 305
  • 448
9
votes
1 answer

MySQL / MariaDB client slow to start/load for user A but not for user B

We had a user (User A) starting the mysql client and it would take several seconds to load, the user felt that this just started out of the blue and hadn't done this before. It was causing a few scripts to time-out and there was a concern that it…
Woody2143
  • 409
  • 2
  • 7
8
votes
3 answers

MariaDB MySQL shows have_ssl disabled when certs are installled

Trying to enabled SSL on my mariadb-server. I have followed the official mariadb docs to generate a ca-key ca-cert server-key server-cert. My machine is a debian 9 kvm vps with mariadb 10.1.37 When I run SHOW VARIABLES LIKE '%ssl'; as root I get…
Reece
  • 211
  • 1
  • 2
  • 5
7
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
  • 229
  • 1
  • 2
  • 8
7
votes
1 answer

Working Nginx fastcgi_cache php-fpm cache and static file caching configuration?

Nginx wiki is very vague with explanation as to how to properly setup nginx with php-fpm with fastcgi_caching for sites which have cookies i.e. wordpress, drupal, vbulletin etc. I downloaded a modified nginx bash shell install script called centmin…
p4guru
  • 963
  • 1
  • 8
  • 16
6
votes
2 answers

mariadb mad file take all space in hard drive

My disk is full, an .MAD file in tmpdir takes up all the space on the file system (50G out of 110G) from log: [Warning] mysqld: Disk is full writing '/var/tmp/#sql_b6f_0.MAD' (Errcode: 28). Waiting for someone to free space I execute the service…
Guillermo
  • 63
  • 1
  • 1
  • 3
6
votes
4 answers

Why won't MariaDB start after upgrade (NO_NEW_PRIVILEGES)

After upgrade of my debian(testing, jessie to stretch) server on DigitalOcean, MariaDB won't start with service mariadb start. I tried to purge all mariadb-* and mysql-* packages, delete configs and data, and reinstall them, but…
Spikolynn
  • 245
  • 1
  • 2
  • 11
6
votes
1 answer

Auto-start MariaDB using systemd after it has crashed

I am trying to set up MariaDB in a way that it automatically recovers -- basically restarts, from a crash. Based on this article -- scroll down to Auto-starting Services with systemd, I opened…
Mahdi
  • 287
  • 2
  • 5
  • 11
6
votes
1 answer

Galera cluster (MariaDB) on Docker/CoreOS: second node doesn't work on first attempt

I'm trying to create an automatic deployment of Galera Cluster with MariaDB, running inside Docker containers on CoreOS. Software used: - MariaDB official Docker image, version 10.1.10 - CoreOS 899.5.0, with Docker 1.9.1 Everything is running on 2…
ItalyPaleAle
  • 455
  • 5
  • 18
6
votes
2 answers

ERROR 2006 (HY000): MySQL Server Has Gone Away... (HaProxy / Galera)

I setup a cluster of 3 MariaDB servers in a multi-master setup which is working fine. I added a 4th server for HaProxy to load balance and round robin so that we can have a little redundancy which is also working, except for 1 issue. I am logged…
Hatem Jaber
  • 163
  • 1
  • 7
6
votes
2 answers

Centos 7. Freeradius fails to start on boot due to priority

I was messing around with FreeRADIUS and MySQL (MariaDB) and it seems FreeRADIUS service can't start properly on startup. But it starts fine using root user or in debug mode (radiusd -X) and works just fine! Debug mode shows no errors. systemctl…
Alex
  • 516
  • 1
  • 7
  • 18
6
votes
2 answers

MariaDB Cluster vs Percona Cluster for MySQL

What are the advantages and and disadvantages between the two? I've only been able to find information on these two implementations without any specifics on clusters. I'm currently implementing a Percona Cluster but my only concern currently is with…
wathou6
  • 63
  • 1
  • 1
  • 3
5
votes
4 answers

MariaDB 10.2.14 (Got timeout reading communication packets)

I am seeing warning messages in my MariaDB server logs. I have tried many things. I have optimize and repair all of my databases but warning are still there. 2018-04-19 22:50:14 139673358411520 [Warning] Aborted connection 473891 to db: 'admin_'…
Muhammad Hassaan
  • 409
  • 2
  • 8
  • 18
1
2
3
…
55 56