Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mariadb]

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

-1
votes
0answers
41 views

SASL: Connect to private/auth failed: Connection refused [closed]

I have problems with my postfix configuration I've configured on my server MariaDB to store information on virtual domains and users and i'm following this guide . When i test postfix i receve the ...
0
votes
0answers
16 views

MariaDB table varbinary column not lined up correctly

I have a strange issue with my MariaDB table. I am using varbinary(16) to store IP addresses (IPv4 and IPv6). The row is inserted ok, but when I SELECT rows, the ip column seems to be skewed. Example: ...
0
votes
0answers
25 views

Failed to start MariaDB on centos 7

I got this error after rebooting the server mariadb-prepare-db-dir[1551]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. mysqld_safe[1581]: 181011 04:04:18 ...
0
votes
0answers
18 views

MariaDB cluster fails to create root user on second node

When I try to create a two node MariaDB cluster in Docker on Windows, I get this error: ERROR 1396 (HY000) at line 8: Operation CREATE USER failed for 'root'@'%' For the first node I run this ...
1
vote
0answers
29 views

MariaDB Cluster is having timeout issue between nodes

I'm having some hard time diagnosing MariaDB Cluster issue that I would like to have some advices. We're running a 3-nodes MariaDB Cluster, each node is on a dedicated ESXi server, and connected by ...
0
votes
1answer
19 views

Temporarily operate on different MySQL/MariaDB data directory without restarting service?

I know that MySQL/MariaDB can be configured at the system level to use a custom path rather than /var/lib/mysql. This requires restarting the service. Is there any way to just run a one-off sql ...
-3
votes
1answer
44 views

Is OK to delete the MySQL database files directly on the server?

So, I need to free up some space on our database server. On investigation it looks like lots of space is being taken up by MariaDB/MySQL databases that are no longer used (snapshots and defunct ...
-1
votes
1answer
40 views

Can't start mysql after installing mariadb

I have just installed mariadb but when I do sudo mysql the I get this error: ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded. i have looked online for fixes but I cannot find any that actually ...
1
vote
0answers
26 views

How to reinstall MariaDB?

I had MariaDB 10.2 installed on Ubuntu 16.04. and I was using MariaDB encryption. I had to uninstall MariaDB so I have uninstalled with following command: apt purge mariadb-server -y That ...
0
votes
0answers
17 views

Getting an error message on while installing any packages in Ubuntu 18.04

While trying to install any packages/apt in my ubuntu terminal after installing showing some error messages. for example, I'm trying to install zip sudo apt-get install zip after execution above ...
0
votes
0answers
53 views

Why is Percona CPU load so high compared to MySQL and MariaDB?

I compared Percona CPU load (left on screenshot) to Oracle MySQL (same almost default config, same DB, load, etc.) Percona vs. MySQL CPU load Tested on all my servers running Debian and Ubuntu. ...
1
vote
1answer
80 views

MySQL server (mariadb) auto shutdown without overload

With old configs, my VPS (1 CPU, 1 GB RAM, 1 GB swap) works normally for almost 2 years. I didn't change anything from beginning. But I have this issue several days ago, MySQL server automatically ...
0
votes
1answer
16 views

2002 Code Error When Trying Import / Export MariaDB Databases in Bitnami's WordPress Multi-tier Stack

I'm trying to do database management via SSH for Bitnami's WordPress Multi-tier Stack/ Specifically I want to export and do an initial import (though I will probably just create a new database). When ...
0
votes
1answer
43 views

Apache queries mariadb database -> how to log queries?

I got a apache2 vhost-configuration with BasicAuth. With the AuthDBDUserPWQery directive I'm checking a mariadb in the background, if the user-pw-combination exists. For troubleshooting I want to see ...
2
votes
1answer
47 views

Where to download MariaDB 10.3 over IPv6?

CentOS 7 server with only IPv6. When I try to use, [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 It ...
0
votes
2answers
39 views

Safe way to manage MySQL on production server

I have production server running on Debian 9. I would like to ask you what is safe way to manage MySQL/MariaDB server (on production server). MySQL/MariaDB server listens only on localhost, because I ...
0
votes
1answer
37 views

MariaDB - import raw InnoDB frm/ibd files?

Good afternoon. My Debian 9 server ran into an issue that rendered the OS inaccessible , I managed to extract all the raw database files (/var/lib/mysql) for my project but unfortunately the engine ...
1
vote
1answer
160 views

systemd not shutting down MariaDB properly?

We are running a LAMP stack on CentOS 7. We have SCL enabled but only PHP and Apache are using it. We were not able to get MariaDB to successfully cutover on a test machine so we never attempted a ...
1
vote
2answers
186 views

MariaDB 10.3 CPU usage, Server performance suggestions

my platform: 8 cores, CPU benchmark > 10k (Intel(R) Xeon(R) CPU E5-1620 v2 @ 3.70GHz) 32GB of RAM 2x 7200 SATA enterprise HDD, 128MB cache, each of them have physical 512b block size Actual file ...
0
votes
1answer
21 views

selinux context for multiple databases

I have a directory /media/databases under which I want to hold 3 different databases : mariadb, postgresql and neo4j. My issue is that I already have configured postgresql selinux context and the ...
0
votes
0answers
27 views

xtrabackup unpacks database backup too slowly

XtraBackup unpacks database backup too slowly (I can't wait when it's done) System: Debian 9, MariaDB 10.1.23 On Debian 8 with the same MariaDB 10.1.23 it works perfect (some minutes) When it try ...
0
votes
1answer
60 views

Enable file key plugin of MariaDB on CentOS 7.5

I'm trying to enable the file_key_management on MariaDB. I'm working on CentOS 7.5 and MariaDB 15.1. Here is the centos-release: CentOS Linux release 7.5.1804 (Core) And the MariaDB version: ...
0
votes
0answers
395 views

Debian 9.5 with MariaDB 10.1.26. Can't write into outfile in a directory if it's in /home/, works fine if it's in /var/. Dirs chowned for mysql:mysql

I'm running MariaDB on Debian 9.5. I've done the following in the Debian shell: mkdir /home/db_out_test chown mysql:mysql /home/db_out_test mkdir /var/db_out_test chown mysql:mysql /var/db_out_test ...
0
votes
1answer
63 views

mariadb service script doesn't create /var/run/mysqld

I have issues starting a MariaDB service on a Centos 7 server, because the directory /var/run/mysqld/ is not created by default, as well as the /var/log/mysqld.log file. Creating this directory and ...
1
vote
1answer
156 views

my.cnf MariaDB configuration - hitting the CPU ceiling even with the optimizations in place

I'm trying to get around this issue of mySQL hitting the ceiling in terms of CPU/Server load, as the server specs are as follows: List item 2 x 2.4GHz Octa-Core E5-2630 v3 Haswell Xeon 128GB RAM SSD ...
0
votes
1answer
45 views

Centos 7 / MariaDB, 1gig DigitalOcean Droplet high traffic kills MySQL [duplicate]

I have a Centos 7 / MariaDB, 1gig DigitalOcean Droplet with 2 low traffic Wordpress sites on. When the server gets approx 15 concurrent users MySQL runs out of memory and drops. Log below: 180806 14:...
0
votes
1answer
81 views

systemd trying to start MariaDB twice (mariadb@multi-user.service vs mariadb.service)

systemd on my system seems to be trying to start MariaDB twice. This first try succeeds, so my system has no real problems, but the second try creates spurious error messages since all the relevant ...
0
votes
0answers
31 views

mariadb 10.3.7 gcache page files not deleted

env: 3 node ubuntu cluster : galera cluster but it is not deleting any of those files. 2018-07-31 22:52:28 16 [Note] The slave is applying a ROW event on behalf of an UPDATE statement on table ...
0
votes
1answer
290 views

MariaDB doesn't start after upgrade from MySQL 5.7

I installed MariaDB server, my MySQL got removed automatically and I tried to get it running using sudo service mysql start, which caused the following error message: Job for mariadb.service ...
0
votes
2answers
327 views

MariaDB won't start after server crash. No error logs

My CentOS 7 server recently crashed by having a hard drive unplugged while it was running and now MariaDB won't start and I'm not getting any error logs. Everything else on the server seems to be ...
0
votes
1answer
49 views

MariaDB (MySQL) 'table marked as crashed' recurring

I have a production environment where about once a week I'm finding the database needs to be repaired and restarted. The MariaDB database contains some InnoDB and some MyISAM tables (the mixture being ...
0
votes
0answers
25 views

MariaDB data loss investigation - user error?

I'm trying to figure out whether a significant data loss in one of the many databases on my MariaDB server was due to user error (customer accidentally deleting data via a web frontend and not ...
1
vote
1answer
27 views

Different cardinality after each ALTER TABLE;

There is no new entries in this table. Same error on 10.3.8-MariaDB and 10.2.6 What could cause that? Also this is strange too.
0
votes
0answers
41 views

MariaDB Galera Cluster ECDSA certificate and cipher

I have created a working MariaDB Galera Cluster and would like to secure it with SSL encryption. I have an ECDSA certificate (ecdsa-with-SHA512) and have setup SSL between the Nodes, but I get the ...
0
votes
0answers
11 views

How do I restore a dokku supported database?

Dokku provides great facilities for automatically backing up databases to S3, and there are lots of examples of setting up automated backups. e.g dokku mariadb:backup-xxx commands However, I can't ...
-1
votes
1answer
12 views

RDA firewalld exception?

I'm using CentOS-7 and configuring two servers to run OTRS System, but the Database Server Firewall "Firewalld" is dropping the Application Server requests for RDA "Remote Database Access". Because ...
1
vote
1answer
42 views

Restart MariaDB cluster with Ansible

I would like to restart my MariaDB cluster with Ansible. I applied serial option to run script on servers one by one, but at the end of the script (= after build cluster), I would like to run command ...
0
votes
1answer
124 views

mariadb in chroot gives Access denied for user 'root'@'localhost' even though password is set

I have a script that runs mariadb in a chroot, its a qemu-arm-static rasoberrypi chroot but I don't that that should change much. The script installs and then sets the password for mariadb root user, ...
0
votes
2answers
262 views

MariaDb won't start debian 9

I just tried to make some changes in my.cnf like: innodb_buffer_pool_size, innodb_log_file_size, innodb_flush_log_at_trx_commit=0, and add "skip-name-resolve" and from that time, can't start the ...
0
votes
0answers
19 views

Galera: What happens after simultaneous downtime

I've got a MariaDB Galera cluster with three nodes in a data center. There is currently only one node that handles the incoming requests (queries). The other nodes are just there for replication and ...
2
votes
2answers
166 views

Server crashing everyday around the same time. MYSQL related? [closed]

We have a dedicated server with a few applications running including a Vbulletin forum and Wordpress site. The main resource intensive application is a PHP chat application that utilizes MYSQL also. ...
0
votes
1answer
73 views

Galera or master/slave MariaDB

What would be the recommended choice for database replication with failover? I know this is a broad question but I'm curious what the general experiences are when it comes to real life setups. As far ...
0
votes
1answer
165 views

Using fail2ban to block mysql on localhost

I have fail2ban working on my server and it does ban SSH but I'm having problems banning users trying to access MariaDB using MySQL. I'm also using Adminer which is the main reason why I'm trying to ...
0
votes
0answers
33 views

MySQL client IP / Server broadcast

Currently I have a machine with multiple IP addresses configured via /etc/network/interfaces. Using debian 9.x. # The primary network interface auto ens192 ens192:1 ens192:2 allow-hotplug ens192 ...
0
votes
1answer
16 views

aws mariadb set file_priv to Y

Is it possible to set file_priv to Y in MariaDB on AWS? I see that rdsadmin has file_priv=Y. My 'admin' user has file_priv=N and if I try to set it to Y, I get an error. To avoid all the "Why in Hell ...
0
votes
1answer
435 views

How to forcefully remove MySQL and MariaDB with unmet dependencies, when apt-get and dpkg do not helped?

I had installed mysql-server on my Ubuntu 16.04 LTS and it worked very good... Next I installed mariadb-server and mariadb-client. There ware some connections with MySQL so I decided to forcefully ...
0
votes
0answers
173 views

unable to enable binary logging in mariadb 10

I have an issue getting binary logging to work, i gone trough many tips but i see many my.cnf files all over and non seem to take the options needed /etc/my.cnf /etc/alternatives/my.cnf /etc/mysql/my....
0
votes
1answer
202 views

Can't access MariaDB from Google Cloud / Compute instance

I can't seem to get remote access to Mysql running on a Google Cloud/Compute instance. I'm trying to do a plain vanilla install. I created the instance, using Debian, the default. I did the apt-get ...
2
votes
2answers
423 views

Mariadb 10.3 high disk write rates

With the help of some other fine people here, I have found the high loads we have been experiencing lately are related to mysqld high disk write rate seen in iotop. With a load average now 3-6 where ...
0
votes
0answers
32 views

Best type of index to create

I need to create an index on the wp_options table of WordPress site and find more than one way to create. Which of these would be better with the issue of WP hitting this table frequently. This is the ...