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
0
votes
2 answers

MariaDB Maxctrl Not Responding CentOS 7

I'm working on setting up a MariaDB 3 Node Cluster and using Maxscale as the proxy. I had set up a practice config on some local KVM machines, worked without a hitch. So I went to spin up the production servers and I'm getting an error I can't make…
Aaron Chamberlain
  • 381
  • 1
  • 3
  • 13
0
votes
0 answers

Could not connect to domain:3306 : Read timed out java.net.SocketTimeoutException: Read timed out

I'm using centos 7 and MariaDB 11. I was connected to my database and it worked fine. but now I got this error message: Could not connect to domain.com:3306: Read timed out java.net.SocketTimeoutException: Read timed out My IP is not blocked and my…
user254039
  • 101
  • 1
0
votes
1 answer

I installed by mistake MySQL version 10.5.0-MariaDB is EOL software, what should I do now server is in production?

I've installed MySQL version 10.5.0-MariaDB is EOL software by mistake what should I do now server in production? What should i do ? wait for a new release since everything seems to be working fine. Or what you guys suggest ? Is it even possible…
Wed
  • 15
  • 9
-1
votes
1 answer

Maria Performance Tuning: HyperThreading is great for marketing, lousy for performance

I'm looking into optimizing my database server and this is what I read in Maria's official documentation here. How true is this? More so, how is this true? Apologies if this is not the best place to ask this question. Please redirect me.
ystark
  • 109
  • 2
-1
votes
1 answer

Can not import table to MySQL database on linux

I am trying to install cacti. When I want to import mysql_test_data_timezone.sql to MySQL database on Linux CentOS, I get an error. My command is mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql I get error No such a file or…
Cebrayil
  • 11
  • 4
-1
votes
1 answer

mariadb service fail to start after reboot

I'm trying to get mariadb 10.2/10.3 to work on a fresh installation of ubuntu server 6.04 which comes with mysql 5.7. The installation process goes fine and everything works fine untill I reboot the system, then mariadb service won't start anymore…
Avi
  • 1
  • 1
-1
votes
1 answer

What's `/var/log/mariadb/mariadb.log` in centos 7?

My system is centos 7 with mariadb 5.5.60. ####LOG#### log_warnings=1 log-error=/var/log/mariadb-err.log ####slow log#### slow-query-log=1 long_query_time=5 slow-query-log-file=/var/log/mariadb-slow.log That 's all about log in my /etc/my.cnf. …
kittygirl
  • 945
  • 5
  • 13
  • 33
-1
votes
1 answer

Can't start mysql after installing mariadb

I have just installed mariadb but when I do sudo mysql the I get this error: ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded. i have looked online for fixes but I cannot find any that actually work.
Matthew Tranmer
  • 139
  • 2
  • 3
  • 7
-1
votes
1 answer

RDA firewalld exception?

I'm using CentOS-7 and configuring two servers to run OTRS System, but the Database Server Firewall "Firewalld" is dropping the Application Server requests for RDA "Remote Database Access". Because when i stop the firewalld service, database is…
Shnbook
  • 11
  • 2
-1
votes
1 answer

Cannot log in to the MySQL server after hosting company restarted my server

Today my hosting company decided to patch their systems due to Meltdown/Spectre and restart all servers. I had my CentOS 7.2 server running for 280 days with no problems of any kind at all. But now I can't use my website anymore, it says "Error…
Karl
  • 99
  • 4
-1
votes
1 answer

MariaDB generating INDEX_*.ibd files, racking up server space

Little bit of context before diving into the issue, I have a Wordpress based blog running on 1 GB (RAM), 20 GB (disk space) linode instance. The database itself is around ~105 MB. Recently, I noticed that the entire disk space was used (from ~4 GB)…
Paritosh
  • 99
  • 2
-1
votes
1 answer

MariaDB keeps quitting when I run it via Supervisord

I'm trying to set up a LEMP stack in rkt (with Docker files), so I'm using Supervisord to get everything running in the same container. When I build and start the Mariadb container separately, it works fine. As soon as I try to run it via…
Darakir
  • 11
  • 4
-1
votes
1 answer

Best Method to Migrate /www Folder and mariadb

I have a server running under Centos 7 with Raid 10 SATA disks (4TB), I have MSA2040 and created a volume for my server (Raid 6 - 10TB SAS). I have formatted and created partition to be able to use this volume on my server. Now I am able to use it…
Lunatic Fnatic
  • 237
  • 1
  • 6
  • 11
-1
votes
1 answer

Missing File: /etc/init.d/mysql or /etc/init.d/mysqld does not exist

We are running mySQL on a Fedora Linux fc19. I have a few corrupt event table errors like in this ticket: mysqldump error #1557: corrupt event table? However, when I to to run step two, "/etc/init.d/mysql restart", restarting mysql bash returns the…
-1
votes
1 answer

How to determine why MySQL is crashing

I have a VPS running a Ubuntu 16.04.1 LAMP stack and I recently started getting a problem where MySQL (MariaDB) will stop working (the static content from my sites is still served, but the database is down). I suspect it might be lack of memory…