This is more of a a design question
I have a local db (mysql if relevant) for reads and remote master for writes but wondering if it's better to..
1) Write changes to a local queue and bulk insert to remote master every 1 min or so
2) Write changes immediately to the remote master
Using 1 I [think] I have more control but there is the delay and it uses 1 connection/thread per outgoing table
but 2 could be any cpu/memory usage and no control, but changes are updated in realtime.
I currently use #1 but now as my project uses more tables I bulk insert 10+ connections and I am planning for horizontal scalability and 10+ connections each instance could eventually add up so please let me know what real/professional developerts/DBA's handle this as I am just in development stage with no actual [production] experience and just using common sense/logic currently.