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

learn more… | top users | synonyms

0
votes
0answers
10 views

Galera/Mariadb won't start WSREP: handshake with remote endpoint ssl://x.x.x.x:4567 failed

I am trying to set up a galera cluster. I am running RHEL7.2. I have my master running but when I try to start mariadb on one of my slaves like so ... # /usr/bin/systemctl start mariadb ... it ...
0
votes
1answer
28 views

MySQL 5.5 and MariaDB5.5 return different number of columns for the same data and same select query?

I have been searching through the net for some time and can not seem to find answer for this case. It would be much appreciated if I can get some advise. Here is the problem in short. We do have 2 ...
0
votes
1answer
37 views

Can't install phpmyadmin for mariaDB [closed]

I want to install phpmyadmin on my server using mariaDB. I'm on Ubuntu 16.04 LTS, Nginx and I installed php7. I followed this tutorial to install all. But when I want to install phpmyadmin I have ...
0
votes
0answers
3 views

'garb' demoted SYNCED->PRIMARY due to gap in history

I'm running a Galera cluster with 3 actual servers and 2 garbd instances (arbitrators). The 2 arbitrators and one of the servers are running in the same data center, to ensure there's always quorum ...
0
votes
1answer
16 views

MariaDB won't start after server lost power at datacenter

CentOS Linux 7.2.1511 MariaDB version 10.1.14 Server was running fine, there was a power failure at the datacenter. When the server came back up everything is working fine, however MariaDB won't ...
0
votes
1answer
49 views

Can't figure out how to automatically set MariaDB root password without user intervention

I'm making a script that installs MariaDB, and I'd like to set a root password. I've got the following in said script: DEBIAN_FRONTEND=noninteractive echo mariadb-server-10.0 mariadb-server-10.0/...
0
votes
1answer
38 views

move mariaDb database to home folder

after install I'm trying to move the database location On fedora: # su # systemtcl stop mariadb # cp -rp /var/lib/mysql /home # chown mysql.mysql /home/mysql Next i'm editing the file /etc/my.cnf....
0
votes
1answer
18 views

Setting group_concat_max_len in Sphinx config is not being applied

I ran into a problem whereby our Sphinx SQL queries are getting truncated. This was due to the default limit for the Group Concat function in MySQL being 1024 bytes. I used the following in my ...
1
vote
0answers
25 views

How to troubleshoot a MySQL / MariaDB error

I've imported two Wordpress databases to a system (CentOS7), and I did not have any problems. When I try to import an .sql file (obtained with mysqldump command) for a vBulleting forum (the newest ...
0
votes
0answers
34 views

Rancher usage of mariadb galera cluster

I was deploying mariadb galera cluster at ranhcer environment and have a problem of node hosts: 6/3/2016 7:11:39 PM160603 15:11:39 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-...
0
votes
1answer
67 views

Replacing mysql with MariaDB

phpMyAdmin shows this version ! I am new to Linux and servers. I was using mysql 5.5 (was installed using third party repositories) as my DBMS and then I decided to replace it with the latest version ...
0
votes
0answers
9 views

Unable to connect to locally ran SQL DB in Docker Container

I have a mariadb (mysql) running in a docker container with a test db, table and dummy data. I very it's running with docker exec fcd12bf1da81 /etc/init.d/mysql status and it outputs the uptime, ...
0
votes
1answer
18 views

Insert multiple sql files

I've 297 sql files, I want import them to mysql but it must be in different databases. I tried: find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u <db_user> -p --batch -D <...
1
vote
0answers
53 views

MariaDB ignores root password completely

I just installed MariaDB (mysqld) on a fresh Ubuntu downloaded yesterday. Then I ran the script /usr/bin/mysql_secure_installation and set new root password and disabled passwordless login. However ...
0
votes
0answers
71 views

MariaDB 10.1.x Online DDL spaming error log files

Since our upgrade to a new mariadb/mysql version (previously the 10.0.x branch) we have tons of this messages in our error log. All of them are a type [note] messages but i cannot find any ...
0
votes
1answer
23 views

MySQL processes gets killed after 900 seconds

I hope this is the right place to ask.. I am facing a strange issue where the connection to the mariadb server gets terminated after a certain time. Like I am trying to connect to the mariadb server ...
0
votes
1answer
122 views

ownCloud Unable to Connect to Local Database on Fedora 23 (LEMP stack, selinux permissive)

The Problem I am having a very strange issue where ownCloud seems unable to access my SQL database, using nginx, mariadb, and php-fpm running on Fedora 23. When I attempt to access the page, I get ...
0
votes
2answers
24 views

MariaDB taking ages to restore backup

So I did a mysqldump of a pretty huge db and I'm trying to restore it now using: mysql db_test < db_test.sql but it looks like it's not gonna end by the end of this year. It's been about an hour ...
0
votes
1answer
313 views

How to install mariadb on amazon linux

I referred to the link https://blog.adminfactory.net/mariadb-and-galera-on-aws-amazon-linux.html to install the mariadb on my amazon linux, since I did not find any other resource related to amazon ...
1
vote
1answer
150 views

MySQL root password not working as expected

I am running MariaDB 10.0.24 on Ubuntu 16.04. I installed it via the xenial repo apt-get install mariadb-server. The root password doesn't seem to be working properly. I ran through these steps to ...
1
vote
0answers
27 views

Configuring a corosync as a witness server

Is it possible to add a witness node to a corosync cluster The cluster is running a 3 node setup: 2 applications server running MariaDB with Galera cluster. 1 "witness" server running Galera ...
0
votes
1answer
136 views

Can't mysql_secure_installation a fresh MariaDB on fresh Ubuntu 16.04 LTS

I am trying to run mysql_secure_installation on a fresh install of MariaDB on a fresh Ubuntu 16.04 LTS server. I installed via the exact instructions found here. When prompted for Remove anonymous ...
0
votes
2answers
52 views

MariaDB dying regularly

I've recently switched from MySQL do MariaDB to host WP website. Everything was smooth and I even noticed speed increase (which might be just placebo ;). From then on though MariaDB started dying ...
1
vote
2answers
788 views

Failed to start MariaDB database server

Since / partition is only 50G, and my data is larger than that. And there are 500G space in /home. So, I move all the data of MySQL into /home. The following are my steps(under root account): shout ...
0
votes
0answers
78 views

Connecting to a MariaDB server with master-master replication setup hangs randomly

I have a two server MariaDB master-master setup as documented on the DigitalOcean community page: https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication. The ...
0
votes
0answers
68 views

Why does MariaDB hang on shutdown on CentOS 7?

I installed MariaDB 5.5 using the CentOS 7 packages (yum install mariadb mariadb-server). The server starts up OK and seems to work fine, but it won't shut down properly. Every time I do systemctl ...
0
votes
0answers
25 views

Mariadb table .ibd file very large

We run a WordPress 4.4.2 website using Mariadb per table indexing. The wp_options.ibd file is almost 7GB in size when there are less than 6K records in the table. phpMyAdmin reports the table size as ...
-2
votes
1answer
35 views

Running on two servers vs. one with more memory? [duplicate]

I currently have one small VPS which I am using to host a Wordpress site (Nginx,PHP5,MariaDB). I have started to run into some memory issues (DB crashes) indicating it's probably time to move to a ...
0
votes
0answers
110 views

Reload not restart of Mariadb on CentOS 7

Hallo I'm having MariaDB 10 installed on a CentOS 7 and I'm looking for a way to reload a tweaked server.cnf. I'm not looking for a restart as I'm having a script running that takes over a month to ...
1
vote
3answers
139 views

SELinux blocks nrpe access to MariaDB

I have a few virtual machines in the same LAN monitored by Icinga2 via NRPE. [Machine A] CentOS 6 Icinga2. [Machine B] CentOS 6 MariaDB v10.1.12 properly running Datadir and socket settings ...
0
votes
0answers
11 views

mySQL/mariaDB stops to work when CIFS mount is broken

A few weeks ago I switched from CentOS 5.7 to the new installation with 7.1. The system have two functions: apache|php|mysql webpage for our local database gate that allows to use windows exports (...
0
votes
1answer
317 views

How to install MariaDB on Redhat Enterprise Linux?

I'm trying to install MariaDB on Red Hat Enterprise Linux in my AWS account. It's failing below when I do a sudo yum -y install mariadb-server. How can I get the libsystemd library that it requires? $...
0
votes
1answer
107 views

Couldn't join MariaDB Galera Cluster node back to cluster after software update. wsrep_* options in my.cnf seem to be ignored

I've had run a Galera Cluster for a while, MariaDB version 10.0.20, Galera version 25.3.10, everything over Gentoo. That cluster worked fine, nodes restarted several times for maintenance and so on. ...
1
vote
1answer
89 views

MySQL (MariaDB) crashing

Good morning - I have reviewed a previous post regarding changing the performance schema to "Off in the configuration settings. It looks as though our configuration is already set to this. So not sure ...
0
votes
0answers
14 views

MariaDb hangs on insert from SELECT with subquery

I have the following query: INSERT INTO lists (list, entity_id) SELECT '13633' list, entity_id FROM ( SELECT must1_entity.id entity_id FROM entity must1_entity WHERE must1_entity....
0
votes
1answer
32 views

systemd seems to ignore my “User=” and “Group=” setting

I'm running mariadb as a different user than the standard mysql. To this end, I've updated the service file and replaced User=mysql Group=mysql with User=someuser Group=somegroup This used to ...
0
votes
1answer
153 views

Auto-start MariaDB using systemd after it has crashed

I am trying to set up MariaDB in a way that it automatically recovers -- basically restarts, from a crash. Based on this article -- scroll down to Auto-starting Services with systemd, I opened /etc/...
0
votes
0answers
18 views

MariaDB replication- slave with high loadavg

We recently set a master-slave replication with MariaDB 10.1.12 on RedHat 6.7 fully patched. Master and slave are powerful Dell R730 with 2 RAID arrays- 1) 2 x 15k SAS drives for OS in RAID1 2) 4 x ...
0
votes
0answers
58 views

Cannot get MariaDB running after migration from MySQL

For hours I have tried all the things in the book with no success. All the solutions seems to involve magic like rebooting or apt-get purge everything related to MariaDB and MySQL and started all over ...
1
vote
0answers
17 views

MariaDB on Amazon RDS - Initial setup user grants and permissions

I'm trying to learn more AWS, and have an EC2 setup and an RDS setup running MariaDB. When I created the RDS instance, it asked for user/pass for the initial user, and created 'rdsadmin'@'localhost' ...
-2
votes
2answers
139 views

MySQL does not start anymore [closed]

unfortunately I am unable to start mysql after reboot: root@server:/etc/mysql# systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon   Loaded: loaded ...
-1
votes
1answer
111 views

MariaDB always show SSL not in use when I start mysqld with --ssl

CentOS 7.2.1511 Linux 3.10.0-123.9.3.el7.x86_64 MariaDB: 10.1.11 /etc/my.cnf # # This group is read both both by the client and the server # use it for options that affect everything # [client-...
0
votes
0answers
13 views

MariaDB audit log empty host

I'm running MariaDB 10.0.23 with the audit plugin logging CONNECT type. The audit log is showing a failed connect with error 1042. Does the host field not show the IP address when a host cannot be ...
1
vote
0answers
81 views

I am getting following error while restarting MariaDBgallera cluster''WSREP has not yet prepared node for application use''

I am running MariaDB Gallera 10.0 in Ubuntu 14.04 Server with 3 node, While Data inserting happening in the server if I restart the mysql server in any of the 3 nodes I am Unable to bring back the ...
0
votes
1answer
72 views

MariaDB refuse to start after VServer reboot

After I rebooted my VServer, MariaDB refuses to start. This are the error messages: # systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: ...
0
votes
0answers
40 views

Mysql and user xfs quota and shared hosting enviroment

I spend to much on reading all over the internet of different methods about this but i solved on my way. Actually i use per user chroot environment and use make xfs project quota on user root. /...
0
votes
0answers
44 views

Unknown storage engine 'AriaDB'

I had MySQL running on Ubuntu 14.04.3 LTS and then upgraded to MariaDB 5.5 with sudo apt-get install mariadb-server. Everything seemed good except I couldn't use AriaDB, so I decided to install ...
1
vote
0answers
27 views

RTC/UTC was innacurate on MySQL (MariaDB) server. I fixed it - was that bad?

I'm pinch hitting as an admittedly green server admin. I installed a bunch of security patches on a MariaDB server that had an incorrectly configured repo (not by me) and wasn't getting patches for a ...
0
votes
0answers
28 views

Database Server froze - High IO - how do I find out whats the reason? (Pics)

got a db server(KVM) running mariadb 10.1, runs fine since months, only servers 2 databases (drupal). Last night it went tits up. Here 2 screenshots from zabbix I checked the logs, they show ...
0
votes
0answers
35 views

Scaling and HA LEMP coming from a single server setup

here is the current configuration 1 Server: nginx php-fpm memcached mariadb 10 The project is growing fast and in the midterm we need to scale. When I have to setup multiple machines I want to ...