2.1 Additional Requirements

• Ensure the platform hosting a query server is dedicated to the query server function. Using the query server platform for any other processing degrades performance and may potentially conflict with the query server operation and produce unpredictable results.

• Use a dedicated 100BASE-TX Ethernet interface.

Note:

The network between the OCLSMS and the query server and between the query server and the daisy-chained query servers must meet the specifications and conditions shown in the Table 2-2 table below.

Table 2-2 Platform Ports Configuration for Firewall Protocol Filtering

Interface	TCP/IPPort	Use	Firewall configuration1 – Port Open for Inbound Access(from Query Server)	Firewall configuration1 – Port Open for Outbound Access(to Query Server)
OCLSMS > Query Server Uses the interface to the OCELAP network, active only on active server. For more information about which interface is used by the OCELAP network, refer to the OCLSMS Configuration Manual.	20	FTP- data(database snapshot)	No	Yes1
	21	FTP(database snapshot)	No	Yes1
	3306	Continuous database replication	Yes2	No
Query Server (master) > Daisy Chained Query Server (slave)	20	FTP- data(database snapshot)	No	Yes1
	21	FTP(database snapshot)	No	Yes1
	3306	Continuous database replication	Yes2	No
The FTP TCP/IP port is required to be open on the OCLSMS and query servers that act as both UPDATWE and slave. This port is used to retrieve the current "snapshot" of the master database so it can be loaded into the query server. The snapshots effectively become the initial version (starting point for replication) of the query server's database. Port 3306 is required to be open on the OCLSMS and query servers that act as both master and slave. The query server connects to the master server on port 3306 to receive continuous replication updates. If the feature “Configurable MySQL port” is enabled on OCLSMS, the configured port is required to be open on the OCLSMS.