Provide a way to transactionally manage a set of records /domains

Designate needs to provide a way to manipulate multiple records/domains with transaction support built into it. For example, a tenant who owns multiple domains should be able to add records in one domain while deleting in another domain. All of this manipulation should be either successful or rolled back together. At a minimum, this feature needs to work on a single domain where adding some records while deleting some records should be done with transaction support built in. This will have impact on API access, Database etc