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

learn more… | top users | synonyms

0
votes
0answers
18 views

Galera new cluster WSREP Unknown error 141

I am trying to create a new Galera cluster in the cloud using Ansible (DevOps tool). I can get the cluster started by issuing commands from an SSH shell, but not from Ansible. I have simplified the ...
-1
votes
0answers
25 views

MySQL / MariaDB will not start [closed]

I keep getting the error below and MariaDB will not start up. 150723 18:03:51 [ERROR] Incompatible header in messagefile /usr/share/mysql/english/errmsg.sys'. Probably from another version of MariaDB ...
-3
votes
2answers
31 views

Can Varnish be deployed to front end mariadb/mysql server pool? Or is varnish helpful only when frontending HTTP servers?

Can Varnish be used to front end a pool of mariadb/mysql servers? I see that it does not handle any non-http requests and gives 503 error.
0
votes
1answer
25 views

MySQL: Replication without MySQL table, add user to replicated database on slave [closed]

I have a MySQL master / slave setup. Only one database is replicated. (not mysql) So now i cannot add users on the replicated database on the slave. #1044 - Access denied for user 'root'@'%' to ...
0
votes
1answer
26 views

MySQL: Master/slave setup

I need to setup a MySQL master and slave, between an office and a webserver in a datacenter. The master will be in the office. What would happen if the internet connection would fail in the office? I ...
0
votes
0answers
32 views

High memory usage on server after upgrading from MySQL to MariaDB

I recently upgraded from MySQL 5.5 to MariaDB 10.0. After upgrading, rebuilding Apache & PHP, I noticed that memory usage went up by around 200+ MB. I have a VPS of 2 GB available. Before the ...
2
votes
1answer
101 views

MariaDB Galera Cluster falls out of sync easily

We're trying to debug an issue with a MariaDB cluster. We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty). There are three machines clustered together, ...
0
votes
1answer
18 views

Galera cluster implementation questions

I've just successfully created my first Galera cluster using MariaDB 10.0.20 between three servers. I have a few questions regarding my implementation: 1. what will happen if one server becomes ...
0
votes
2answers
28 views

encrypt mariadb database files

I'm currently setting up an installation of mediawiki on arch linux using nginx and mariadb as a database. Since it will be a private wiki I would like to encrypt the database files using veracrypt. ...
0
votes
1answer
130 views

How to install mariadb when mysql gets in the way?

I have searched for a while on google but nothing seems obvious from this weird situation I have on VM, can someone help me? root@sathia:/etc/apt# apt-cache policy mariadb-server mariadb-server: ...
1
vote
1answer
33 views

Connect to MariaDB through SSH fails with error 2013 - Lost connection to MySQL server at 'reading initial communication packet'

I'm trying to connect to a remote MariaDB server through SSH using Navicat Premium from Windows but all the time I can't and get this error: 2013 - Lost connection to MySQL server at 'reading ...
0
votes
1answer
44 views

MariaDB Galera Cluster, Force Sync

I have three servers in a multi-master Galera cluster. I've imported some old databases recently, and noticed that the tables were being created across all three, but the data wasn't being ...
1
vote
1answer
38 views

MariaDb and Httpd getting killed due to memory

I have a Centos7 VPS on OVH with this settings: 1Virtual Core 1 GB Ram 10 GB Raid 10 I have running on it 3 wordpresses. One of them is still on building (0 access to public), other has very few ...
0
votes
1answer
51 views

Freeradius/MySQL server not responding to external calls

I'm currently building up a (CentOS 7) freeradius with MySQL(mariadb) for radius authentication. I'm able to receive auth from local host testing using radtest. Once I use NTRadPing with the same ...
0
votes
2answers
69 views

InnoDB: mmap(68878336 bytes) failed; errno 12

The screenshots explain everything, first I try to start it, and it won't, so I check the status, then I check the logs. After following a number of previous suggestions that I founder around ...
0
votes
1answer
31 views

Remote MariaDB Server - Slow response

I have a website with a lot of traffic. The website is running a forum with around 1000-1500 users online. The load of the current server is at around 4.0, which is about fine, but I want to host the ...
0
votes
0answers
61 views

Unable to install MariaDB on CentOS 6

I am trying to install MariaDB on CentOS6. I have added repo file as per the instruction from Mariadb official webstite. [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/5.5/centos6-amd64 ...
0
votes
0answers
71 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
1answer
47 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
1answer
138 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
149 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
322 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
31 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
32 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
124 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
119 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
3k 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
369 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
1answer
429 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
71 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
153 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
261 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
46 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
731 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
354 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
86 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
68 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 ...
2
votes
1answer
293 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
47 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
75 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
333 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
156 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
301 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
253 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
76 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
73 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
1answer
170 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
2answers
206 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
104 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
29 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 ...