Tagged Questions

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

learn more… | top users | synonyms

0
votes
0answers
8 views

Running MariaDB Galera (5.5) Cluster on Debian failing to start

I am struggling to get a MariaDB Galera cluster running on my Debian 7 machine. I am trying to setup a cluster with two nodes both running on Debian 7. When I first install Galera I can run it find. ...
-1
votes
0answers
12 views

Table not converted in Owncloud migrating from SQLite to MySQL/MariaDB

In Owncloud database migratiion from SQLite to MySQL/MariaDB I have been prompted for the following question... # php occ db:convert-type --all-apps mysql owncloud_user 127.0.0.1 owncloud Creating ...
0
votes
2answers
108 views

Database password error in Owncloud migrating from SQLite to MySQL/MariaDB

In a Fedora system, I need to convert the Owncloud's SQLite database into a MySQL/MariaDB database I started installing MySQL: # systemctl enable mysqld # systemctl start mysqld $ ...
0
votes
0answers
15 views

MariaDB, ARIA, “File size bigger than expected”

On (only) my production server, whenever I wait a while and restart MariaDB, it completely crashes and burns, e.g.: 141110 16:18:26 [Note] /usr/sbin/mysqld: Shutdown complete 141110 16:18:26 [ERROR] ...
0
votes
1answer
59 views

MariaDB 10.0 / Docker / Vagrant - Sub-process /usr/bin/dpkg returned an error code

MariaDB 10.0 does not install properly when using Vagrant, Docker and other virtualised services. $ DEBIAN_FRONTEND=noninteractive apt-get install -y mariadb-galera-server Setting up ...
0
votes
0answers
29 views

MariaDB Multimaster replication and AWS Auto Scaling Group

One of the things I hate most about RDBMS is that it can't sit on an ASG like the web servers and bounce it around and scale it up and down like a yoyo. Or can it? Recently looking at MariaDB galera ...
0
votes
1answer
67 views

Can I do zero downtime MySQL replication if I have archive tables present?

I've read the question and answers at How to setup MySQL replication with minimal downtime. It looks like I can get a slave DB into sync without down time if I am using only Innodb tables. My ...
0
votes
1answer
45 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
124 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
209 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
40 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
44 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
135 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
50 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
184 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
2k 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
15 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
78 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
1k 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
219 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
114 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
131 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
78 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
243 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
56 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
49 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
83 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 ...
1
vote
1answer
216 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
374 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
48 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
82 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
250 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
30 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
277 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
289 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
76 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
446 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
218 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
402 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
241 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
630 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
2k 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
123 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
91 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
216 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 ...
1
vote
1answer
218 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 ...
1
vote
0answers
188 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
303 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
856 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 ...