Home > Storage > Data Storage Essentials > Storage Resource Manager (SRM) > Dell SRM: Disaster Recovery and Federated Architecture > Global site deployment tasks
Global site deployment tasks depend on the data replication type from the DR architecture.
The following command is an example for jdbc resource APG-DB1 from GLOBAL-ABE1 backend server (database apg1):
GLOBAL-FE# manage-resources.sh create dba/APG-DB1 '{"type":"jdbc","datasource":{"maxActive":"10","maxIdle":"10","validationQuery":"SELECT 1","testOnBorrow":"false","testWhileIdle":"true","validationQueryTimeout":"5","timeBetweenEvictionRunsMillis":"10000","minEvictableIdleTimeMillis":"60000","maxWait":"10000","removeAbandoned":"true","removeAbandonedTimeout":"60","logAbandoned":"true","driverClassName":"com.mysql.jdbc.Driver","username":"apg","password":"{6230FED930DD59BEB1095D6801AA74E2FC23B2C8B76AFF6447D5C49B84C4001FDF5B6441DF7CD5CB2B19D4A927C63934}","url":"jdbc:mysql://GLOBAL-ABE1:53306/apg1?autoReconnect=true&connectTimeout=20000&maxReconnects=2"},"settings":{'cachegrp': 'DB'}}'
The following command is an example for mgmt resource APG-DB1 from GLOBAL-ABE1 backend server (backend apg1):
GLOBAL-FE# manage-resources.sh create mgmt/APG-DB1 '{"type": "webservice","connection": {"disableSSLValidation": true,"url": "https://GLOBAL-ABE1:48443/Backends/APG-Backend/apg1","user": "admin","password": "{68951D237EABAFD17BD2F90B2029E51B9078C3968D27791E745EB38C2F8E4B7B6351D632200618220667E25792D7E8894330B34886D638E3C3B93856C94998B9}"}}'
For example, run this command on global PBE and ABE servers:
mysql> grant all privileges on *.* to 'apg'@'GLOBAL-FE' IDENTIFIED BY 'watch4net';
Note: If global frontends should have their own reports, independent of regional report templates, importing the master templates table into the global PBE is not necessary.
GLOBAL-PBE# /opt/APG/Databases/MySQL/Default/bin/mysql -hlocalhost -P 53306 -uapg -pwatch4net -S /opt/APG/Databases/MySQL/Default/data/mysql.sock -D master < /opt/APG/templates.sql
Events databases (genericevents_live table) are on regional site's PBE server and are not replicated to the global PBE. The genericevents_live table has a flat structure and does not refer to other tables, as is the case with time-series databases. Querying it from the frontend does not require the same amount of time it would require querying a time-series database (apg). For this reason, we are not replicating events databases from a regional site to the global site but are reaching them directly from the global frontend.
The following command is an example for jdbc resource FLOW-EVENTS-GENERIC-A from REGION-A-PBE server (database events, table genericevents_live):
GLOBAL-FE# manage-resources.sh create dba/FLOW-EVENTS-GENERIC-A '{"type":"jdbc","datasource":{"maxActive":"10","maxIdle":"10","validationQuery":"SELECT 1","testOnBorrow":"false","testWhileIdle":"true","validationQueryTimeout":"5","timeBetweenEvictionRunsMillis":"10000","minEvictableIdleTimeMillis":"60000","maxWait":"10000","removeAbandoned":"true","removeAbandonedTimeout":"60","logAbandoned":"true","driverClassName":"com.mysql.jdbc.Driver","username":"apg","password":"{6230FED930DD59BEB1095D6801AA74E2FC23B2C8B76AFF6447D5C49B84C4001FDF5B6441DF7CD5CB2B19D4A927C63934}","url":"jdbc:mysql://REGION-A-PBE:53306/events?autoReconnect=true&connectTimeout=20000&maxReconnects=2"},"settings":{"mapping":"FLOW-GENERIC-EVENT.xml","table":"genericevents_live"}}'
For example, run the following command on the REGION-A-PBE server:
mysql> grant all privileges on events.* to 'apg'@'GLOBAL-FE' IDENTIFIED BY 'watch4net';
It will cause the Alerts reports to show events data from all genericevents_live database tables (regional+global), not only the default one from the global PBE.
<!-- Alerting Properties -->
<Resource name="manager/REGION-A-ABE" auth="Container" type="com.watch4net.alerting.jmx.AlertManagerFactory" factory="org.apache.naming.factory.BeanFactory" user="admin" pass="{F6692B2ECA1E1C6CE5B00669EA6C364E687A673F4DA9BAB6136C9F9A6F0242B3C3152CCE07E4215A8D7DBB20F292A2EF}" url="service:jmx:rmi:///jndi/rmi://REGION-A-ABE:52569/jmxrmi"/>
<Resource name="manager/REGION-B-ABE" auth="Container" type="com.watch4net.alerting.jmx.AlertManagerFactory" factory="org.apache.naming.factory.BeanFactory" user="admin" pass="{F6692B2ECA1E1C6CE5B00669EA6C364E687A673F4DA9BAB6136C9F9A6F0242B3C3152CCE07E4215A8D7DBB20F292A2EF}" url="service:jmx:rmi:///jndi/rmi://REGION-B-ABE:52569/jmxrmi"/>
The following command is an example for jdbc resource APG-DB1 from GLOBAL-ABE1 backend server (database apg1):
GLOBAL-FE# manage-resources.sh create dba/APG-DB1 '{"type":"jdbc","datasource":{"maxActive":"10","maxIdle":"10","validationQuery":"SELECT 1","testOnBorrow":"false","testWhileIdle":"true","validationQueryTimeout":"5","timeBetweenEvictionRunsMillis":"10000","minEvictableIdleTimeMillis":"60000","maxWait":"10000","removeAbandoned":"true","removeAbandonedTimeout":"60","logAbandoned":"true","driverClassName":"com.mysql.jdbc.Driver","username":"apg","password":"{6230FED930DD59BEB1095D6801AA74E2FC23B2C8B76AFF6447D5C49B84C4001FDF5B6441DF7CD5CB2B19D4A927C63934}","url":"jdbc:mysql://GLOBAL-ABE1:53306/apg1?autoReconnect=true&connectTimeout=20000&maxReconnects=2"},"settings":{'cachegrp': 'DB'}}'
The following command is an example for mgmt resource APG-DB1 from GLOBAL-ABE1 backend server (backend apg1):
GLOBAL-FE# manage-resources.sh create mgmt/APG-DB1 '{"type": "webservice","connection": {"disableSSLValidation": true,"url": "https://GLOBAL-ABE1:48443/Backends/APG-Backend/apg1","user": "admin","password": "{68951D237EABAFD17BD2F90B2029E51B9078C3968D27791E745EB38C2F8E4B7B6351D632200618220667E25792D7E8894330B34886D638E3C3B93856C94998B9}"}}'
For example, run the following command on global PBE and ABE servers:
mysql> grant all privileges on *.* to 'apg'@'GLOBAL-FE' IDENTIFIED BY 'watch4net';
Note: If global frontends should have their own reports, independent of regional report templates, importing the master templates table into the global PBE is not necessary.
GLOBAL-PBE# /opt/APG/Databases/MySQL/Default/bin/mysql -hlocalhost -P 53306 -uapg -pwatch4net -S /opt/APG/Databases/MySQL/Default/data/mysql.sock -D master < /opt/APG/templates.sql
Events replication: Events replication is performed natively over global LBCs. Global frontends will query events database from global PBE server (default behavior) and will not query events database from regional sites
Alerting: The global frontend has declared access to the alerting backend on the global PBE. It has alert definitions replicated from PROD ABE.