Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mariadb]

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

MariaDB is based on MySQL and is available under the terms of the GPL v2 license.

It's developed by the MariaDB community with Monty Program Ab as its main steward.

MariaDB is kept up to date with the latest release from the same branch.

In most respects will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB. There is no need to convert databases to switch to MariaDB. MariaDB is a true drop in replacement of MySQL! Additionally, MariaDB has a lot of nice new features that you can take advantage of.

See the MariaDB FAQ for more information.

See also:

837 questions
-1
votes
1 answer

MySQL on iscsi drive CentOS7 wont start on boot

I configured Mariadb on CentOS 7 to run on iscsi drive mounted on /mnt/iscsi, but it wont start on boot with following error (it can be started manually): mariadb.service - MariaDB database server Loaded: loaded (/etc/systemd/system/mariadb.service;…
Hikaru
  • 73
  • 11
-1
votes
1 answer

MariaDB 10.0.4 different mysqlclient reported

I use MariaDB-server 10.0.4 on my CentOS 6.4 64-bit server. PHPMyAdmin shows: libmysql - 10.0.4-MariaDB While phpinfo shows: Client API version 5.3.12-MariaDB Why I got two versions ? How to change Client API version to 10.0.4 ? I got…
Spacedust
  • 568
  • 5
  • 13
  • 28
-1
votes
1 answer

MariaDB Galera Clustering - Active Active - Operation not permitted error

I am having issues with MariaDB and Galera running on RHEL 6.4 & 6.2 64bit servers and getting them to cluster. I installed the required RPM's for Galera…
FilBot3
  • 234
  • 4
  • 18
-1
votes
1 answer

Mysql MariaDB replication broken

I have a primary DB and two replicates. replicate1 became corrupted when the linux server was rebooted without stopping mysqld. I want to load replicate1 with a dump I've taken from replicate2 with the command mysqldump --master-data…
Raul Matas
  • 1
-1
votes
1 answer

Improving Database Performance

I've heard that you can do something like the following in my.cnf to get better performance: tmpdir = /dev/shm I'm running MariaDB and wondering is this a good idea? All it does it create the temporary tables in memory and not disk correct. Do I…
Tiffany Walker
  • 6,681
  • 14
  • 56
  • 82
-1
votes
1 answer

MariaDB - Emulate MySQL 5.7 version number?

I have been running MariaDB 5.5 on a linux server for several years. Yesterday, I upgraded to MariaDB 10.11.3. Now, my backup software has stopped backing up the databases, reporting an error that "MySQL 10.11 is not supported". Since the backup…
Ryan Griggs
  • 963
  • 2
  • 14
  • 29
-1
votes
1 answer

When will Amazon RDS suport MariaDB > 10.6?

RDS has historically added support for new mariadb releases within a year, but they seem stuck on 10.6 and haven't added the new 10.7, 10.8, 10.9, 10.10, 10.11, which are all GA. MariaDB did change their policy and only provide 1 year support for…
ysth
  • 129
  • 1
  • 10
-1
votes
1 answer

Ports closed remotely while they are open locally

i have a problem with a mariaDB server, the port is locally open, but on a remote desktop, the port appears closed. Port Status service 3306/tcp open mysql ^^^^ localhost output Port 3306 is closed on (my IP) ^^^^ remote…
kuba42
  • 1
  • 2
-1
votes
1 answer

How to Mirror MariaDB schema into Mysql?

We are using MariaDB for our main service and Mysql on another for our ATM machines, I trying to fetch all the data and to have all the transactions available. I don't know if this is possible because Mysql and MariaDB are not the same... We also…
ikenas
  • 131
  • 3
-1
votes
1 answer

Error upgrading mariadb-10.1 to 10.2 on debian 9

What about this error? upgrading on debian 9 with plesk from mariadb 10.1 to 10.2 Any clue how to fix it and continue upgrade? apt install mariadb-server-10.2 Reading package lists... Done Building dependency tree Reading state information...…
Sam Provides
  • 109
  • 1
  • 4
-1
votes
1 answer

Fixing crashed MariaDB databases on a cPanel server

I have a small cPanel server which I use for my clients' projects and my own personal projects. This is also shared among a few of my friends who chime in to keep the disks spinning. Recently I've noticed a huge increase in CPU usage for mysql and…
CodingSomething
  • 109
  • 3
-1
votes
2 answers

PHP not connecting to my database on Linux?

I use mariadb as my database and phpmyadmin to access on databases web on Linux. Although I am able to connect to the database on the commandline as root but cannot check connection to the database with PHP? I am unsure if there's something I'm…
TJH
  • 1
-2
votes
1 answer

Is OK to delete the MySQL database files directly on the server?

So, I need to free up some space on our database server. On investigation it looks like lots of space is being taken up by MariaDB/MySQL databases that are no longer used (snapshots and defunct applications). I want to delete those, but due to…
Mikey C
  • 39
  • 6
-2
votes
1 answer

MariaDB Optimization

I've a Single Core, 1GB RAM server on DigitalOcean. OS: CentOS Linux release 7.4.1708 (Core) mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1 No other services on this server. Config…
Sanjay
  • 63
  • 2
  • 8
-2
votes
1 answer

Access denied for user 'john'@'gateway' (using password: NO) MARIA DB

My os are linux. I got denied to access db server from web server. I have built database with name is test. I also already created user with name 'john'@'10.0.0.1' with password 'pass' and set all privileges to the database test. For another…
Prox40
  • 1
  • 1
  • 1
1 2 3
…
55
56