Use data agents on your remote database systems to better load balance data migration.

Before You Start

Download Cirro Data Agent installer

  • Click Data Puppy then Add Agent

  • Click the download link and choose a download folder.

  • Run the installer on each of your remote servers.

Execute SQL

Execute these commands for each remote data agent.

  • Click Data Puppy > Federated Query.

  • Enter the following:


set passthrough 'CIRRO' true

select * from rms.rdbmsrms;

update rms.rdbmsrms set connection = 'jdbc:derby://organization:1088' where id = 12 and connection = 'jdbc:derby://localhost:1088';

update rms.rdbmsrms set connection = 'jdbc:postgresql://organization:5432' where id in (5,10) and connection = 'jdbc:postgresql://localhost:5432';

select * from rms.rdbmsrms;

set passthrough 'CIRRO' false

Where:

  • CIRRO - is local Cirro server

  • jdbc:derby://organization:1088 - substitute your hostname or IP address of the Cirro installation in place of organization

For example:


set passthrough 'CIRRO' true

select * from rms.rdbmsrms;

update rms.rdbmsrms set connection = 'jdbc:derby://ogranization.cirro.com:1088' where id = 12 and connection = 'jdbc:derby://localhost:1088';

update rms.rdbmsrms set connection = 'jdbc:postgresql://organization.cirro.com:5432' where id in (5,10) and connection = 'jdbc:postgresql://localhost:5432';

select * from rms.rdbmsrms;

set passthrough 'CIRRO' false

Restart Cirro hub process

  • Login to your Cirro command line as root.

  • Execute the following:

cirro_fqod restart

See Also