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,860 questions
0
votes
1
answer
23
views
MariaDB --skip-grant-tables --skip-networking appears to remain despite removal from cnf files
AlmaLinux 9.6
We have recently been having some big issues with a Plesk update from MariaDB 10.5 to mariaDB 10.11.14 .
This now seems to be resolved (I reinstalled the MariaDB and the data from a dump)...
- 269
0
votes
2
answers
29
views
How to resolve "phantom" tables in the tablespace?
We run a Plesk server, for our sins. We yesterday did an update from MariaDB 10.5.17 to 10.11.14
SYSTEM:
AlmaLinux 9.6
Plesk Obisidan 18.0.73
An issue that has been identified with this is that ...
- 269
0
votes
1
answer
33
views
how to solve SQLSTATE[HY000] [2002] Permission denied on localhost mariaDB 10.11.14
We use Plesk, for our sins.
We have updated MariaDB from 10.5 to 10.11.14 and now all websites on the server that previously connected on "localhost" are coming back with:
SQLSTATE[HY000] [...
- 269
0
votes
0
answers
26
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
1
answer
30
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
17
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
32
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
64
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
35
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
29
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
20
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
54
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
26
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