MariaDB is an open source RDBMS that is designed to be a "drop-in" replacement for MySQL.

learn more… | top users | synonyms

1
vote
1answer
20 views
+250

Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?

We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this balancing works fine, the parameters wsrep_log_conflicts and cert.log_conflicts should never log any ...
1
vote
0answers
33 views

Open source & cheap 'data at rest' encryption solutions

So I am exploring some options about database encryption. The best options are commercial (TDE). I am looking for an open-source implementation. Recent releases of MySQL and MariaDB have data-at-rest ...
1
vote
2answers
44 views

Enabling SSL in MariaDB running on Synology NAS

I am having problems with enabling SSL in MariaDB running on Synology NAS (DSM version 6.0) using self signed certificates. I have modified the my.cnf file to point to certificate files and the DB ...
4
votes
3answers
74 views

Behavior of transactions on multiple connections

I have a MariaDB database with InnoDB tables. I have two connections to the same database. One connection is using a transaction around a large chunk of work. The other connection is tasked with ...
1
vote
0answers
36 views

Slow MariaDB performance my.cnf

I migrated my eCommerce website database (Magento) from MySQL to MariaDB (10.0.25-MariaDB) and my site isn't performing as well as it did with MySQL. I've gone through my.cnf several times but to be ...
1
vote
2answers
33 views

guessing unused junk space in table. (innodb mysql/mariadb )

We have in every site (a dozen) one big database with lots of tables and record, using innodb as default and with innodb_file_per_table. from time to time we have space issue on some site and I am ...
4
votes
2answers
148 views

Update old database with SQL dump

I had to recover a database with a some months old full backup. I have however in my possession a most recent but unfortunately incomplete SQL dump for this same database done with mysqldump. Is ...
0
votes
2answers
127 views

Connect MariaDB and Oracle XE

I got an existing MariaDB running on a CentOS 7, I want to add a reporting layer on top of it, I therefore installed an Oracle 11g XE with APEX 5. My goal is to link those two databases in order for ...
1
vote
1answer
373 views

MariaDB Galera Cluster without HAProxy, MYSQL Proxy, etc

I'm looking to deploy a MariaDB galera cluster across three servers. However, I've noticed that the documentation often references HAProxy or the like. Does this not cause a single point of failure ...
1
vote
0answers
10 views

MariaDB / mYSQL Order BY PrimaryKey DESC vs DESC set by Default

What do you guys think about: After each query, I put "Order BY PrimaryKey DESC" VS I set "PrimaryKey Sort by DESC Default" and each query I don't need to put Order By there. Which one will be ...
1
vote
1answer
140 views

Question about a two-node MariaDB Galera Cluster

Hypothetical situation: Node1 is where data gets written to by the app server ... it was where the cluster was bootstrapped from. Node 2 is the second node in the cluster. Both these nodes run in the ...
0
votes
1answer
35 views

How do I get mysql to start for the first time?

I want to get mysql to start for the first time. I installed it on RHEL version 6. All of the commands posted were executed as root. As a test, I ran this: # yum install mysql This is the output:...
1
vote
2answers
3k views

Mariadb on Centos 7 not changing max connections based on my.cnf

The following configuration in my.cnf is not being followed. Max_connections go back to 151. please help as i have 16gb of dedicated ram that i would like to use properly. [mysqld] datadir=/var/...
0
votes
2answers
467 views

MariaDB Galera cluster nod won't start

I have configured a MariaDB Galera cluster with three nodes. The master node and one slave-master node is up and running, but the third node just won't run. The system specs and cluster config are the ...
0
votes
1answer
36 views

MySQL MyIsam Compressing tables

Im packing big MyISAM tables with myisampack and came up with the following issue. (MariaDB 10.1.14 64bit windows) Indexes are rebuilt after packing the tablewhile running myisamchk -rq, so, it doesnt ...
1
vote
1answer
181 views

Why do innodb tables get corrupted so easily?

I'm upgrading a legacy system running MySQL 5.1 all the way to MariaDB 10. We're on a brand new Windows server, running XAMPP. I've done plenty of DB migrations in my time but this one has just been ...
0
votes
0answers
24 views

Howto defrag a Galera Cluster (5.5.41) with innodb_file_per_table = off? After TRUNCATE a huge table is defrag needed?

First question how to defragment our cluster (see Galera and MariaDB config)? I don't know how Galera replicates the new data files size? Second question, is defrag needed? We truncated a 30 GB table ...
2
votes
3answers
64 views

2 fast SQL queries get slow when bunched as subquery on a very large table

I'm trying to use a subquery to speed up a query on a very large table right now 30 million row it most likely going to end up close to 1 billion rows. My table lnmntr is as follow Lnmntr_ndx: ...
0
votes
2answers
227 views

Please recommend changes for my.cnf

I am not having any performance problems per se but want to improve my sites' performance if possible. Would appreciate any advice for how I can improve my.cnf. I have just one server, not ...
0
votes
0answers
33 views

Howto fix replication failure with Galera - thousands of GRA_*.log files on all nodes

Galera Cluster generates a GRA log files if it fails to apply the writeset on the target node. This files exists in the MySQL data directory I use grareader to extract the SQL statement and get ...
0
votes
0answers
29 views

mysqldump: Got error: 1049: “Unknown database 'xx'” when selecting the database - because database deleted during backup? DBaaS

I receive this error during dump (runs a few hours, because 31 GB data files) mysqldump: Got error: 1049: "Unknown database 'ZETF_353D082E_422C_47C4_905F_FF961EEA29B8'" when selecting the database ...
1
vote
0answers
13 views

Howto restore Trigger filesystem copy (*.TRG and *.TRN files) in addition to mysqldump?

We use mysqldump for backup (without Trigger/Events/Routines included). mysqldump --opt --flush-logs --single-transaction --ignore-table=mysql.event --all-databases The triggers we copy with cp to ...
0
votes
1answer
262 views

Non-Replicating commands from (master) Mysql 5.5.40 to (slave) MariaDB 10.0.19

CRUD replicates just fine. But we noticed that DB structure altering commands such as ALTER TABLE and/or adding/updating columns to a table and even creating new ones do not replicate to the slave at ...
1
vote
1answer
122 views

Error connecting to 10.0.17-MariaDB-1~trusty

I'm having problem connecting remotely to my MariaDB server. I've tried more or less everything, and can open a socket with nc(nc myserver 3307) but with the mysql (mariadb) client I only get the ...
1
vote
0answers
27 views

Mysql replication, master_log_pos sync but tables not update

First, my replication config on Master: replicate-do-db = mydb binlog-do-db = mydb expire_logs_days = 2 max_binlog_size = 100M binlog_format = MIXED log-...
0
votes
0answers
14 views

Copying MySQL MariaDB databases MyISAM vs Aria

One of the main advantages that MyISAM continues to have over InnoDB is the ability to copy databases directly between servers using just tar files of the database directories. InnoDB has ...
0
votes
1answer
61 views

Building MySQL InnoDB clustered indexes

Assuming that you have a table like CREATE TABLE `t1` ( `search_id` int(11) NOT NULL, `provider_id` bigint(20) unsigned NOT NULL, `status` text NOT NULL, `imported_at` int(11) NOT ...
1
vote
1answer
57 views

what's practical example / use case SELECT SLEEP() for DBA

I don't know how to use SELECT SLEEP(). It looks like a dirty hack. I found an interesting question How and when to use SLEEP() correctly in MySQL?. The answer is developer oriented: If you don't ...
0
votes
1answer
65 views

Unable to change innodb_log_file_size in MariaDB Galera Cluster 10.0

I have a MariaDB Galera cluster (v. 10.0.19) with 3 nodes. I want to increase the innodb_log_file_size (i.e. the size of the InnoDB redo log files) on one of the nodes to match what it is on the other ...
0
votes
1answer
300 views

Install MariaDB 10 Generic Binaries + TokuDB

I used to install MariaDB from Generic Binaries on a Debian Wheezy 64bits: mariadb-10.0.13-linux-x86_64.tar.gz (from downloads.mariadb.org) I would like to use TokuDB as Storage Engine. However, ...
1
vote
1answer
33 views

I'm seeing inconsisntecies in table data after exporting from one server and importing to another, why is this?

I'm quite new to the process of importing/exporting databases. I'm using Maria DB, and HeidiSQL to run queries, etc. I exported an entire database from our dev server, and loaded it into our live ...
1
vote
0answers
11 views

galera cluster in simple failover mode

Can mariadb-galera cluster be configured without data replication but simply in failover mode? I envision such configuration as one active master server and one backup server, both using the same ...
1
vote
0answers
25 views

1 Node crashed of 3 node mariadb galera cluster

Heading I have three nodes Galera cluster MariaDB, a node in June 4, 2016 suddenly crash, the following is log error Red Hat Enterprise Linux Server release 6.5 Server version: 5.5.39-MariaDB-wsrep-...
0
votes
1answer
591 views

MariaDB I/O capacity with innodb_io_capacity parameter

I use hdparm to test my SSD hard drive I/O benchmark : [root@mail ~]# hdparm -t -T /dev/xvda2 /dev/xvda2: Timing cached reads: 12906 MB in 1.99 seconds = 6477.79 MB/sec Timing buffered disk ...
1
vote
1answer
82 views

howto read/interpret “show engine innodb mutex” output?

We use a 3 node Galera cluster with version 5.5.41-MariaDB-wsrep MariaDB [(none)]> show engine innodb mutex; +--------+---------------------------------+------------------+ | Type | Name ...
1
vote
1answer
398 views

Does MariaDB-Galera Cluster support LAST_INSERT_ID and mysql_info?

As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query? LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock ...
0
votes
1answer
243 views

Removing per column and table collation and charset

I recently completed a transition of a database from CHARSET=utf8 COLLATE=latin1 to CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci. During the process tables were migrated one at a time by altering their ...
1
vote
1answer
57 views

Querying dates with different timezones at db and application level

There is a created_at column of datetime type in the order table. In my application I'm storing dates to the db as datetime in UTC. When I bring them back from the db I'm presenting/formating them to ...
1
vote
1answer
25 views

Contradictory reports from MySQL that a binlog file exists

Our replication recently stopped working. I submitted a question but was unsuccessful in fixing the problem (Error 1236 - "Could not find first log file name in binary log index file"). ...
1
vote
2answers
102 views

Error 1236 - “Could not find first log file name in binary log index file”

Our setup: Master: MariaDB 10.0.21 Slave: MariaDB 10.0.17 Replication was working fine until recently at which point the slave's DBs had to be restored from a dump. I performed all of the ...
0
votes
1answer
269 views

indexable JSON datatype in MySQL/MariaDB

In PostgreSQL 9.4 there is a JSONB datatype which allows you to index on fields in the stored JSON objects. Does MySQL/MariaDB have an equivalent? I'm specifically interested in the MariaDB Galera ...
0
votes
1answer
615 views

Mariadb Galera Cluster using Xtradb backup is not working

I am trying out the first test of MariaDB Galera cluster setup without success. This is the error in the log innobackupex: Created backup directory /tmp tar: -: Cannot write: Broken pipe tar: Error ...
0
votes
3answers
67 views

Combine WHERE NOT EXISTS with ON DUPLICATE KEY UPDATE

I have 2 tables params and params_exceptions where params is supposed to be updated frequently by an external script. INSERT INTO params (extension, type, subtype, paramvalue) VALUES ('12345', 'FRNR1'...
1
vote
0answers
16 views

mysql/mariadb - prepared statement to create schema for users

I have the following scenario: mariaDB (mysql Ver 15.1 Distrib 5.5.49-MariaDB to be exact - I could bug the sysadmins to update if necessary) I want users to be able to create their own, distinct ...
1
vote
0answers
72 views

LEAST with 'if' condition brings timestamp instead of date

I was testing some new code in my server 1 and everything was just fine. When I sent my code to my server2 [Ver 15.1 Distrib 10.0.22-MariaDB, for Linux (x86_64)] , which is almost the same as server1 [...
0
votes
0answers
24 views

WSREP: Requesting state transfer failed: -11(Resource temporarily unavailable)

We have a 3 node Galera cluster. Only one node has "valid" data (gal-1). The other nodes need to sync from this node. I delete datadir and start MariaDB. 160527 14:28:20 [Note] WSREP: discarding ...
1
vote
1answer
31 views

MySQL trigger to update a key if record exists

I'm trying to build a trigger in MariaDB to follow this logic: 1. If the primary key val exists, increment the counter column 2. Else, insert the primary key into the table Here is my prosed ...
1
vote
1answer
374 views

Galera, MariaDB and multiple datacenter

Looking into using Galera and MariaDB across 3 data centers. We have a metroE comnection between the sites. Connectivity is pretty stable, but my concern is if a WAN link goes down at one of the sites,...
0
votes
0answers
37 views

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

I try to use this on my vps with mariadb: # Optimized MySQL configuration for cPanel servers by Fotis Evangelou - Updated Feb 2016 # # The settings provided below are a starting point for a 4GB-8GB ...
1
vote
0answers
30 views

'mysqlcheck' hangs over a database

Sometime ago I noticed my WordPress sites wont load. I found the problem with MySQL. The server I am running on is a VPS server with: Debian 8.1 MariaDB - Ver 15.1 Distrib 10.1.14-MariaDB 2048 MB ...