For some reasons (very old database engine that does not allow replicating nor anything) which I can't change, I need a workaround to lower the number of connections to my main database server.
So I want to keep only my integrated management software with read/write access to the database.
All other tools would use a mirror of this database in read only mode.
My idea to have all data synced immediately on my secondary server is to use the file system (as this database engine stores everything in his file system).
I have already tested this with copy/paste the files manually and it works.
Now I need live writing to both HDD !
I don't know if this should be done at file system level / software level / hardware level..... I don't even know if this is possible !
Thank you very much for your benevolent answers on this topic.