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
-2
votes
1 answer

Running on two servers vs. one with more memory?

I currently have one small VPS which I am using to host a Wordpress site (Nginx,PHP5,MariaDB). I have started to run into some memory issues (DB crashes) indicating it's probably time to move to a larger VPS. I have two options: I can upgrade the…
matthew
  • 1,319
  • 1
  • 11
  • 21
-2
votes
2 answers

MySQL does not start anymore

unfortunately I am unable to start mysql after reboot: root@server:/etc/mysql# systemctl status mysql.service ● mysql.service - LSB: Start and stop the mysql database server daemon   Loaded: loaded (/etc/init.d/mysql)   Active: failed (Result:…
MyFault
  • 913
  • 3
  • 15
  • 36
-2
votes
1 answer

MariaDB will not start on reboot after changing data directory

I'm running a local vagrant setup with Centos 7. I recently changed the data directory to persist data across destroys of the box. However, now MariaDB will not start on reboot. My setup is as follows. .cnf file in /etc/my.cnf.d (definitely being…
-2
votes
1 answer

MariaDB service won't start on FreeBSD jail

Just set up a dedicated database jail running databases/mariadb55-server and for some reason it won't start on demand nor on boot. Any suggestions? # service mysql-server start Starting mysql. /usr/sbin/daemon: Permission…
dzhi
  • 800
  • 3
  • 10
  • 26
-2
votes
1 answer

Backup/Recovery like barman for MySQL

I'd like to have a Backup/Recovery tool for MySQL (MariaDB/Percona) servers which has somehow the same features as barman has for postgresql take full backups on a regular basis (xtrabackup, but cool life with others too) collect binary logs (copy…
m.sr
  • 1,060
  • 1
  • 8
  • 19
-2
votes
1 answer

Partitioning Mariadb small error on https://mariadb.com/kb/en/range-partitioning-type/

Please correct me but I've located a small error on the Mariadb documentation on https://mariadb.com/kb/en/range-partitioning-type/ The second example under Use cases has a superfluous UNIX_TIMESTAMP in the PARTION BY RANGE line. As the column…
theking2
  • 179
  • 1
  • 1
  • 9
-3
votes
1 answer

Can't restart MySQL server on CentOS 7 because of mariadb.service failing

I have MySQL server installed on a CentOS 7. However, I stopped it once and now I can't restart it because I get this error: Failed to start database : Redirecting to /bin/systemctl start mariadb.service Job for mariadb.service failed because the…
Cain Nuke
  • 77
  • 1
  • 1
  • 3
-3
votes
2 answers

Can Varnish be deployed to front end mariadb/mysql server pool? Or is varnish helpful only when frontending HTTP servers?

Can Varnish be used to front end a pool of mariadb/mysql servers? I see that it does not handle any non-http requests and gives 503 error.
pvpk
  • 1
-3
votes
1 answer

How to recover a maria db password

I am using maria db for long, and now one of my servers had a necessity of being restored, how can i recover the db password The server is a centos 7 server
-4
votes
1 answer

MariaDB on Centos7, service still called MySql

I have a Centos 7 server. Removed previous MariaDb 5.5 and installed MariaDb 10 following https://mariadb.com/kb/en/mariadb/yum/ Added the MariaDB YUM Repository,and then executed: sudo yum install MariaDB-server MariaDB-client All good, then when…
Gordon Hickley
  • 101
  • 1
  • 3
-4
votes
2 answers

How to recover MariaDB database after a failed update?

Due to a failed update, now my VPS system is broken. I can only access to my files with rescue mode. So, where does MariaDB store his .sql files? So I can make a backup. The update was made by my vps provider. And they didn't said to me that they…
-5
votes
1 answer

How do I fix my PHP/MariaDB installations?

I ran the clear_iredmail script found here: http://www.iredmail.org/forum/topic333-iredmail-support-faq-how-to-uninstall-iredmail.html and accidentally deleted some important config files (and more) on my CentOS6 VPS. Fortunately CentOS keeps some…
m3hr
  • 1
1 2 3
55
56