To set up unidirectional transactional replication manually, do the following: 1. Create a new database on the Primary and Standby universes with the same name. 1. Create tables and indexes on both Primary and Standby; the schema must match between the databases, including the number of tablets per table. For example, create the following tables on the Primary and Standby: ```sql create table ordering_test (id int) split into 8 tablets; create table customers ( customer_id UUID, company_name text, customer_state text, primary key (customer_id) ) split into 8 tablets; create table orders ( customer_id uuid, order_id int primary key, order_details jsonb, product_name text, product_code text, order_qty int, constraint fk_customer foreign key(customer_id) references customers(customer_id) ) split into 8 tablets; create index order_covering_index on orders (customer_id, order_id) include( order_qty ) split into 8 tablets; create table if not exists account_balance ( id uuid, name text, salary int, primary key (id) ) split into 8 tablets; create index account_balance_secondary_index on account_balance(name) split into 8 tablets; create table if not exists account_sum ( sum int ) split into 8 tablets; ``` 1. Enable point in time restore (PITR) on the Standby database: ```sh ./bin/yb-admin \ --master_addresses \ create_snapshot_schedule 1 10 ysql.yugabyte ``` 1. If the Primary universe already has data, then follow the bootstrap process described in [Bootstrap a target universe](../async-deployment/#bootstrap-a-target-universe) before setting up replication with the transactional flag. 1. Set up xCluster replication from Primary to Standby using yb-admin as follows: ```sh ./bin/yb-admin \ --master_addresses \ --certs_dir_name \ setup_universe_replication \ _ \ \ \ transactional ``` 1. Set the role of the Standby universe to `STANDBY`: ```sh ./bin/yb-admin \ --master_addresses \ --certs_dir_name \ change_xcluster_role STANDBY ```

To set up unidirectional transactional replication using YugabyteDB Anywhere, do the following: 1. On the Primary universe (with and without data), create a new database. For example: ```sql create database ybdb; \c ybdb ``` 1. Create your tables and indexes. For example, create the following: ```sql create database ybdb; \c ybdb create table ordering_test (id int); create table customers (customer_id UUID, company_name text, customer_state text, primary key (customer_id)); create table orders(customer_id uuid, order_id int primary key, order_details jsonb, product_name text,product_code text, order_qty int, constraint fk_customer foreign key(customer_id) references customers(customer_id)); create index order_covering_index on orders (customer_id, order_id) include( order_qty); create table if not exists account_balance (id uuid, name text, salary int, primary key (id)); create index account_balance_secondary_index on account_balance(name); create table if not exists account_sum ( sum int ); ``` 1. On the Standby, create a new database with the same name (with and without data). During initial replication setup, you don't need to create objects on the Standby cluster. xCluster bootstrap auto-creates tables and objects and restores data on the Standby from the Primary cluster. 1. In YugabyteDB Anywhere, enable point-in-time recovery for the Primary and Standby universes as follows: - Navigate to the universe, **Backups > Point-in-time Recovery**, and click **Enable Point-in-Time Recovery**. ![Enable PITR](/images/yp/create-deployments/xcluster/deploy-xcluster-tran-pitr1.png) - Choose the API, select your database, and specify the retention period, then click **Enable**. ![Enable PITR](/images/yp/create-deployments/xcluster/deploy-xcluster-tran-pitr2.png) For more information on setting up PITR in YugabyteDB Anywhere, refer to [Point-in-time recovery](../../../../yugabyte-platform/back-up-restore-universes/pitr/). 1. Set up xCluster replication from Primary to Standby as follows: - Navigate to your Primary universe, select the **Replication** tab, and click **Configure Replication**. - Enter a name for the replication, set the target universe to the Standby, and click **Next: Select Tables**. - Select the **Enable transactional atomicity** option. - Select your database and click **Validate Table Selection**. If there is data in the databases, then YugabyteDB Anywhere will walk you through the backup and restore process. - Click **Next: Configure Bootstrap**. - Choose the storage configuration to use for backup and click **Bootstrap and Enable Replication**. Note that if there are any connections open against the Standby databases and replication is being set up for a Primary database that already has some data, then Bootstrap and Enable Replication will fail with the following error: ```output Error ERROR: database "database_name" is being accessed by other users DETAIL: There is 1 other session using the database. ``` This is because setting up replication requires backing up the Primary database and restoring the backup to the Standby database after cleaning up any pre-existing data on the Standby. Close any connections to the Standby database and retry the replication setup operation. For more information on setting up replication in YugabyteDB Anywhere, refer to [xCluster replication](../../../../yugabyte-platform/manage-deployments/xcluster-replication/). **Adding a database to an existing replication** Note that, although you don't need to create objects on Standby during initial replication, when you add a new database to an existing replication stream, you _do_ need to create the same objects on the Standby. If Primary and Standby objects don't match, you won't be able to add the database to the replication. In addition, If the WALs are garbage collected from Primary, then the database will need to be bootstrapped. The bootstrap process is handled by YugabyteDB Anywhere. Only the single database is bootstrapped, not all the databases involved in the existing replication.