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

learn more… | top users | synonyms

-2
votes
0answers
9 views

haproxy with mariadb galera cluster connection issue

I have a haproxy and 3 node mariadb 5.5 galera cluster setup . Application is point to haproxy for connect sql database . When haproxy balance under roundrobin application is loosing its connection ...
0
votes
0answers
18 views

How to backup MySQL (MariaDB) database on dedicated servers to AWS (S3 Object Storage?)

We have a 180GB dedicated production server, which we currently backup daily using Percona xtrabackup to a backup server in our rack. We're looking at moving our backups (not the database itself) to ...
0
votes
1answer
24 views

Sharing developing site on VM with 3rd computer within local network

I'm trying to figure out the correct url I should type to show my subsite1 by browsing through an inner network computer. The only site I've been able to view was the mainsite. I don't really ...
0
votes
1answer
41 views

Cant read dir of /etc/my.cnf. (Errcode: 2)

I am running MariaDB (libmysql - 5.5.41-MariaDB) and today I noticed that I couldn't go to mysql via command line to create a dump file. It would throw an error: mysql: Can't read dir of ...
1
vote
2answers
91 views

csv import mysql null

I have to import some csv-formatted data into a mysql (mariadb) database. There is no csv header and the lines look like this: 00323acd-7909-41a4-a849-073ca3391dcf,2014-05,\N ...
1
vote
1answer
46 views

Installing MySQL (MariaDB) on Centos7

New to Centos7, trying to install MariaDB with: sudo yum install mariadb-server mariadb And this is what it spits out: Loaded plugins: fastestmirror, langpacks, rhnplugin This system is ...
0
votes
2answers
42 views

Pros and cons of database choice for OwnCloud [closed]

OwnCloud provides 3 choices for its database: SQLite MariaDB PostgreSQL Obviously SQLite is not a practical choice, since it can rarely handle the load. What about the other two? Is MariaDB or ...
0
votes
1answer
24 views

Skip failing statement in galera multi-master: Duplicate Column, wsrep_local_state: 2

After a Schema-Change on which I have missed out to take care about replication, I now have one Server not synching anymore, as it tries to alter the table which already has been taken care of (Server ...
-2
votes
0answers
15 views

Which db choose to concurrent work of 2000 connections and more? [duplicate]

Let's assume. I have some credentials data which plan to store in mariadb. And I have two php scripts: worker.php - must work 2,000 workers(it is condition!). This workers must use same db for select ...
0
votes
1answer
32 views

MariaDB auto-increment-increment having no effect

I am trying to set up a master-master MySQL replication (both active servers). As I'm doing this on Centos 7, I have to use MariaDB instead of MySQL, although it seems fairly similar. So, before I ...
1
vote
1answer
43 views

Galera bootstrap fails without errors

I've been pulling my hair out all weekend trying to get a Galera cluster up and running, using MariaDB 10.1.5 (which includes Galera 25.3.9) on CentOS 7. This server runs two database instances, one ...
0
votes
1answer
130 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 ...
-3
votes
2answers
40 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
31 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
30 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
42 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
288 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
26 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
43 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
270 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
63 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
79 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
44 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
96 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
136 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
45 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
111 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
152 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
87 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
211 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
189 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 ...
1
vote
2answers
414 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
32 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
35 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
1answer
183 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
146 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
582 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
438 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
87 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
200 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
401 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
50 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
827 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
483 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
113 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
72 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
357 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
52 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
85 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...) ...