Portal Home > Knowledgebase > Articles Database > MySQL Alternative
|Posted by prashant1979, 05-23-2014, 12:19 PM|
|Is there any alternative for MySQL when it comes to performance? I have a few servers with lot of database transactions and I feel MySQL falls short. I would like to know what are open source RDBMS alternatives for MySQL.
|Posted by WebHostingBroker, 05-23-2014, 12:37 PM|
|The obvious answer is PostgreSQL or possibly SQLite, they're both good alternative. Check this article for comparison;
|Posted by siteturn-joe, 05-23-2014, 12:46 PM|
|If you want a drop-in replacement for MySQL, check out mariadb:
It's apparently faster than MySQL and is still free.
|Posted by Sponsi, 05-23-2014, 04:29 PM|
|1 for Mariadb.
|Posted by Steven, 05-23-2014, 04:30 PM|
|We primarily use MariaDB on our deployment these days
|Posted by WebHostON, 05-23-2014, 04:31 PM|
|I would go with MariaDB. I am testing it on some servers and I am happy with its better performance compared to MySQL.
|Posted by mixmox, 05-23-2014, 04:36 PM|
|is it safe to replace mysql with MariaDB without losing data?
in directadmin or cpanel ?
|Posted by subhash, 05-23-2014, 05:53 PM|
|Percona server and MariaDB are the best alternatives for MySQL.
Although MariaDB is built on Percona XtraDB storage engine it seems to have more changes to the rest of the MySQL server itself.
|Posted by Steven, 05-23-2014, 06:43 PM|
|Yes it is.
|Posted by gingir, 05-24-2014, 07:31 AM|
|I love the way MariaDB is gaining ground on MySQL and in so short a time.
|Posted by mixmox, 05-25-2014, 12:13 PM|
|I did not work much with MariaDB .
i prefer MySQL coz i have more experience to optimize and working with it.
ive research about the advantage of Maria and most of the result is about MariaDB is better than myql, because its under GPL license however that is not!
also some of CMS support MariaDB so its not a good choice for share hosting servers
is there any difference between MYSQL and mariaDB in programming language?
MYSQL is support and developer work on it so why use MariaDB?
Last edited by mixmox; 05-25-2014 at 12:26 PM.
|Posted by subhash, 05-25-2014, 07:25 PM|
|From what I know MariaDB is almost similar to MySQL with some added bug fixes, new features, search engines, enhanced performance and scalability.
MariaDB 5.X.X works exactly like MySQL 5.X.X so I'm not sure if there would be an extensive incompatibility issue when run on shared hosting.
Also, as per WikiPedia MariaDB is licensed under GPL.
|Posted by jetorbit, 05-26-2014, 12:26 AM|
|Using mariadb in production server is good replacement for mysql, with good tuning you will get even more great performance
|Posted by WPHS, 05-26-2014, 12:58 AM|
|MariaDB is fantastic! +10 for them! We just switched to MariaDB and it gave quite a bit of a DB performance boost.
|Posted by mixmox, 05-26-2014, 05:31 AM|
|and how about configuration ?
is it as same as MYSQL by confi my.cnf ? variable are the same ?
if is better than MYSQL why most of control panel ike directadmin and cpanel decide to compile mysql by default ?
|Posted by ayksolutions, 05-26-2014, 09:32 AM|
|MariaDB gets thumbs up from me too.
|Posted by eva2000, 05-26-2014, 10:34 AM|
|1000000 for MariaDB
I use MariaDB 5.5 and soon MariaDB 10.x for out of box Centmin Mod Nginx auto installer setup. And been using MariaDB for past 2yrs for most installs.
There's a reason even major distros like RedHat (for version 7), Fedora, openSuse, Arch Linux, and Slackware are all moving over to MariaDB as default offerings (well maybe more than one reason as most think it aligns more closely with open source etc ).
But switching from Oracle MySQL to MariaDB or even Percona, isn't a magic bullet - performance still needs to be tweaked and tuned regarding MySQL settings for your specific work loads.
Settings wise there are differences particularly for InnoDB specific names for Oracle MySQL compared to MariaDB and Percona. MariaDB and Percona are more closely aligned as MariaDB uses Percona XtraDB InnoDB engine for it's InnoDB offerings by default (although you can switch to Oracle InnoDB plugin within MariaDB 5.5/10 as well if you want).
mixmox, most use whatever is default offering from the distro they use. I'm sure that will change once RedHat 7 and CentOS 7 come with MariaDB as default.
For feature comparison between Oracle, MariaDB and Percona for MySQL 5.5, 5.6 and 10 check out https://mariadb.com/blog/mariadb-10-...parison-update as well as MariaDB Knowledge Base at https://mariadb.com/kb/en/ and their blog https://mariadb.com/blog?destination=blog
|Posted by cloudrck, 05-26-2014, 09:37 PM|
|I would go with PostgreSQL 9, I find it more adapt at scaling up. If you want an almost drop in replacement for MySQL I would go with MariaDB
|Posted by stabletron, 05-27-2014, 02:54 AM|
|MariaDB or Percona. But maybe you just can optimize current config?
|Posted by jetorbit, 05-28-2014, 12:20 AM|
|They are just the same, mariadb is just a replacement for mysql and it will use same my.cnf
i thought that they are just working together with oracle(mysql) so not remove from their default installation.
|Posted by bizness, 05-28-2014, 06:01 AM|
|mariadb + gallera
|Posted by ovais, 05-28-2014, 07:12 AM|
|Your existing MySQL my.cnf will work as is and all of variables are same which is why we call MariaDB as Drop-in-replacement.
MySQL has been default for ages, it will take a while before we can see MariaDB included as an option with cPanel and DirectAdmin.
|Posted by stabletron, 05-28-2014, 08:23 AM|
|There no problems to use MariaDB or Percona with cPanel or DirectAdmin. By the way, MariaDB we can see in couple of distros as default MySQL server.
|Posted by arthur8, 05-28-2014, 12:07 PM|
|MariaDB and Percona. Both two are extremely easy to install on any server that you have and you will get a bit of instant performance boost. With an good optimization you will get a nice performance increase and stability.
|Posted by davidpaj, 06-12-2014, 07:51 PM|
|Is MariaDB compatable with phpmyadmin? Many clients use the tool
|Posted by XViD, 06-13-2014, 02:19 AM|
It is a drop-in replacement - its very core is based on MySQL and everything should work as it works with MySQL.
|Posted by mixmox, 06-13-2014, 02:58 AM|
|yes, all of share hosting tools to work with mysql, are compatible with Maria
also you can switch back to mysql in 3-4 simple steps
|Posted by wartungsfenster, 06-13-2014, 08:41 AM|
|I'd go with Percona if I had to run a loaded MySQL server.
It's the only flavour that has actual reporting via some custom tables.
Like 15% of what you could do on oracle, where a normal MySQL is at 0.1% - reporting-wise.
I.e. doing an analysis of the ibdata1 contents and where they relate to is a real nightmare on non-Percona MySQL versions.
Otherwise MariaDB for the performance, and, tbh, personally I use PostgreSQL whereever I can.
|Posted by HostPride, 06-14-2014, 12:31 AM|
|1 for mariaDB. My personal server which I hosted a forum suffered from memory issue, until the day I upgrade to mariaDB I no longer seeing a single memory issue. The memory graph shows how stable it is after upgrading to mariaDB as compared to the crazy up-and-down graph when i was using mysql.
|Posted by armenio, 06-14-2014, 02:30 PM|
|Percona, MariaDB - but I prefer to MySql
Add to Favourites Print this Article
Tomsyer ? (Views: 382)