Questions tagged [mariadb]
MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).
867
questions
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 ...
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-...
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 ...
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 ...
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 ...
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]: ...
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%, ...
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 ...
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 ...
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 ...
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 (...
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 ...
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 ...
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 ...
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 ...
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
...
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 ...
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, ...
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.
...
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 ...
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, ...
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 ...
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~...
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 ...
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 ...
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
...
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=...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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()" ...
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 ...
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: ...
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 ...
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 ...
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 ...
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 ...
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 ...
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), ...
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
...
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 ...
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 ...