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

MariaDB 10.3 won't restart after upgrade from 10.2 on RHEL 7

Could anyone please let me know what I am doing wrong after an upgrade from MariaDB10.2 to 10.3 [db@hawk ~]systemctl status mariadb.service ? mariadb.service - MariaDB 10.3.36 database server Loaded: loaded…
Noor M
  • 1
0
votes
0 answers

Unable to configure ssl on mariadb using certbot generated certificates and private key

I'm using certbot to generate a certificate for mariadb server and client ,but it's not working. sudo certbot certonly -d mariadbserver -d mariadbuser This is the command that i've used to generate certificates using certbot, I've got 4 files for…
Vijay
  • 1
  • 2
0
votes
0 answers

MariaDB memory much higher than innodb_buffer_pool_size

I have a backend server with 1G RAM for my HTTP server and my MariaDB. I noticed the database keeps getting killed by OOM once or twice a day. Most of the time the OOM is triggered by the HTTP server, but not always. I tried limiting…
ydrezende
  • 1
0
votes
1 answer

MariaDB 10: CHECK TABLE does not return

Problem / Observation: When executing CHECK TABLE MYDB.ICONS; in mysql, the call does not return (within an hour). The same is with SELECT ID FROM MYDB.ICONS; and all other statements at this table. Environment: Server version:…
S. Doe
  • 101
  • 4
0
votes
1 answer

Conflict between mariadb-server-core-10.3 and mariadb-server-10.3 1:10.3.30+maria~bionic on Ubuntu 20

I'm trying to upgrade my server and I'm in a weird state where mariadb-server-core-10.3 and mariadb-server-10.3 1:10.3.30+maria~bionic is conflicting with each other, and possibly maybe involving mysql-server-core-5.5. This is a Ubuntu 20 server and…
Snap E Tom
  • 101
  • 1
0
votes
0 answers

SHA512-CRYPT MariaDB passwords migration to DynamoDB

I used to run my mail server's DB in MariaDB (10.5.16) on-prem on Debian 10. I've now migrated this to RDS, however I would also like to try and migrate to DynamoDB. Most of the data is plaintext, however per say in my account table I have my…
carlitobrigante
  • 31
  • 6
0
votes
0 answers

Can connect one remote server to MySql, but cannot connect two servers

I am trying to finish a website creation using three servers with Linux. For simplicity, I will identify the servers as server 1, server 2 and server 3. I am using MariaDB. All three servers are configured identically, with two exceptions. Server 1…
Charlie
  • 1
  • 1
0
votes
1 answer

Different bin log file index on maria db galera nodes

Setup: Galera Cluster with 3 nodes running in Docker Containers. In front of every node is a maxscale proxy. Remotely is a replication slave running with bin-log replication where the cluster is acting as the master (behind the maxscale proxy).…
Jonas Marty
  • 101
0
votes
1 answer

How difficult is to migrate from Windows to Linux without any experience with Linux?

I have an immense background with Microsoft Windows Server (from Windows NT to the latest server editions), but now I am forced to move some services off Windows Server platform to reduce hosting costs. Within the next couple of months, I will have…
Interface Unknown
  • 111
  • 3
0
votes
1 answer

Synology DS420+, mariadb permission denied in /volume1/logs/mysql

I would like to put the MariaDB logs in an easily accessible place (without having to go through the ssh), but I couldn't do it. My current configuration is as follows: [mysqld] general_log general_log_file=/volume1/logs/mysql/general.log #…
Nomanoclass
  • 1
  • 2
0
votes
0 answers

How to sync table data between two nodes of a mariadb galera cluster?

I built a mariadb galera cluster on CentOS7. Below is the galera node information: 10.200.67.27 MariaDB-Node1 10.200.67.29 MariaDB-Node2 10.200.67.26 MariaDB-Node3 However, MariaDB-Node2 was unexpected stopped. And I found a table named…
Winbert
  • 13
  • 5
0
votes
1 answer

Error java.sql.SQLNonTransientConnectionException between Glassfish 3 and MariaDB

I have a java web application deployed in glassfish. This application interacts with Mariadb server. Suddenly, the app stops working. I'm checking the app.log and glassfish server log and I have the following results: app.log Could not open JDBC…
user3637971
  • 155
  • 2
  • 11
0
votes
0 answers

Mariadb 10.3 on Debian 10 won't start anymore -

on one of my servers there are Mariadb which stops with following status: ● mariadb.service - MariaDB 10.3.31 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: failed (Result:…
DeviC3
  • 3
  • 2
0
votes
0 answers

Upgrade to KeyCloak 18 fails

I have a KeyCloak 17.0.1 that is apparently working without issues on my server, configured to use MariaDB. I say "apparently" because, as of today, it's not in production yet, albeit it starts in production mode, but it is on a development server…
Lucio Crusca
  • 420
  • 3
  • 12
  • 33
0
votes
3 answers

Mariadb legacy support

I have old version of php site, which uses unescaped 'row_number' column number in its sql queries. It seems in the new version of mariadb there has been new function called "row_number()" added and thus the queries fail. To refactor the whole…
tach
  • 131
  • 3
1 2 3
…
55 56