Dynamic, distributed, and scalable single endpoint solution for a service in cloud platform

A non-transitory, computer readable medium having instructions stored thereon, the instructions being executable by one or more processors to perform a method comprising:

• executing a first forwarding Virtual Machine (“VM”) in a first availability zone and having a first Internet Protocol (“IP”) address;
• executing a second forwarding VM in a second availability zone and having a second IP address;
• recording the first and second IP addresses with a cloud Domain Name Service (“DNS”) web service of a cloud provider such that both receive requests from applications directed to a particular DNS name acting as a single endpoint;
• providing a Relational Database Management System (“RDBMS”) as a service cluster, including a master RDBMS VM node and a standby RDBMS VM node;
• forwarding, by an IPtable in each forwarding VM, a request having a port value to a cluster port value associated with the master RDBMS VM node;
• detecting a failure of the master RDBMS VM node;
• and
• responsive to said detecting, the standby RDBMS VS transmitting one or more signals to each forwarding VM to update the IPtables to:
• designate the standby RDBMS VM node as a new master RDBMS VM node, and
• forward requests having the port value to a cluster port value associated with the new master RDBMS VM node.