Menu
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?
798
A telephone directory is a good example, where the key is the person or business name, and the value is the phone number. Stock trading data is another example of a key-value pair.
The key-value database defined A key-value database is a type of nonrelational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as a unique identifier.
Amazon DynamoDB: Probably the most widely used key-value store database, in fact, it was the research into DynamoDB that really started making NoSQL really popular.
MySQL Key Value Store — A schema less approach.
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.
64
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
