MYSQL KEY-VALUE PAIR Viability
key-value, mysql
Solution
Any relational database can provide a key-value store, but it's not what they're for: and they aren't good at it, not when compared to native key-value databases like e.g. Cassandra.
If your requirements aren't extreme, your best bet would be MyISAM as it's probably fastest and transaction support is not (high) on the priority list of key-value databases.
Problem
I am new to MySQL and I am looking for some answers to the following questions: a) Can MySQL community server be leveraged for a key-value pair type database? b) Which MySQL engine is best suited for a key-value pair type database? c) Is MySQL cluster a must for horizontal scaling of key-value based datastore or can it be acheived using MySQL replication? d) Are there any docs or whitepapers for best practices when implementiing a key-value datastore on MySQL? e) Are there any known big implementations other than friendfeed doing key-value pair using MySQL?