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

learn more… | top users | synonyms

0
votes
0answers
8 views

Scaling and HA LEMP coming from a single server setup

here is the current configuration 1 Server: nginx php-fpm memcached mariadb 10 The project is growing fast and in the midterm we need to scale. When I have to setup multiple machines I want to ...
0
votes
1answer
13 views

WSREP: Bad value for 'socket.ssl_key'

I am attempting to initialize a new MariaDB Galera cluster with SSL-encrypted replication. I have followed this guide to the letter, specified different details for CA, Server, and Client ...
0
votes
0answers
5 views

Galera Rsync SST Secured via SSL/SSH

Is it possible to secure Galera Cluster SST via rsync with SSL/SSH? This page suggests it is not, specifically the following quote: Unlike rsync, xtrabackup includes support for SSL encryption ...
0
votes
1answer
16 views

GTID have been turned off But I have error in replication

I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
1
vote
0answers
12 views

Minimizing downtime during MariaDB Replication Setup [migrated]

I have the task of setting up MariaDB (10.0) replication from a master running in a datacenter to a slave running out in an AWS VPC. Reading up on the instructions on Setting Up Replication - MariaDB ...
4
votes
1answer
66 views

Galera cluster (MariaDB) on Docker/CoreOS: second node doesn't work on first attempt

I'm trying to create an automatic deployment of Galera Cluster with MariaDB, running inside Docker containers on CoreOS. Software used: - MariaDB official Docker image, version 10.1.10 - CoreOS ...
0
votes
0answers
18 views

Debian Mysql 5.6 and MariaDB Instances on Same Server

I'm trying to have Mysql 5.6 and MariaDB to make comparison and track performance between each other. Everything i have found over the internet was this link: ...
0
votes
0answers
23 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...
-2
votes
0answers
16 views

What would trigger haveged process?

Every now and then, I would see /usr/sbin/haveged -w 1024 -v 1 --Foreground process running when I view top. Why is this process running? Could another process like mariadb or apache trigger this ...
0
votes
1answer
19 views

Is MySQL using up all the memory? [duplicate]

I need help with reading this output of free -m. This server has a total of 32 GB of ram but it shows 9383 used and 290 free. The rest seems to be in the buff/cache. I am running mysql on this server ...
-2
votes
0answers
33 views

MariaDB Galera Cluster during service window

We have a working 3-nodes mariadb galera cluster behind haproxy. It's been a while since those where patched. I'm afraid I'll break the cluster when applying patches. My thoughts about it is to bring ...
0
votes
0answers
14 views

Maria db Optimization and performance

I have a dedicated server comes with 8 x 3.3GHz cores, 16GB memory DDR3, CENTOS 6.7 64 bits, Apache 2.2.9, PHP 5.6, im running a php applications that needs a lot of connections with maria db version ...
0
votes
1answer
16 views

MariaDB galera cluster fail when dumping or optimizing database

It seems that a Galera cluster deadlocks every time when I run a mysqldump or table optimize. I've ran a "mysqlcheck" and a "mysqldump" on my MariaDB 10.1 database server several times. (which runs ...
0
votes
0answers
38 views

8 minute timeout delay in starting MariaDB with galera turned on

I'm just trying to get one node up for testing, and at first I thought it wasn't working at all, until I left the terminal running for a bit. See the 8 min timeout in the middle of the logs? ...
2
votes
1answer
41 views

Vagrant provision : shell script install mariadb-server on Debian prompt error

I'm looking for provisioning a Debian 8.2 Virtualbox VM with MariaDB 10. I use the following : sudo export DEBIAN_FRONTEND=noninteractive sudo debconf-set-selections <<< "mariadb-server ...
0
votes
0answers
33 views

trouble setting up pt-heartbeat (percona toolkit) for mysql/mariaDB replication

I'm facing some problems with pt-heartbeat (from percona toolkit) in order to observe MariaDB replication. I have one master instance with IP 172.17.0.3 and server-id = 1 I have one slave instance ...
-4
votes
1answer
64 views

MariaDB on Centos7, service still called MySql

I have a Centos 7 server. Removed previous MariaDb 5.5 and installed MariaDb 10 following https://mariadb.com/kb/en/mariadb/yum/ Added the MariaDB YUM Repository,and then executed: sudo yum ...
2
votes
2answers
106 views

CentOS 7.2, PHP 5.4 - MySQL extension is missing [closed]

I'm trying to install a Wordpress blog on my Linux server (CentOS 7.2), using PHP 5.4 and MariaDB, but I keep running into this error: Your PHP installation appears to be missing the MySQL extension ...
0
votes
1answer
34 views

Secure galera cluster MariaDB

I'm using a Galera cluster between a few web servers over the WAN. I have the traffic encrypted with ipsec between the servers, but it just struck me that anyone can connect to my Galera cluster and ...
0
votes
0answers
40 views

MariaDB keeps restarting

since yesterday I noticed a strange behavior on my machine. I have a backup script to backup sql and files. I noticed that the archive files are much smaller and corrupted. I analized the logs and I ...
0
votes
1answer
214 views

unable to run a mariadb 10.1 galera cluster

I have installed mariadb 10.1 via the instructions here: https://mariadb.com/kb/en/mariadb/yum/#installing-mariadb-galera-cluster-with-yum but when I run the server with : sudo service mysql start ...
0
votes
0answers
21 views

Way to know what source is reading the most from MySQL Server(RDS)?

I have a mysql server which is registering very large bandwidth usage. I want to know what options I have for: Knowing what source is using the MySQL server most. (server ip?) What tables or queries ...
0
votes
1answer
21 views

mysql master to master replication with one slave

I have 3 servers Server A master to Server B Server B master to Server A and Server C Server C slave to Server B When I add table to Server A, it replicated on server B but not in Server C When I ...
3
votes
0answers
20 views

MySQL user suddenly loses some permissions [closed]

On CentOS 7, I have a MySQL (actually MariaDB) database user that needs all server privileges from a remote IP (to be able to use Navicat Premium to manage the database). Somehow every once in a ...
1
vote
1answer
41 views

mariadb mysql parallel installation apache and php

I'm trying to install mysql and mariadb on the same server as a parallel installation, each service on a different port. I installed mysql server using apt-get on a debian-based distro and then ...
0
votes
0answers
22 views

Migrating MySQL 5.1 to MariaDB 10

I plan on migrating my data from MySQL 5.1 to MariaDB 10. At the same time I will be upgrading hardware so I will have a completely new server. Is it possible to simply mysqldump from MySQL 5.1 and ...
1
vote
0answers
19 views

Scaling Mariadb Galera Cluster

I have installed MariaDB Galera Cluster on ubuntu 14 and it is working fine. See the tutorial I have 3 nodes (each 500GB HDD capacity) mariadb cluster and all replications are working perfect. My ...
0
votes
1answer
28 views

Where is systemd script for mysql.service located?

I am actually using MariaDB (drop-in replacement for MySQL). I'm trying to make some changes to my systemd mysql.service file. I can see it exists because running sudo systemctl lists it and ...
0
votes
0answers
33 views

Galera Cluster: system requirements for an Arbitrator?

I'm planning the deployment of a Drupal website running on Linux (CentOS 7) and Nginx in IaaS. I will be using two nodes for HA, and each will offer the exact same services (Nginx, PHP, Redis, ...
0
votes
0answers
42 views

user and file permission issues while installing mariadb on ubuntu

I was following the installation instructions of mariadb: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | ...
0
votes
1answer
55 views

How to view mariadb log?

I am using new relic to monitor the performance of my server. Recently I noticed a very strange problem where for every 3 hours, the server will be down for 1 minute. And in the new relic report, ...
0
votes
1answer
71 views

Millions of requests and MariaDB vs. PostgreSQL

I do not ask for comparison. I already know what PostgreSQL and MariaDB is and differences. I am looking this issue from another point. Such companies like Facebook uses MySQL (of course patched) but ...
0
votes
1answer
158 views

Can't Install MariaDB - Dependency Error?

I'm running Ubuntu 14.04 on a Digital Ocean VM. I'm trying to install MariaDB 10.1. When doing so, I get the following error: Setting up mariadb-server-10.1 (10.1.8+maria-1~trusty) ... dpkg: error ...
1
vote
1answer
48 views

Timeout error on MariaDB in Docker container

I have an ArchLinux installation with Docker and MariaDB running in a container. Now when I try to connect to the database, I get the following euro: MySQL said: Can't connect to MySQL server on ...
0
votes
0answers
75 views

InnoDB settings - mysql tuner results after running for awhile

Newbie as far as InnoDB goes, but I installed MySQLTuner awhile back and according to this it looks like I need to adjust my settings, but can someone chime in with some deeper understanding of all ...
0
votes
1answer
75 views

MariaDB won't start - fails to check integrity

I have a MariaDB installed with brew in my macbook. Worked fine till today. All of a sudden it wound not start: -> mysql.server start Starting MySQL ERROR! also, if I issue mysql -uroot or any ...
1
vote
1answer
200 views

MariaDB replication lag

I'm trying to get replication working between 2 servers running MariaDB 10.1.7 64 bit. The database I'm trying to replicate is huge, 520G and the export/import on the slave with disabled autocommits ...
1
vote
1answer
34 views

mysqlimport file not found error in Windows but exists a file

I have a problem with (Oh, I am using Windows 7, MariaDB 10.1.7) mysqlimport -u root -p --fields-terminated-by="," --local db_name textfile.csv; which founds an ERROR 29, FILE ...
2
votes
0answers
68 views

MariaDB crashed and now won't start

While activating a wordpress plugin MariaDB crashed on me, and it won't restart. I am using Centos 7.1. systemctl status: systemctl status mariadb.service mariadb.service - MariaDB database server ...
0
votes
0answers
46 views

'/var/lib/mysql/mysql.sock' (2) Issue with apache remotely connecting to mysql

Every now and then, I will get this issue where my Apache server cannot connect to my mariadb server remotely. It seems to occur at least once a month and I can't pinpoint the problem. It does however ...
1
vote
0answers
102 views

MySQL encryption at rest

Context: Rackspace CloudServers. The options I can find are rather slim. Amazon will encrypt the whole disk (meh), Gazzang could encrypt a virtual partition with just the DB files on it (if the ...
1
vote
2answers
439 views

ERROR 2006 (HY000): MySQL Server Has Gone Away… (HaProxy / Galera)

I setup a cluster of 3 MariaDB servers in a multi-master setup which is working fine. I added a 4th server for HaProxy to load balance and round robin so that we can have a little redundancy which is ...
0
votes
0answers
37 views

Apache / mariadb out of memory

I've been struggling for a few weeks now trying to find the cause of why mariadb shuts down due to 'out of memory'. The server is a CentOS7 running Apache 2.4 and Mariadb 5.5 with 8GB of memory. When ...
0
votes
0answers
51 views

Adding to tar archive /var/lib/mysql is it enough for backup restore task?

In every docker project, I have a backup.sh and restore.sh file I want to find a good way for backing up and restoring mysql backup using only ./restore.sh ${timestamp} My backup.sh look like ...
0
votes
1answer
230 views

Your PHP installation appears to be missing the MySQL extension

Your PHP installation appears to be missing the MySQL extension which is required by WordPress. This is what I get when I try to install WP. The server is running. Centos 6.7 x64. ...
0
votes
0answers
35 views

Need to do partial restore from a full xtrabackup

I'm using percona xtrabackup to do full DB backups on mariadb 10 and now i'm testing the restore. I want to restore just some databases (the important DBs) and ignore others (big archive DBs), ...
0
votes
2answers
108 views

Medium traffic causes wordpress server to require a hard reboot

We are having trouble with our rackspace wordpress server falling down with medium traffic after an email send. The server specs are: CPU 2 vCPUs RAM 2 GB System Disk 80 GB ...
0
votes
1answer
91 views

Puppet doesn't configure MySQL

I have a following Puppet class using puppetlabs/mysql module: class hg_playground::makowals::brains::db { class { '::mysql::client': package_name => 'mariadb', } $override_options = { ...
0
votes
1answer
224 views

Ubuntu Server 14.04: No login with new MariaDB users

I have a fresh Ubuntu 14.04 LTS system and installed MariaDB on it (version 5.5.36-1) whichI can access with the root user through phpMyAdmin. When I now create a new user in phpMyAdmin and then try ...
0
votes
1answer
79 views

Magento randomly crashes

I've got an Ubuntu Server 12.04 with MariaDB and PHP 5.4.35 The server currently hosts 60+ small WordPress sites, of wich only 3-4 got high traffic. Everything was working fine for the past 2 year. ...