What is the advantage / difference of using separate banks, one for reading and one for writing?
In my conception there is no such concept. The writing bank, one hour will have to be read to replicate the data in the read, which in turn will suffer writing to receive the replication.
Even I understand that this replication could occur in a time where the bank / system is not being used so much as at dawn for example, but in my case, I can not afford this, synchronization / replication between banks has occur within a maximum of 5 minutes.
I have a database today that suffers thousands of insertions per minute, so if every 5 minutes I run a synchronization process between banks, I believe it will be millions of lines, and at that point, my reading bank would lose performance because it would be suffering from replication writing.
I am considering that this replication would be done in the "hand" through a service developed by me as a queue, or if I use the replication features in SGDBs, would it be more advantageous / performance?