We have an application running in our production environment, and it functions well under normal load. However, during peak times, such as at the end of the month, when there is a high volume of concurrent transactions, some users experience connection timeout errors. This occurs because the CPU utilization of the DB server exceeds 90%.
I wanted to inquire if OutSystems supports database server scalability through techniques like Sharding and Partitioning.
Hi Ishaan, there is no horizontal scaling of databases in the OutSystems cloud, but you vertically upscale the database server's memory and CPU, by requesting this by opening a support case.
Hi Ishaan Takkar,
Please check below link:
https://www.outsystems.com/evaluation-guide/how-does-outsystems-provide-horizontal-scalability/
https://success.outsystems.com/documentation/best_practices/infrastructure_management/designing_outsystems_infrastructures/scaling_and_high_availability_for_outsystems_platform_servers/
You can check with OutSystems support team as well because it depends upon your infrastructure as well.
Hope this helps,
Regards,
Manish Jawla
Hi @Manish Jawla , appreciate you sharing the links. We currently operate 2 front servers for our production environment, which perform well even under high loads. However, our challenge lies with the DB server as we only have one instance handling all transactions, leading to potential issues during peak usage. I'm wondering if OutSystems offers the capability to use multiple DB servers, allowing user traffic to be distributed across several instances. This could prevent CPU utilization from reaching 80-90% and help avoid connection timeout errors for end users. Thanks
Hi Daniel, appreciate your confirmation regarding horizontal scalability. Although we have already vertically upscaled our DB Servers and it is currently at the highest configuration possible as per OS support team.
Hi Ishaan,
To share the load, you can create multiple physical database and map it accordingly to an OutSystems database catalog. You can also create databases, and create your own tables, then you can map it to OutSystems entries via OutSystems integration studio.
Please visit the following link, hope this help you.
https://success.outsystems.com/support/enterprise_customers/maintenance_and_operations/multiple_database_catalogs_and_schemas/?_gl=1*1fkalq7*_ga*MjA0ODkxOTM3MS4xNjk1NjI4MDgw*_ga_ZD4DTMHWR2*MTY5OTI1NTIzMy44LjEuMTY5OTI1NTg4OC42MC4wLjA.
Kindly Note: This works for On-Premise environment
Thanks,
PD
To add to this reply, it is only possible if you run OutSystems on-premise.
Hi Pradeep, Thanks for the sharing this but our application is hosted on OS Cloud.