CPC G06F 16/2282 (2019.01) [G06F 9/5088 (2013.01); G06F 16/24552 (2019.01); G06F 16/27 (2019.01)] | 20 Claims |
1. A data read/write method for a database implemented by a computer apparatus, wherein the data read/write method comprises:
creating a first tablespace carrying a first identifier indicating a first node;
establishing a first connection to a client, wherein the first connection comprises the first identifier;
receiving a first read/write request from the client using the first connection;
determining the first tablespace corresponding to the first connection;
determining, from a plurality of second nodes and the first identifier, the first node corresponding to the first connection or the first tablespace, wherein the computer apparatus comprises the second nodes, and wherein each of the second nodes comprises a first processor and a first memory, wherein the first connection carries the first identifier after determining the first node;
loading data in the first tablespace to the first memory in the first node;
processing the first read/write request using a first working thread that is generated by the first processor in the first node;
processing, by a second working thread in a first thread pool of the computer apparatus, a second read/write request on a second connection carrying the first identifier; and
processing, by a third working thread in a second thread pool of the computer apparatus, a third read/write request on a third connection that does not carry the first identifier.
|