News for hackers. Stuff that matters.
Re:Ask HN: What's your biggest struggle with Microservices? by renke1 on Tuesday July 25, 2017 @01:04PM (#14849540)
I see no problem in a "monolith" using different kinds of databases.
Re:Ask HN: What's your biggest struggle with Microservices? by PaulHoule on Tuesday July 25, 2017 @01:11PM (#14849605)
Sure, but peeling off something that has radically different scaling properties is easier if you put a "web service" in the way.
Re:Ask HN: What's your biggest struggle with Microservices? by takeda on Tuesday July 25, 2017 @02:49PM (#14850710)
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.
Re:Ask HN: What's your biggest struggle with Microservices? by JamesBarney on Tuesday July 25, 2017 @02:56PM (#14850789)
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?
Re:Ask HN: What's your biggest struggle with Microservices? by PaulHoule on Wednesday July 26, 2017 @05:28PM (#14860532)
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.