3 ms·

I see no problem in a "monolith" using different kinds of databases.

• PaulHoule 9y ago
  Sure, but peeling off something that has radically different scaling properties is easier if you put a "web service" in the way.
  • takeda 9y ago
    Still, based on what you're describing it was MySQL in your case that was the bottleneck. In that case you scale database, either by sharding or creating separate ones for different usecases. It is irrelevant to whether you use microservices or not.
  • JamesBarney 9y ago
    I don't understand why putting a web service in front of mysql and a key value store makes scaling easier. Would you mind explaining?
    • PaulHoule 9y ago
      Simple. Most of the database is "large" in terms of data (say 50M rows) but that database gets maybe 10,000 updates a day. The read load is well-controlled with caching. One table is small in terms of data but involves an interactive service that might generate 50 updates/sec at peak times. With the "hot" service implemented on top of a key-value store, the database is the ultimate commodity, I have many choices such as in-memory with logging, off-heap storage, distributed key-value stores, etc. The service is not "in front" of MySQL, but is on the side of it so far as the app is concerned.