Questions tagged [mariadb]

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

Filter by
Sorted by
Tagged with
0 votes
2 answers
25 views

Why is Invoiceplane giving error while I copied the ipconfig.php.example file to ipconfig.php file?

The error I got is in this url: url in browser: http://localhost/ error in browser: https://justpaste.it/d82bd What am I missing here? I copied the file ipconfig.php (given below) from ipconfig.php....
0 votes
1 answer
21 views

How to upgrade a MariaDB database to utf8mb4_unicode_ci?

I have a Drupal 9.4.8 website a MariaDB database and phpMyAdmin. My website is already active with data in its 220 MB database. How to upgrade a MariaDB database to utf8mb4_unicode_ci ? Here is my ...
0 votes
1 answer
18 views

systemd start mariadb after mounting USB stick

I moved the datadir of mariadb to a USB-stick, subsequently mariadb won't start anymore at boot time, because the stick is mounted after mariadb was started. I tried to modify the start order by ...
0 votes
0 answers
12 views

zabbix connection to external database

0 I am trying to setup zabbix with two database , one on localhost and another on diffrent machine. zabbix server: 192.168.0.100 external database :192.168.0.154 I setup zabbix with localhostdatabaase ...
0 votes
0 answers
15 views

What does fragmented table mean in MySQL?

I have a MariaDB database with an InnoDB engine and querying data take a lot of time so I search and found that it is maybe related to the tables being fragmented but I cannot understand what it means ...
0 votes
1 answer
72 views

Can't stop/restart MariaDB after a server ran out of disk space?

Using CentOS Stream release 8. I've made space, but my site still responds with Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/www/sites/mysite/inc/DB.php I've ...
  • 1,034
0 votes
1 answer
28 views

MariaDB Master-Master replication with 3 servers, no ports open on master

I want three MariaDB database servers, one master and two "slaves". I want to be able to read and write on every server, and have this replicated on the other servers. I read on the internet ...
0 votes
1 answer
65 views

Getting a SQLSTATE[HY000] [2002] Connection refused in PHP Apache Docker container using mariadb, if connected via Dockerfile's CMD (PHP CLI works)

I'm trying to run a Docker container based on: PHP 8.1 Apache 2.4 MariaDB (latest official docker image) It all starts up without any issue; but I'm unable to connect with the Docker Container's DB ...
  • 135
2 votes
1 answer
113 views

MariaDB - Contiunes to use more memory

We are running Maria DB 10.6.9 on CentOS and we are observing it continues to increase the usage of memory. Server Specifications: RAM - 128 GB vCPUs - 48 Swap - 100 GB We have configured ...
0 votes
0 answers
43 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 ...
  • 186
-1 votes
0 answers
19 views

get ips and hostname in localdatabase to do ansible tasks

Hello im trying to get all ips + hostname in my database [mariadb] and do ansible task in all hosts listed there im using like this: --- - hosts: localhost connection: local gather_facts: no ...
0 votes
2 answers
26 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-...
  • 451
0 votes
0 answers
30 views

MySql losing connection after few minutes while waiting [migrated]

I have an annoying problem. I think the connection is lost when there is no operation in mysql for a while. I've added a video to make it more explanatory. I tried the solutions on the internet but ...
0 votes
0 answers
46 views

Unable to Recover MySQL Database [Missing FILE_CHECKPOINT]

Using MariaDB 10.7.3 via Homebrew on MacOS Monterey 12.6.1 While trying to recover the database after a system crash, I am stuck with the following situation. [Note] mysqld (server 10.7.3-MariaDB) ...
  • 11
0 votes
0 answers
49 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
72 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 ...
  • 11
0 votes
0 answers
30 views

mysql server failed when I run mysql.server start

I use macOS Big Sur(11.5.1) and MariaDB(10.8.3_1) with Brew. After some manipulations with Docker(my guess) my mysql.server stopped working. I cannot run my local MySQL server. These lines I have in ...
0 votes
0 answers
34 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
213 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]: ...
  • 73
0 votes
1 answer
42 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
1 vote
1 answer
26 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
29 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
0 answers
126 views

Why I got the error: %pre(MariaDB-server-10.9.3-1.el7.centos.x86_64) scriptlet failed, exit status 1?

I tried to install mariadb-server on my Centos 7 server by following commands: def install_mariadb(distributor, release, host, maria_version, root_password): galera = 'galera-3' if ...
0 votes
1 answer
49 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 ...
  • 176
0 votes
0 answers
22 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 (...
  • 1
0 votes
0 answers
123 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
81 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 ...
0 votes
0 answers
67 views

Could my website's initial slow response be due to a cheap SSL?

I have my website running on an XMAPP setup using the following software... [ServerA] Windows Server 2019 Standard [ServerA] Apache/2.4.53 (Win64) [hosts websites] [ServerA] PHP 8.1.6 (cli) (built: ...
2 votes
2 answers
88 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 ...
  • 21
0 votes
1 answer
65 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 ...
  • 11
0 votes
1 answer
95 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 ...
  • 1
0 votes
0 answers
97 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 ...
  • 1
0 votes
0 answers
112 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
57 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. ...
  • 101
0 votes
0 answers
42 views

MariaDB randomly crashed and unable to restart

I've been running mariadb on a Pi zero for several weeks now with no problem. It's just for a couple pet projects. Small DBs and only couple relatively light queries per hour. Server crashed few days ...
0 votes
1 answer
504 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
31 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
27 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 ...
4 votes
4 answers
5k 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~...
  • 71
0 votes
1 answer
149 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
35 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
108 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
211 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=...
0 votes
0 answers
323 views

Mariabackup taking too long since 10.8.3

We just upgraded mariadb from 10.7.3 to 10.8.3 and now backup locks the whole database for minutes, before the change the lock was only 3 or 4 seconds (no hardware change, beefy server). This is the ...
0 votes
1 answer
639 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 ...
0 votes
0 answers
57 views

snuffleupagus yelling about disabled functions in phpmyadmin setup

What I am working on is a self setup arch with a LAMP stack, onto which I also want to add phpMyAdmin, and it is complaining about some disabled functions. Here is the file after I have commented out ...
1 vote
1 answer
558 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 ...
  • 13
0 votes
0 answers
240 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 ...
  • 13
0 votes
2 answers
130 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
507 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
2 3 4 5
16