Testing load balancing and high availability

Everything done so far has been with the aim of achieving high availability in our database architecture. From now on, when we have an established connection to the database, it should not be lost in the event of a disaster, such as the crashing of our master server. Here, we will instigate a crash in our master server, leaning on Vagrant to suspend it, and we will see how Heimdall acts in this instance.

 In order to shake things up a bit, we will run the following query on psql:

atm=>
SELECT
    format('select pg_sleep(2), "BankName", "Address" from "ATM locations" where                         "ID"=%s;', "ID")
FROM
    "ATM locations";
                                    format 
--------------------------------------------------------------------------------
 select pg_sleep(2), "BankName", "Address" from "ATM locations" where...