为具有多个值的密钥建议数据库，具有高度可扩展性(Suggest a database for key with multiple values , highly scalable)

 我们有key-multipleValues的数据。 每个密钥可以有大约500个值（每个值大约为200-300个字符），这些密钥的数量大约为1000万。 主要操作是检查给定键的值。 
 
 我一直在使用mysql，我有两个选项：每个键值一行，每个键一行，文本字段中的所有值。但这些对我来说似乎没有效率，因为第一个模型有很多行，冗余和第二个模型文本字段将变得非常大。 
 
 我正在考虑使用nosql数据库为此目的，我以前使用mongodb，我不认为它适合我目前的情况。 基于keyvalue或基于列系列的nosql db会更好。不需要分发。使用riak，redis，cassandra等的人分享你的想法。 
 
 谢谢 

We have data with key-multipleValues. Each key can have around 500 values (each value will be around 200-300 chars) and the number of such keys will be around 10 million. Major operation is to check for a value given a key.
 
I've been using mysql for long time where i've got 2 options: one row for each keyvalue, one row for each key with all values in a text field.But these does not seem efficient to me as the first model has lot of rows,redundancies and second model text field will become very large .
 
I am considering using nosql database for this purpose, i've used mongodb before and i dont think it is suitable for my current case. keyvalue based or column family based nosql db would be better.It need not be distributed.Someone who used riak,redis,cassandra etc pls share your thoughts.
 
Thanks

原文：https://stackoverflow.com/questions/6649535