Yeah, you are right.. there are lots of factors that needs to consider

i already asked forge.. i am just waiting for their reply, so it is safe to assume that the problem is the LB?

Hello I am having a problem.. my client is receiving Read timed out. (read timeout=10) from my server when they access to my API, this will only occur on high traffic based on my logs when it reaches around 13+ requests per second or around 35k requests per 10 minutes (Peak). My API is sync because i need to display the output as response

My current set up is this(I am using forge to setup)

• Load Balance
• 3 App servers (running octane swoole with 24 workers each and with a max requests of 5000)
• 4 Queue servers
• 1 Caching Server
• Dedicated Database Server with Standby node

i am not sure if the problem is my load balancer or what.. im not really good at servers

PS: the endpoints response time based on sentry is around 407ms average and 530ms P95.

Edit: Checked my sentry, i already reached 35k requests per 10 minutes

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?