System, method and database proxy server for separating operations of read and write

A non-transitory machine-readable storage medium having embedded therein program instructions, which when executed by a processor causes the processor to execute a method of operating a database system, the method comprising:

• receiving a client connection request from a client device, the client connection request including a client ID and a password;
• sending a slave connection request in response to the client connection request to a client read-only slave database, the slave connection request including the client ID and the password, the client read-only slave database having identical datasets as a client write-only master database;
• receiving a response to the slave connection request from the client read-only slave database that establishes a slave database connection with the client read-only slave database when the client read-only slave database verifies the client ID and the password;
• storing the client ID as a stored client ID after the slave database connection has been established;
• receiving a write request from the client device, the write request including the client ID;
• sending a master connection request to the client write-only master database, the master connection request including a public ID and a public passcode;
• receiving a response to the master connection request from the client write-only master database that establishes a master database connection with the client write-only master database when the client write-only master database verifies the public ID and the public passcode;
• sending the client ID and an access permission associated with the client ID to the client write-only master database by way of the master database connection;
• and
• sending the write request to the client write-only master database after the client ID has been sent to the client write-only master database, the client write only master database preventing the client device from writing to areas that have not been assigned to the client device based on the access permission associated with the client ID.

A database system comprising:

• a client write-only master database;
• a client read-only slave database, the client read-only slave database having identical datasets as the client write-only master database;
• and
• a proxy server coupled to the client write-only master database and the client read-only slave database,
• the proxy server to:
• receive a client connection request from a client device, the client connection request including a client ID and a password;
• send a slave connection request in response to the client connection request to the client read-only slave database, the slave connection request including the client ID and the password;
• the client read-only slave database to receive the slave connection request, verify the client ID and the client passcode, and output a response to the slave connection request to establish a slave database connection with the proxy server when the client read-only slave database verifies the client ID and client passcode;
• the proxy server to:
• receive the response to the slave connection request from the client read-only slave database that establishes the slave database connection with the client read-only slave database when the client read-only slave database verifies the client ID and the password;
• store the client ID as a stored client ID after the slave database connection has been established;
• receive a write request from the client device, the write request including the client ID;
• send a master connection request to the client write-only master database, the master connection request including a public ID and a public passcode;
• the client write-only master database to receive the master connection request, verify the public ID and the public passcode, and output a response to establish a master database connection with the proxy server when client write-only master database verifies the public ID and public passcode;
• the proxy server to:
• receive the response to the master connection request from the client write-only master database that establishes the master database connection with the client write-only master database when the client write-only master database verifies the public ID and the public passcode;
• send the client ID and an access permission associated with the client ID to the client write-only master database by way of the master database connection;
• and
• send the write request to the client write-only master database after the client ID has been sent to the client write-only master database;
• and
• the client write-only master database to prevent the client device from writing to areas that have not been assigned to the client device based on the access permission associated with the client ID.