MYSQL KEY-VALUE PAIR Vitality

Question

I am new to MySQL and I am looking for answers to the following questions:

a) Can I use a MySQL community server for a key-value database?

b) Which MySQL engine is best for a key-value database?

c) Is a MySQL cluster mandatory for horizontally scaling a key-based data store or can it be obtained using MySQL replication?

d) Are there any documents or documents for best practices when implementing a data warehouse with key values ​​in MySQL?

e) Are there any known large implementations, other than friendfeed, that make a key-value pair using MySQL?

Answer 1

Any relational database can provide a keystore, but that's not what they are for: and they are not good at it, and not compared to their own key databases, for example, for example. Cassandra .

If your requirements are not extreme, MyISAM will be the best choice, as it is probably the fastest, and transaction support is not (high) in the key database priority list.

Answer 2

, HandlerSocket Mysql. , . , ( , ..) mysql, ( ).

Answer 3

I know that I am late for the game here, but in fact, in version MySQL 5.6 there are some changes that allow it to become a repository of key values ​​with built-in memcached. It looks really good:

NoSQL interface via memcached