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

learn more… | top users | synonyms

1
vote
2answers
36 views

Does a server use bandwidth when connecting to itself?

I have a dedicated server (CentOS 7) with Storm on Demand. I have a rails application running on the server served by nginx and unicorn. I'm using MariaDB on the same server. The rails app handles ...
1
vote
2answers
336 views

Query cache for MariaDB Galera cluster

I've read from multiple sources now that you can't have query caches with Galera, but my current application could really benefit from a query cache. I'm load-balancing this cluster with HAProxy and ...
0
votes
2answers
2k views

How to install MariaDB rpms in CentOS 6.4 using rpm (not yum cmd) + handling mysql-libs conflicts

I need to script the install of MariaDB using the rpm command in CentOS 6.4. I can't use yum since it's going to be an offline install so there's no access to the repository. The only MySQL package ...
0
votes
2answers
466 views

MariaDB set maximum database size to 1 GB

I'm using MariaDB on my hosting. I would like to limit database size to 1 GB. How to do this properly in /etc/my.cnf ?
0
votes
2answers
835 views

Changing Data directory in MariaDB

I have a doubt : Is mariadb support datadirectory location change from the default location to the another user defined location ? When Iam trying to change datadir location of mariadb by ...
3
votes
1answer
170 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
14 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
407 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
235 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
25 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
47 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
96 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
131 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
500 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
103 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
464 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
253 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
543 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
182 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
339 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
votes
1answer
99 views

Mysql MariaDB replication broken

I have a primary DB and two replicates. replicate1 became corrupted when the linux server was rebooted without stopping mysqld. I want to load replicate1 with a dump I've taken from replicate2 with ...
-4
votes
1answer
116 views

How do I fix my PHP/MariaDB installations?

I ran the clear_iredmail script found here: http://www.iredmail.org/forum/topic333-iredmail-support-faq-how-to-uninstall-iredmail.html and accidentally deleted some important config files (and more) ...
1
vote
0answers
103 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
54 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
106 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
320 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
85 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
22 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
114 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
242 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
20 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
80 views

HAProxy but still single point of failure

I'm setting up a test cluster - Maria Galera Cluster on 3 physical nodes with HAProxy. Its working, but I've made some kind of beginner error which I can't seem to resolve - so hopefully someone can ...
0
votes
0answers
95 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
23 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
46 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
156 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
51 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
0answers
86 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
105 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
120 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
720 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
145 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
136 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
76 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
132 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
53 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
533 views

Either, nginx+php-fpm bad config or nginx+php-fpm cannot handle high query?

I have wordpress installed in my server configured(hopefully with nginx+php-fpm+mariaDB). I am trying to import using wordpress importer a 1.5MB xml file. Everytime I try to upload it using the ...
0
votes
0answers
2k views

MySQL (MariaDB) crashes frequently

I recently migrated an old server running MySQL to a new VPS running MariaDB 5.5. I don't have too much running on the server (just a few PHP sites) and free memory seems to be OK, but the DB keeps ...
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 ...