Electronic Arts Inc.

Mengxin Ye

Jian Zhou

Shengyong Li

Anand Nair

Greg William Schaefer

Miao Xiong

Xin Feng Zhang

Xinfeng Zhang

Zhifeng Chen

Xiaokai Wu

An example method of live migration of distributed databases may include implementing a first database access mode with respect to a distributed database to be migrated from an original set of storage servers to a destination set of storage servers, wherein, in the first database access mode, database read requests are routed to the original set of storage servers and database update requests are routed to both the original set of storage servers and the destination set of storage servers. The method may further include copying a plurality of records of the distributed database from the original set of storage servers to the destination set of storage servers. The method may further include switching to a second database access mode, in which database read requests are routed to the destination set of storage servers and database update requests are routed to both the original set of storage servers and the destination set of storage servers. The method may further include switching to a post-migration database access mode, in which database read and update requests are routed to the destination set of storage servers.

Live migration of distributed databases

An example distributed database includes a first instance and a second instance. The first instance is configured to: responsive to performing, within a scope of a database update transaction, a first database update operation, invalidate a cache entry residing in the first database cache maintained by the first instance, wherein the first database update operation is reflected by a transaction log maintained by the first instance; perform, within the scope of the database update transaction, a second database update operation to insert an identifier of the cache entry into a predetermined table of the distributed database, wherein the second database update operation is reflected by the transaction log; and responsive to committing the database update transaction, transmit the transaction log to the second instance. The second instance is configured responsive to receiving the transaction log, to: perform the first database update operation specified by the transaction log; and invalidate the cache entry in the second database cache maintained by the second instance.

Low latency cache synchronization in distributed databases

An example method of live migration of distributed databases may include implementing a first intermediate database access mode with respect to a distributed database to be migrated from an original set of storage servers to a destination set of storage servers, wherein, in the first database access mode, database read requests are routed to the original set of storage servers and database update requests are routed to both the original set of storage servers and the destination set of storage servers. The method may further include copying a plurality of records of the distributed database from the original set of storage servers to the destination set of storage servers. The method may further include switching to a second intermediate database access mode, in which database read requests are routed to the destination set of storage servers and database update requests are routed to both the original set of storage servers and the destination set of storage servers. The method may further include switching to a post-migration database access mode, in which database read and update requests are routed to the destination set of storage servers.

Growing community of inventors

Redwood City, CA, United States of America

Mengxin Ye