LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   mysql vs mariabd (https://www.linuxquestions.org/questions/linux-server-73/mysql-vs-mariabd-4175502820/)

dyto 04-24-2014 05:10 AM

mysql vs mariabd
 
hello
is it better to use mariadb for my mailserver?
also to keeb db on RAID 5 will it degrade performance? or better is tu use mirror RAID.

tronayne 04-24-2014 07:53 AM

MariaDB is a drop-in replacement for MySQL. See https://mariadb.com/kb/en/mariadb-ve...compatibility/ for details.

In my experience, the switch from MySQL to MariaDB was transparent, I had zero problems with existing MySQL data bases, some stand-alone, some LAMP. Nothing, everything just works.

For more details, see https://mariadb.org/.

I would think that your existing data base(s) on a RAID 5 array would not be affected -- I don't know that for certain, but I would think that you should not have any problems.

Hope this helps some.

eklavya 04-28-2014 01:41 AM

Just Take a look
https://mariadb.com/products/mariadb/mariadb-vs-mysql
http://www.admin-magazine.com/Articl...iaDB-vs.-MySQL

emaderam 04-28-2014 11:26 AM

MySQL is the most widely adopted database technology for enterprise and web applications in the world. It has proven to be a flexible, powerful, and cost-effective alternative to proprietary databases, and MySQL technology is central to the architecture of the Internet. MariaDB builds on that legacy with enhancements designed to handle even more complex database challenges born of today’s fast-moving, web-scale, always-on mobile Internet. MariaDB is a enhanced, high performance, free and open source alternative to MySQL that helps the world's busiest websites deliver more content faster.

dyto 04-28-2014 11:31 AM

thank you are good people helping each other. I will help also others as you do :)

szboardstretcher 04-28-2014 11:35 AM

Mysql/MariaDB sql clustering is terrible. It is so bad, and so worthless, that we had to re-architect an entire system to use CouchDB. And the CouchDB cluster was simple to set up and roll out.

Before you lock yourself into a SQL that cannot cluster over many datacenters, you might want to look into one of the Json document stores that can cluster over a great number of datacenters and geographical locations. A quick search of the preferred databases of the biggest companies with the most data, will show you that SQL is falling out of favor fast.


All times are GMT -5. The time now is 03:32 AM.