OS4X master-slave database usage - Revision history

Admin at 12:47, 21 January 2025

2025-01-21T12:47:30Z

Admin at 14:47, 15 June 2008

2008-06-15T14:47:04Z

Admin: New page: If your environment enforces a parallel database installation, where OS4X should use the slave database (i.e. in a DMZ or multi-application firewalled environment), OS4X webinterface is ab...

2007-12-01T15:56:58Z

New page: If your environment enforces a parallel database installation, where OS4X should use the slave database (i.e. in a DMZ or multi-application firewalled environment), OS4X webinterface is ab...

New page

If your environment enforces a parallel database installation, where OS4X should use the slave database (i.e. in a DMZ or multi-application firewalled environment), OS4X webinterface is able to change both the main defined database, but also another (slave) database for various updates. These entities are the following:
*basic configuration
*CAPI configuration
*partner specific CAPI configuration
*cipher suite definition
*automatic software update settings
*position of a self-signed certificate
*OFTP partner configuration
*send queue entries (status, priority etc.)
*receive queue
*poll queue

The behaviour can be enabled with the configuration switch "[[OS4X Core configuration#Update_other_partner_database_too.3F]]". The remote partner database parameter can be inserted if the switch is enabled. The defined database has to be the same schema as the local one, since the SQL statements are executed on both databases.

The configured database user must have INSERT, UPDATE and DELETE permissions on the configured database. '''It's highly recommended to configure the "slave" OS4X web interface to use a database user which has no writing permissions in the database, but data SELECT permissions only.'''

When changing information in the "master" environment, the data will be transfered to the second database server, executed there. If there is any error during this transfer, there will appear an error message in the web interface. The error should then be fixed and the command restarted in order to have a consistent databse.

Before starting in such an environment, you should clone the complete database from the master to the slave, so they have the same ky information, like auto-increment values etc.!

@@ Line 15: / Line 15: @@
 The configured database user must have INSERT, UPDATE and DELETE permissions on the configured database. '''It's highly recommended to configure the "slave" OS4X web interface to use a database user which has no writing permissions in the database, but data SELECT permissions only.'''
-When changing information in the "master" environment, the data will be transfered to the second database server, executed there. If there is any error during this transfer, there will appear an error message in the web interface. The error should then be fixed and the command restarted in order to have a consistent databse.
+When changing information in the "master" environment, the data will be transferred to the second database server, executed there. If there is any error during this transfer, there will appear an error message in the web interface. The error should then be fixed and the command restarted in order to have a consistent databse.
 Before starting in such an environment, you should clone the complete database from the master to the slave, so they have the same ky information, like auto-increment values etc.!

@@ Line 11: / Line 11: @@
 *poll queue
-The behaviour can be enabled with the configuration switch "[[OS4X Core configuration#Update_other_partner_database_too.3F]]". The remote partner database parameter can be inserted if the switch is enabled. The defined database has to be the same schema as the local one, since the SQL statements are executed on both databases.
+The behaviour can be enabled with the configuration switch "[[OS4X Core configuration#Update_other_partner_database_too.3F|Update other partner database too?]]". The remote partner database parameter can be inserted if the switch is enabled. The defined database has to be the same schema as the local one, since the SQL statements are executed on both databases.
 The configured database user must have INSERT, UPDATE and DELETE permissions on the configured database. '''It's highly recommended to configure the "slave" OS4X web interface to use a database user which has no writing permissions in the database, but data SELECT permissions only.'''