Questions tagged [mariadb]
Open source RDBMS that forked from MySQL. Add a version-specific tag like mariadb-10.5 if that context is important.
2,858 questions
0
votes
0
answers
8
views
Should I Switch from Master–Slave to Master–Master Database Replication in VoIP Environments?
I have two Asterisk+FreePBX servers that share a common database. The services are active on one server at a time, and in the event of a failure of the main server, the services are then started on ...
- 1
1
vote
0
answers
18
views
Best database driver/connector for MariaDB in Go?
What database drivers and libraries do people use with MariaDB in Go? The page https://go.dev/wiki/SQLDrivers lists 3 MySQL drivers, but none for MariaDB. The SqlX seems to use the same drivers as ...
- 479
0
votes
0
answers
16
views
MariaDB PITR from mariadb-backup (GTID) fails "ERROR: Found out of orders GTID"
I'm trying to perform a Point-in-Time Recovery on a MariaDB 11.4.2 where GTID is enabled. I have successfully restored a full and an incremental backup using mariadb-backup, but I'm failing at the ...
- 163
0
votes
2
answers
30
views
mysqltuner advises to hold all db in ram
I have a small mariadb standalone server (RHEL9 x64), 8GB ram holding a (small) java app and a mariadb 11.4.5 database server (25GB data).
If I run mysqltuner (2.7.0) it tells:
✔ InnoDB Buffer Pool ...
0
votes
0
answers
7
views
MariaDB Slave replication just for backup
I have a MariaDB Galera master-master replication with 2 nodes.
I would like to know if it is a good idea / best practice to add a third slave node just to run periodical dump.
Currently dumps are ...
- 211
0
votes
1
answer
59
views
Slow "best so far" query
I want to filter a table with map, playername, timestamp, time (2 million rows) to the rows that had the "best so far" time at their timestamp. So conceptually something like this:
SELECT * ...
- 113
0
votes
1
answer
27
views
Many mariadb processes running parallelly
I have a tiny Ubuntu 24.04 server with 2GB of memory and running a few basic websites. Since yesterday, I see that the system is running out of memory and swapping a lot so I checked htop and saw that ...
- 101
0
votes
0
answers
28
views
MariaDB replication issue between versions 10.6.19 (master) and 10.11.10 (slave)
I’m running into a replication problem between two MariaDB servers:
Master: MariaDB 10.6.19
Slave: MariaDB 10.11.10
Replication appears to start correctly. SHOW SLAVE STATUS\G under the slave shows ...
- 1
0
votes
1
answer
18
views
Galera 4.24: Added option to disable application level protocol check to allow migration from MySQL to MariaDB?
The release notes at https://github.com/codership/documentation/blob/master/release-notes/release-notes-galera-26.4.24.txt say
Added option to disable application level protocol check to allow ...
- 479
0
votes
0
answers
21
views
MariaDB Connector/ODBC <-> Connector/C compatibility issue?
UPDATE: After 3 days of playing Sherlock Holmes I finally found the problems (plural).
Unbeknownst to me, a newer version (than what is in the default repo) of Connector/ODBC had been manually ...
1
vote
1
answer
53
views
MariaDB: Is there a difference between binlogs and general logs with regard to the information on queries?
We are running two MariaDB instances in a master-slave-configuration. There is quite a high load on the master already, so we are reluctant to switch on the general log to have a look at the queries ...
- 11
0
votes
0
answers
23
views
Add 2nd replica to an existing mariadb primary replica configuration on AWS EC2 instances
We've a Mariadb primary replica configuration on AWS ec2 instances. Can a 2nd replica be added by using AMI of 1st replica including root+ data ebs volumes? If AMI can be used to launch a new ec2 ...
- 1
1
vote
1
answer
59
views
Concurrent conditional inserts, prevent duplicates
I'd like to guard against concurrent conflicting inserts given a certain condition. I'm building a system that allows users to select an available time slot and reserve it but prevent two users from ...
- 111
0
votes
1
answer
37
views
How to use new PARSEC password authentication method in MariaDB?
I tried to use the new PARSEC auth method in MariaDB 11.8 but ran into an error:
> CREATE USER 'app_user'@'%' IDENTIFIED VIA parsec USING PASSWORD('your_secure_password');
ERROR 1524 (HY000): ...
- 479
0
votes
1
answer
47
views
What happens in MariaDB if an index is dropped from a table while a join is running on that table?
I am running Fedora 42 KDE spin, and the output from mysql -V is
mysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using
EditLine wrapper
I have a script that runs weekly that creates a ...
- 161