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

How does one go about using master to master replication along with something like rsync to keep two identical copies of an application identical?

I have servers that do things for me at home, for instance they keep copies of my bookmarks in the way that del.icio.us used to (nextCloud) and keep copies of my code (gitea). Initially I thought that connecting back to them at my house was the…
leeand00
  • 4,869
  • 15
  • 69
  • 110
0
votes
0 answers

Mariadb failover VIP- check the host behind

During MariaDB failover our VIP didn't reflect the host change in UI which caused issues. Is there a way/command to check if the VIP got assigned new master host properly by any command? So that we don't have to roll back the changes. I tried…
dbNovice
  • 153
  • 4
0
votes
0 answers

MariaDB Galera needs openssl 1.0.0 on RHEL 8

I have a RHEL 8.3 installation. It comes with openssl.x86_64 1:1.1.1g-11.el8. However the MariaDB 10.5.7 Galera needs libssl and libcrypto 1.0.0. ldd libgalera_smm.so ldd: warning: you do not have execution permission for `./libgalera_smm.so' …
Richard
  • 55
  • 5
0
votes
1 answer

Unable to change tmp_table_size and max_heap_table_size mariadb

I'm running MariaDB 10.1.47 and trying to set: tmp_table_size = 64M max_heap_table_size = 64M I've set it under both the [server] and [mysqld] sections of my.cnf I've tried setting it in bytes…
steveH
  • 148
  • 2
  • 6
0
votes
0 answers

cant create a DB with Ansible

I have installed MariaDB 10.4 on a CentOS 7 box. The box has MariaDB running and it does not have a root password on the DB. It is only allows local logins. I keep getting the error message below. I have tried to add a .my.cnf file and doesn't…
user2236794
  • 139
  • 1
  • 3
0
votes
1 answer

Mixing Galera and MariaDB/MySQL replication

reading about it online, it appears we can use both Galera replication and native MariaDB/MySQL replication together. Can anyone confirm that this is correct? I'm thinking of a scenario where Data Center A has 3 Galera nodes synchronously…
David Cunningham
  • 31
  • 3
0
votes
1 answer

Is there "another" way of getting log information on SFTP activity?

I'm administrating a debian server since last week. It used to have another administrator. I presume it's been hacked: files might have been read via SFTP to obtain information about a site that's hosted on the server I'm mentioning, and then tables…
newbie
  • 101
  • 5
0
votes
2 answers

MySQL/MariaDB database migration to server

I want to migrate a MySQL/MariaDB database from my local box, where I use it for development, to the server that will actually use it in "production". I'm totally new, so please bear with me. I'm asking for help because I don't even know where/what…
nullgeppetto
  • 113
  • 5
0
votes
1 answer

CentOS 8 syslog entrys for xrdp & mariadb

I recently took a look into my syslog /var/log/messages and noticed two repeating entries that I don't understand: The log is full (and I mean full) of: xrdp[959]: [INFO ] Socket 12: AF_INET connection received from
blaze4k
  • 1
0
votes
1 answer

SELinux Permissions Error on Fedora 32

I am getting this error repeatedly while trying to run Nextcloud on Fedora 32 type=AVC msg=audit(1601229230.944:718): avc: denied { connectto } for pid=584 comm="php-fpm" path="/var/lib/mysql/mysql.sock" scontext=system_u:system_r:httpd_t:s0…
navjotjsingh
  • 126
  • 4
0
votes
1 answer

Unable to start mysql server on linux Debian 9

I have tried a hundred of commands to fix this but to no avail. I get this error when I try to run mysql service: root@lander:/# systemctl status mariadb.service ● mariadb.service - MariaDB 10.1.45 database server Loaded: loaded…
Abeer Sul
  • 101
  • 4
0
votes
2 answers

Best practice on where to store my.cnf configuration with MariaDB

After a small update ran by an Ansible playbook from MariaDB 10.5.4 to MariaDB 10.5.5, the custom configuration file got silently overriden by the default configuration causing the server to refuse connection because the valid custom configuration…
Tristan
  • 498
  • 2
  • 9
  • 27
0
votes
1 answer

MariaDB won't start after upgrade to 10.2 on Centos 7

I am new to Linux. I upgraded MariaDB to version 10.2.33 today and the service refuses to start: mariadb.service - MariaDB 10.2.33 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled) …
BGreene
  • 111
  • 4
0
votes
0 answers

How to actually set up MariaDB replication/high availability

I'm setting up a high availability LAMP stack - so far, I have two servers with HAProxy running on both their frontends that own a floating IP. HAProxy redirects requests to backend Apache servers running on each of them (same machine, port…
forkwasher
  • 75
  • 1
  • 4
0
votes
1 answer

Use case for mysql users depending on host

What is the use case for having different passwords for the same username but different hosts on mariadb/mysql? Is there a way to synchronized the password for the same username for different hosts?
theking2
  • 179
  • 1
  • 1
  • 9
1 2 3
…
55 56