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
1 answer

Completely Disable InnoDB in MariaDB 10.6

Not really sure whether to ask this here or at dba.stackexchange.com but I figured here might be more appropriate since it's a server config issue. I have a brand new MariaDB 10.6.5 install on Ubuntu 20.04 I've used MariaDB's own repositories that…
Sledge Hammer
  • 143
  • 10
0
votes
2 answers

High availability with round robin - rsync and DB replication or a cluster?

I have one machine (centos7) with Apache, PHP, MariaDB and Nginx, Nodejs, MongoDB installed and being used by many different domains. I'd like to create a working mirror and can't decide between 2 options: rsync static websites, server and config…
knm
  • 5
  • 2
0
votes
2 answers

MariaDB doesn't start after server restart

I have installed MariaDB on Ubuntu 20.0 where Mysql was installed already. I have removed MySql before installing MariaDB. I had to run command aa-remove-unknown and then sudo service mariadb start only then the DB server starts. This was working…
Ashik Basheer
  • 101
  • 2
0
votes
1 answer

Need help deciding best MariaDB storage engine for our use case and server hardware limitations

I work for a small company and we are in need of a data warehouse. Our production database have around 50Gb of data (grows ~10GB/year, currently), our server is running a little over it's capacity and we think that we could move some historical data…
Henrique Miranda
  • 103
  • 4
0
votes
0 answers

MySQL not saving to separate data directories

Lately I've been struggling with MySQL and it's data directory a lot. At first, I've tried docker for multiple instances but our company doesn't prefer docker no one knows why. So I come up with a solution. Some information; Multiple servers (6)…
emir ko
  • 1
0
votes
1 answer

MariaDB do not store select all view

im using views in mariadb. at the moment i'm on a windows server. if i save in windows an select *(all) view for a table. next time if i open the view it stays as an select *(all). in linux(i tested ubuntu and centos) after saving the view it writes…
d3mi
  • 1
  • 1
0
votes
1 answer

How to query linux kernel which storage-related operations are currently being run on the level of FS / block layer / SATA controller?

Every once in a while, our Linux LAMP server (using PHP-FPM, XFS on thin LVM on HW RAID, Centos8) becomes inaccessible and stops responding to HTTP(S) requests. Via centralized logging we found out that in those cases, load average quickly shoots up…
Ján Lalinský
  • 282
  • 1
  • 11
0
votes
1 answer

mysql_install_db wrong charset and collation

I am creating a new server with the mysql_install_db tool. It sets the correct datadir, port, password, service etc. But My problem is that the charset and collation of my base tables are wrong. They need to be utf8mb4 and utf8mb4_general_ci. I…
Niels
  • 101
  • 5
0
votes
1 answer

MYSQL: Many slave servers with smaller resources or less with larger resources

I want to create High availability with Master Slave replication (for Select query). I am wondering which one is better: Having smaller resources slaves but more servers or Having larger resources slaves but less servers I only use One Master for…
yodann
  • 101
  • 1
0
votes
1 answer

MariaDB installation using RPM failed

I'm trying to reinstall MariaDB since unable to restart the service. Using Centos 7.6. Previous uninstalled was using yum but this install i'm using RPM since i chose for specific older version (10.3.17) that doesn't offer in yum package…
Daniel
  • 1
0
votes
1 answer

What can I do about a hanging MyCollab installation?

MyCollab displays an initial setup screen a la Wordpress, but the installer hangs, regardless of how permissive I've set its directory to be. When I test a database connection, it said that it can't make a connection. I have specified the database…
Christos Hayward
  • 1,162
  • 3
  • 16
  • 35
0
votes
0 answers

Nginx 2 servers 1 port

I know this can be done in Apache and I am still new to nginx but how do I based on the domain entering do I send it to a different server? So I basically have 2 sites I just use for messing about with and I want to use nextcloud but this will have…
Riddleuk
  • 1
0
votes
0 answers

2 servers, 2 databases on each, 1st server 1st db master and 2nd slave, 2nd server 1st db slave, 2nd master, is it possible?

I have 2 MySQL/MariaDB servers each of them with its own database and I would like to set up a continuous backup on each other via replication. Is it possible to make 1 DB master and 1 slave on each one of the servers? Server 1 Server 2 db1…
Eugene
  • 119
  • 5
0
votes
0 answers

Can I flatten MariaDB general logs from their multiline format?

We're trying to get our MariaDB transaction logs imported into SumoLogic, however the logs are in a multiline format so the logs that are being uploaded are essentially unusable in this format. Sumo allows us to use regex to determine the log…
Brad R
  • 45
  • 6
0
votes
0 answers

MariaDB 10.3 Randomly crash

I'm facing a very weird issue with a mariadb database, randomly it crash with this error: free(): corrupted unsorted chunks 210804 20:05:16 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or…
NET-WATCH
  • 1
  • 1
1 2 3
…
55 56