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