Questions tagged [mariadb]

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

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

How to ignore DATABASE.TABLE SQL queries in binlog in MySQL for the databases I don't want to replicate

I set up replication for 1 database with binlog_do_db setting. But there are some queries like: USE replicated_db; DELETE not_replicated_db.table; Which breaks replication (with an error about ...
1
vote
1answer
37 views

Mysqldump generated file that is smaller size then database [closed]

My database is 250 MB and dump size is 82 MB. I am using latest MariaDB. running this command: mysqldump -u user -p database > t.sql
0
votes
0answers
40 views

MySQL and MariaDB are not working after installing

I am attempting to setup wordpress on my nginx server. During the installation the tutorial I was following had me install mariaDB. However after running the secure_sql... command, it reported that ...
0
votes
0answers
67 views

Mariadb multi-source replication - Table doesn't exist

I'm setting up multi-source replication with Mariadb 10.6 servers. I have 2 mariadb servers with databases that have the same name "database". I want those two servers to replicate their DB ...
1
vote
1answer
44 views

weird behaviour in a Windows 2019 .BAT script

I have to restore a backup from a Linux MariaDB to a Windows MariaDB, where the PowerBI gateway will import its data. "mariabackup" is MariaDB's physical backup tool. But to restore it, the ...
0
votes
0answers
16 views

Mariadb xtrabackup_binlog_info location

I want to set up replication on my existing Mariadb 10.6 servers. I backup the databases automatically everyday with a custom script. Basically, it runs the following command : mariabackup --defaults-...
0
votes
2answers
30 views

High availability with round robin - rsync and DB replication or a cluster?

I have one machine (centos7) with Apache, PHP, MariaDB and Nginx, Nodejs, MongoDB installed and being used by many different domains. I'd like to create a working mirror and can't decide between 2 ...
0
votes
0answers
41 views

Failed to get properties: Unit name mariadb-extra@.socket is missing the instance name

I've recently upgraded my MariaDB servers from 10.1 to 10.6 and now when I restart services for example wildfly, I get this message : sudo service wildfly restart Failed to get properties: Unit name ...
0
votes
2answers
31 views

MariaDB doesn't start after server restart

I have installed MariaDB on Ubuntu 20.0 where Mysql was installed already. I have removed MySql before installing MariaDB. I had to run command aa-remove-unknown and then sudo service mariadb start ...
0
votes
0answers
15 views

persistent volume for a SaaS project on docker Swarm & ON MY OWN Servers / VPS (non-AWS, non-Azure): what to use for the MySQL & for the file-uploads?

I am not sure, what architecture / which way to go for the persistent data of my docker Swarm SaaS webapp. A draft of the layout with traefik_proxy and some context for a better understanding of my ...
0
votes
0answers
21 views

Docker container communicating with mariadb crashes on Got an error reading communications packet

I have Rails app in docker and also mariadb docker image. But it fails during connection on 2021-11-05 8:27:49 3 [Warning] Aborted connection 3 to db: 'development' user: 'root' host: '172.18.0.4' (...
0
votes
0answers
33 views

HAProxy + MariaDB: Got an error reading communication packets?

My normal config of haproxy is: defaults log global mode http option tcplog option dontlognull timeout connect 5000 timeout client 50000 ...
0
votes
1answer
41 views

Need help deciding best MariaDB storage engine for our use case and server hardware limitations [closed]

I work for a small company and we are in need of a data warehouse. Our production database have around 50Gb of data (grows ~10GB/year, currently), our server is running a little over it's capacity and ...
0
votes
0answers
25 views

MySQL not saving to separate data directories

Lately I've been struggling with MySQL and it's data directory a lot. At first, I've tried docker for multiple instances but our company doesn't prefer docker no one knows why. So I come up with a ...
0
votes
0answers
13 views

Getting error while trying to install MariaDB on CentOS

I've got a VPS which runs CentOS 7, and i need to install MariaDB 10.6.4 instead of the default version (5.5), so i completely uninstalled the previous version alongside mariadb-libs However, when i ...
0
votes
1answer
28 views

MariaDB do not store select all view

im using views in mariadb. at the moment i'm on a windows server. if i save in windows an select *(all) view for a table. next time if i open the view it stays as an select *(all). in linux(i tested ...
0
votes
1answer
119 views

Slow server performance [nginx + php+fpm + mariadb]

I'm having problems finding a bottleneck of my slow server performance. Single wordpress site (10-40 online users) with fastcgi caching and full HTML cloudflare caching. Site performance is fine for ...
0
votes
1answer
54 views

How to query linux kernel which storage-related operations are currently being run on the level of FS / block layer / SATA controller?

Every once in a while, our Linux LAMP server (using PHP-FPM, XFS on thin LVM on HW RAID, Centos8) becomes inaccessible and stops responding to HTTP(S) requests. Via centralized logging we found out ...
0
votes
1answer
39 views

mysql_install_db wrong charset and collation

I am creating a new server with the mysql_install_db tool. It sets the correct datadir, port, password, service etc. But My problem is that the charset and collation of my base tables are wrong. They ...
0
votes
0answers
16 views

All Nodes in Gallera Cluster(MariaDB) has seqno: -1

I Have 4 nodes in Galera Cluster and all of their has seqno: -1 and safe_to_bootstrap: 0 in grastate.dat , i can bootstrap one node manually and now all node is online and working fine but my ...
0
votes
1answer
40 views

MYSQL: Many slave servers with smaller resources or less with larger resources

I want to create High availability with Master Slave replication (for Select query). I am wondering which one is better: Having smaller resources slaves but more servers or Having larger resources ...
0
votes
1answer
71 views

MariaDB installation using RPM failed

I'm trying to reinstall MariaDB since unable to restart the service. Using Centos 7.6. Previous uninstalled was using yum but this install i'm using RPM since i chose for specific older version (10.3....
0
votes
1answer
69 views

What can I do about a hanging MyCollab installation?

MyCollab displays an initial setup screen a la Wordpress, but the installer hangs, regardless of how permissive I've set its directory to be. When I test a database connection, it said that it can't ...
0
votes
0answers
18 views

Nginx 2 servers 1 port [duplicate]

I know this can be done in Apache and I am still new to nginx but how do I based on the domain entering do I send it to a different server? So I basically have 2 sites I just use for messing about ...
1
vote
0answers
33 views

2 servers, 2 databases on each, 1st server 1st db master and 2nd slave, 2nd server 1st db slave, 2nd master, is it possible?

I have 2 MySQL/MariaDB servers each of them with its own database and I would like to set up a continuous backup on each other via replication. Is it possible to make 1 DB master and 1 slave on each ...
2
votes
3answers
124 views

MariaDB crazy at 500% cpu time

GLOBAL STATUS MariaDB [(none)]> SHOW GLOBAL STATUS; +--------------------------------------------------------------+--------------------------------------------------+ | Variable_name ...
0
votes
0answers
15 views

Can I flatten MariaDB general logs from their multiline format?

We're trying to get our MariaDB transaction logs imported into SumoLogic, however the logs are in a multiline format so the logs that are being uploaded are essentially unusable in this format. Sumo ...
0
votes
0answers
42 views

MariaDB 10.3 Randomly crash

I'm facing a very weird issue with a mariadb database, randomly it crash with this error: free(): corrupted unsorted chunks 210804 20:05:16 [ERROR] mysqld got signal 6 ; This could be because you hit ...
1
vote
0answers
154 views

Can't connect Wordpress and MariaDB on LAMP stack with docker-compose

I'm new here and that's my 1st question so tell me if anything is wrong in the way I put it. So here's the problem: I'm building a LAMP stack with 3 separate containers for nginx, maiadb and wordpress....
0
votes
1answer
42 views

unknown variable 'file-key-management-filename'

New installation of Debian 10, with MariaDB 10.3.29. Trying to set up encryption-at-rest, but MariaDB won't start due to an error... 2021-07-16 17:13:16 0 [Note] InnoDB: Using Linux native AIO 2021-07-...
-1
votes
1answer
62 views

Ports closed remotely while they are open locally [closed]

i have a problem with a mariaDB server, the port is locally open, but on a remote desktop, the port appears closed. Port Status service 3306/tcp open mysql ^^^^ localhost output ...
2
votes
2answers
45 views

Why does MariaDB CHAR_LENGTH return NULL instead of 0 when a field is NULL?

I am trying to calculate to total size of stored metadata in a table using CHAR_LENGTH to add up the size of the relevant fields in each row to get a rough idea of the storage size of a result set. I ...
0
votes
0answers
24 views

Use snapshots to freeze a single database in MySQL

Various resources such as https://mariadb.com/kb/en/backup-and-restore-overview/ or https://www.thegeeksearch.com/how-to-backup-and-restore-mariadb-database/ describe how to backup the entire data of ...
1
vote
1answer
49 views

Update MySQL replication server position

I have been trying to set up a replication of a large DB (90GB) I have created a backup using mysqldump --single-transaction I have then restored that on the replication server. I have then enabled ...
0
votes
0answers
206 views

MariaDB crashes frequently

I'm suffering from MariaDB crashing issue for a weeks running on VPS Debian 10. I searched a lot in the internet ,but couldn't found any solution. I tried this , this, this etc... but seriously I didn'...
0
votes
1answer
276 views

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) as non-root user

Can't connect to a local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) I am getting this message, but only when I am not logged in as root. How come not everyone has access to mysql? ...
0
votes
1answer
257 views

MySQL High Load CPU

I have problem with MariaDB , when connect analytics ~ 200 mysql started to appear 132% load and pushed the main CPU to about 40%. Making the website extremely slow I'm using centos 7 ( 8GB ram , 2 ...
0
votes
1answer
87 views

MariaDB Galera Cluster simultaneously got 2000+ Connections on single node How to trace this issue

I am using MariaDB Galera Cluster (Master/Master) having 5 nodes with specs of 32Core 64GB Ram Ubuntu 20.04 Personal Vm-Machines at own Datacenter Top of these nodes, Haproxy is configured which ...
0
votes
1answer
93 views

I want to install mysql 8 instead of mariadb

Good evening, I did install mariadb 10.4 in order to install magento 2.4.2 but when I did a general update it upgrade to mariadb 10.5 automatically, which is not supported for magento... As I can't ...
0
votes
1answer
118 views

Package MariaDB-shared requires MariaDB-common, but none of the providers can be installed

I am trying to update the packages on my CentOS 8 server, but when I run sudo dnf update, the following message shows up: Last metadata expiration check: 0:43:34 ago on Wed 12 May 2021 11:59:25 AM ...
2
votes
2answers
827 views

kubernetes mariadb-galera cluster - bitnami helm chart - Readiness probe failed

I am trying to setup a mariadb-galera cluster through the bitnami helm chart in my kubernetes cluster (1 master, 3 nodes). I have modified the myvalues.yaml to include an existingClaim: dbstorage and ...
-1
votes
1answer
46 views

How to Mirror MariaDB schema into Mysql? [closed]

We are using MariaDB for our main service and Mysql on another for our ATM machines, I trying to fetch all the data and to have all the transactions available. I don't know if this is possible because ...
0
votes
1answer
118 views

Postfix/Dovecot cannot connect to MariaDB after crash

I am running a mail server on CentOS 8 using Postfix, Dovecot (virtual users) with MariaDB. ~1 week ago, Mariadb seemingly crashed and deleted most (?!) of the users, but failed "softly" and ...
0
votes
0answers
39 views

How to recover frm and ibd files?

I had a monster problem after the lack of space by mysql-slow and it ended and apparently MariaDB stopped working because it corrupted something in the bank. Luckily I made a backup of / var / lib / ...
0
votes
1answer
44 views

Unknown table 'table_io_waits_summary_by_table' in information_schema

how can i get IO stats per table in MySQL/MariaDB? MariaDB [INFORMATION_SCHEMA]> SELECT * FROM INFORMATION_SCHEMA.table_io_waits_summary_by_table \G; ERROR 1109 (42S02): Unknown table '...
1
vote
0answers
50 views

Best MySQL/MariaDB scaling strategy for shared hosting provider

As a small shared hosting service provider our MariaDB server is going to face a hardware limit very soon. So we want to add another machine for another MariaDB instance. Our goals are: Reduce disk/...
0
votes
0answers
51 views

How to restore a Galera Cluster node from backup

I have a 5 node cluster, with 3 running as VMs on different hosts, and 2 nodes as physical machines. We had a power failure which took down the cluster, and I was not able to get any node to restart (...
0
votes
1answer
63 views

mariadb oom-killer on CentOS8 in EC2 t2.micro instance

I seem to be having memory problems in my t2.micro instance (1GB) running nginx, mariadb, php and WordPress. I can see that mariadb.service is being killed regularly (I have used grep -e kill /var/log/...
0
votes
0answers
168 views

Maria.db Service Doest Not Start in Ubuntu. InnoDB: The innodb_system data file 'ibdata1' must be writable

When I try to restart mariadb.service I get this error messages: ● mariadb.service - MariaDB 10.4.12 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: ...
0
votes
1answer
33 views

Is it Safe to Use "ufw allow from xx.xx.xx.xx" Command for IP Addresses Which are Faced With UFW_BLOCK?

I have UFW opened on my database servers and I have seen a lot of UFW_BLOCK logs. Is it safe or right to use "ufw allow from xx.xx.xx.xx" and "ufw allow to xx.xx.xx.xx" command for ...

1
2 3 4 5
15