Home > Readers Choice > Vote for MySQL[plus] awards 2011 !

Vote for MySQL[plus] awards 2011 !

First of all, I wish you a happy new year.
Many things happened last year, it was really exciting to be involved in the MySQL ecosystem.
I hope this enthusiasm will be increased this year, up to you !

To start the year, I propose the MySQL[plus] Awards 2011
It will only take 5 minutes to fill out these polls.
Answer with your heart first and then with your experience with some of these tools or services.

Polls will be closed January 31, so, vote now !
For “other” answers, please,  let me a comment with details.

Don’t hesitate to submit proposal for tools or services in the comments.
And, please, share these polls !

 

Best MySQL GUI client Tool

  • SQLyog (47%, 85 Votes)
  • MySQL Workbench (20%, 36 Votes)
  • HeidiSQL (8%, 14 Votes)
  • Navicat for MySQL (7%, 12 Votes)
  • MySQL Administrator / Query browser (6%, 10 Votes)
  • Other (5%, 9 Votes)
  • phpMyAdmin (4%, 8 Votes)
  • SQLWave (1%, 1 Votes)
  • SIDU DB Web GUI (1%, 1 Votes)
  • EMS SQL Manager for MySQL (1%, 1 Votes)
  • Sequel Pro (1%, 1 Votes)
  • sqldeveloper (1%, 1 Votes)
  • dbForge Studio (1%, 1 Votes)
  • MyQuery (1%, 1 Votes)
  • DBTools Manager (0%, 0 Votes)
  • SQL Maestro MySQL Tools (0%, 0 Votes)
  • Toad for MySQL (0%, 0 Votes)

Total Voters: 181

Loading ... Loading ...

 

Best MySQL Monitoring Tool

  • MONyog (35%, 135 Votes)
  • MySQL Enterprise Monitor (29%, 113 Votes)
  • Nagios (13%, 52 Votes)
  • Cacti (10%, 38 Votes)
  • Other (6%, 25 Votes)
  • Zabbix (5%, 19 Votes)
  • Ganglia (2%, 4 Votes)

Total Voters: 386

Loading ... Loading ...

 

Best MySQL Backup Tool (two possible answers)

  • Xtrabackup (46%, 151 Votes)
  • mysqldump (29%, 94 Votes)
  • MySQL Enterprise Backup (28%, 91 Votes)
  • mydumper (9%, 30 Votes)
  • LVM Backup (FS snapshot) (6%, 19 Votes)
  • mylvmbackup (5%, 17 Votes)
  • ZRM Enterprise (5%, 15 Votes)
  • ZRM Community (5%, 15 Votes)
  • Other (5%, 15 Votes)
  • Cold backup (2%, 6 Votes)
  • r1soft CDP for MySQL (1%, 2 Votes)

Total Voters: 329

Loading ... Loading ...

 

Best MySQL Replication/Cluster Tools (two possible answers)

  • MySQL Replication (37%, 183 Votes)
  • Tungsten Replicator (21%, 105 Votes)
  • MySQL NDB Cluster (17%, 83 Votes)
  • ShoonerSQL (16%, 76 Votes)
  • Galera Replication (13%, 66 Votes)
  • DRBD (9%, 45 Votes)
  • Other (2%, 11 Votes)
  • ScaleDB (2%, 9 Votes)

Total Voters: 490

Loading ... Loading ...

 

Best MySQL community Tool

  • Percona toolkit (37%, 117 Votes)
  • MySQL Sandbox (28%, 89 Votes)
  • MHA for MySQL (mysql-master-ha) (14%, 45 Votes)
  • Other (6%, 18 Votes)
  • Xtrabackup Manager (5%, 15 Votes)
  • mysqltuner (3%, 11 Votes)
  • Innotop (3%, 10 Votes)
  • mycheckpoint (2%, 5 Votes)
  • openark kit (1%, 3 Votes)
  • MMM (1%, 3 Votes)
  • Common schema (0%, 2 Votes)

Total Voters: 318

Loading ... Loading ...

 

Best MySQL Support Service

  • SkySQL (38%, 130 Votes)
  • Percona (28%, 96 Votes)
  • Oracle (26%, 90 Votes)
  • Other (4%, 15 Votes)
  • FromDual (3%, 9 Votes)
  • Pythian (1%, 4 Votes)
  • Blue Gecko (0%, 1 Votes)
  • PalominoDB (0%, 0 Votes)

Total Voters: 345

Loading ... Loading ...

 

Best MySQL based distribution

  • Oracle MySQL (36%, 122 Votes)
  • MariaDB (33%, 114 Votes)
  • Percona server (27%, 91 Votes)
  • Drizzle (3%, 11 Votes)
  • Other (1%, 4 Votes)
  • TokuDB (0%, 0 Votes)
  • InfiniDB (0%, 0 Votes)

Total Voters: 342

Loading ... Loading ...

 

Best NoSQL solution (two possible answers)

  • Memcached (46%, 120 Votes)
  • Hadoop / HBase (28%, 72 Votes)
  • MongoDB (25%, 65 Votes)
  • Cassandra (10%, 27 Votes)
  • Other (10%, 27 Votes)
  • HandlerSocket (9%, 24 Votes)
  • CouchDB (6%, 16 Votes)
  • Redis (5%, 13 Votes)
  • Tarantool (4%, 11 Votes)
  • Riak (3%, 7 Votes)
  • Amazon SimpleDB (2%, 5 Votes)
  • Tokyo Cabinet / Tyrant (1%, 3 Votes)

Total Voters: 259

Loading ... Loading ...

 

Best MySQL 5.6 improvement

  • Performances (27%, 77 Votes)
  • Replication (26%, 74 Votes)
  • Fulltext (16%, 47 Votes)
  • memcached API (13%, 36 Votes)
  • Backup/Restore buffer pool (8%, 22 Votes)
  • Partitioning (6%, 16 Votes)
  • Other (4%, 11 Votes)

Total Voters: 285

Loading ... Loading ...

 

Happy 2012 !
Cédric

This article is obviously not sponsored !
(MySQL is a trademark of Oracle Corporation and/or its affiliates)

Congratulations, you've read this post till the end !
If you enjoyed this article, please leave a comment


You can also subscribe to RSS feed or by email to automatically receive real-time notification of new posts

Thanks for your visit on MySQL+. Cédric
Categories: Readers Choice
  1. January 5th, 2012 at 22:27 | #1

    Where is MySQL-Sandbox? It should be mentioned among the tools.
    Mysqlsandbox.net

  2. January 6th, 2012 at 01:04 | #3

    AFAIK, MySQL 5.6 does have materialized views
    http://dev.mysql.com/doc/refman/5.6/en/faqs-views.html#qandaitem-B-6-1-5

  3. January 6th, 2012 at 05:33 | #5

    Aha! You’ve got yourself into a bottomless pit!
    Thank you for listing mycheckpoint & common_schema; perhaps openark-kit as well?

    • January 6th, 2012 at 10:32 | #6

      Yes, but I’ll try to do my best :-)
      openark-kit added, thx Shlomi and sorry to have forgotten it.

  4. January 6th, 2012 at 17:03 | #7

    Your options leave a lot out, is there a reason why?
    For example:
    Therea are at least 20 monitoring tools, Ganglia is just one key one missing.
    Pythian/Blue Gecko are service providers
    RDS is a MySQL distribution (be it not always ideal)
    Redis a key NoSQL missing
    Performance_schema and optimizer_trace 2 very nice 5.6 features (partitioning has 1 ‘n’ BTW)

    • January 6th, 2012 at 18:30 | #8

      Yes there is : Instinct !
      Sometimes we think about something and the next minute we did it…

  5. January 6th, 2012 at 17:08 | #9

    Is there any chance to vote for Sphinx ? I’m jealous! ;-) Thanks!

    • January 6th, 2012 at 18:13 | #10

      Unfortunately not !
      Sphinx is a very great product but I didn’t find a box to put it.

  6. kriton
    January 7th, 2012 at 03:10 | #11

    Hard to cover all available solutions.

  7. January 7th, 2012 at 12:44 | #12

    Drizzle isn’t a distribution of MySQL, it’s most certainly a fork… so it could never be “the best MySQL distribution” because it isn’t one.

    • January 7th, 2012 at 13:40 | #13

      Hi Stewart, yes, it’s true !
      But the poll said : “Best MySQL based distribution”
      The “based” term is for fork or derived MySQL distribution, sorry if it is not clear enough.
      Thx for your comment.

  8. January 9th, 2012 at 13:17 | #14

    I was missing OSC (online schema changes) as one of the option for best MySQL community tools!

  9. January 9th, 2012 at 13:44 | #15

    MySQL MMM is missing: http://mysql-mmm.org

  10. January 9th, 2012 at 18:50 | #17

    @Monty, this is why openark-kit is on the list; oak-online-alter-table is part of it.

  11. Anders Karlsson
    January 12th, 2012 at 13:34 | #19

    What about my MyQuery MySQL Query tools (Windows only, I know) in the MySQL GUI tools poll? (Available on http://sourceforge.net/projects/myquery/)

    /Karlsson

  12. January 31st, 2012 at 17:48 | #21

    Excellent initiative !

  13. January 31st, 2012 at 19:16 | #23

    Cedric,

    Two question: i) why ‘Shooner Replication’ is on the list as it is not open source as far as I know and ii) what kind of policies you have in place to counter quite obvious vote rigging?

    Cheers,

    Eero

    • January 31st, 2012 at 23:16 | #24

      Indeed, there seems to be a problem. Let me carry out an investigation.

      About open source now, you know, TokuDB, MONyog, MySQL Enterprise backup… are closed source too.
      I don’t think that open source is always better than closed source.
      I just would like to offer an overview of the most used tools.

      I’ll publish a new post this week about these awards, so, stay tune.

  14. February 2nd, 2012 at 07:08 | #25

    Cedric,

    In that case for all fairness you should have posted our premier commercial clustering solution, Tungsten Enterprise on the ballot.

    Since based on title these should be “Community Awards” I automatically assumed that all solution also should be open source. But that conclusion is obviously my bad, not yours.

    Eero

    • February 2nd, 2012 at 16:22 | #26

      Yes, I understand it can be a problem.
      I used the word “community” wrongly. I meant “MySQL+ Readers Choice Awards”.

  15. malike
    October 21st, 2013 at 14:53 | #27

    You can check one more free tool – Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview

  1. January 27th, 2012 at 11:42 | #1
  2. February 2nd, 2012 at 16:25 | #2
  3. March 20th, 2012 at 08:39 | #3