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

learn more… | top users | synonyms

2
votes
0answers
126 views

MariaDB crashed and now won't start

While activating a wordpress plugin MariaDB crashed on me, and it won't restart. I am using Centos 7.1. systemctl status: systemctl status mariadb.service mariadb.service - MariaDB database server ...
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 ...
1
vote
0answers
42 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 ...
1
vote
0answers
18 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 ...
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' ...
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 ...
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 ...
1
vote
0answers
43 views

Scaling Mariadb Galera Cluster

I have installed MariaDB Galera Cluster on ubuntu 14 and it is working fine. See the tutorial I have 3 nodes (each 500GB HDD capacity) mariadb cluster and all replications are working perfect. My ...
1
vote
0answers
143 views

MySQL encryption at rest

Context: Rackspace CloudServers. The options I can find are rather slim. Amazon will encrypt the whole disk (meh), Gazzang could encrypt a virtual partition with just the DB files on it (if the ...
1
vote
0answers
210 views

MariaDB 5.5 on Slackware 14 need to change to new password format

Strangely, this worked fine for a while, but my computer rebooted recently and now my php apps won't work: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an ...
1
vote
0answers
249 views

Mysql table doesnt exist error after trying run from lvm snapshot

I'm trying to set up mysql replication by making lvm snapshot of master datadir and copying it to slave. The procedure is quite simple, on master server I execute "FLUSH TABLES WITH READ LOCK" and on ...
1
vote
0answers
168 views

apache php-fpm - max_children reached -> server unresponsive until php-fpm restart

One of our servers with a very special setting is very sensitivee to an unknown event. Hardware: Xen - VM 22 Cores (build with Intel xeon 4*6 Core) raid 6 SSD 60 GB RAM Configuration: Suse ...
1
vote
0answers
189 views

mariadb 5.5.36 with innodb plugin

I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to ...
1
vote
0answers
376 views

Bootstrapping Galera Cluster

We would like to use a MariaDB Galera cluster for our project. The Galera cluster works and seems to work fine. If some nodes of cluster are down the cluster continues to work. But after a complete ...
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
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
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
0answers
73 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
53 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
20 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 ...
0
votes
0answers
89 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 ...
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
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
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 ...
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 ...
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 ...
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
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 ...
0
votes
0answers
24 views

Maria db Optimization and performance

I have a dedicated server comes with 8 x 3.3GHz cores, 16GB memory DDR3, CENTOS 6.7 64 bits, Apache 2.2.9, PHP 5.6, im running a php applications that needs a lot of connections with maria db version ...
0
votes
0answers
112 views

8 minute timeout delay in starting MariaDB with galera turned on

I'm just trying to get one node up for testing, and at first I thought it wasn't working at all, until I left the terminal running for a bit. See the 8 min timeout in the middle of the logs? galera....
0
votes
0answers
89 views

trouble setting up pt-heartbeat (percona toolkit) for mysql/mariaDB replication

I'm facing some problems with pt-heartbeat (from percona toolkit) in order to observe MariaDB replication. I have one master instance with IP 172.17.0.3 and server-id = 1 I have one slave instance ...
0
votes
0answers
89 views

MariaDB keeps restarting

since yesterday I noticed a strange behavior on my machine. I have a backup script to backup sql and files. I noticed that the archive files are much smaller and corrupted. I analized the logs and I ...
0
votes
0answers
23 views

Way to know what source is reading the most from MySQL Server(RDS)?

I have a mysql server which is registering very large bandwidth usage. I want to know what options I have for: Knowing what source is using the MySQL server most. (server ip?) What tables or queries ...
0
votes
0answers
33 views

Migrating MySQL 5.1 to MariaDB 10

I plan on migrating my data from MySQL 5.1 to MariaDB 10. At the same time I will be upgrading hardware so I will have a completely new server. Is it possible to simply mysqldump from MySQL 5.1 and ...
0
votes
0answers
48 views

Galera Cluster: system requirements for an Arbitrator?

I'm planning the deployment of a Drupal website running on Linux (CentOS 7) and Nginx in IaaS. I will be using two nodes for HA, and each will offer the exact same services (Nginx, PHP, Redis, ...
0
votes
0answers
97 views

user and file permission issues while installing mariadb on ubuntu

I was following the installation instructions of mariadb: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | ...
0
votes
0answers
114 views

InnoDB settings - mysql tuner results after running for awhile

Newbie as far as InnoDB goes, but I installed MySQLTuner awhile back and according to this it looks like I need to adjust my settings, but can someone chime in with some deeper understanding of all ...
0
votes
0answers
64 views

'/var/lib/mysql/mysql.sock' (2) Issue with apache remotely connecting to mysql

Every now and then, I will get this issue where my Apache server cannot connect to my mariadb server remotely. It seems to occur at least once a month and I can't pinpoint the problem. It does however ...
0
votes
0answers
51 views

Apache / mariadb out of memory

I've been struggling for a few weeks now trying to find the cause of why mariadb shuts down due to 'out of memory'. The server is a CentOS7 running Apache 2.4 and Mariadb 5.5 with 8GB of memory. When ...
0
votes
0answers
73 views

Adding to tar archive /var/lib/mysql is it enough for backup restore task?

In every docker project, I have a backup.sh and restore.sh file I want to find a good way for backing up and restoring mysql backup using only ./restore.sh ${timestamp} My backup.sh look like ...
0
votes
0answers
61 views

Need to do partial restore from a full xtrabackup

I'm using percona xtrabackup to do full DB backups on mariadb 10 and now i'm testing the restore. I want to restore just some databases (the important DBs) and ignore others (big archive DBs), ...
0
votes
0answers
36 views

MySQL mysqld error --wait_timeout requires an argument

I simply wanted to restart my MySQL server (MariaDB) and it failed. It runs on Ubuntu 14.04. So I went to the error log and saw this: [ERROR] /usr/sbin/mysqld: option '--wait_timeout' requires an ...
0
votes
0answers
177 views

High memory usage on server after upgrading from MySQL to MariaDB

I recently upgraded from MySQL 5.5 to MariaDB 10.0. After upgrading, rebuilding Apache & PHP, I noticed that memory usage went up by around 200+ MB. I have a VPS of 2 GB available. Before the ...
0
votes
0answers
461 views

Unable to install MariaDB on CentOS 6

I am trying to install MariaDB on CentOS6. I have added repo file as per the instruction from Mariadb official webstite. [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/5.5/centos6-amd64 ...
0
votes
0answers
776 views

Mariadb galera node error when joinning cluster

I am getting these errors when trying to join nodes to a master. Ubuntu 14.04 MariaDb Galera 5.5.42. I had this problem with rsync as well. No iptables rules blocking connections. Any help would be ...
0
votes
0answers
189 views

Direct server return loadbalancer for mariadb galera cluster with 2 networks

Is it possible to configure LVS (keepalived) loadbalancer with direct server return (DSR) for 2 leg network setup? The desired architecture is as follows: mariadb galera cluster, where each node has ...