Due to a combination of business/enterprise requirements and our architect's preferences we have arrived at a particular architecture that seems a bit off to me, but I have very limited architectural knowledge and even less cloud knowledge, so I would love a sanity check to see if there's improvement that can be made here:
Background: We are developing a replacement for an existing system that is a complete rewrite from the ground up. This requires us to source data from an SAP instance through BAPI/SOAP Web Services, as well as use some databases of our own for data not in SAP. Currently all of the data that we will be managing exists in local DBs on a distributed application, or in a MySQL database that will need to be migrated off of. We will need to create a handful of web applications that replicate the functionality of the existing distributed app, as well as providing admin related functionality over the data we control.
Any databases we control must be implemented in MS SQL Server
Minimize the number of databases created
Phase 1 will have us deploy our applications to Azure, but we need the ability to bring these applications on-prem in the future
Our Ops team wants us to dockerize everything as they feel it will make their management of the code a lot simpler.
Minimze/eliminate replication of data
The coding stack is going to be .NET Core for microservices and Admin apps, but Angular 5 for the main front-end application.
Our front-ends will feed from a series of microservices (I use that term lightly as they are 'Domain' level and rather large), which will be broken into Read Services and Write Services in each domain. Both will be scalable and load balanced through Kubernetes. Each will also have a read-only copy of their database attached to them within their container, with a single master instance of the db available for writes that will push out updates to those read only copies.
(Sorry for the poor quality images, I'm redoing them from memory since, naturally, there's no actual documentation for this stuff except in the architect's head)
Service to Service communication will happen through a message queue that each service will listen to, and process any relevant messages. The primary use of this will be for email generation, as there isn't anything else we've identified that requires service to service communication for information yet. Anything "business logic" related that would require multiple services being involved would likely flow from the front-ends, where the front-ends would call each service individually and deal with atomicity.
From my perspective, the thing that rubs me the wrong way is the read-only db instances spinning up inside the docker containers for the services. The service itself and the db would have drastically different demands in terms of load, so it would make a lot more sense if we could load balance them separately. I believe MYSQL has a way of doing that with master/slave configurations, where new slaves can be spun up whenever load gets high. Especially while we have our system in the cloud and are paying for each instance, spinning up a new instance of the whole service when we only need another db instance seems wasteful (as does the opposite, spinning up a new db copy when we really just need a web service instance). However, I don't know the limitations of MS SQL Server for this.
My largest concern is around the MS SQL Server implementation. Coupling the read only instances so tightly to the services feels wrong. Is there a better way to do this?
NOTE: I asked this over on software engineering and they pointed me here. Sorry if this is not the appropriate SE.
Also there's no MS SQL Server tag