Stack Overflow
Stack Overflow

Questions tagged [mariadb]

MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.

MariaDB is an open source database server that offers drop-in replacement functionality for .

This MySQL fork has been made by its own original developers, triggered by doubts over the future management of MySQL after its acquisition by Oracle (through Sun Microsystems) in 2009. MariaDB is now released under the , and maintained by the community with the intent to maintain a high compatibility with MySQL APIs and commands.

Supported Storage Engines:

  • ARCHIVE
  • Aria
  • BLACKHOLE
  • Cassandra (added in 10.0)
  • CONNECT (added in 10.0)
  • CSV
  • FederatedX (drop-in replacement for Federated)
  • InnoDB
  • MEMORY
  • MERGE
  • Mroonga (added in 10.0)
  • MyISAM
  • OQGRAPH
  • S3 (added in 10.5.4)
  • SEQUENCE (added in 10.0)
  • SphinxSE
  • Spider (added in 10.0)
  • TokuDB (added in 5.5)
  • XtraDB (DEFAULT, drop-in replacement for InnoDB)

Legacy storage engines:

  • Federated (still provided, but FederatedX is recommended instead)
  • IBMDB2I (removed in 5.5)
  • PBXT (removed in 5.5)

Resources:

Related tags:

13893 questions
22
votes
5 answers

How to enable large index in MariaDB 10?

In Debian Jessie I installed MariaDB server 10.0.30 and I try to increase max key length. AFAIU it depends of the config parameter innodb_large_prefix being enabled. According to the docs, it also requires barracuda file format and…
w.k
  • 8,218
  • 4
  • 32
  • 55
22
votes
5 answers

How can I access my docker maria db?

My main question is that after I have created a docker container for my mariadb with the command docker run --name db -e MYSQL_ROOT_PASSWORD=test -d -p 3306:3306 mariadb how can I access the sql db? Somewhere I have seen a solution using a temporal…
MorRich
  • 426
  • 2
  • 5
  • 15
22
votes
7 answers

Migrating from MySql: MariaDB server closing client connections unexpectedly

We in the process of migrating from MySql to MariaDB due to licensing/commercial usage reasons. We have successfully replaced the MySql connector jar with MariaDB client jar (first change) and are now trying to replace MySql server with MariaDB…
Vivek
  • 221
  • 1
  • 2
  • 5
21
votes
3 answers

MariaDB not allowing remote connections

As the screenshots show, I have the accounts setup to allow remote connections but as shown in the second screenshot I still cannot connect remotely.
ItsJamie
  • 231
  • 1
  • 3
  • 7
21
votes
7 answers

Use MariaDB instead of MySQL in my Rails project

How can I use MariaDB instead of MySQL in my Rails project? When I try to install mysql2 gem it returns error,because mysqlclient was not found. Here some solution, but I didn't found any libmariadbd-dev package on my openSUSE 12.3.
rthink
  • 213
  • 1
  • 2
  • 6
20
votes
1 answer

Why we still need innodb redo log when mysql binlog has been enabled?

In my understanding, mysql binlog can fully function as InnoDB's redo log. So, after the binlog is enabled, why does InnoDB have to write a redo log at the same time instead of just switching to use the binlog? Doesn't this significantly slow down…
ASBai
  • 724
  • 2
  • 7
  • 17
20
votes
2 answers

mariadb galera - Error when a node shutdown ERROR 1047 WSREP has not yet prepared node for application use

I installed 2 Mariadb Galera nodes (mariadb-galera-10.0.27-linux-x86_64.tar.gz) on 2 CentOs 6.6 servers. After installed, I start node1 with parameter --wsrep-new-cluster, then start node2 without this parameter. They work fine, data is…
namdt55555
  • 409
  • 1
  • 3
  • 14
20
votes
2 answers

In MariaDB how do I select the top 10 rows from a table?

I just read online that MariaDB (which SQLZoo uses), is based on MySQL. So I thought that I can use ROW_NUMBER() function However, when I try this function in SQLZoo : SELECT * FROM ( SELECT * FROM route ) TEST7 WHERE ROW_NUMBER() < 10 then I…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
19
votes
6 answers

ERROR 2002 (HY000): Can't connect to MySQL server on '192.168.1.15' (115)

I'm trying to make a MySQL database on my Raspberry Pi 4, but it isn't going very well, using localhost instead works perfectly but I want to remote control it from my Windows 10 computer on the same internet. When I create a user with the address…
Lasse Bendiksen
  • 191
  • 1
  • 1
  • 3
19
votes
3 answers

What is the default port number of MariaDB?

What is the default port number of MariaDB? I am new to programming. I am creating my first Java application that connect to MariaDB. I need to specify the database port number.
Divudi Lanka
  • 209
  • 1
  • 2
  • 6
19
votes
3 answers

how to perform a SELECT on a JSON column in mysql/mariaDB

how to apply WHERE clause on JSON column to perform a SELECT query on a table which is having two columns (id Integer, attr JSON). The JSON is nested and in the filter condition there is only one key value pair of json is allowed. This key value…
wenky
  • 471
  • 1
  • 6
  • 14
19
votes
2 answers

How to update a row based a joined table in MariaDB?

I have sql like this: UPDATE "user_login a" LEFT OUTER JOIN "p_pegawai b" ON a.id_pegawai = b.id SET a.password = 'Keluarga1' WHERE b.NIP = '195812' I have tried this : MySql Update A Joined Table but it always give me error…
Gagantous
  • 432
  • 6
  • 29
  • 69
19
votes
3 answers

MySQL/MariaDB - order by inside subquery

I used the following query with MySQL 5.5 (or previous versions) for years without any problems: SELECT t2.Code from (select Country.Code from Country order by Country.Code desc ) AS t2; The order of the result was always descending as I…
G. Plante
  • 429
  • 1
  • 5
  • 13
18
votes
2 answers

docker-compose mariadb docker-entrypoint-initdb.d sql is not executed

I am attempting to have my docker db container automatically populate the database with a dataset when created. According to the mariadb documentation, there is an docker-entrypoint-initdb.d folder in the volume that can be used for this purpose. I…
BU0
  • 609
  • 2
  • 10
  • 20
18
votes
5 answers

MariaDB: ALTER TABLE syntax to add a FOREIGN KEY?

what'S wrong with the following statement? ALTER TABLE submittedForecast ADD CONSTRAINT FOREIGN KEY (data) REFERENCES blobs (id); The error message I am getting is Can't create table `fcdemo`.`#sql-664_b` (errno: 150 "Foreign key constraint is…
user1774051
  • 843
  • 1
  • 6
  • 18
1 2 3
…
99 100