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

learn more… | top users | synonyms

2
votes
1answer
124 views

The right way of starting up a Galera Cluster

I am confused about the bootstrap process of MariaDB Galera Cluster. Let's say we have 3 nodes of a MariaDB Galera Cluster, working and functioning normally on CentOS6/7. However, at some point we ...
0
votes
0answers
13 views

Converting ARIA table to Innodb remove PAGE_CHECKSUM option

In the process of converting ARIA tables to InnoDB engine. I need remove the PAGE_CHECKSUM table option that is not used on non-mariadb server. ALTER TABLE table_name, ENGINE=InnoDB ...
0
votes
0answers
9 views

'/etc/init.d/mysql start ­­wsrep­sst_donor=node1' with systemctl (pass WSREP options)

With classic init.d you can pass startup options. /etc/init.d/mysql start ­­wsrep­sst_donor=node1 How to do the same with RHEL7 and systemd (systemctl start mariadb). We use Red Hat provided ...
0
votes
0answers
53 views

How to do rolling upgrade MariaDB 10.0 -> 10.1 on ubuntu 14

I'm trying to figure out how to do a rolling upgrade of our galera cluster running on MariaDB on Ubuntu 14.04. In testing, the first node I upgraded started complaining about the timestamp column in ...
0
votes
0answers
33 views

Slow Join queries using Spider-Storage-Engine on MariaDB

Using: MariaDB 10.1.12 Spider 3.2.27 How can I tell my Spider node to do the JOIN queries on the remote host instead of trying to join over the network one by one? I'm using a query that looks ...
1
vote
0answers
31 views

Using Galera-Replication, what's the use in having a GTID associated with your backup?

On the topic of using a backupscripts the documentation for galera-cluster states that: You can use backups of this kind to recover data, but they are insufficient for use in recovering nodes to ...
0
votes
3answers
47 views

How to detect level in nested MySQL table? [duplicate]

I have simple child-parent relation by saving parent_id. Is it possible to count which level each entry? My DB looks like this: As You can see from the image, for example the first item relation ...
1
vote
0answers
9 views

need to calculate max_connection

I am trying to calculate max_connections. I already have a formula for it from this forum only which is max_connections = (Available RAM - Global Buffers) / Thread Buffers I am not sure with ...
0
votes
1answer
47 views

Mariadb sql query get stuck

I have table A which size is 32GB and has the following 5 fields: a (int) b (varchar(128) c (varchar(128) d (int) e (int) a, b and c are unique key. Now, when I query like this: select * ...
1
vote
1answer
72 views

How can I randomize primary key values?

I need to avoid having my primary keys sequential. Basically looking for this in MySQL: https://wiki.postgresql.org/wiki/Pseudo_encrypt
1
vote
4answers
59 views

User privileges error on server maria db Create trigger Drop trigger

User privileges error on server maria db User : user1 DB : db1 Error 15:00:46 DROP TRIGGER IF EXISTS audit_trigger Error Code: 1419. You do not have the SUPER privilege and binary logging ...
0
votes
0answers
17 views

innotop “Command Summary”

We provide DBaaS. This is innotop C output: We have only 8% read workload? The rest is write? I don't understand this is very uncommon workload for DBaaS? Statistics since last restart? What is ...
1
vote
0answers
329 views

Negative InnoDB Write Log efficiency in mysqltuner.pl results

I noticed something strange in results from mysqltuner.pl. I see this in mysqltuner output from three of my four servers with MariaDB 10.1.12: [OK] You have the latest version of ...
0
votes
0answers
28 views

mariadb can't import sql which contains \' in insert statement

i export a large db from mysql5.6, then i import into a mariadb (xampp) on my localhost by command line C:\Windows\System32>C:\xampp\mysql\bin\mysql -u root -p dbname < D:/folder/filename.sql ...
1
vote
1answer
110 views

How can I efficiently optimise MariaDB?

I am running a 24 GB KVM with 8 Xeon 3.2 SSD RAID 0. And I would like to get the most from my MariaDB sql server. I am using following my.cfg # # This group is read both both by the client and the ...
1
vote
1answer
74 views

MySQL. Capture Cis program makes incorrect query: SELECT DISTINCT “PartType” FROM “Capacitor” ORDER BY “PartType”

I am having problems to get one database running. I have a MySQL in my server, the server is running "5.5.48-MariaDB - MariaDB Server" with "UTF-8 Unicode (utf8)" I have a MySQL ODBC 64 bits 3.51 ...
2
votes
1answer
40 views

Keywords and reserved words: What's a poor boy to do?

We have been using MySQL since its beginnings. Back then we thought that descriptive column names were a good idea. So we created columns like date, open, high, low, close, volume, signal and so on ...
1
vote
1answer
25 views

right join leaving one row from right table

I am using MariaDB,in my sample database I am having two tables department and emp. I want to display all the department having less than 50 employees. In this case it should display all the ...
0
votes
0answers
16 views

What is the most efficient way to represent this relationship?

In the database a user can follow many different users. I'm looking for an efficient way to represent this. In the image above you can see my initial idea. This works however results in duplicated ...
0
votes
1answer
29 views

MariaDB: calculate the reads/writes ratio in percent

I found a blog post howto calculate the reads/writes ratio in percent. I receive NULL values in our env. > SELECT @total_com := SUM(IF(variable_name IN ('Com_select', 'Com_delete', 'Com_insert', ...
2
votes
1answer
52 views

Hybrid Synchronous / Asynchronous Replication?

We have a situation where we would like to have synchronous replication in our main data center, but replicate asynchronously to another region. Our second data center is 3,000 miles away (Site B) and ...
0
votes
0answers
24 views

MariaDB Galera cluster write all nodes

I've setup a MariaDB Galera cluster. It replicates OK, and works OK. I want to be able to allow inserts in all the cluster nodes, not only on the first node, and right now, I can't do it. It allow ...
1
vote
1answer
25 views

Changing tx_isolation and binlog format on master server - do i also need to adjust slave?

We are running a Drupal Commerce site with MariaDB 10.0 and master/slave replication. Because of the way our application works, we end up running in to a ton of deadlocks under heavy load. Apparently ...
1
vote
1answer
65 views

High Availability for MariaDB and Postgres : replication or active-passive (SAN)

During the last weeks I did a lot of research on High Availability for Postgres and MariaDB. Both by my own research and also recommended by vendor's, replications seems to have more advantages. Some ...
0
votes
0answers
37 views

Improving slow queries, slow query log attached

I am running MariaDB under Cpanel and hosting Wordpress websites. My slow query log has reached ~400MB in size, and I would like to know how to eliminate the DB issues. Link to the slow query log. ...
0
votes
0answers
63 views

MariaDB engine choice (Aria vs. XtraDB

I am trying to choose the better of two engines for my particular application: I want to have the DB in Raspberry Pi 1 model B, on a USB pendrive. Limitations are pretty obvious: slow storage access, ...
2
votes
1answer
156 views

ERROR WSREP`: gcs/src/gcs.cpp:gcs_open():1379:` Failed to open channel 'test_cluster'

I have three server that I want to Install Galera clustering on them, I followed this link to install and config it. but when I want to start the first server I got this error : ...
0
votes
0answers
39 views

Mariadb Prepared Statements stopped working, they were OK last week, I need help locating the issue

I have a number of stored procedures that were working perfectly well last week, but this week are causing me problems. The first problem is I seem to be getting the following: Mariadb SQL ...
2
votes
1answer
46 views

MySQL is too slow

I have a project with PHP/Laravel/MariaDB, the DB is getting bigger every day now some tables has 4kk+ records already Server is 4GB RAM + Ubuntu 14.04 + Apache (DigitalOcean) when I only start the ...
1
vote
1answer
129 views

MySQL cluster write performance with Galera (MariaDB)

I am currently evaluating the migration from our current database server to a three node cluster. Our current server is a VM running MariaDB 10.1 with asynchronous replication to another server in ...
0
votes
2answers
45 views

at the moment mysqldump (22 minutes exec time, 5 GB Dump), when to use xtrabackup?

We use the Puppet code for deploying MariaDB. Those are the backup options. mysql::backup::mysqldump: Implements mysqldump backups. mysql::backup::mysqlbackup: Implements backups with Oracle MySQL ...
0
votes
0answers
57 views
0
votes
0answers
40 views

Query result different between MySQL(4.1.22) and Maria(10.1.X)

Im trying to change DB of an application from MySQL(4.1) to MariaDb(10.1.X). During my testing, I came across a strange issue. Return value of a certain query is different between mysql (4.1.22) and ...
0
votes
0answers
98 views

MariaDB: Can't connect to MySQL server on '127.0.0.1' (107)

What does it mean the error 107? Can't connect to MySQL server on '127.0.0.1' (107) I haven't found this error in any documentation: https://mariadb.com/kb/en/mariadb/mariadb-error-codes/ ...
0
votes
0answers
29 views

Unexplained MariaDB/MySQL memory jump

All of a sudden the memory usage of my MariaDB instance has jumped from around 1.5GB to 6GB. A restart briefly solves the issue, but slowly creeps back to the peak value. Stopping all processes that ...
1
vote
0answers
54 views

MaxScale vs Fabric [closed]

I am looking to expand my single MySQL database into multiple instances to provide High Availability. As well, I am looking to be able to have read replicas and to shard in the future. I have looked ...
1
vote
1answer
38 views

Galera cluster: change the size of InnoDB Redo log files online?

We have a 3 node Galera cluster. I need to change the mysqld innodb_log_file_size parameter (see Changing the Number or Size of InnoDB Redo Log Files). I do this by stopping all 3 nodes and ...
0
votes
1answer
55 views

How does InnoDB represent composite integer keys?

Let's say I have the following table: Create Table Orders(server : tiny int, ticket : integer, primary key (server, ticket)); How is the composite primary key representation when stored on disk? ...
0
votes
0answers
37 views

SQL Joining across multiple tables

I'm trying to query across multiple queries at once, it is fairly easy to run queries one after the other but that is not what I should be doing in this case. I have one free variable and the rest of ...
4
votes
1answer
98 views

MariaDB database access using roles

I run MariaDB 10.0.23, and I use roles to grant privileges to users. I have a user john: +-------------------------------------------------------------------+ | Grants for john@% ...
1
vote
0answers
11 views

Need advice on storing pincode system (Zip code) and Shipping company Service Details

I am in the process of creating a system that could identify shipping companies (Fedex, UPS, etc.) from a given pincode (zip code) for a e-commerce platform. The shipping companies will provide a ...
0
votes
0answers
65 views

How can I avoid this deadlock in MariaDB?

I saw that I got a deadlock in a MariaDB cluster. I have 3 cluster database. What should I do to avoid that? 160211 16:29:02 *** (1) TRANSACTION: TRANSACTION 75AB6B17, ACTIVE 0 sec starting index ...
0
votes
0answers
42 views

MariaDB: inner join searching for 1 in TINYINT column not working

Since yesterday I've been trying to make a query work. I have two tables: image where I store information about images and imagehit where I store information about how many times those images are ...
0
votes
0answers
33 views

simple math with SELECT - no resulting row

Simple math with SQL don't give a result. There is written 1 row in set, but I don't see the result/row. MariaDB [(none)]> select 5242880 / 1024 / 1024 as current; 1 row in set (0.01 sec) ...
1
vote
1answer
46 views

Changing IP address from existing Mariadb10.1 Galera Cluster

I have a multimaster cluster with MariaDB Galera working properly, it is set to perform the replica through its WAN interface. This configuration was a result of a previous migration from another ...
0
votes
0answers
44 views

Is there any reason to use Innodb over Aria for wordpress?

Is there any reason to use Innodb over Aria for Wordpress? I currently have an nginx php-fpm wordpress Mariadb stack. Aria seems like a natural fit, given my workload is 98% select statements, and ...
0
votes
2answers
32 views

How do I do a join and exclude certain records?

Table STUDENT has columns ID, LASTNAME, FIRSTNAME Table TEACHER has columns ID, TEACHER_ID, STUDENT_ID Students can have many teachers. Teachers can add students to their class. I want to be able ...
1
vote
1answer
77 views

How do Locks Work in MySQL or MariaDB

There is a case which makes me a bit confused. As far as I understand deadlocks should appear if there are two query statements (including subqueries) in request (each transaction). So the ordering of ...
0
votes
2answers
113 views

MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash

We have tables with MyISAM. The are out of sync, the number of records is different on each cluster node > select table_schema, table_name from tables where ENGINE = 'MyISAM' and table_schema != ...
0
votes
1answer
48 views

Retrieving most recent X rows for each given user from a table

We've got a seemingly simple query that's running extremely slowly, but I can't quite figure out the best solution to the problem. The scenario is as follows. We have an inbox table, which has the ...