公开(公告)号：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.

公开(公告)号：US20210286824A1

公开(公告)日：2021-09-16

申请号：US16880965

申请日：2020-05-21

Applicant: salesforce.com, inc.

Inventor： Sheng Qiao ,  Zhaohui George Yao ,  Kim S. Lee ,  Abhishek Chaturvedi ,  Jeff Zhu ,  Mukesh Burgupalli

IPC: G06F16/27 ,  G06F16/21 ,  G06F3/06

Abstract: An online system performs upgrades of replicated databases. The online system stores data in a primary site and a secondary site. The primary site comprising databases used to process client requests and a secondary site comprising databases used as standby. The online system upgrades databases of both sites by upgrading the secondary site, switching client requests to the secondary site while using the databases of primary site as standby databases. The online system then upgrades the primary site. The process allows the online system to upgrade databases with small down time.

公开(公告)号：US12050618B2

公开(公告)日：2024-07-30

申请号：US16880965

申请日：2020-05-21

Applicant: salesforce.com, inc.

Inventor： Sheng Qiao ,  Zhaohui George Yao ,  Kim S. Lee ,  Abhishek Chaturvedi ,  Jeff Zhu ,  Mukesh Burgupalli

IPC: G06F16/27 ,  G06F3/06 ,  G06F16/21

CPC classification number: G06F16/27 ,  G06F3/0607 ,  G06F3/064 ,  G06F3/065 ,  G06F3/0683 ,  G06F16/21

Abstract: An online system performs upgrades of replicated databases. The online system stores data in a primary site and a secondary site. The primary site comprising databases used to process client requests and a secondary site comprising databases used as standby. The online system upgrades databases of both sites by upgrading the secondary site, switching client requests to the secondary site while using the databases of primary site as standby databases. The online system then upgrades the primary site. The process allows the online system to upgrade databases with small down time.

公开(公告)号：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.