WRITEABLE PARTITIONS WITHIN READ-ONLY REPLICATED RECORDS
Techniques for using writeable partitions with read-only replicated records include one or more non-transitory computer-readable media storing program instructions that, when executed by one or more processors of an authorization server, cause the one or more processors to perform a method including receiving a replica of a portion of a database, storing the replica of the portion of the database in a read-only partition, adding a field to the portion of the database in a writeable partition, and writing data to the added field.
1 . One or more non-transitory computer-readable media storing program instructions that, when executed by one or more processors of a first node, cause the one or more processors to perform a method comprising:
receiving a replica of a portion of a database;
storing the replica of the portion of the database in a read-only partition;
adding a field to the replica of the portion of the database in a writeable partition; and
writing data to the added field.
2 . The one or more non-transitory computer-readable media of claim 1 , wherein the replica of the portion of the database includes records received from a second node.
3 . The one or more non-transitory computer-readable media of claim 1 , wherein the method further comprises:
receiving a query to execute on the portion of the database to access data in data in both the read-only partition and the writeable partition; and
executing the query without using a join.
4 . The one or more non-transitory computer-readable media of claim 1 , wherein the method further comprises replicating the portion of the database including both the read-only partition and the writeable partition to another node.
5 . The one or more non-transitory computer-readable media of claim 1 , wherein the portion of the database comprises a database table, a plurality of documents from a document-based database, or a plurality of key-value pairs from a key-value database.
6 . The one or more non-transitory computer-readable media of claim 1 , wherein the read-only partition is associated with a partition identifier identifying the read-only partition as read-only.
7 . The one or more non-transitory computer-readable media of claim 1 , wherein the writeable partition is associated with a partition identifier identifying the writeable partition as writeable.
8 . The one or more non-transitory computer-readable media of claim 1 , wherein each portion of the database in the read-only partition is associated with metadata indicating that the portion of the database in the read-only partition is read-only.
9 . The one or more non-transitory computer-readable media of claim 1 , wherein each portion of the database in the writeable partition is associated with metadata indicating that each portion is writeable.
10 . The one or more non-transitory computer-readable media of claim 1 , wherein the portion of the database comprises a database table, and adding the field to the portion of the database in the writeable partition further comprises adding a writeable column to the database table.
11 . The one or more non-transitory computer-readable media of claim 1 , wherein the method further comprises adding a second field to the portion of the database in the writeable partition, wherein the field is writeable only by a first user and the second field is writeable only by a second user.
12 . A system comprising:
memory storing instructions; and
one or more processors coupled to the memory and, when executing the instructions, are configured to perform operations comprising:
receiving a replica of a portion of a database;
storing the replica of the portion of the database in a read-only partition;
adding a field to the replica of the portion of the database in a writeable partition; and
writing data to the added field.
13 . The system of claim 12 , wherein the replica of the portion of the database includes records received from a second node.
14 . The system of claim 12 , wherein the operations further comprise:
receiving a query to execute on the portion of the database to access data in data in both the read-only partition and the writeable partition; and
executing the query without using a join.
15 . The system of claim 12 , wherein the operations further comprise replicating the portion of the database including both the read-only partition and the writeable partition to another node.
16 . The system of claim 12 , wherein the portion of the database comprises a database table, a plurality of documents from a document-based database, or a plurality of key-value pairs from a key-value database.
17 . The system of claim 12 , wherein the read-only partition is associated with a partition identifier identifying the read-only partition as read-only.
18 . The system of claim 12 , wherein the writeable partition is associated with a partition identifier identifying the writeable partition as writeable.
19 . The system of claim 12 , wherein each portion of the database in the read-only partition is associated with metadata indicating that the portion of the database in the read-only partition is read-only.
20 . The system of claim 12 , wherein each portion of the database in the writeable partition is associated with metadata indicating that each column is writeable.
21 . The system of claim 12 , wherein the portion of the database comprises a database table, and adding the field to the portion of the database in the writeable partition further comprises adding a writeable column to the database table.
22 . The system of claim 12 , wherein the operations further comprise adding a second field to the portion of the database in the writeable partition, wherein the field is writeable only by a first user and the second field is writeable only by a second user.
23 . A computer-implemented method comprising:
receiving a replica of a portion of a database;
storing the replica of the portion of the database in a read-only partition;
adding a field to the replica of the portion of the database in a writeable partition; and
writing data to the added field.
24 . The computer-implemented method of claim 23 , wherein the replica of the portion of the database includes records received from a second node.
25 . The computer-implemented method of claim 23 , wherein the method further comprises:
receiving a query to execute on the portion of the database to access data in data in both the read-only partition and the writeable partition; and
executing the query without using a join.
26 . The computer-implemented method of claim 23 , wherein the method further comprises replicating the portion of the database including both the read-only partition and the writeable partition to another node.
27 . The computer-implemented method of claim 23 , wherein the portion of the database comprises a database table, a plurality of documents from a document-based database, or a plurality of key-value pairs from a key-value database.
28 . The computer-implemented method of claim 23 , wherein the read-only partition is associated with a partition identifier identifying the read-only partition as read-only.
29 . The computer-implemented method of claim 23 , wherein the writeable partition is associated with a partition identifier identifying the writeable partition as writeable.
30 . The computer-implemented method of claim 23 , wherein each portion of the database in the read-only partition is associated with metadata indicating that the portion of the database in the read-only partition is read-only.
31 . The computer-implemented method of claim 23 , wherein each portion of the database in the writeable partition is associated with metadata indicating that each column is writeable.
32 . The computer-implemented method of claim 23 , wherein the portion of the database comprises a database table, and adding the field to the portion of the database in the writeable partition further comprises adding a writeable column to the database table.
33 . The computer-implemented method of claim 23 , wherein the method further comprises adding a second field to the portion of the database in the writeable partition, wherein the field is writeable only by a first user and the second field is writeable only by a second user.