Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).

Filter by
Sorted by
Tagged with
0 votes
0 answers
253 views

HAProxy inside Kubernetes proxying to MariaDB Galera Cluster VMs having intermittent connectivity if more than one pod

My project at work is having applications running on Kubernetes that connect to MariaDB Galera cluster running on VMs. To manage the connections to the MariaDB, I'm using HAProxy running as pods ...
Lukman's user avatar
  • 186
0 votes
2 answers
768 views

Override MySQL Variable from conf file

I try to override the variable optimizer_switch and change rowid_filter=on to rowid_filter=off. The official documentation does not provide an example. Attempt #1: /etc/mysql/mariadb.conf.d/70-...
Black's user avatar
  • 491
2 votes
1 answer
387 views

MariaDB regularly freezes every 1-2 days

I'm using MariaDB on Ubuntu 22.04 running on a Proxmox container (LXC). I have two instances for two different services, but since upgrading from 21.10 to 22.04 both instances completely freeze once ...
Marco Fincato's user avatar
1 vote
1 answer
559 views

MySQL Corrupted After System Crash

I'm using MacOS Monterey 12.6.1 with Homebrew 3.6.6 and MariaDB 10.8.3 The OS crashed out of nowhere and rebooted itself. After the reboot I was unable to connect to the database: Can't connect to ...
Rawkon's user avatar
  • 11
1 vote
0 answers
703 views

MariaDB 10.5 refusing remote connections

I've gone through a lot of tutorials and questions and I still can't get it to work. I installed MariaDB 10.5 on a Debian 11 server. We changed its IP address yesterday and since then we cannot do a ...
Victor Leal's user avatar
0 votes
0 answers
1k views

Maria Database (Mariadb) - Aborted connection to db: 'unconnected' user: 'unathenticated' host: '127.0.0.1'

I am running an Ubuntu based LEMP mail/web server, using MariaDB. When I run the command sudo service mariadb status I get the following warnings: Oct 24 00:32:44 mail.example.com mariadbd[1226]: ...
DanRan's user avatar
  • 123
0 votes
1 answer
618 views

Limiting CPU usage of Mariadb proccess doesn't work

I'm building a server that runs Mariadb 10.5, apache, nginx and PHP-FPM. The server have 16 cores and 32GB Ram. This server suppose to work under load, but it doesn't because Mariadb is using 1500%, ...
niceu's user avatar
  • 1
1 vote
1 answer
81 views

AWS MariaDB RDS stalls while upgrading

Our RDS database has been in state 'Upgrading' for over 5 hours. It appears it was applying an Automatic minor version upgrade to mariadb 10.4.26 I cannot connect to the database in any way; I can ...
soniaseguz's user avatar
0 votes
0 answers
215 views

MariaDB replication lagging up to a dozen times a day for no obvious reasons

We first set up MariaDB replication using less powerful servers but considering our increased database load we had to rent more powerful servers and that's when the troubles began. Right now the ...
Artem S. Tashkinov's user avatar
0 votes
1 answer
60 views

does it benefit if split multiple sites into multiple database in shared hosting env?

I have been wondering this for long time let's say I run a server where I hosted 2 PHP sites , they are both heavy on database query server is multi-core , let's say 4 core 8 thread with bunch of RAM ...
qtwrk's user avatar
  • 176
0 votes
0 answers
26 views

CentOS7 VPS: Install WordPress with existing MySQL and httpd

Requirement: Install Wordpress in CentOs 7 VPS Currently available: Apache : Server version: Apache/2.4.35 (IUS), Server built: Dec 8 2018 02:08:22 MySQL : mysql Ver 14.14 Distrib 5.6.47, for Linux (...
Vishnu's user avatar
  • 1
0 votes
0 answers
910 views

Docker/Mariadb: Error starting userland proxy: Listen tcp {IP}:{PORT}: bind cannot assign requested address

I have been unable to run the command: docker-compose up --build -d as I get the following error: ERROR: for mariadb Cannot start service mariadb: driver failed programming external connectivity on ...
divyashie's user avatar
2 votes
2 answers
884 views

Improving mysqltuner recommendations

Problem with mysql under Ubuntu 20.04.0 in a CPU optimized droplet of 32GB RAM with 16 cores. I have 25 sites installed on this server. I have around 100k pages views daily and during peaks around 300 ...
mayomalo's user avatar
2 votes
2 answers
1k views

mariadb cant turn on error_log

I want to turn on error logging for mariadb to resolve "unable to connect to database" errors I can turn on General Log and Slow Query Log in mariadb no problem. However when I restart ...
stevlav's user avatar
  • 21
0 votes
1 answer
571 views

MariaDB Galera. Why is replication not working?

I tried a lot of manuals for configuring MariaDB Galera and in all cases replication does not work. I struggled with version 10.5 Today I tried version 10.3 and the only thing that appeared was ...
Maksim's user avatar
  • 111
0 votes
0 answers
410 views

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 ...
Noor M's user avatar
  • 1
0 votes
0 answers
308 views

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 ...
Vijay's user avatar
  • 1
0 votes
0 answers
369 views

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, ...
ydrezende's user avatar
0 votes
1 answer
104 views

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. ...
S. Doe's user avatar
  • 101
0 votes
1 answer
3k views

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 ...
Snap E Tom's user avatar
0 votes
0 answers
120 views

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, ...
carlitobrigante's user avatar
0 votes
0 answers
65 views

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 ...
Charlie's user avatar
6 votes
4 answers
11k views

MariaDB 10.8.3 in Docker: can't initialize timers

This error happens even after clearing the Docker image cache: $ docker run -it --rm mariadb:10.8.3 2022-06-15 11:28:14+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.8.3+maria~...
Arno's user avatar
  • 101
0 votes
1 answer
490 views

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 ...
Jonas Marty's user avatar
0 votes
1 answer
118 views

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

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 ...
Interface Unknown's user avatar
0 votes
1 answer
363 views

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 ...
Nomanoclass's user avatar
1 vote
0 answers
385 views

MariaDB 10.8.x Strict Mode always ON?

I'm installing MariaDB on a new Debian 11 server and transferring my projects but I have a problem. STRICT MODE is always ENABLED on MariaDB. I check many sites, and try to add the string sql_mode=...
Алексей Бунак's user avatar
1 vote
1 answer
3k views

Error with database authentication in Apache Guacamole

I'm setup a new Ubuntu Server 22.04 VM and am following the documentation here: https://guacamole.apache.org/doc/gug/jdbc-auth.html Guacamole 1.4 installs fine along with Tomcat9 and Nginx proxy; I ...
S3rvant's user avatar
  • 21
1 vote
1 answer
2k views

Mariadb Galera Cluster Cannot Start Up

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 and ...
Winbert's user avatar
  • 13
0 votes
0 answers
573 views

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 ...
Winbert's user avatar
  • 13
1 vote
2 answers
428 views

There is the warning when I run database backup bash script

My database is 8GB When I run the database backup bash script, there is the warning/failure. They have appeared since 1 month ago Here are my warning/failure mysqldump: Error 2013: Lost connection to ...
Bach Do's user avatar
  • 11
0 votes
1 answer
2k views

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 ...
user3637971's user avatar
1 vote
1 answer
4k views

mariadb-client cannot connect to db throwing "RSA Encryption not supported"

I have a docker-compose with a 'db' and 'web' containers. The db is a mysql:8.0 image, and the web is a python:3.9-slim. If I try to connect to the MySQL server inside the db container, it works. But ...
Amat Martinez's user avatar
1 vote
1 answer
338 views

MariaDB cache going cold overnight

We are running a LAMP stack which includes MariaDB 10.5.15 on Centos 7. It's a dedicated server with 4 CPU's and 8GB RAM. Never had a problem until the last few weeks, where I noticed slow queries ...
MrCarrot's user avatar
  • 355
0 votes
0 answers
328 views

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 ...
DeviC3's user avatar
  • 3
0 votes
0 answers
637 views

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 ...
Lucio Crusca's user avatar
3 votes
2 answers
4k views

How to find joins performed without indexes?

I run a WordPress website on Mariadb 10.6, and recently I saw an error Joins performed without indexes in Mysqltuner. Although the number is not very large, Mysqltuner recommends that you keep ...
Junuk 's user avatar
  • 33
1 vote
1 answer
3k views

mariaDB 10.5.12 access denied for [email protected]

fresh installation of mariaDB 10.5.12 on debian 11 was hardened with 'mysql_secure_installation' script, question "Switch to unix_socket authentication [Y/n]" was answered with 'yes'. Now ...
mpr's user avatar
  • 11
0 votes
3 answers
74 views

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()" ...
tach's user avatar
  • 131
0 votes
0 answers
511 views

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 ...
Yav's user avatar
  • 1
0 votes
0 answers
2k views

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: ...
BestRazer's user avatar
  • 101
0 votes
1 answer
1k views

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 ...
Nuramon's user avatar
  • 150
1 vote
0 answers
348 views

Wordpress on Ubuntu Server behind Synology Reverse Proxy (HTTP-HTTS) settings

I am currently setting up my website and need some help while setting the access as it should be. Here the facts: I have a static and public IPv4 address registered TLD (gear-trade.at) DNS entry ...
HightronicDesign's user avatar
0 votes
0 answers
340 views

(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 ...
arty0m's user avatar
  • 1
0 votes
0 answers
644 views

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 ...
G. G.'s user avatar
  • 143
0 votes
1 answer
85 views

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 ...
Roger Dueck's user avatar
4 votes
1 answer
7k views

MariaDB using much more memory than it should

We are using MariaDB 10.3.32 on a Ubuntu 20.04.4 machine with 6 GB of memory, about 20 applications running on it. Databases are all InnoDB. Even with mostly default settings (see on the bottom), ...
rofire's user avatar
  • 41
3 votes
1 answer
9k views

mysqld fails to start due to InnoDB

I did install MariaDB on MX Linux, my system info below : System: Kernel: 5.10.0-9-amd64 x86_64 bits: 64 compiler: gcc v: 10.2.1 parameters: BOOT_IMAGE=/boot/vmlinuz-5.10.0-9-amd64 ...
chepakwak's user avatar
0 votes
0 answers
397 views

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 ...
Jules PAYAGE's user avatar
0 votes
2 answers
1k views

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 ...
Sara June's user avatar
  • 521

1 2
3
4 5
18