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

learn more… | top users | synonyms

0
votes
0answers
24 views

Zabbix-server-mysql can't allocate shared memory - Access denied

I'm trying to run an instance of zabbix-server-mysql on Fedora 20, but Zabbix keeps saying that cant allocate shared memory space for history cache due to an Access Denied error. i'm sure that the ...
1
vote
1answer
12 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
0answers
12 views

MySQL/MariaDB CLI limits max password? [migrated]

I've got strange problem - my MariaDB instance CLI (Linux) does enforce limit on how long password can be. For example, setting password like this UPDATE mysql.user SET ...
0
votes
2answers
42 views

phpmyadmin can't login on nginx Centos 6 Server

I've installed phpmyadmin on my ded server with Nginx and MariaDB under Centos 6.i can login into mariaDB cli with root user falwlessly but i can't login through phpmyadmin. it shows me first login ...
1
vote
1answer
73 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
19 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
0answers
20 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 ...
0
votes
1answer
69 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
0answers
14 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 ...
0
votes
0answers
24 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
1answer
18 views

Over 100% of stage done during DROP COLUMN

I'm running a DROP COLUMN on the primary key column (I know, it's terrible but I had to do it). There's a progress indicator: Stage: 1 of 2 'copy to tmp table' 107% of stage done I haven't been ...
1
vote
1answer
91 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
197 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 ...
0
votes
0answers
110 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
3answers
1k 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
0answers
27 views

Create puppet manifests file with mariaDb

I want to customize vagrant with puppet and install there php5, apache and mariaDb. I try to use this site to generate suitable manifests file but there absent mariaDb. Can someone suggest where I can ...
1
vote
1answer
296 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
103 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
117 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 ...
2
votes
2answers
293 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
92 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 ...
0
votes
0answers
25 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 ...
0
votes
1answer
156 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
769 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
67 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
854 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
154 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
64 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
411 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
86 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
votes
1answer
58 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 ...
0
votes
1answer
147 views

MariaDB Galera Cluster hang after issue cluster command

When trying to cluster two MariaDB Galera servers on RHEL 6 together using the command: mysqld -uroot --wsrep_cluster_address=gcomm:// and the screen then sits there, and looks at me with this ...
0
votes
1answer
331 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
0answers
222 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
38 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
96 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
369 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
541 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
37 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
735 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
230 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
3k 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
934 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
157 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
165 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 ...
0
votes
1answer
181 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
3answers
269 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
148 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
421 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 ...