If I have 2 subnetworks, 10.0.0.0 for my processes and 188.8.131.52 for databases, how can I load balance the databases internally within the subnetwork such that any of the processes in 10.0.0.0 network can access any of the database instances via single internal IP like 184.108.40.206?
So 220.127.116.11 would load balance lets say 3 virtual machines at 18.104.22.168, 22.214.171.124 and 126.96.36.199.
The IP addresses are given purely to demonstrate the point and I understand that they may look different when actually done.
Or is a better solution to have a completely separate virtual network for the database servers and connect both virtual networks together. If so what configuration would you recommend for this?
I want to avoid going out to the Internet only to come back in again to access the database from the processes. Speed is of essence and all machines are in the same region.
All machines are running Ubuntu 15.10 if that's of any help.