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

learn more… | top users | synonyms

25
votes
1answer
3k views

Is MariaDB a secure replacement for MySQL?

I've been using MariaDB, "an enhanced, drop-in replacement for MySQL" on my Debian stable servers for years, because of its increased performance. However I've noticed that it appears to lag with ...
9
votes
3answers
657 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
7k 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
3k 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 ...
6
votes
2answers
4k 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 ...
6
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 ...
5
votes
1answer
726 views

Can I copy the entire /var/lib/mysql folder to a different server? (mysql vs mariadb, different versions)

I used to have a Linux system (LMDE) with MySQL. The system used innodb_file_per_table for most of the databases. (not sure about the version, whatever is the "latest" in LMDE) I am now on a new ...
5
votes
2answers
15k 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 ...
4
votes
3answers
10k views

No mysqld or mysql.server after mariadb-server install

So... likely I'm an idiot, but I'm stuck. I just set up a CentOS 7 on Digial Ocean and I can't seem to get the MariaDB/MySQL server running. Some output [root@hostname ~]# yum list installed |grep ...
3
votes
2answers
3k views

Centos 7. Freeradius fails to start on boot due to priority

I was messing around with FreeRADIUS and MySQL (MariaDB) and it seems FreeRADIUS service can't start properly on startup. But it starts fine using root user or in debug mode (radiusd -X) and works ...
3
votes
3answers
1k views

Migrating 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 ...
3
votes
1answer
2k 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 ...
3
votes
1answer
250 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 ...
3
votes
2answers
3k 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
7k 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
616 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
2k views

Uninstalling MySQL for MariaDB Replacement on cPanel [on hold]

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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
3k 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 ...
2
votes
1answer
3k 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 ...
2
votes
2answers
447 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
1answer
45 views

Galera: Run slow ALTER without locking entire server

I have a 3-node galera cluster with a few hundred databases servicing various clients. I'm only using galera as an easy way to handle replication and fallover. I'm not actually using multiple masters ...
2
votes
1answer
1k views

MySQL high CPU/query time usage during concurrent inserts

I just setup a new server for a large MySQL database of about 70GB. This database is regularly written by automatic processes that must write as quickly as they can their data. Before we had a server ...
2
votes
1answer
587 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 ...
2
votes
1answer
469 views

MariaDB how to handle 2/3 node failure in multi master cluster.

I run 3 node multi master MariaDB galera cluster. It basically works for me how it is. When one node fails, two other work and it's fine. But I'm wondering is there a way for it to keep working on ...
2
votes
2answers
775 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
3answers
456 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
129 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
2answers
481 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
3k 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
37 views

mysql / mariadb - remove ipv6 user

Can I remove the 'user'@'::1' <- ipv6 user from mariadb? I have ipv6 disabled on my CentOs install. Or is it not related to ipv6?
1
vote
3answers
5k 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 ...
1
vote
1answer
402 views

Nginx + HHVM + MariaDB + WordPress install -> Error establishing a database connection

I'm setting up a VPS for a WordPress blog. I'm using Ubuntu 14.04 LTS 64 bits and then I've installed Nginx 1.7.8, HHVM 3.6.0, MariaDB (don't remember the version). Finally I've downloaded WordPress ...
1
vote
1answer
32 views

Is it possible to safely edit mysql-bin.index file while mysql server is running

I changed location of mysql bin-log files. I copied them so mysql started fine, because they where in both locations, but then removed them from old location. I forget about correcting the path in ...
1
vote
1answer
95 views

How to avoid PHP errors during server reboot?

I found a PHP error in my server log that says: [02:09:27 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in ...
1
vote
1answer
36 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
425 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
1answer
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 ...
1
vote
1answer
43 views

Any way to import MySQL tables with indexes intact?

Currently our live database server does daily downloads of large data dumps (on the order of 10GB), imports them into MySQL, normalizes the data, and builds a number of indexes (full-text indexes ...
1
vote
1answer
85 views

TokuDB storage engine missing after restart

I'm using MariaDB-server 10.0.14 and just had a power outage and hard restart. When coming back up I had to manually remount drives etc. but everything seems intact except I have an error when trying ...
1
vote
1answer
421 views

Configuring MariaDB to log to mysql.log using rsyslog

I'm a little stumped - there is something obvious I'm missing here. Recently I made the switch from mySQL to mariaDB. Everything is working so far - except for the logging, as I realized today. All ...
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
278 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
629 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
802 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
36 views

removing STATS_PERSISTENT=0 for innodb

Is it okay to disable "STATS_PERSISTENT=0" from mariadb 10.0 dump, restoring to mariadb 5.5 ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
1
vote
1answer
22 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
0answers
134 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
69 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 ...