In many environments MySQL is not the only technology used to store in-process data.
Quite frequently, especially with large-scale or complicated applications, we use MySQL alongside other technologies for certain tasks of reporting, caching as well as main data-store for portions of application.
What technologies for data storage and processing do you use alongside MySQL in your environment? Please feel free to elaborate in the comments about your use case and experiences!
What technologies you run alongside with MySQL ?
- MemcacheD (29%, 264 Votes)
- Redis (15%, 134 Votes)
- Sphinx (15%, 132 Votes)
- MongoDB (11%, 102 Votes)
- Lucene (9%, 80 Votes)
- Cassandra (5%, 41 Votes)
- Inhouse Developed Technology (5%, 41 Votes)
- Hadoop (4%, 38 Votes)
- Hbase (2%, 22 Votes)
- CouchBase (2%, 20 Votes)
- Tarantool (2%, 18 Votes)
- Riak (1%, 9 Votes)
- RethinkDB (1%, 6 Votes)
Total Voters: 415
Lucene/Solr for Searching
Memcached for Caching a lot of stuff
MongoDB as a job queue
Lucene/Solr for Searching
Memcached for Caching a lot of stuff
Varnish for caching too, but that’s a bit different
Sphinx for searching
Memcached for caching
MongoDB for analytics
Can anyone compare the Lucene and sphinx performance?
SOLR for searching
MemcacheD for caching
RabbitMQ for queue
Using solr for searching, filters and catalog,
Used Sphinx for search in past
We also use Xapian which isn’t on the list – solr/lucene/sphinx dont really cut it for some of the things we do.
I’m only allowed to select up to six choices while we use more than that… Maybe that’s an indication we’re doing something wrong? 😉
Anyway, some of the additional technologies used: Disco and Vertica.
Memcached, Redis, Sphinx
I use Cassandra and Tarantool. And planning to use also Sphinx.
SOLR for searching
MemcacheD for caching
RabbitMQ for queue