Thank you for this reference

Hello! i am currently using dedicated database of Digital Ocean and it has a standby node. My question now is that, what is the best practice for creating backups? Do i still need to dump the file? How about the binlogs? What are the best config for the database?

EDIT: My app is a Payment gateway, we are now handling large amount of money daily

got it.. thank you!

thank you for this insight! i am thinking of using the replica when showing metrics or exporting reports

Hello! i created a fintech app, and right now we have a high traffic(16 reqs/second.. not sure if this is a high traffic already) and now, i am thinking of using a database replication.. by setting the read/write config and 'strict' => true, ... should i not be worried of the integrity of the data? like the delays of the newly added/updated record?

Sorry for the late reply guys @vincent15000 @imrandevbd @martinbean... so what i did was, i stored it on the cache and create a job that will sync..

I created a fintech app, right now i am using ->increment/decrement for the balance.. my current problem is that when a certain merchant has lots of traffic, it causes a problem it needs to wait before it updates because of the atomic lock.. I also have a ledger of the wallet transaction but using sum to get the real balance will be very expensive when it has a lot of records.. how do you handle this stuff?