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

learn more… | top users | synonyms

3
votes
1answer
530 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
1answer
239 views

MariaDB Galera Cluster falls out of sync easily

We're trying to debug an issue with a MariaDB cluster. We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty). There are three machines clustered together, ...
1
vote
1answer
35 views

Galera bootstrap fails without errors

I've been pulling my hair out all weekend trying to get a Galera cluster up and running, using MariaDB 10.1.5 (which includes Galera 25.3.9) on CentOS 7. This server runs two database instances, one ...
1
vote
1answer
43 views

MariaDb and Httpd getting killed due to memory

I have a Centos7 VPS on OVH with this settings: 1Virtual Core 1 GB Ram 10 GB Raid 10 I have running on it 3 wordpresses. One of them is still on building (0 access to public), other has very few ...
1
vote
1answer
48 views

MariaDB Replication server disk usage drop

I have a MariaDB master-slave setup on 2 CentOS 7.0 servers. Today, I extended a LVM volume on the master server (because it was getting full). After extending the partition, I rebooted the server and ...
1
vote
1answer
32 views

Auditing connections using certificates

We would like to have clients connect to our MariaDB server, using client certificates from a trusted (internal) issuer and then log which user connected. Unfortunately, the following limitations are ...
1
vote
1answer
572 views

Mysql through ssh often can't connect or timeout

I have a MariaDB server (10.0.12) on a machine (Ubuntu 14.04) that other servers connect to through ssh for security purpose. The ssh tunnel is openned via autossh like so: autossh -M 3306 -f -Ng ...
1
vote
1answer
287 views

MySQL Password Authentication with Proxy Users and Group Mapping

I'm actually using MariaDB here, but I'm working under the pretext that MariaDB is a "drop in replacement" for MySQL. I won't be surprised if this winds up being a cross platform difference/issue, but ...
0
votes
1answer
20 views

Sharing developing site on VM with 3rd computer within local network

I'm trying to figure out the correct url I should type to show my subsite1 by browsing through an inner network computer. The only site I've been able to view was the mainsite. I don't really ...
0
votes
1answer
29 views

MariaDB auto-increment-increment having no effect

I am trying to set up a master-master MySQL replication (both active servers). As I'm doing this on Centos 7, I have to use MariaDB instead of MySQL, although it seems fairly similar. So, before I ...
0
votes
1answer
108 views

Galera new cluster WSREP Unknown error 141

I am trying to create a new Galera cluster in the cloud using Ansible (DevOps tool). I can get the cluster started by issuing commands from an SSH shell, but not from Ansible. I have simplified the ...
0
votes
1answer
87 views

Freeradius/MySQL server not responding to external calls

I'm currently building up a (CentOS 7) freeradius with MySQL(mariadb) for radius authentication. I'm able to receive auth from local host testing using radtest. Once I use NTRadPing with the same ...
0
votes
1answer
42 views

Remote MariaDB Server - Slow response

I have a website with a lot of traffic. The website is running a forum with around 1000-1500 users online. The load of the current server is at around 4.0, which is about fine, but I want to host the ...
0
votes
1answer
84 views

MariaDB Galera Deployment

I am looking to experiment with MariaDB 10 Galera Cluster. I am looking for highly available, scalable and reliable architecture. Basically I am curious what would be the better architecture and would ...
0
votes
1answer
199 views

Maria db wont start | Failed to get D-Bus connection

I try to start my mariadb but I am failing to start the maria db and I dont have any clue why.. I am running centos 7 with mariadb. It doenst start when I reboot, also when I use the cli to start it ...
0
votes
1answer
185 views

Deploy MySQL/MariaDB on demand in a C# application

I'm creating a lightweight bug tracker, and I'm really having difficulties with people that don't know how to deploy and connect to a MySQL database on their own. What they should do is to create ...
0
votes
1answer
32 views

Trying to upgrade MariaDB server

I'm running Ubuntu 14.04trusty with MariaDB server 5.5.41 and would like to upgrade to version 10. I shutdown and uninstalled 5.5.41 per instructions, ran the updates, and apt-get and got the ...
0
votes
1answer
173 views

Vagrant and MariaDB (provision)

I'm trying to create a provision file that installs MariaDB but it keeps failing. The provision looks like this: sudo apt-get install -y software-properties-common sudo apt-key adv --recv-keys ...
0
votes
1answer
435 views

MariaDB crashing with “Assertion failure in thread xxx in file rem0rec.cc line 580”

I have three MariaDB servers set up in a Galera cluster. I use one server at a time as a "primary" master (i.e., Galera is just for failover, the app doesn't actively use multiple masters). About ...
0
votes
1answer
52 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...
0
votes
1answer
83 views

localhost != localhost for MySQL/PHP

System: Mac OS X Server 10.6.latest I just switched from the ancient MySQL (<5?) that came with Mac OS X Server to MariaDB 10.1, installed via MacPorts. (That was a whole 'nuther barrel of fun...) ...
0
votes
1answer
379 views

MariaDB Galera SST Fails

I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs: 150212 ...
0
votes
1answer
305 views

CentOS 7 and MariaDB issue

I have recently moved to DigitalOcean, and installed Centos7 along with its default MysQl server (MariaDB). But I am facing since first install. MySql is exiting down spontaneously and there is no ...
0
votes
1answer
2k views

yum dependancy error - looking for the wrong version of php-mysql

So I was trying to upgrade from MariaDB 5.5 to 10.0. (which is essentially MySQL fork) The installation instructions say to yum remove mariadb-server mariadb-common mariadb-compat then re-install ...
0
votes
1answer
104 views

Debian autostart MariaDB Galera cluster

I have a MariaDB Galera cluster with two nodes. I have got it up and running fine, however the first node in the cluster needs to be started with: sudo service mysql start --wsrep-new-cluster I am ...
0
votes
1answer
191 views

Can I do zero downtime MySQL replication if I have archive tables present?

I've read the question and answers at How to setup MySQL replication with minimal downtime. It looks like I can get a slave DB into sync without down time if I am using only Innodb tables. My ...
0
votes
1answer
497 views

Setting Up Replication/master slave configuration to mariaDB

I'm starting my project using mariaDB I want to setup master slave configurations on windows 7 64Bit. I don't know how to setup this kind of configuration. I've searched on google, visited ...
1
vote
0answers
274 views

error creating database using ansible on centos 7

I am trying to install mysql AND setup database using ANSIBLE on CentOS7(i have no idea why every documention in the world now ONLY talks about Ubuntu and NO CentOS anymore...really SAD!) here is my ...
1
vote
0answers
112 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
138 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
510 views

Installing MariaDB + Galera via yum fails with “No package MariaDB-Galera-server available”

I'm spun up a brand new Cento OS 7 virtual machine and I'm following this tutorial to install a MariaDB + Galera cluster. I've added the MariaDB repos as follows: vi /etc/yum.repos.d/MariaDB.repo ...
1
vote
0answers
113 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
137 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
303 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
11 views

How to backup MySQL (MariaDB) database on dedicated servers to AWS (S3 Object Storage?)

We have a 180GB dedicated production server, which we currently backup daily using Percona xtrabackup to a backup server in our rack. We're looking at moving our backups (not the database itself) to ...
0
votes
0answers
41 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
100 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
131 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
72 views

Lot's of dealocks since migrating to galera cluster

I recently migrated from a 1 node MySQL server, to a 2 nodes mariadb Galera cluster. (I know, 2 nodes is not recommended). At first, I enabled writes to both of the nodes, but realized it increased ...
0
votes
0answers
29 views

Why has MariaDB created database directories with @ in?

A backup script on a Debian server looked at /var/lib/mysql/*/ to find local database names. Having recently installed Seafile, this no longer works because although the databases are called normal ...
0
votes
0answers
112 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
257 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
120 views

Running MariaDB Galera (5.5) Cluster on Debian failing to start

I am struggling to get a MariaDB Galera cluster running on my Debian 7 machine. I am trying to setup a cluster with two nodes both running on Debian 7. When I first install Galera I can run it find. ...
0
votes
0answers
164 views

MariaDB, ARIA, “File size bigger than expected”

On (only) my production server, whenever I wait a while and restart MariaDB, it completely crashes and burns, e.g.: 141110 16:18:26 [Note] /usr/sbin/mysqld: Shutdown complete 141110 16:18:26 [ERROR] ...
0
votes
0answers
219 views

MariaDB Multimaster replication and AWS Auto Scaling Group

One of the things I hate most about RDBMS is that it can't sit on an ASG like the web servers and bounce it around and scale it up and down like a yoyo. Or can it? Recently looking at MariaDB galera ...
0
votes
0answers
1k 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
220 views

MariaDB mysqldump fails on tables with underscores

mysqldump -u root -pvagrant --skip-lock-tables --no-data databasename is giving me this: mysqldump: Couldn't execute 'show table status like 'view\_admin\_mu\_list\_view'': SELECT command denied to ...
0
votes
0answers
183 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
60 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?
0
votes
0answers
33 views

installing php & nginx without mysql?

I'm setting up some servers on digitalocean's cloud hosting. I have mariadb installed on its own server, and I am now setting up the nginx/php server for files. Is it necessary to install ...