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

Maria DB - IP address 'XXX.XXX.XX.XXX' could not be resolved: Name or service not known

I have port 3306 blocked to external connections on Centos server, 3306 is open to a VPN only. I can confirm this using a port check. But the Maria DB logs has lots of entries for DNS reverse look ups, so what is going on? The lookups aren't even…
Kline
  • 247
  • 1
  • 5
  • 17
0
votes
1 answer

Moving from Virtualmin - Should I go with Docker?

For last 5 years I was using Virtualmin on my small VPS where I host my websites. It was mainly used for my projects and presentations, but in last few years I started to host other people's websites (friends etc.). With my Virtualmin setup I had no…
Baterka
  • 137
  • 1
  • 6
0
votes
1 answer

Install MariaDB Server 10.3.12 onto Debian Buster

I am running Debian 10 (buster) and need to install the exact version of MariaDB Server 10.3.12. The version that comes default with Debian Buster is 10.3.27. I tried: sudo apt-get install mariadb-server=10.3.12 E: Version '10.3.12' for…
Justin
  • 5,328
  • 19
  • 64
  • 84
0
votes
1 answer

Galera cluster up sync but missing variable wsrep_cluster_size

I have a Galera cluster up running and in sync, but it's missing wsrep_cluster_size, see the command screenshot below. MariaDB [(none)]> show variables like 'wsrep_cluster_size'; Empty set (0.01 sec) More details: Configuration on the first…
James
  • 121
  • 3
0
votes
2 answers

Import MySql DB Dump Into New MariaDB

I am on Ubuntu 20.04, trying to migrate from MySQL to MariaDB 10.5. I have mariadb installed correctly and I am trying to import the dump of all of my dbs in the new mariadb using mysql -u root -p < all_dbs.sql, but just it outputs: ERROR 1005…
Maestro223
  • 203
  • 2
  • 13
0
votes
2 answers

Mariadb not starting on amazon linux

I am new to aws server configuration. I have setup an nginx web server with mariadb database server for my php/laravel web application. My database server was running good for the last few days hence my website was running without any error. But…
Rejaul
  • 101
  • 3
0
votes
1 answer

MariaDB: my.cnf settings cause mysql commands to error out

in my /etc/my.cnf file i have, under the [client-server] section, the following: sql_mode=NO_ENGINE_SUBSTITUTION when i try to run any mysql commands, such as mysqldunmp or even mysql --help, i get the following error: mysql: unknown variable…
WhiteRau
  • 107
  • 7
0
votes
0 answers

MariaDB Error Reading Communication Packets

I have a problem. When I split my MariaDB from main server to another server (my database server is running MariaDB docker from latest tag) I got an error: Got an error writing communication packets i have 2 server the one is a webserver (no db)…
arash
  • 1
  • 1
  • 2
0
votes
1 answer

mariadb-where is open_files_limit parameter set?

I have LAMP with CentOS 8 and MariaDB installed on my server. in PHPMyAdmin I need to increase open files limit parameter, which is disabled and cannot be edited from there. its current value is set to 16,​384. I checked the hard and soft limits of…
user589154
  • 3
  • 3
0
votes
2 answers

Galera + MariaDB: Deadlock: wsrep aborted transaction

I have 1 server configured the galera, 4 servers with mariadb and 1 with haproxy. But when I want to do an update on any server I get the error "Deadlock: wsrep aborted transaction" or "wsrep_max_ws_rows exceeded" (sometimes). The servers are…
Kronnopio
  • 1
  • 1
  • 3
0
votes
0 answers

Benchmarking ssd MySQL write performance: sysbench oltp_write_only vs write iops, fio. Madness

I've benchmarked about 10 diffrent ssd devices with sysbench oltp_write_only.lua and I found no coroleation whatsoever between max sustained write IOPS of device (both from specification and from fio --bs=4k --iodepth=64 benchmark). I've tested nvme…
ndd
  • 139
  • 6
0
votes
1 answer

ERROR: mysqld: Plugin 'unix_socket' already installed

Every time I restart mysql (mariadb) I get this error : [ERROR] mysqld: Plugin 'unix_socket' already installed [Note] Server socket created on IP: '::'. But I don't even try to enable or setup this unix_socket [Note] mysqld (mysqld…
Anylyn Hax
  • 298
  • 1
  • 5
0
votes
1 answer

MySQL to MariaDB migration on IBM i connected to DB2 with IBMDB2I storage engine and RPG programs

we are in the process of migrating MySQL to MariaDB database on IBM i (AS400) server, but the problem is that MySQL DB has some databases connected to DB2 with DB2 storage engine so the migration will affect programs RPGs that need recompilation.…
Pablo Sartor
  • 1
0
votes
1 answer

Change password length for MariaDB

I'm currently working with mariadb and phpmyadmin on my debian 10 server. For some reason mariadb only allows passwords with a maximum length of 79 characters. If I specify a password that is longer than 79 characters I can easily login to…
Torge Stehr
  • 5
  • 4
0
votes
2 answers

Why the length of tinyint seems to make no difference?

I've been searching for what the length in the tinyint declaration means (e.g. tinyint(5)). And the answers seem to be that it should just be a rule for how MySQL displays the data. But in my case there seems to be no change whichever length i use,…
Digital Ninja
  • 113
  • 4
1 2 3
…
55 56