Cause a Replication

Now you can modify the stock table on one database server and see the change reflected on the other database servers.

To cause a replication

Use DB–Access to insert a line into the stock table on usa:

INSERT INTO stores@usa:stock VALUES (401, "PRC", "ski boots", 200.00, "pair", "pair");

Observe the change on the italy and japan database servers:

SELECT * from stores@italy:stock;
SELECT * from stores@japan:stock;

To update the stock table on the japan database server

Use DB–Access to change a value in the stock table on japan:

UPDATE stores@japan:stock SET unit_price = 190.00
WHERE stock_num = 401;

Verify that the change has replicated to the stock table on usa and on italy:

SELECT * from stores@usa:stock WHERE stock_num = 401;
SELECT * from stores@italy:stock WHERE stock_num = 401;