公开(公告)号：US20230095756A1

公开(公告)日：2023-03-30

申请号：US17449417

申请日：2021-09-29

Applicant: salesforce.com, inc.

Inventor： Samantha Wilkinson ,  Bohan Chen ,  Donald Tam

IPC: H04L29/06

Abstract: Technologies are provided for dynamically reconfiguring a database system of a tenant that is part of a multi-tenant database system based on risk profile(s) of the tenant. The database system includes database and an application server of the tenant. When a request is received from a client of the tenant, a database transaction having one or more query language patterns can be automatically detected. Query language pattern(s) can be automatically associated with a corresponding transaction category for that tenant, and a corresponding risk profile for that tenant can be determined based on the corresponding transaction category. Based on the corresponding risk profile, it can be determined if a dynamic reconfiguration process should be performed, and if so, system parameter(s) of the database system can be dynamically reconfigured to take action(s) to address one or more risks associated with the corresponding risk profile.

公开(公告)号：US10902021B2

公开(公告)日：2021-01-26

申请号：US16139255

申请日：2018-09-24

Applicant: salesforce.com, inc.

Inventor： Bohan Chen ,  Donald Tam

IPC: G06F16/27 ,  G06F9/455 ,  G06F11/14 ,  G06F16/21

Abstract: A method and system for automatically scaling out read operations in an automated self-scaling database system are provided. An automated self-scaling database module analyzes telemetry information from a primary database and a first standby database to determine whether there is the need for upscaling storage capacity and computation resources of the database system for read operations. When upscaling is needed, a snapshot of the first standby database is taken and stored at a snapshot storage system. The snapshot is a complete copy of data stored in a storage system of the first standby database at a given time. Upscaling is then automatically initiated by provisioning a new standby database by automatically provisioning a new virtual machine (VM) and a new storage system for the new standby database, and then restoring the snapshot that was taken from the snapshot storage system to the new standby database.

公开(公告)号：US10891308B2

公开(公告)日：2021-01-12

申请号：US16139266

申请日：2018-09-24

Applicant: salesforce.com, inc.

Inventor： Bohan Chen ,  Donald Tam

IPC: G06F16/27 ,  G06F9/455 ,  G06F11/14 ,  G06F16/21

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.

公开(公告)号：US11093356B2

公开(公告)日：2021-08-17

申请号：US16440104

申请日：2019-06-13

Applicant: salesforce.com, inc.

Inventor： Bohan Chen ,  Donald Tam ,  Jesse Collins ,  Sheng Qiao ,  Ted Liu ,  Youngjin Yu

IPC: G06F11/20 ,  G06F16/27 ,  G06F16/23 ,  G06F11/16

Abstract: An automated self-healing database system is provided that includes a primary database, an application server that writes data to the primary database and reads data from the primary database when it is available, a standby database that is a replica of the primary database, and a self-healing module (SHM). The SHM can automatically detect unavailability of the primary database, and if the standby database is available, the SHM can automatically enable the standby database as readable and writable, assign the standby database the role of primary database at the primary site to start replicating data to other standby databases, and use a pre-established connection between the application server and the standby database to allow the application server to read data from the standby database and to write data to the standby database resulting in the standby database assuming role of the primary database at the primary site.

公开(公告)号：US10409697B2

公开(公告)日：2019-09-10

申请号：US15440810

申请日：2017-02-23

Applicant: salesforce.com, inc.

Inventor： Bohan Chen ,  Donald Tam ,  Jesse Collins ,  Sheng Qiao ,  Ted Liu ,  Youngjin Yu

IPC: G06F11/20 ,  G06F16/27 ,  G06F16/23 ,  G06F11/16

Abstract: An automated self-healing database system is provided that includes a primary database, an application server that writes data to the primary database and reads data from the primary database when it is available, a standby database that is a replica of the primary database, and a self-healing module (SHM). The SHM can automatically detect unavailability of the primary database, and if the standby database is available, the SHM can automatically enable the standby database as readable and writable, assign the standby database the role of primary database at the primary site to start replicating data to other standby databases, and use a pre-established connection between the application server and the standby database to allow the application server to read data from the standby database and to write data to the standby database resulting in the standby database assuming role of the primary database at the primary site.

公开(公告)号：US20180239677A1

公开(公告)日：2018-08-23

申请号：US15440810

申请日：2017-02-23

Applicant: salesforce.com, inc.

Inventor： Bohan Chen ,  Donald Tam ,  Jesse Collins ,  Sheng Qiao ,  Ted Liu ,  Youngjin Yu

IPC: G06F11/20 ,  G06F17/30

CPC classification number: G06F11/203 ,  G06F11/1666 ,  G06F11/2094 ,  G06F16/2308 ,  G06F16/27 ,  G06F2201/80 ,  G06F2201/805 ,  G06F2201/82

Abstract: An automated self-healing database system is provided that includes a primary database, an application server that writes data to the primary database and reads data from the primary database when it is available, a standby database that is a replica of the primary database, and a self-healing module (SHM). The SHM can automatically detect unavailability of the primary database, and if the standby database is available, the SHM can automatically enable the standby database as readable and writable, assign the standby database the role of primary database at the primary site to start replicating data to other standby databases, and use a pre-established connection between the application server and the standby database to allow the application server to read data from the standby database and to write data to the standby database resulting in the standby database assuming role of the primary database at the primary site.

公开(公告)号：US20190294512A1

公开(公告)日：2019-09-26

申请号：US16440104

申请日：2019-06-13

Applicant: salesforce.com, inc.

Inventor： Bohan Chen ,  Donald Tam ,  Jesse Collins ,  Sheng Qiao ,  Ted Liu ,  Youngjin Yu

IPC: G06F11/20 ,  G06F16/23 ,  G06F16/27 ,  G06F11/16

Abstract: An automated self-healing database system is provided that includes a primary database, an application server that writes data to the primary database and reads data from the primary database when it is available, a standby database that is a replica of the primary database, and a self-healing module (SHM). The SHM can automatically detect unavailability of the primary database, and if the standby database is available, the SHM can automatically enable the standby database as readable and writable, assign the standby database the role of primary database at the primary site to start replicating data to other standby databases, and use a pre-established connection between the application server and the standby database to allow the application server to read data from the standby database and to write data to the standby database resulting in the standby database assuming role of the primary database at the primary site.