Demonstrations
Live recording of databases updating from the blockchain
We are running two independent pipelines of node & Db-sync in Europe: bca1 and bca3. We also run a replica in the US: bca4b. And, for demonstration purposes, I run a local replica: replica1.
All these databases get updated by Db-sync whenever there is a new block available on mainnet.
Using some queries on the block height, i.e. slot_no, we can demonstrate that the pipelines update their databases and the replica follow with short delay.
Live recording of failover behaviour
Additionally to the above setup, we have setup a PostgreSQL proxy, e.g. pgcat, through which the queries are sent either to one pipeline bca1, or the second bca3.
The demonstration shows that when pipeline bca1 stops updating its database, thus the block height for bca1 does not increase anymore, then the querying through the proxy still returns the latest block height as it now redirects the query to the other pipeline bca3.
