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

learn more… | top users | synonyms

0
votes
1answer
18 views

FreeBSD: mariadb55 conflicts mysql55

I'm trying to install percona-toolkit as package/port on my system: [root@alexus ~]# uname -a FreeBSD alexus.org 9.2-RELEASE-p5 FreeBSD 9.2-RELEASE-p5 #0 r265974: Wed May 14 07:57:04 PDT 2014 ...
1
vote
1answer
66 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 ...
0
votes
0answers
70 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
26 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
1answer
33 views

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should ...
-1
votes
1answer
92 views

MariaDB 10.x on CentOS 7?

Why there is no MariaDB 10.x RPM for CentOS/RedHat 7? I'm trying to install the most recent stable version on my server, but it seems, that official repo is absent for so long since release. Why? ...
1
vote
0answers
38 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 ...
0
votes
1answer
94 views

Increasing nproc for processes launched by systemd on CentOS 7

I have successfully increased the nofile and nproc value for the local users, but I couldn't find a proper solution for the processes launched by systemd. Adding max_open_files to the MariaDB ...
0
votes
2answers
672 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 ...
1
vote
0answers
14 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: ...
0
votes
2answers
54 views

MariaDB RHEL Fresh Install Root Login Issue

I just installed MariaDB on a RHEL system and this is my first time using MariaDB. I can start/stop the service only using the following commands: sudo systemctl start mariadb.service sudo systemctl ...
3
votes
2answers
694 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 ...
0
votes
1answer
214 views

Forced reboot caused /var/lib/mysql to 'disappear'

During the nigh my provider had to force reboot the server (pull the plug), after boot, there was a problem with the MySQL server (I'm using MariaDB). After hours of research I can't find the main ...
0
votes
1answer
65 views

Maria db rpm Installation Error

I am getting below error while trying to install Maria DB on centos [root@server1 MariaDB]# rpm -i MariaDB-5.5.30-centos6-x86_64-common.rpm warning: ...
-2
votes
1answer
99 views

MariaDB service won't start on FreeBSD jail

Just set up a dedicated database jail running databases/mariadb55-server and for some reason it won't start on demand nor on boot. Any suggestions? # service mysql-server start Starting mysql. ...
0
votes
0answers
57 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
2answers
118 views

Completely stuck on a new mariadb-server initialization

New install of mariadb-server 5.5.38 on FreeBSD 10.0-RELEASE-p5 amd64 refuses to start. Currently refusing to start for this reason: 140808 14:12:28 [ERROR] mysqld: Can't find file: ...
1
vote
1answer
41 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 ...
0
votes
0answers
37 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
77 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
161 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
332 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
46 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
1answer
75 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
223 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
29 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 ...
2
votes
3answers
196 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 ...
1
vote
1answer
224 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
58 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
363 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
1answer
206 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
337 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
2answers
221 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
3answers
469 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 ...
2
votes
1answer
1k 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
1answer
116 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
85 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
200 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
190 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
177 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
24 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
265 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
761 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
719 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
3k 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
88 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 ...
2
votes
1answer
909 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
195 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
713 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
581 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 (= ...