Problem: I am building out a web application architecture with C#.NET MVC Client App and a WebAPI Service. Currently, I have multiple clients and a single, bloated Web API Service. All of my client apps call the service to retrieve data. However, because our application is getting much bigger, I want to break my single service into multiple services - essentially, one Web API service per database, so that the service layer is directly tied to its respective database. This will allow me to do code-first development on the database with the service layer, and decouple any other code that references other data access, so that when I make a change to the service or database, I can know for sure that it is only affecting that service or database, and I don't need to do regression testing on anything else.
The main problem I have now is that I have a bunch of client apps that have references to a bunch of different Web API services, and if I change the location of one service I need to update that change in any and all clients. To remedy this, I am creating a new "Gateway" Web Api, that is essentially just a pass-through from Client App to Web API Service, but all Client Apps call a controller on the Gateway, and the Gateway knows how to route the traffic to the correct Web API Service. So if I make a change to the Service, I simply change the reference in Gateway, and that is all - clients do not need to be modified.
So now the Architecture looks like MVC Client App -> Gateway Web API -> Service Web API -> Database.
Question: I have this working as intended, and it seems to solve the issues I had before - but my question is - is this overkill? Is there a better way to handle this without introducing the complexity of two hops over the wire?
I have tried googling to get info about software and web application architecture examples, but I can't find anything with this level of complexity. It seems all literature I can find are simply referring to multiple clients calling a single service.
Any insight that anyone may have is much appreciated.