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
5
votes
0 answers

What could cause a LAMP server to perform poorer than my laptop?

I'm running a WEB application (PHP + MariaDB) for my company, developing on my laptop and running the production version on a dedicated server. Recently, I've started to measure performance and noticed that my laptop performs better than the server.…
François
  • 51
  • 1
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
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,295
  • 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,516
  • 2
  • 22
  • 42
5
votes
4 answers

MariaDB 10.8.3 in Docker: can't initialize timers

This error happens even after clearing the Docker image cache: $ docker run -it --rm mariadb:10.8.3 2022-06-15 11:28:14+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.8.3+maria~jammy started. 2022-06-15 11:28:14+00:00 [ERROR]…
Arno
  • 81
  • 1
  • 5
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

MySQL cli does not remember history of some commands

I use linux OS with mysql database. mysql CLI doesn't log some commands in ~/.mysql_history . For example can not log create user. How can force cli to store all commands in mysql_history ? How can fix this problem ?
mah454
  • 157
  • 4
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
  • 233
  • 5
  • 16
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
  • 163
  • 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
1 2
3
…
55 56