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
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [mariadb]

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

1
vote
1answer
78 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
19 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
43 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
19 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 ...
-2
votes
0answers
34 views

mariadb galera cluster Killed /Checking permissions

mariadb version : 10.3.7 os : ubuntu cluster : galera cluster The result of update query took too long, so the PROCESSLIST kill did. But it stays locked for two days. How should ...
0
votes
1answer
40 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
54 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 ...
-1
votes
0answers
88 views

Mysql2::Error: Unknown MySQL server host 'expvipdb' with docker-compose

docker-compose up gave me Mysql2::Error: Unknown MySQL server host 'expvipdb' (-2) with the following docker-compose.yml file: expvip: build: . restart: always ports: - "80:80" ...
0
votes
0answers
9 views

How to remove options from mariadb tables? [migrated]

Mariadb 10.2.8 I am trying to convert an aria table to InnoDB. My problem is MariaDB> alter table materiales engine=innodb; ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support ...
0
votes
1answer
22 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
21 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
27 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
9 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
10 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
30 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
56 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
114 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
16 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
152 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
41 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
79 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
26 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
187 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
62 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
98 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
302 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
27 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 ...
0
votes
4answers
106 views

How to change datadir for MariaDB?

I have installed MariaDB and changed datadir to /tank/mysql and that was working. After that I had to reinstall MariaDB and I was using: apt -y remove --purge mariadb-server apt -y install mariadb-...
0
votes
0answers
71 views

performance_schema = off mysql running out of memory

I am running a centos 7.5 server that has been updated. The issue I am having is that the server is crashing everyday. When this originally started happening, what I found was if I turned off the ...
0
votes
2answers
52 views

Issue with updated MariaDB using older version

Environment Ubuntu 16.04 Nginx 1.13.12 PHP-FPM 7.2 MariaDB (was 10.1.31, updated to 10.2.15) Issue I updated MariaDB from 10.1 to 10.2. The server shows that 10.2.15 (with MySQL 5.7.22) is ...
-2
votes
1answer
95 views

MariaDB Optimization [closed]

I've a Single Core, 1GB RAM server on DigitalOcean. OS: CentOS Linux release 7.4.1708 (Core) mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1 No other services on this ...
0
votes
1answer
90 views

MariaDb Master-master replication

I tried master-slave replication of mutliple databases of mariadb-5.5.52-1 in RHEL environment, the mariadb came as a part of nagiosxi application. while replicating from master to slave i had many ...
0
votes
1answer
107 views

migrate stopped mariadb server to new one

Hi I'm running a freenas system where I have two jails. One jail is broken in a way that I cannot start the mariadb server anymore due to userland and kernel version mismatch. So I created a new jail ...
0
votes
1answer
24 views

When MySQL/MariaDB is starting, if it has to repair innoDB tables, what happens to queries sent it's way before it's up?

I'm curious. Are they queued, lost, stuck in php connect_timeout till MySQL/MariaDB comes up?
0
votes
1answer
95 views

Performance difference between MySQL and MariaDB

I've strange performance difference between a MariaDB and a MySQL servers I've 2 servers : 1° On the first one I'm running the standard MariaDB package (10.1.26-0+deb9u1) distributed with Debian 9.1 ...
0
votes
0answers
310 views

Unable to start mariaDB service on CentOS 7 - [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/validate_password.so'

Whenever I start the mariadb.service it fails miserably . I tried to reboot and to completely remove the installation then start it over again which I did like 5 times already but I still get the same ...
1
vote
2answers
405 views

MariaDB 10.2.14 (Got timeout reading communication packets)

I am seen warning messages in my logs of MariaDB server. These are there, I have tried many things. I have optimize and repair all of my databases but warning are still there. 2018-04-19 22:50:14 ...
-2
votes
1answer
305 views

Access denied for user 'john'@'gateway' (using password: NO) MARIA DB

My os are linux. I got denied to access db server from web server. I have built database with name is test. I also already created user with name 'john'@'10.0.0.1' with password 'pass' and set all ...
0
votes
0answers
81 views

Ejabberd on Archlinux

I've installed Archlinux and I'd like to setup ejabberd, as it seems to be the perfect software for setting up a jabber server. I've configured Archlinux and setup iptables accordingly, however - ...
1
vote
1answer
161 views

mariadb - fresh install fails on reboot

Been trawling around for a solution to this for a while. Initially in attempting to run mysql i am getting : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/...
0
votes
0answers
72 views

MariaDB optimisation for embedded application

I have distributed embedded system: 1 server and 6 clients, each client runs several applications talking to DB. All units run on the single-core 1GHz ARM SoM with 512Mb RAM. Mariadb was compiled with ...
1
vote
2answers
507 views

High CPU usage by mariadb even after allocated more memory to mariadb?

I am using aws server r4.4xlarge and allocated more than 60GB to database only still i am facing issue of high cpu usage. I have around 10 big table each of approximate size of 18GB with integer ...
0
votes
0answers
156 views

How do I script an unattended setup for MariaDB's mysql_secure_installation?

I found an answer on this for MySQL, but it doesn't seem to work for MariaDB: https://ubuntuforums.org/showthread.php?t=981801 I'd rather use debconf than the stdin based solutions from https://...
2
votes
1answer
388 views

Setup wordpress container in subdirectory with nginx and mariadb

Ok guys here is the problem: i have my webserver serving a website, a cms and mobile app api using a subdirectory approach like this localhost -> site localhost/cms localhost/api everything is ...
1
vote
0answers
64 views

MariaDB Permission denied selecting into /home/testing but works fine in /var/testing, Debian 9.2, MariaDB 10.1.26

I have two directories: /var/testing and /home/testing I've run chown mysql:mysql testing on both. ls -l confirms correct permissions, and sudo -u mysql touch testing/test0.csv works on both. Within ...
0
votes
0answers
256 views

Mariadb 10.1 - 1 of 3 nodes will not restart

Here is the scenario, had to make a config change to Mariadb in a 3 node cluster. I edited the config file, and shut down the node with: # service mysqld stop Made the change on the other 2 nodes ...
1
vote
0answers
95 views

Moving entire database server to Galera cluster

We currently have more or less the following setup: Three individual MySQL database servers (individual Linux machines) with 15 to 50 logical databases and 20 to 50 GB of data Galera cluster (MariaDB)...
0
votes
0answers
46 views

Moving a MySQL database to another device, even if dropped and recreated

I'm using symlinks to move some MySQL databases to another device with more space. All works fine until one of those DBs gets dropped and then re-created: the symlink is deleted in the process of ...