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
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
  • 553
  • 4
  • 6
  • 13
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
4
votes
1 answer

MariaDB how to handle 2/3 node failure in multi master cluster.

I run 3 node multi master MariaDB galera cluster. It basically works for me how it is. When one node fails, two other work and it's fine. But I'm wondering is there a way for it to keep working on one node? (that is really unlikely but I just…
piotrektt
  • 184
  • 2
  • 14
4
votes
0 answers

ERROR 1006 (HY000): Can't create database 'webdata' (errno: 2 "No such file or directory")

On Debian 10, I'm logging into MariaDB with sudo mysql -u root -p Then trying to create a DB create database webdata; ERROR 1006 (HY000): Can't create database 'webdata' (errno: 2 "No such file or directory") Running the following: sudo mysqladmin…
Tom Dudman
  • 41
  • 1
  • 3
4
votes
4 answers

MariaDB memory use rises beyond configured size

I noticed a steady increase in system memory use %age (as reported by sar) which I've tracked to MariaDB. It's does not seem to be related to db load: this increase is notmatched by an increasing number of queries. I have the following size…
artfulrobot
  • 2,949
  • 13
  • 36
  • 60
3
votes
2 answers

Mariadb not running after AWS Linux 2 installation

I'm running an AWS Linux 2 AMI and installed mariadb. The packages installed are: But when I try to start the service running sudo systemctl start mariadb I get Failed to start mariadb.service: Unit not found. Any hints?
xain
  • 677
  • 3
  • 13
  • 24
3
votes
1 answer

MariaDB on docker keeps corrupting data

I'm using the official MariaDB mariadb:10.4.6-bionic image and I have a problem: my tables corrupt themselves. This had happened at least four times this month: on two different dev machines using docker-compose on the staging machine using docker…
Nicolas Reynis
  • 141
  • 3
3
votes
1 answer

After mariaDB 10.0 to 10.1 upgrade, mysql can no longer write tmpdir

I ordered a new server that came with mariaDB 10.0 installed. I edited /etc/my.cnf to change the tmpdir to /home/mysql_tmp_dir (owned by mysql:mysql). All worked fine. Did upgrade to mariaDB 10.1.37 and the tmpdir can no longer be written…
vicos
  • 31
  • 1
3
votes
3 answers

High CPU usage by mariadb even after allocated more memory to mariadb?

I am using aws server r4.4xlarge and allocated more than 60GB to database only still i am facing issue of high cpu usage. I have around 10 big table each of approximate size of 18GB with integer primary key. all tables are innodb and I have…
rajesh6115
  • 131
  • 1
  • 1
  • 4
3
votes
1 answer

MariaDB: Host '127.0.0.1' not privileged

My Ghost instance want to conntect to my MariaDB, but the error is: Message: 'ER_HOST_NOT_PRIVILEGED: Host '127.0.0.1' is not allowed to connect to this MariaDB server' Here my my.cnf: [server] skip-name-resolve innodb_buffer_pool_size =…
gummipunkt
  • 31
  • 1
  • 2
3
votes
1 answer

MariaDB is not listening on port 3306

I have MariaDB server running on Debian 9. Problem is that if I run netstat -anp | grep 3306 nothing shows, but MariaDB server is running, I can connect to it via mysql command. MariaDB config: bind-address = 0.0.0.0 port = 3306 skip-networking
tomsk
  • 287
  • 1
  • 6
  • 18
3
votes
1 answer

Installed Mysql on Debian, but got another database On Debian (MariaDB)

I used the same setup for Nginx server environment for Ubuntu 16.04 on Debian 9.3 but on Debian my database is MariaDB instead Mysql. apt-get install nginx python-certbot-nginx mysql-server php-fpm php-mysql -y I understand that's the default…
Arcticooling
  • 1
  • 3
  • 7
  • 22
3
votes
0 answers

MariaDB on Windows - InnoDB hang on table conversion to MyISAM

This is a bit of a strange one (and a big post, sorry), i am working with a customer who runs MariaDB on Windows (Server 2008 R2). They have several large MyISAM tables (up to 30 GB each, 200+ million rows) and for several reasons i'm converting…
localhost
  • 226
  • 1
  • 6
3
votes
1 answer

Transform Galera cluster into single node mariadb server

We want to get rid of all cluster features on our galera cluster (currently consisting of three virtual machines). The connection between the nodes is not stable enough so the cluster is much slower than our previous single node setup was. Is it…
Christopher Thonfeld-Guckes
  • 137
  • 2
  • 7
3
votes
3 answers

Why are my deadlocks not shown by SHOW ENGINE INNODB STATUS;?

I have a MariaDB (5.5.41) cluster made of 2 nodes configured as master-slave. All reads and writes are sent to the same node. I have been investigating some deadlock issues for a few weeks. On a regular basis, my PHP application returns Message:…
liquidity
  • 418
  • 1
  • 7
  • 22
1 2 3
…
55 56