Results 1 to 12 of 12
  1. #1
    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?

  2. #2
    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)

  3. #3
    Join Date
    Dec 2011
    Location
    Surrey, BC
    Posts
    454
    I really like MongoDB as a lightweight alternative.

  4. #4
    Join Date
    Dec 2013
    Posts
    34
    Quote Originally Posted by AcclaimedHost Alan View Post
    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)
    Thanks. Will eventually be going to a "MySQL Cluster". In that case, is using MySQL the only option? Or can you use another Database in a MySQL Cluster?

  5. #5
    Join Date
    Dec 2013
    Location
    Tirana, Albania
    Posts
    25
    Quote Originally Posted by Arteia View Post
    Thanks. Will eventually be going to a "MySQL Cluster". In that case, is using MySQL the only option? Or can you use another Database in a MySQL Cluster?
    Pretty much any serious datababse today has cluster support.

    MySQL when used with innoDB engine and with simple key index is as performant as the rest of the noSQL mentioned. At least from my personal benchmarks results. But different people have different opinions.
    Host.al
    .al domains
    Cheap offers for many ccTLDs

  6. #6
    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.

  7. #7
    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.

  8. #8
    Join Date
    Mar 2013
    Posts
    1,328
    Go for MariaDB. There is the same good man that created MySQL behind it.

  9. #9
    Join Date
    Dec 2013
    Posts
    34
    Quote Originally Posted by gingir View Post
    Go for MariaDB. There is the same good man that created MySQL behind it.
    Does a MariaDB Cluster perform and scale better than a MySQL Cluster?

  10. #10
    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)

  11. #11
    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").

  12. #12
    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

  1. need alternative to MySQL DB server
    By brian73 in forum Cloud Hosting
    Replies: 17
    Last Post: 03-05-2013, 01:42 PM
  2. Fastest MySQL server
    By mcdroid in forum Cloud Hosting
    Replies: 13
    Last Post: 02-07-2011, 05:36 AM
  3. Lightest RAM control panel
    By galaxhost in forum Hosting Software and Control Panels
    Replies: 1
    Last Post: 06-18-2007, 07:49 AM
  4. Fastest Query - MySQL/PHP
    By mattschinkel in forum Programming Discussion
    Replies: 16
    Last Post: 05-17-2003, 03:34 AM
  5. Biggest, Fastest, Most stable MySQL Host?
    By ElliotH in forum Web Hosting
    Replies: 4
    Last Post: 03-12-2003, 06:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •