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

learn more… | top users | synonyms

0
votes
1answer
12 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
19 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
22 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
64 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
7 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
15 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
43 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
56 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
21 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
89 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
19 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
193 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
139 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
19 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
102 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
50 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
449 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
74 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
54 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
21 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
91 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
112 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
243 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
83 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
72 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
10 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
27 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
128 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
17 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
55 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
14 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
114 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
87 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
12 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
58 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
57 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
34 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
34 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
31 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 ...
0
votes
1answer
79 views

WSREP: Bad value for 'socket.ssl_key'

I am attempting to initialize a new MariaDB Galera cluster with SSL-encrypted replication. I have followed this guide to the letter, specified different details for CA, Server, and Client ...
1
vote
1answer
152 views

Galera Rsync SST Secured via SSL/SSH

Is it possible to secure Galera Cluster SST via rsync with SSL/SSH? This page suggests it is not, specifically the following quote: Unlike rsync, xtrabackup includes support for SSL encryption ...
0
votes
1answer
124 views

GTID have been turned off But I have error in replication

I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
4
votes
1answer
252 views

Galera cluster (MariaDB) on Docker/CoreOS: second node doesn't work on first attempt

I'm trying to create an automatic deployment of Galera Cluster with MariaDB, running inside Docker containers on CoreOS. Software used: - MariaDB official Docker image, version 10.1.10 - CoreOS 899.5....
0
votes
0answers
28 views

Debian Mysql 5.6 and MariaDB Instances on Same Server

I'm trying to have Mysql 5.6 and MariaDB to make comparison and track performance between each other. Everything i have found over the internet was this link: https://mariadb.com/kb/en/mariadb/...
0
votes
0answers
39 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...