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

learn more… | top users | synonyms

3
votes
1answer
439 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 ...
1
vote
1answer
39 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
525 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
270 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
29 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
89 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
109 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
27 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
39 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
63 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
282 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
262 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
84 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
161 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
493 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 ...
0
votes
1answer
313 views

Fedora 20, How to add MariaDB TokuDB engine

I was able to install MariaDB using this command: sudo yum install mariadb-server mariadb-client And it is working fine, but i am unable to install TokuDB engine as plugin. I have tried this: sudo ...
0
votes
1answer
646 views

Installing MariaDB along with MySQL: Could not find mysqld (Cent OS 6.4)

I am following the instruction on the MariaDB site here all is fine until I get to the part shown below. [root@squir scripts]# mysql_install_db --defaults-file=/mariadb/data/my.cnf FATAL ERROR: ...
0
votes
1answer
193 views

MySQL and MariaDB replication

Did anyone configure the replication from mysql to mariadb if yes can let me know how he did it thx in advance. My problem occurred after getting replication to start and the error is saying Error ...
0
votes
1answer
403 views

MariaDB installation failed in fedora17,No more mirrors to try

Iam trying to install mariadb in fedora17 using the following link : https://kb.askmonty.org/en/installing-mariadb-with-yum/#manually-importing-the-mariadb-signing-key It shows an error, there is ...
1
vote
0answers
27 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
0answers
220 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
93 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
124 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
459 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
102 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
24 views

Auditing connections using certificates

We would like to have clients connect using client certificates from a trusted (internal) issuer and then log which user connected. Unfortunately, the following limitations are preventing success: ...
1
vote
0answers
127 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
280 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
17 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
0answers
31 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
37 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
25 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
0answers
102 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
0answers
382 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
0answers
64 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
148 views

Fail to set up mariadb-galera cluster

I am trying to set up galera cluster in my VM cluster, however I can't seem to get the second node to connect to the first properly, this is my current configuration [mysqld] ...
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
86 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
219 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
105 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
140 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
191 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
992 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
184 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
166 views

Creating Table in mariaDB - ERROR 1429 (HY000)

I successfully integrated mariaDB-10.0.13 with Cassandra-2.0.8 and 2.0.9 I was able to created a table present in cassandra on mariaDB and was able to query successfully. But my problem is that ...
0
votes
0answers
87 views

How to make permission of mysql log file stick?

I am running a custom cron script to do log rotation and email newly compressed log files. Due to permission problems, I have to set the group user to root instead of the default mysql so that the ...
0
votes
0answers
170 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
31 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 ...