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

learn more… | top users | synonyms

0
votes
0answers
18 views

Fail to set up mariadb-galera cluster

I am trying to set up galera cluster in my VM cluster, however I can't seem to get the second node to connect to the first properly, this is my current configuration [mysqld] ...
1
vote
1answer
13 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
0answers
33 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 ...
0
votes
0answers
14 views

Why has MariaDB created database directories with @ in?

A backup script on a Debian server looked at /var/lib/mysql/*/ to find local database names. Having recently installed Seafile, this no longer works because although the databases are called normal ...
1
vote
1answer
41 views

Dovecot isn't working after upgrading MariaDB

I've just updated my database engine to MariaDB (5.5.40-MariaDB-0ubuntu0.14.04.1 - (Ubuntu)). Everything else (Apache2 :80, :443, phpMyAdmin, Webmin, etc.) but Dovecot is working. I'm not quite ...
0
votes
0answers
13 views

Setup Server for Optimization [duplicate]

I've got my first Dedicated server and I would like some help with the Optimization of it. I am thinking of going a bit different than the regular setup and I'd like your feedback. Before we start, ...
5
votes
1answer
285 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 ...
0
votes
1answer
85 views

Suddenly mysql/mariadb won't start

Suddenly, after simply adding a few tables to database within the install... the service won't start. Any help welcome. systemctl start mariadb Job for mariadb.service failed. See 'systemctl status ...
0
votes
0answers
31 views

CentOS 7 and MariaDB issue

I have recently moved to DigitalOcean, and installed Centos7 along with its default MysQl server (MariaDB). But I am facing since first install. MySql is exiting down spontaneously and there is no ...
0
votes
0answers
60 views

Mysql table doesnt exist error after trying run from lvm snapshot

I'm trying to set up mysql replication by making lvm snapshot of master datadir and copying it to slave. The procedure is quite simple, on master server I execute "FLUSH TABLES WITH READ LOCK" and on ...
0
votes
0answers
30 views

Direct server return loadbalancer for mariadb galera cluster with 2 networks

Is it possible to configure LVS (keepalived) loadbalancer with direct server return (DSR) for 2 leg network setup? The desired architecture is as follows: mariadb galera cluster, where each node has ...
-1
votes
0answers
109 views

mysql_upgrade fatal Error on CentOS 7

I just upgrade MariaDB (Mysql) 5.5.40 to MariaDB 10.0.15 by following this step by step. I have failed to enable the mysql and also mysql_upgrade with the following errors mysql_upgrade -u root -p ...
0
votes
1answer
104 views

yum dependancy error - looking for the wrong version of php-mysql

So I was trying to upgrade from MariaDB 5.5 to 10.0. (which is essentially MySQL fork) The installation instructions say to yum remove mariadb-server mariadb-common mariadb-compat then re-install ...
2
votes
0answers
50 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 ...
0
votes
0answers
80 views

MySQL unable to repair, dump, upgrade table (simply crashes)

I need to backup one of my databases from MySQL (Running MariaDB). The issue is that aside from all of my other databases that backup perfectly fine, this database has issues backing up and crashes ...
0
votes
1answer
30 views

It is possible having MySQL server and MariaDB server together in the same Ubuntu 14.04 using official packages?

It is possible having MySQL server and MariaDB server together in the same Ubuntu 14.04 using official packages? I want to have both servers running in the same machine, using different listening ...
0
votes
1answer
39 views

error in msiexec for mariadb

This fails (and wont let me add /L for logging) and displays the help popup: Start-Process -FilePath msiexec -ArgumentList /i, "C:\app\install\mariadb-10.0.14-winx64.msi", ...
0
votes
1answer
109 views

MySQL/MariaDB stops running. How do I find out why?

Today I've seen MySQL/MariaDB stop running on a CentOS VPS. When I check the status I get: # service mysql status ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists So I ...
0
votes
0answers
27 views

Debian autostart MariaDB Galera cluster

I have a MariaDB Galera cluster with two nodes. I have got it up and running fine, however the first node in the cluster needs to be started with: sudo service mysql start --wsrep-new-cluster I am ...
1
vote
2answers
32 views

Does a server use bandwidth when connecting to itself?

I have a dedicated server (CentOS 7) with Storm on Demand. I have a rails application running on the server served by nginx and unicorn. I'm using MariaDB on the same server. The rails app handles ...
1
vote
0answers
176 views

Installing MariaDB + Galera via yum fails with “No package MariaDB-Galera-server available”

I'm spun up a brand new Cento OS 7 virtual machine and I'm following this tutorial to install a MariaDB + Galera cluster. I've added the MariaDB repos as follows: vi /etc/yum.repos.d/MariaDB.repo ...
0
votes
0answers
78 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. ...
0
votes
2answers
235 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
56 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
186 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
78 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
78 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
134 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 ...
2
votes
1answer
506 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
513 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
95 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
81 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
3answers
257 views

MariaDB 10.x on CentOS 7?

Why there is no MariaDB 10.x RPM for CentOS/RedHat 7? How can I install it? I'm trying to install the most recent stable version on my server, but it seems, that official repo is absent. 5.5 is ...
1
vote
0answers
73 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
472 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 ...
4
votes
2answers
5k 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
18 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
169 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
2k 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
242 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
193 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
202 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
117 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
623 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
79 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
65 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
99 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
318 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
438 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
50 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?