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

learn more… | top users | synonyms

9
votes
3answers
631 views

Anyone used MySQL Forks in Production

Now that MySQL is owned by Oracle many are starting to consider using some of the popular forks such as MariaDB and Drizzle. Has anyone used these in production for any extended periods of time? If ...
9
votes
1answer
6k views

MariaDB vs Percona server - main differences?

I'm running Mysql in production today but are planning to switch to either MariaDB or Percona server when I move to new servers. The main reason for the switch is to distance us from Oracle, but also ...
8
votes
4answers
2k views

Has anyone migrated production machines from MySQL to MariaDB?

I'm running MySQL for most of our DBs right now, and would like to get off the Oracle ship before it takes more of a turn. My understanding is that the transition from MySQL->MariaDB should be ...
5
votes
2answers
1k views

MariaDB Cluster vs Percona Cluster for MySQL

What are the advantages and and disadvantages between the two? I've only been able to find information on these two implementations without any specifics on clusters. I'm currently implementing a ...
5
votes
1answer
4k views

Working Nginx fastcgi_cache php-fpm cache and static file caching configuration?

Nginx wiki is very vague with explanation as to how to properly setup nginx with php-fpm with fastcgi_caching for sites which have cookies i.e. wordpress, drupal, vbulletin etc. I downloaded a ...
3
votes
2answers
2k views

How to disable all MariaDB storage engine except MyISAM?

(in my.cnf) I've tried default-storage-engine = myisam, skip-innodb, and commented out every innodb features, but none of them works
2
votes
5answers
4k views

Fast Database to store 1 Billion records [closed]

I am writing a code to store data and want to store 1 Billion to 10 Billion records or even more. Most importantto this is speed (nearly 10000 - 20000 / records per second), SPACE usage and CRASH ...
2
votes
2answers
426 views

mytop: least privileges required to run it?

What is the minimum set of privileges that mytop requires in order to work, without actually requiring super-user privileges. I feel uncomfortable with the fact that I have to save the password in ...
2
votes
2answers
417 views

When - if at all - should I switch from MySQL to MariaDB?

Now that MySQL is owned by Oracle, the future of the RDBMS seems uncertain. The fork by the main developer of MySQL, Monty Widenius, called MariaDB, is a drop-in replacement for MySQL. Version numbers ...
2
votes
2answers
413 views

Ubuntu upgrade process failed

I tried to dist-upgrade my ubuntu server on my percona cluster but it failed with this message The following packages have unmet dependencies: libmysqlclient18 : Depends: libmariadbclient18 (= ...
2
votes
1answer
5k views

how to uninstall mariadb and re-install mysql ? Mysql install turns into mariadb install

I recently upgraded my centos system via the desktop. mistake! I had mariadb, phpmyadmin working just fine before - but after the upgrade they stopped. I frantically googled and tried to follow some ...
2
votes
3answers
63 views

HAProxy Only Sending Traffic To One Node

I have an HAProxy with IP 10.60.61.20 and three MariaDB nodes at IP .21, .22, .23, all of course in the same subnet. I have the MariaDB cluster sync'd and they can read/write to eachother, but when I ...
2
votes
1answer
105 views

Galera Cluster starting backup can't find innobackupex in the path

I am trying to get a Galera cluster running. I have the first node up and ready for connections. My second node, however, when trying to run wsrep_sst_xtrabackup gets the error "Can't find ...
1
vote
3answers
310 views

How to check if MySQL replication is using SSL

I have a MySQL (actually mariaDB) install that I just started replicating to another server. I want to ensure that I've setup SSL correctly. The SSL portion of SHOW SLAVE STATUS looks like: ...
1
vote
1answer
416 views

Deadlock trigger on MariaDB Galera cluster

I can trigger a deadlock on our (test) Galera cluster when updating a row with the same data. INSERT INTO test (id, val) VALUES (1, 42), (2, 47); -- Query OK, 2 rows affected (0.01 sec) -- Records: 2 ...
1
vote
1answer
2k views

MariaDB / MySQL using a lot of threads / memory

I've been setting up a new VPS and wanted to try out MariaDB. I'm using MariaDB 10.0.1, which as far as I understand it is the equivalent of MySQL 5.6. Has the thread handling of threads changed ...
1
vote
1answer
25 views

Get mysql to block all new connections but honor existing ones in preparation for being taken out of service

I'm looking for a way to get MySQL (actually MariaDB) to block all new connections but honor existing ones. I'd intend to put this restriction in place before taking the server down for maintenance. I ...
1
vote
1answer
158 views

MariaDB 10.0 slow work mysqldump

i have 1.800(innodb) DBs in my MariaDB 10.0, 'mysqldump' work very slowly! If i run 'mysqldump' starts the process: "SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE , EXTRA ...
1
vote
2answers
1k views

Uninstalling MySQL for MariaDB Replacement on cPanel

Well the first part of my day was spent researching how to remove MySQL to install MariaDB and the second part of my day was spent trying to reinstall MySQL cause something was messed up. So now I ...
1
vote
1answer
1k views

Problems with mysql-libs *after* installing MariaDB

I have installed MariaDB 5.3.3 on a Centos 6 server. In order to do that, I had to issue this command before installing the MariaDB-server rpm: rpm -e --nodeps mysql-libs And now mariadb and all ...
1
vote
1answer
400 views

Can't login to remote MariaDB server with phpMyAdmin, but works in shell

I recently configured two servers. The first to use Apache and phpMyAdmin. On the other server I have a maria-DB server correctly configured. phpMyAdmin it's reading the config file, but I can't ...
1
vote
1answer
531 views

MariaDB / MySQL galera cluster nodes won't join

I'm setting up a MariaDB Galera cluster and I can’t seem to get the nodes to join each other. They both start up without errors but never seem to join, the status is always disconnected: MariaDB ...
1
vote
1answer
589 views

apt-get purge mariadb leaving traces which stop mysql install

I'm trying to bug test a database issue with a website I'm working on. I would like to see if switching between mariadb and MySQL fixes the issue (however unlikely that is). I thought this would be a ...
1
vote
2answers
1k views

Error message with phpmyadmin when starting up apache

I'm trying to get phpmyadmin working with mysql(mariadb fork). I get this error message in the browser when I try to access phpmyadmin: > phpMyAdmin - Error The mysqli extension is missing. ...
1
vote
1answer
191 views

MariaDB + PAM: Is Remote Auth Secure?

I have a MariaDB instance which is using PAM to auth against Active Directory. Is remote authentication with this service secure? I ran a Wireshark trace during the auth process, and passwords are not ...
1
vote
1answer
325 views

Can't set binlog_format for MariaDB

I have MariaDB running on my dev server (no replication or anything else) running version 5.3.5. It's an Ubuntu 10.04 server running all the latest patches and updates. I am having issued getting ...
1
vote
1answer
719 views

Problem with mysql (mariadb) crash

An hour ago I noticed that the mysql (mariadb 5.2.5) server is not running on my debian VPS. So I immediately ran "/etc/init.d/mysql restart" and it started just fine. Here's what the daemon log says ...
1
vote
1answer
83 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 ...
1
vote
0answers
43 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
1answer
300 views

MariaDB replication not auto reconnecting

I've got a simple master-slave replication setup amongst two MariaDB 5.5 servers. The connection between the servers is somewhat flaky, causing disconnections every now and then. However ...
1
vote
1answer
162 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 ...
1
vote
4answers
1k views

Upgrading from MySQL Server to MariaDB

I've heard that MariaDB has better performance than MySQL-Server. I'm running software that makes an intensive use of MySQL, thats why I want to try upgrading to MariaDB. Please tell me your ...
0
votes
1answer
35 views

HAProxy's Flooding MySQL Connections

I have a setup of 2 HAProxy servers using the KeepAlived process for failover, and each HAProxy is configured to load balance mysql connections to my MariaDB Galera cluster of 3 nodes. I'm trying to ...
0
votes
1answer
285 views

can't connect to mysql with a host

I have mariadb installed and running. I can connect to it with this: mysql -u dev -p or mysql -h localhost -u dev -p but I can't connect to it using mysql -h 127.0.0.1 -u dev -p It asks me ...
0
votes
2answers
248 views

Dedicate more cpu usage to apache and modules

I'm currently trying to process a bunch of data with apache and php, I estimate it will take a few hours and I'd like to reduce that time In my webmin I see following information CPU usage 25% ...
0
votes
1answer
39 views

MariaDB, Galera, xtrabackup - do I need the binary log?

We are using a MariaDB Galera Cluster with 3 nodes. For the state transfer we are using xtrabackup. We have some problems with the binary logs - they got too big and crashed the server. We can ...
0
votes
1answer
96 views

MariaDB 5.5 and Ubuntu 13.10 -> 14.04 upgrade

I have installed MariaDB (5.5.37+maria-1~saucy) on Ubuntu Server 13.10. Then I have upgraded Ubuntu to 14.04 LTS. Upgrade process has disabled repository for MariaDB 5.5. Current part of sources.list ...
0
votes
2answers
109 views

MariaDB Permission denied when using socket

Here is the gist of my problem: I have a web application that won't connect when the database has the host is set as localhost, however it will if I use the address 127.0.0.1. The error that PHP ...
0
votes
3answers
2k views

Trying to install PHP MySQL driver with MariaDB already installed

I have a VPS which came from an image called CentOS 6.4 x64,Nginx,php-fpm,MariaDB. PHP and MariaDB are both installed, but it seems that PHP does not have the MySQL driver installed. I first tried ...
0
votes
1answer
134 views

MariaDB doesn't upgrade, 2 versions are installed

I have a server running on Debian wheezy with MaraiDB and OwnCloud. Few days ago, I wanted to update the packages because of the OwnCloud updates but something went wrong. Usually in this case I'd ...
0
votes
1answer
210 views

PHP loosing connection to MariaDB server each 3 hours

I found my PHP 5.4.20 (from remi repo) on CentOS 6.4 64-bit is loosing connection to my MariaDB 10.0.4 server each 3 hours. I use mysqlclient18 5.5.28 from atomic repo as mysql library. MariaDB ...
0
votes
1answer
436 views

Cannot stop MariaDB on Ubuntu Lucid

On starting MariaDB 5.5 I am getting the following error: InnoDB: Unable to lock /var/lib/mysql/ibdata1 Initially ran into this error after a server reboot was done running MariaDB 5.1. Have ...
0
votes
3answers
926 views

MariaDB Galera Cluster

I ma trying setup MariaDB in cluster but looks like I stuck on this error: #mysqld -u mysql 130407 21:36:24 InnoDB: The InnoDB memory heap is disabled 130407 21:36:24 InnoDB: Mutexes and rw_locks use ...
0
votes
1answer
335 views

Error when install Wordpress with mariadb “Your PHP installation appears to be missing the MySQL extension which is required by WordPress.”

rpm -e --nodeps mysql-libs yum install MariaDB-server The above command helped me to install mariadb, also installed Wordpress. This was a great help. My problem now is when I reboot the server or ...
0
votes
0answers
5 views

WNMP issue when starting MariaDB [on hold]

I've just installed WNMP for Windows (as a replacement to XAMPP) and I'm having an issue. Using the WNMP control panel, I've managed to start NGINX & PHP but am unable to start MariaDB. I've ...
0
votes
1answer
15 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
0answers
16 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
39 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 ...
0
votes
1answer
25 views

disk full because of tmpdir, safe to restart?

My disk is full, an .MAD file in tmpdir takes up all the space on the file system (179G out of 189G) from log: [Warning] mysqld: Disk is full writing '/var/tmp/#sql_b6f_0.MAD' (Errcode: 28). Waiting ...
0
votes
0answers
119 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 ...