![MySQL[Plus]](http://www.mysqlplus.net/wp-content/uploads/2013/01/plus_logo_blanc_mini2.png){kind=logo}
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 ...- SQLYog : http://www.webyog.com
- MySQL Workbench : http://www.mysql.fr/products/workbench
- Heidisql : http://www.heidisql.com
- Navicat : http://www.navicat.com/en/products/navicat_mysql/
- MySQL Administrator / Query browser : http://dev.mysql.com/downloads/gui-tools/5.0.html
- phpMyAdmin : http://www.phpmyadmin.net
- EMS SQL Manager for MySQL : http://www.sqlmanager.net/fr/products/mysql/manager
- SQLWave : http://www.nerocode.com/
- Sequel Pro : http://www.sequelpro.com/
- Oracle SQL Developer : http://www.oracle.com/technetwork/developer-tools/sql-developer
- dbForge Studio : http://www.devart.com/dbforge/mysql/studio
- SQL Maestro MySQL Tools : http://www.sqlmaestro.com
- DBTools Manager : http://www.dbtools.com.br/EN
- Toad for MySQL : http://www.quest.com/toad-for-mysql/
- SIDU DB Web GUI : http://sidu.sourceforge.net/sidu/
- MyQuery : http://sourceforge.net/projects/myquery
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 ...- Zabbix : http://www.zabbix.com/
- MySQL Cacti templates : http://code.google.com/p/mysql-cacti-templates/
- Nagios : http://www.nagios.org/
- Ganglia : http://ganglia.sourceforge.net/
- MONyog : http://www.webyog.com
- Oracle products, tools and services : http://www.mysql.com
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 ...- Percona products, tools and services : http://www.percona.com
- Oracle products, tools and services : http://www.mysql.com
- r1soft CDP for MySQL : http://www.r1soft.com/linux-cdp/cdp-enterprise-edition/mysql/
- mylvmbackup tool : http://www.lenzg.net/mylvmbackup/
- mydumper tool : http://www.mydumper.org/
- ZRM tools : http://www.zmanda.com
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 ...- Oracle products, tools and services : http://www.mysql.com
- Galera replication : http://codership.com/products/galera_replication
- Tungsten replicator : http://code.google.com/p/tungsten-replicator/
- DRBD : http://www.drbd.org/
- ShoonerSQL : http://www.schoonerinfotech.com/products/schoonersql
- ScaleBase : http://www.scalebase.com/
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 ...- Percona products, tools and services : http://www.percona.com
- common-schema : http://code.google.com/p/common-schema/
- Innotop : http://code.google.com/p/innotop/
- MySQL Tuner : https://launchpad.net/mysqltuner/2.0/mysqltuner-2.1-rev17
- mycheckpoint : http://code.openark.org/forge/mycheckpoint
- MySQL Sandbox : http://mysqlsandbox.net/
- openark kit : http://code.openark.org/forge/openark-kit
- MHA for MySQL : http://code.google.com/p/mysql-master-ha
- Xtrabackup Manager : http://code.google.com/p/xtrabackup-manager
- MMM : http://mysql-mmm.org
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 ...- Oracle products, tools and services : http://www.mysql.com
- SkySQL products, tools and services : http://www.skysql.com
- Percona products, tools and services : http://www.percona.com
- FromDual products, tools and services : http://www.fromdual.com
- PalominoDB products, tools and services : http://palominodb.com/
- Pythian products, tools and services : http://www.pythian.com/
- Blue Gecko products, tools and services : http://www.bluegecko.net/
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 ...- Oracle products, tools and services : http://www.mysql.com
- Percona products, tools and services : http://www.percona.com
- MariaDB : http://mariadb.org/
- TokuDB : http://www.tokutek.com/
- InfiniDB : http://infinidb.org/
- Drizzle : https://launchpad.net/drizzle
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 ...- Amazon SimpleDB : http://aws.amazon.com/fr/simpledb//180-2635771-0721067/
- mongoDB : http://www.mongodb.org/
- Cassandra : http://cassandra.apache.org/
- CouchDB : http://couchdb.apache.org/
- Tokyo Cabinet : http://fallabs.com/
- Riak : http://basho.com/
- Hadoop : http://hadoop.apache.org/
- Tarantool : http://tarantool.org/
- memcached : http://memcached.org/
- Redis : http://redis.io/
- HandlerSocket : https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL
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 ...
Happy 2012 !
Cédric
This article is obviously not sponsored !
(MySQL is a trademark of Oracle Corporation and/or its affiliates)
Where is MySQL-Sandbox? It should be mentioned among the tools.
Mysqlsandbox.net
Of course yes, shame on me !
Added right now, thx for your contribution
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
AFAIK no !
Just a dream, sorry for mistake…
Thx
Aha! You’ve got yourself into a bottomless pit!
Thank you for listing mycheckpoint & common_schema; perhaps openark-kit as well?
Yes, but I’ll try to do my best :-)
openark-kit added, thx Shlomi and sorry to have forgotten it.
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)
Yes there is : Instinct !
Sometimes we think about something and the next minute we did it…
Is there any chance to vote for Sphinx ? I’m jealous! ;-) Thanks!
Unfortunately not !
Sphinx is a very great product but I didn’t find a box to put it.
Hard to cover all available solutions.
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.
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.
I was missing OSC (online schema changes) as one of the option for best MySQL community tools!
MySQL MMM is missing: http://mysql-mmm.org
Yop, done (but perhaps too late).
Thx
@Monty, this is why openark-kit is on the list; oak-online-alter-table is part of it.
Also in Percona toolkit.
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
Added !
Thx
Excellent initiative !
Thx !
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
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.
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
Yes, I understand it can be a problem.
I used the word “community” wrongly. I meant “MySQL+ Readers Choice Awards”.