NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: kevin plummer on November 09, 2015, 03:47:19 PM

Title: MySQL v MariaDB
Post by: kevin plummer on November 09, 2015, 03:47:19 PM: 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
Title: Re: MySQL v MariaDB
Post by: Stu on November 09, 2015, 04:43:45 PM: Would be very interested to hear about this too, thanks for asking the question Kevin!
Title: Re: MySQL v MariaDB
Post by: Bruce on November 09, 2015, 09:55:45 PM: 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
Title: Re: MySQL v MariaDB
Post by: kevin plummer on November 09, 2015, 10:35:39 PM: 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
Title: Re: MySQL v MariaDB
Post by: agustinh2000 on November 10, 2015, 05:03:21 AM: 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 (:
Title: Re: MySQL v MariaDB
Post by: kevin plummer on November 10, 2015, 01:55:47 PM: Thanks for the reply Agustin. Have you got replication, HA setup with master\master server Clusters?
Title: Re: MySQL v MariaDB
Post by: agustinh2000 on November 11, 2015, 05:51:45 AM: Kevin, I have no experience in replication. There has been presented the opportunity. I would learn how to configure clustering with mysql.

Agustín
Title: Re: MySQL v MariaDB
Post by: kevin plummer on November 11, 2015, 03:31:25 PM: and final question, are you running MySQL on a Linux box and if so what Linux version?
Title: Re: MySQL v MariaDB
Post by: agustinh2000 on November 12, 2015, 07:05:39 AM: 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
Title: Re: MySQL v MariaDB
Post by: kevin plummer on November 12, 2015, 07:32:42 PM: 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.