How can I replace MySQL with MariaDB on production server?

4 posts / 0 new
Last post
#1 Fri, 08/01/2014 - 09:09
jimdunn

How can I replace MySQL with MariaDB on production server?

How can I replace MySQL with MariaDB on production server?

I'm running Debian 7.6
And I installed Virtualmin using install.sh

Thu, 08/30/2018 - 21:28
Francewhoa
Francewhoa's picture

How can I replace MySQL with MariaDB on production server?

@jimdunn :) It's possible but challenging, lots of work, and risky depending on your configuration. If you consider yourself an advanced user there are related comments at:

There is a much easier, more stable, and safer option. Find my other comment #3 below.

- - -
Senior Product Manager, and Co-Founder at Ubertus.org Inc.
Love back your Virtualmin & Webmin community

Thu, 08/30/2018 - 21:44
Francewhoa
Francewhoa's picture

How can I replace MySQL with MariaDB on production server?

@jimdunn :) There is a much easier, more stable, and safer option you might be interested in. Have you consider migrating your data from Debian 7.6 Virtualmin to a Debian 9.x Virtualmin? You would automatically get MariaDB. Easy.

Steps

  1. Install a fresh new Debian 9 and install Virtualmin. Virtualmin will automatically be configure for MariaDB. Because Debian 9 Stretch comes with MariaDB by default.
  2. Using your Virtualmin on Debian 7, export your data
  3. Using your Virtualmin on Debian 9, import your data
  4. Done. Enjoy :)

For those note familiar with MariaDB, some of the benefits you get are listed at https://www.virtualmin.com/comment/797061#comment-797061

- - -
Senior Product Manager, and Co-Founder at Ubertus.org Inc.
Love back your Virtualmin & Webmin community

Fri, 08/31/2018 - 09:34
jimdunn

Um... this was from 2014... I'm on Debian 9 now... : )

Topic locked