Automated self-scaling database system for automatically scaling out write operations and method for implementing the same in a multi-tenant, cloud-based computing environment

Abstract

A method and system are provided for automatically scaling out write operations in an automated self-scaling database system. The database system initially includes a first primary database (PD) and a first standby database. Telemetry information from the first PD is analyzed to determine whether the first PD has reached its maximum computation and storage capacity. If so, a write scaling process is automatically initiated so storage capacity and computation resources of the system can be upscaled for write operations. To write scale, a new PD can be automatically provisioned, and once it is active, tenants of the system can be distributed among the first PD and the new PD (e.g., equally distributed or distributed based on workload, etc.) such that the first PD handles requests that originate from a first group of the tenants, and the new PD handles requests that originate from a second group of the tenants.