Share replication between remote deployments
Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. For example, the method may comprise modifying a share object of a first account of a data exchange into a global object wherein the share object includes grant metadata indicating share grants to a set of objects of a database. The method may further comprise creating, in a second account of the data exchange, a local replica of the share object on the remote deployment based on the global object, wherein the second account is located in a remote deployment. The set of objects of the database may be replicated to a local database replica on the remote deployment and the share grants may be replicated to the local replica of the share object.
1. A method comprising:
creating, in a second database account, a local replica of a share object of a first database account, wherein the first and second database accounts are located in first and second regions respectively and wherein the share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account;
replicating the set of objects of the database to a local database replica located in the second region and associated with the second database account; and
refreshing, by a processing device, the grant metadata to the local replica of the share object using a global message comprising logic to process the grant metadata.
2. The method of claim 1 , wherein refreshing the grant metadata to the local replica of the share object comprises:
receiving a share refresh message;
serializing the grant metadata of the share object;
storing the serialized grant metadata into the global message, wherein the global message comprises logic to inform a deployment in the second region that the global message includes grant metadata and enable the deployment to properly deserialize the grant metadata for the purposes of share replication; and
transmitting the global message to the second deployment.
3. The method of claim 2 , wherein refreshing the grant metadata to the local replica of the share object further comprises:
de-serializing the global message based on the logic of the global message; and
applying the grant metadata to the local replica of the share object.
4. The method of claim 2 , wherein in response to determining that one or more of the set of objects are not present in the local database replica during the subsequent refresh:
refreshing grant metadata associated with objects that are present in the local database replica to the local replica of the share object; and
creating a log file indicating:
the one or more objects that are not present in the local database replica; and
grant metadata associated with the one or more objects that are not present in the local database replica.
5. The method of claim 1 , further comprising:
performing a subsequent refresh of the grant metadata to the local replica of the share object; and
performing a subsequent replication of the set of objects of the database to the local database replica, wherein one or more of the grant metadata and the set of objects are modified.
6. The method of claim 1 , wherein the grant metadata indicates share grants to the set of objects of the database.
7. The method of claim 1 , wherein creating the local replica comprises:
establishing a secure connection between the first database account and the second database account; and
establishing a remote execution context in the second database account, wherein the first database account may create the local replica in the second database account using the remote execution context.
8. A system comprising:
a memory; and
a processing device, operatively coupled to the memory, the processing device to:
create, in a second database account, a local replica of a share object of a first database account, wherein the first and second database accounts are located in first and second regions respectively and wherein the share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account;
replicate the set of objects of the database to a local database replica located in the second region and associated with the second database account; and
refresh the grant metadata to the local replica of the share object using a global message comprising logic to process the grant metadata.
9. The system of claim 8 , wherein to refresh the grant metadata to the local replica of the share object, the processing device is to:
receive a share refresh message;
serialize the grant metadata of the share object;
store the serialized grant metadata into the global message, wherein the global message comprises logic to inform a deployment in the second region that the global message includes grant metadata and enable the deployment to properly deserialize the grant metadata for the purposes of share replication; and
transmit the global message to the second deployment.
10. The system of claim 9 , wherein to refresh the grant metadata to the local replica of the share object, the processing device is further to:
de-serialize the global message based on the logic of the global message; and
apply the grant metadata to the local replica of the share object.
11. The system of claim 9 , wherein in response to determining that one or more of the set of objects are not present in the local database replica during the subsequent refresh, the processing device is to:
refresh grant metadata associated with objects that are present in the local database replica to the local replica of the share object; and
create a log file indicating:
the one or more objects that are not present in the local database replica; and
grant metadata associated with the one or more objects that are not present in the local database replica.
12. The system of claim 8 , wherein the processing device is further to:
perform a subsequent refresh of the grant metadata to the local replica of the share object; and
perform a subsequent replication of the set of objects of the database to the local database replica, wherein one or more of the grant metadata and the set of objects are modified.
13. The system of claim 8 , wherein the grant metadata indicates share grants to the set of objects of the database.
14. The system of claim 8 , wherein to create the local replica, the processing device is to:
establish a secure connection between the first database account and the second database account; and
establish a remote execution context in the second database account, wherein the first database account may create the local replica in the second database account using the remote execution context.
15. A non-transitory computer-readable medium having instructions stored thereon which, when executed by a processing device causes the processing device to:
create, in a second database account, a local replica of a share object of a first database account, wherein the first and second database accounts are located in first and second regions respectively and wherein the share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account;
replicate the set of objects of the database to a local database replica located in the second region and associated with the second database account; and
refresh, by the processing device, the grant metadata to the local replica of the share object using a global message comprising logic to process the grant metadata.
16. The non-transitory computer-readable medium of claim 15 , wherein to refresh the grant metadata to the local replica of the share object, the processing device is to:
receive a share refresh message;
serialize the grant metadata of the share object;
store the serialized grant metadata into the global message, wherein the global message comprises logic to inform a deployment in the second region that the global message includes grant metadata and enable the deployment to properly deserialize the grant metadata for the purposes of share replication; and
transmit the global message to the second deployment.
17. The non-transitory computer-readable medium of claim 16 , wherein to refresh the grant metadata to the local replica of the share object, the processing device is further to:
de-serialize the global message based on the logic of the global message; and
apply the grant metadata to the local replica of the share object.
18. The non-transitory computer-readable medium of claim 16 , wherein in response to determining that one or more of the set of objects are not present in the local database replica during the subsequent refresh, the processing device is to:
refresh grant metadata associated with objects that are present in the local database replica to the local replica of the share object; and
create a log file indicating:
the one or more objects that are not present in the local database replica; and
grant metadata associated with the one or more objects that are not present in the local database replica.
19. The non-transitory computer-readable medium of claim 15 , wherein the processing device is further to:
perform a subsequent refresh of the grant metadata to the local replica of the share object; and
perform a subsequent replication of the set of objects of the database to the local database replica, wherein one or more of the grant metadata and the set of objects are modified.
20. The non-transitory computer-readable medium of claim 15 , wherein the grant metadata indicates share grants to the set of objects of the database.
21. The non-transitory computer-readable medium of claim 15 , wherein to create the local replica, the processing device is to:
establish a secure connection between the first database account and the second database account; and
establish a remote execution context in the second database account, wherein the first database account may create the local replica in the second database account using the remote execution context.