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

learn more… | top users | synonyms

3
votes
1answer
1k views

Failed at step EXEC spawning /usr/libexec/mariadb-prepare-db-dir

a bit of a newbie here so mind my obliviousness. I'm trying to install mariadb on a fresh Centos 7 server, though upon running "systemctl start mariadb.service" I get this malarkey: Job for ...
2
votes
0answers
105 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
5 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
11 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
29 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
24 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
35 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
135 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
195 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
237 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
156 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
183 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
365 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
33 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
34 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
15 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
40 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
8 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
7 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 ...
0
votes
0answers
15 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
38 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
11 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
20 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
19 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
27 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
20 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
22 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: ...
0
votes
0answers
31 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
21 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
82 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? ...
0
votes
0answers
62 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
67 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
31 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
43 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
89 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
102 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
56 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
43 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
61 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
47 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
28 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
147 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
435 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
678 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
182 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 ...
0
votes
0answers
374 views

MySQL unable to repair, dump, upgrade table (simply crashes)

I need to backup one of my databases from MySQL (Running MariaDB). The issue is that aside from all of my other databases that backup perfectly fine, this database has issues backing up and crashes ...
0
votes
0answers
2k views

Installing, configuring and running mariadb in foreground on Centos 7 via docker without systemd or services

Under CentOS 7, I understand we're moving from mysql-server to implementation-compatible MariaDB. I'm using a docker image of centos:latest, which puts me under the auspices of Centos 7. mysqld_safe ...
0
votes
0answers
245 views

MariaDB inside Ubuntu OpenVZ CT: Error on delete of '/tmp/#sql' (Errcode: 1 “Operation not permitted”)

I've installed MariaDB 10.0.12 on a fresh OpenVZ container: ubuntu-14.04-x86_64-minimal.tar.gz. Unfortunately when I browse tables via Adminer I keep getting errors like these: Error on delete of ...
0
votes
0answers
66 views

Mixing percona and mariadb in a galera cluster

Assuming both percona and mariadb runs the same engine (innoDB), can i use them interchangeably in a galera cluster? If it is possible, is there anything I should know before doing it?