MySQL v MariaDB

[kevin plummer]

Hi All,

I'm looking to move away from MSSQL Server (due to the high licensing costs) and was looking to move to MySQL but someone suggested MariaDB as an alternative. Just wanted to see if anyone was using either and what odbc driver they used and their experience with either.

Cheers,

Kevin

[Stu]

Would be very interested to hear about this too, thanks for asking the question Kevin!

[Bruce]

Personally I'd choose PostgresQL over MySQL or MariaDB. Or possibly even Firebird. (I've used both.) Postgres is more of a "big boy" so is suitable for installs you have control over, Firebird is better for deployment to many customers. The Clarion community is reasonable for both, so both are pretty well supported.

The licensing for MySQL is really unclear. So I'd probably pick MariaDB out of the two of them. However I don' have any experience with either.
Back in the day when I did some research MySQL was inferior in most ways (although was more popular in the general public's mind.) I'm sure it's come on since then though.

cheers
Bruce

[kevin plummer]

Bruce, thanks for your thoughts. I think MySQL has come a long way since you probably last looked at it from my reading. The licensing is a bit muddy and probably why more people are moving to MariaDB.

The install will be under my control for cloud based applications but I need 24/7 HA with no human intervention.

My attraction to MySQL and MariaDB apart from the licensing is the HA and creating nodes of Master DB's o create redundancy and HA.

Cheers,

Kevin

[agustinh2000]

Hi Kevin, I'm using mysql four years ago and the truth that I had no problems, have now updated to version 5.7.9 servers. with 5.1 ODBC connector. Currently I have not updated the connector 5.3 because I had some problems with the FM3.

If you have any specific questions feel free to ask.

Cheers

Agustín

PD: If you do not understand something it is the fault of the translator google (:

[kevin plummer]

Thanks for the reply Agustin. Have you got replication, HA setup with master\master server Clusters?

[agustinh2000]

Kevin, I have no experience in replication. There has been presented the opportunity. I would learn how to configure clustering with mysql.

Agustín

[kevin plummer]

and final question, are you running MySQL on a Linux box and if so what Linux version?

[agustinh2000]

Kevin am currently using windows (virtualized) under  linux (centos). I have not had any problem.The webserver and mysql are installed on Windows, but as I heard the performance is much better if you install MySQL on Linux. I'll try soon as it is not complicated !.

Agustín

[kevin plummer]

Thanks - I heard that about Linux as well and was thinking of using Debian. I'm keen to set up a MySQL Galera Cluster with a floating IP address.