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

learn more… | top users | synonyms

0
votes
0answers
3 views

Mariadb galera node error when joinning cluster

I am getting these errors when trying to join nodes to a master. Ubuntu 14.04 MariaDb Galera 5.5.42. I had this problem with rsync as well. No iptables rules blocking connections. Any help would be ...
0
votes
0answers
9 views

MariaDB Galera Deployment

I am looking to experiment with MariaDB 10 Galera Cluster. I am looking for highly available, scalable and reliable architecture. Basically I am curious what would be the better architecture and would ...
0
votes
0answers
16 views

MariaDB ENGINE=CONNECT IMPORT DUMP FAILED [on hold]

I have a new mariadb 10 server. I am trying to import a database dump (again from mariadb 10) which contains tables with engine=connect with specified mysql connection to a remote database. During ...
0
votes
1answer
28 views

Maria db wont start | Failed to get D-Bus connection

I try to start my mariadb but I am failing to start the maria db and I dont have any clue why.. I am running centos 7 with mariadb. It doenst start when I reboot, also when I use the cli to start it ...
0
votes
1answer
55 views

Deploy MySQL/MariaDB on demand in a C# application

I'm creating a lightweight bug tracker, and I'm really having difficulties with people that don't know how to deploy and connect to a MySQL database on their own. What they should do is to create ...
0
votes
2answers
134 views

OpenBSD Nginx/PHP/MariaDB/PHP-FPM Stack

I have a minimal OpenBSD 5.7 amd64 install in VMware where I have installed matching versions of PHP and PHP-FPM, plus nginx, and mariadb using pkg_add. I configure all the services, and get nginx to ...
0
votes
1answer
16 views

Trying to upgrade MariaDB server

I'm running Ubuntu 14.04trusty with MariaDB server 5.5.41 and would like to upgrade to version 10. I shutdown and uninstalled 5.5.41 per instructions, ran the updates, and apt-get and got the ...
-1
votes
1answer
20 views

Cent0S 7 and Mariadb

I can not start mariadb/mysql the innodb file became corrupt after hard shut down. Now after working on it I get this. I replace the entire /var/lib/mysql direct with a backup copy and after that I ...
0
votes
0answers
68 views

Vagrant and MariaDB (provision)

I'm trying to create a provision file that installs MariaDB but it keeps failing. The provision looks like this: sudo apt-get install -y software-properties-common sudo apt-key adv --recv-keys ...
-4
votes
2answers
68 views

How to recover MariaDB database after a failed update? [closed]

Due to a failed update, now my VPS system is broken. I can only access to my files with rescue mode. So, where does MariaDB store his .sql files? So I can make a backup. The update was made by my vps ...
27
votes
1answer
2k views

Is MariaDB a secure replacement for MySQL?

I've been using MariaDB, "an enhanced, drop-in replacement for MySQL" on my Debian stable servers for years, because of its increased performance. However I've noticed that it appears to lag with ...
0
votes
1answer
122 views

How to upgrade MySQL 5.6 to MariaDB

We are using MySQL 5.6 on a productive Server which we want to migrate to MariaDB. Many reasons - but the main reason is the way the Master <-> Master Replication on MariaDB is working. There are ...
0
votes
0answers
353 views

MariaDB crashing with “Assertion failure in thread xxx in file rem0rec.cc line 580”

I have three MariaDB servers set up in a Galera cluster. I use one server at a time as a "primary" master (i.e., Galera is just for failover, the app doesn't actively use multiple masters). About ...
1
vote
1answer
45 views

mysql / mariadb - remove ipv6 user

Can I remove the 'user'@'::1' <- ipv6 user from mariadb? I have ipv6 disabled on my CentOs install. Or is it not related to ipv6?
1
vote
1answer
60 views

removing STATS_PERSISTENT=0 for innodb

Is it okay to disable "STATS_PERSISTENT=0" from mariadb 10.0 dump, restoring to mariadb 5.5 ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
0
votes
2answers
89 views

MariaDB: mysql_install_db problems

I just install MariaDB on a clean Debian 7 machine. When I want to run mysql_install_db, I get this set of errors: 150329 18:01:27 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150329 ...
1
vote
1answer
35 views

MariaDB Replication server disk usage drop

I have a MariaDB master-slave setup on 2 CentOS 7.0 servers. Today, I extended a LVM volume on the master server (because it was getting full). After extending the partition, I rebooted the server and ...
1
vote
1answer
516 views

Nginx + HHVM + MariaDB + WordPress install -> Error establishing a database connection

I'm setting up a VPS for a WordPress blog. I'm using Ubuntu 14.04 LTS 64 bits and then I've installed Nginx 1.7.8, HHVM 3.6.0, MariaDB (don't remember the version). Finally I've downloaded WordPress ...
0
votes
1answer
123 views

How to monitor MariaDB Galera cluster status from command line

I know to check the Galera cluster status, the command that should be used after login to the mysql client is: SHOW STATUS LIKE 'wsrep%'; but, how to get the output directly from the command line? ...
1
vote
1answer
43 views

Is it possible to safely edit mysql-bin.index file while mysql server is running

I changed location of mysql bin-log files. I copied them so mysql started fine, because they where in both locations, but then removed them from old location. I forget about correcting the path in ...
0
votes
0answers
48 views

Lot's of dealocks since migrating to galera cluster

I recently migrated from a 1 node MySQL server, to a 2 nodes mariadb Galera cluster. (I know, 2 nodes is not recommended). At first, I enabled writes to both of the nodes, but realized it increased ...
0
votes
0answers
185 views

HAProxy but still single point of failure

I'm setting up a test cluster - Maria Galera Cluster on 3 physical nodes with HAProxy. Its working, but I've made some kind of beginner error which I can't seem to resolve - so hopefully someone can ...
0
votes
1answer
33 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...
0
votes
1answer
54 views

localhost != localhost for MySQL/PHP

System: Mac OS X Server 10.6.latest I just switched from the ancient MySQL (<5?) that came with Mac OS X Server to MariaDB 10.1, installed via MacPorts. (That was a whole 'nuther barrel of fun...) ...
0
votes
1answer
203 views

MariaDB Galera SST Fails

I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs: 150212 ...
-1
votes
1answer
109 views

MySQL on iscsi drive CentOS7 wont start on boot

I configured Mariadb on CentOS 7 to run on iscsi drive mounted on /mnt/iscsi, but it wont start on boot with following error (it can be started manually): mariadb.service - MariaDB database server ...
0
votes
1answer
174 views

How to tune MariaDB/MySQL in a docker container?

I understand that it's easy to get a MariaDB docker container up and running, and using nsenter to edit config files is possible. But how can I tune the config files in this container, e.g. the ...
1
vote
0answers
177 views

error creating database using ansible on centos 7

I am trying to install mysql AND setup database using ANSIBLE on CentOS7(i have no idea why every documention in the world now ONLY talks about Ubuntu and NO CentOS anymore...really SAD!) here is my ...
1
vote
1answer
49 views

Any way to import MySQL tables with indexes intact?

Currently our live database server does daily downloads of large data dumps (on the order of 10GB), imports them into MySQL, normalizes the data, and builds a number of indexes (full-text indexes ...
2
votes
1answer
53 views

Galera: Run slow ALTER without locking entire server

I have a 3-node galera cluster with a few hundred databases servicing various clients. I'm only using galera as an easy way to handle replication and fallover. I'm not actually using multiple masters ...
0
votes
0answers
123 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
121 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
81 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
26 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 ...
0
votes
1answer
107 views

Dovecot isn't working after upgrading MariaDB [closed]

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
880 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
680 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
1answer
210 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 ...
1
vote
0answers
122 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
68 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 ...
0
votes
1answer
1k 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 ...
3
votes
1answer
316 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
192 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
43 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
69 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
243 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
1answer
65 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
38 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
412 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 ...