Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog Archive Cutedge

by: Bernard Teo

Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

The Ultimate Business Machine - Archives

List of Categories : Database * Technology * Commentary * Singapore * Travel *

Mon 20 Aug 2012

MariaDB Installer on Mac OS X Mountain Lion

Category : Technology/MariaDBOnMountainLion.txt

I've been wanting to do this for a while now. I've finally been able to build a Mountain Lion Installer for MariaDB, which is a "drop-in" replacement for MySQL.

As the word "drop-in" implies, you can use MariaDB, once it's installed, like you've always been using MySQL. MariaDB pretends to be MySQL and it will execute all the usual mysql commands, without your having to change a thing.

This version of the installer installs MariaDB-5.5.25 (the latest I can find) into /usr/local/mariadb-5.5.25 and makes a symlink to /usr/local/mysql which, in fact, points to /usr/local/mariadb-5.5.25.

So, all the mysql commands just work. Like if you do a 

mysql --version

in the command line, you will get :

Server version: 5.5.25-MariaDB Source distribution

and a MariaDB command prompt, but other than that you can work like you've always done in MySQL.

If you have a working MySQL database, like one that was installed by our own MySQL installer, the MariaDB installer will attempt to move your current databases over (if you choose to do the Upgrade option, rather than a Clean Install).

Finally, because MariaDB's command gets called when you execute /usr/local/mysql, even the MySQL Start Up Preferences Pane (that we've built together with our MySQL installer) continues to work.

So, what's the point of all this?

Well, many develoeprs are concerned over the future of MySQL, now that it's in the arms of Oracle. The existence of MariaDB, brought into life by the original developers of MySQL, gives hope that a free, independent, quality, database option continues to be available, should Oracle decide one day to close-source or worse kill, if it comes to that, MySQL.

So, this gives us a third option to work with—MySQL, Postgres and now MariaDB. I've just tested Liya (our friendly database table editor) with MariaDB and it continues to work. If MariaDB is running on your server instead of MySQL, simply choose MySQL as the database option to access your new MariaDB database.

Obviously, in this arrangement, MySQL has to be stopped from running, in order to have MariaDB run and impersonate it.

Maybe a future version of our installer will allow MariaDB to be run on another port alongside MySQL. But I will have to improve Liya so that it will accept a port number as a connection option. (Currently it doesn't have such an option.)

So, I hope now to use more of MariaDB and see what I can learn from it. If you do download the Installer, let me know if it works for you and also what you think of MariaDB. 

Posted at 8:59AM UTC | permalink

Put your Mac to Work Now how would you do something like that?

Weblogs. Download and start a weblog of your own.

A Mac Business Toolbox
A survey of the possibilities

A Business Scenario
How we could use Macs in businesses

VPN Enabler for Mavericks

MailServe for Mavericks

DNS Enabler for Mavericks

DNS Agent for Mavericks

WebMon for Mavericks

Luca for Mavericks

Liya for Mountain Lion & Mavericks

Postfix Enabler for Tiger and Panther

Sendmail Enabler for Jaguar

Services running on this server, a Mac Mini running Mac OS X 10.9.2 Mavericks:

  • Apache 2 Web Server
  • Postfix Mail Server
  • Dovecot IMAP Server
  • Fetchmail
  • SpamBayes Spam Filter
  • Procmail
  • BIND DNS Server
  • DNS Agent
  • WebDAV Server
  • VPN Server
  • PHP-based weblog
  • MySQL database
  • PostgreSQL database

all set up using MailServe, WebMon, DNS Enabler, DNS Agent, VPN Enabler, Liya and our SQL installers, all on Mavericks.