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

Are MySQL/MariaDB and Postgresql compatible?

I want to install multiple applications on my web server. For most of them, using PostgreSQL is possible or the only option. But in one of them's installation guide, only MariaDB is mentioned. If I create a PostgreSQL database, will it work on the…
Yav
  • 1
  • 1
0
votes
0 answers

MySQL doesn't start

Today I wanted to restart mariaDB because I couldn't connect to the database anymore. When I tried to restart it, I got these errors: ● mariadb.service - MariaDB 10.7.3 database server Loaded: loaded (/lib/systemd/system/mariadb.service;…
BestRazer
  • 1
  • 1
0
votes
1 answer

MariaDB High CPU load after Crash

I have a problem with MariaDB 10.3.16. I was trying to convert a rather large table (26GB) from MyISAM to InnoDB and unfortunately the disk space ran out during this process. When it got full, it logged plenty messages like this: 2022-03-25 0:03:54…
Nuramon
  • 150
  • 2
  • 10
0
votes
0 answers

(FREERADIUS&MYSQL) Getting aborted connections to my db (got an error reading communication packets)

https://i.stack.imgur.com/qUI2n.png Running Debian 11, 1 week trying to figure out where this issue comes from, tried authentication method (made a fresh install of mariadb, setting unix socket so radius won't even have to give a pass since my vm is…
arty0m
  • 1
0
votes
0 answers

MariaDB 10.4 Ubuntu 18.04 issue

I installed with success MariaDB 10.4 in our ubuntu 18.04. Root user created with success and another local user for controlling only one database. Although I notice that with command in ssh: service mysql status Mar 21 17:49:11 fresco systemd[1]:…
G. G.
  • 143
  • 7
0
votes
1 answer

How can I fix the keyboard shortcuts in the MariaDB/MySQL shell?

I upgraded from Debian 10 to 11, and from MariaDB 10.3 to 10.7, and keyboard shortcuts were broken, due to a switch from GNU readline to the editline library. I was used to using vi mode, but it is no longer supported, and standard emacs shortcuts…
Roger Dueck
  • 131
  • 5
  • 17
0
votes
0 answers

Issue while setuping Guacamole with Database connection

I installed a Guacamole 1.4.0 instance on a RHEL 8.5 server. Now, I need to setup the LDAP extensions, but for that I first need to setup the database connection and it's at this moment that I have an issue. I'm using MariaDB 10.3.28 The connector…
0
votes
2 answers

How to fix connection issue with mariadb in amazon RDS?

I have created an AMAZON RDS mariadb database under free tier. I used a random generated password first but it is not connecting. So, I click modify and updated the database with new password. but still, I am getting error as below. (conn=36) Access…
Sara June
  • 451
  • 1
  • 9
  • 28
0
votes
1 answer

apache 2.4.6 site works on Debian 10 but not on CentOS - php 7 code

I have a bootstrap website that runs on Debian 10 - php 7.4.25, httpd 2.4.52, mysqld 15.1 Distrib 10.5.12 which works perfectly. I copied it to my CentOS 7 box, which has selinux running as permissive (temporarily). Php version is 7.4.26, Apache…
kathyl
  • 1
  • 1
0
votes
1 answer

Mariadb using all cpu on Ubuntu VPS and makes server unresponsive

I have couple of ecommerce websites on one Ubuntu VPS with 4 CPU cores and 16GB of RAM. Nothing really intensive it ran perfectly fine even on shared hosting. However now I am having issue with mariadb. Once mysql service is started it begins poping…
cvetan
  • 101
  • 2
0
votes
1 answer

Restore partition file after deleting the other files

I have a date based partitioned database table like this archivedmsgs#p#p202001.ibd archivedmsgs#p#p202002.ibd archivedmsgs#p#p202003.ibd . . archivedmsgs#p#p202012.ibd archivedmsgs#p#p2021.ibd the 2020 partition files got deleted only…
0
votes
0 answers

How to set up multiple apache + php-fpm + mariadb service groups on a single server with per-group resource limits?

We have a centos8 web server hosting hundreds of websites, using 3 services: apache, mariadb and php-fpm. Because apache and mariadb do not support per-account resource limitation, all websites have the same access to many system resources (storage,…
Ján Lalinský
  • 282
  • 1
  • 11
0
votes
1 answer

Establishing SSL with MariaDB10 on Synology

Can anyone please point me to a solution for enabling SSL connections for MariaDB10 on a Synology device? The device is a Synology NAS running DSM 7.0.1 (Update 2). I have: Created the recommended certificates (ca-key.pem / server-key.pem /…
Tree28
  • 1
0
votes
1 answer

MariaDB failed to start on Debian After Upgrading Server

I am running magento application on debian server. MariaDB failed to start after server upgrade. Please find the errors below: I am running magento on Debian Linux server. The site failed to load with error 521. MariaDB is not running. I tried to…
Vibhu Bajaj
  • 21
  • 1
  • 2
0
votes
1 answer

What would initiate MariaDB to start to resolve IP addresses?

In my Windows Logs > Application I see these Warnings IP address 'xxx.xxx.xxx.xxx' could not be resolved: No such host is known. The IP is unknown to me. These Warnings get logged as: Log Name: Application Source: MariaDB Event ID: 100 Level:…
MeSo2
  • 254
  • 1
  • 3
  • 18