Results 1 to 12 of 12
-
01-11-2014, 10:58 PM #1Junior Guru Wannabe
- Join Date
- Dec 2013
- Posts
- 34
Lightest, Fastest alternative to MySQL?
Performance and scaling being the most important criteria...
What is the Lightest, Fastest alternative to MySQL?
-
01-11-2014, 11:03 PM #2Disabled
- Join Date
- Oct 2013
- Location
- Everywhere
- Posts
- 696
There are a ton of other options. Check out MariaDB, PostegreSQL, MongoDB, and Cassandra. They're all different, so it would behoove you to check benchmarks & do some research. I'm not very familiar with any of these alternatives (so take it as a list of alternatives--not necessarily as a recommendation) and I just happen to know them by name, unfortunately not by experience (yet)
-
01-12-2014, 01:50 AM #3Web Hosting Evangelist
- Join Date
- Dec 2011
- Location
- Surrey, BC
- Posts
- 454
I really like MongoDB as a lightweight alternative.
-
01-12-2014, 03:25 AM #4Junior Guru Wannabe
- Join Date
- Dec 2013
- Posts
- 34
-
01-12-2014, 04:37 AM #5Newbie
- Join Date
- Dec 2013
- Location
- Tirana, Albania
- Posts
- 25
-
01-12-2014, 04:49 AM #6Hello World
- Join Date
- Nov 2009
- Location
- /etc/my.cnf
- Posts
- 10,657
I recommend MariaDB but more importantly what will the database server cluster be used for?
UK Based Proactive Server Management.
Zabbix Enterprise 24/7 Monitoring.
-
01-12-2014, 05:15 AM #7Temporarily Suspended
- Join Date
- May 2013
- Location
- India
- Posts
- 747
MariaDB and Percona are the well know drop-in replacements for MySQL, and both are says to be faster and better than MySql community edition. As others said, choose a platform based on your requirement.
-
01-12-2014, 02:08 PM #8Web Hosting Master
- Join Date
- Mar 2013
- Posts
- 1,328
Go for MariaDB. There is the same good man that created MySQL behind it.
-
01-13-2014, 02:35 AM #9Junior Guru Wannabe
- Join Date
- Dec 2013
- Posts
- 34
-
01-13-2014, 03:09 AM #10Web Hosting Master
- Join Date
- Aug 2007
- Posts
- 906
MariaDB is just a fork of MySQL, I wouldn't call it a "light and fast replacement"
Some useful tutorials for VPSes...
Set up an unmanaged Linux VPS to host websites (avoid having to pay for cPanel)
Install a GUI on a Linux VPS with RDP (cheap alternative to paying for a Windows license if you need a basic remote workstation)
-
01-13-2014, 05:33 AM #11Web Hosting Master
- Join Date
- Oct 2009
- Posts
- 865
For most purposes, there is no discernible performance difference between MySQL + InnoDB and the forks MariaDB/Percona + XtraDB. The biggest reason to choose MariaDB is ideological ("it's not Oracle").
-
01-14-2014, 10:26 AM #12Junior Guru
- Join Date
- May 2007
- Location
- Atlanta
- Posts
- 201
Just setup a good cluster and you should be good with mysql.
Also a huge performance gain would be to use a large raid card with a lot of cache and ssds for performance.Jon Fatino
Similar Threads
-
need alternative to MySQL DB server
By brian73 in forum Cloud HostingReplies: 17Last Post: 03-05-2013, 01:42 PM -
Fastest MySQL server
By mcdroid in forum Cloud HostingReplies: 13Last Post: 02-07-2011, 05:36 AM -
Lightest RAM control panel
By galaxhost in forum Hosting Software and Control PanelsReplies: 1Last Post: 06-18-2007, 07:49 AM -
Fastest Query - MySQL/PHP
By mattschinkel in forum Programming DiscussionReplies: 16Last Post: 05-17-2003, 03:34 AM -
Biggest, Fastest, Most stable MySQL Host?
By ElliotH in forum Web HostingReplies: 4Last Post: 03-12-2003, 06:49 PM