0
votes
0answers
16 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
1answer
20 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 ...
0
votes
1answer
39 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
0answers
50 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
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 ...
0
votes
2answers
131 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 ...
1
vote
1answer
97 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
1answer
499 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 ...
0
votes
0answers
67 views

UTF-8 encoding gone missing after enabling mysqlnd

I've enabled mysqlnd on my PHP 5.4.26 server using MariaDB 10.0.8. My SQL config contained this: [mysqlnd] character-set-server = utf8 collation-server = utf8_general_ci It was all working fine ...
1
vote
1answer
166 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 ...
0
votes
0answers
293 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
574 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 ...
0
votes
1answer
306 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
1answer
223 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 ...
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 ...
-1
votes
1answer
96 views

MariaDB 10.0.4 different mysqlclient reported

I use MariaDB-server 10.0.4 on my CentOS 6.4 64-bit server. PHPMyAdmin shows: libmysql - 10.0.4-MariaDB While phpinfo shows: Client API version 5.3.12-MariaDB Why I got two versions ? How to ...
0
votes
2answers
1k 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
1answer
89 views

MySQL Replication Stale

I had some interesting problems with Maria DB. 1st I have max_connections in config under section [mysqld] but the value is always 214 (default) after restart. So the problem is I can't defined the ...
-1
votes
1answer
537 views

MariaDB Galera Clustering - Active Active - Operation not permitted error

I am having issues with MariaDB and Galera running on RHEL 6.4 & 6.2 64bit servers and getting them to cluster. I installed the required RPM's for Galera clustering: MariaDB-Galera-server ...
-4
votes
1answer
93 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
1answer
637 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
1answer
310 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 ...
0
votes
1answer
65 views

Clear “failed login attempts” in MySQL (without restart?)

In phpMyAdmin it displays how many failed, aborted and successfull login attempts I have on the server. I put up some iptables rules and want to see how it's going now. I want to reset the stats ...
-1
votes
1answer
116 views

Backup/Recovery like barman for MySQL [closed]

I'd like to have a Backup/Recovery tool for MySQL (MariaDB/Percona) servers which has somehow the same features as barman has for postgresql take full backups on a regular basis (xtrabackup, but ...
0
votes
1answer
446 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
1answer
700 views

How to combine Zabbix with MariaDB?

Ubuntu Server 13.04; Zabbix actual version from source code; MariaDB 5.5 Fistly I've download and unpack Zabbix source code. After that: ./configure --enable-server --enable-agent --with-mysql ...
-1
votes
1answer
39 views

Improving Database Performance [closed]

I've heard that you can do something like the following in my.cnf to get better performance: tmpdir = /dev/shm I'm running MariaDB and wondering is this a good idea? All it does it create the ...
0
votes
3answers
974 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
2answers
283 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 ?
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 ...
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
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 ...
0
votes
1answer
161 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 ...
1
vote
1answer
192 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
3answers
313 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
168 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
680 views

Install php-fpm + php-mysql + MariaDB on Centos from repos

I try to take CentOS 6.4 x64 and install nginx w/ php-fpm on it (and that's easy part, no problem at all), then add php-mysql package and MariaDB as a mysql drop-in replacement. And here I face the ...
0
votes
0answers
154 views

MarriaDB on OpenSUSE 11.4 continually crashes

I've had a openSUSE 11.4 VM running for quite some time with no problems. Recently, ever day or so my MariaDB (MySQL fork) will crash out of nowhere. Nothing has really changed as far as database side ...
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 ...
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 ...
2
votes
2answers
433 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 ...
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 ...
1
vote
1answer
724 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 ...
2
votes
2answers
418 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 ...
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 ...
9
votes
3answers
634 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 ...