The following are the steps we followed for setting up Master-Child Architecture. First make sure you have the latest version of Profiler 4.6.8 Build:20140918 and up. After successfully installing the application on all the servers and right before you start up tomcat on the servers do the following:

Step 1:

  • Go to /securonix/securonix_home/conf/application-context.xml
  • On the line that says <application-settings, make sure the URL points to the exact hostname with its url for example url="http://securonix1:8080/Profiler"
  • On the line that says <clustering , make sure clustering is enabled for all nodes. Make sure master="false" for the child nodes and master="true" for the master. Next make sure that the nodename unique for all servers and the name doesn't contain any special characters.
  • Save changes

Step 2: - Go to /securonix/securonix_home/conf/hibernate/hibernate.cfg.default.xml - Make sure that the url under <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" is "http://hibernate.org/dtd/hibernate-mapping-3.0.dtd" - Save Changes

Step 3:

  • Start up tomcat on all servers master and children
  • Use the UI only on the master node and go to Configure -> Clustering
  • Make sure enable clustering is turned on , at the top right
  • The master node is registered and shows up with its host name and url
  • Click on Action -> Register new node
  • Enter the details of the child node , with the unique node name and application url.
  • The Manager url as shown will be something like http://securonix1:8080/manager
  • Click on test node url.
  • Click on next
  • Enter the connection parameters for the child database, using the same host name and test the connection.
  • Click on Register Node and the child nodes will show up on the master node's UI.

asked 01 Oct '14, 14:43

Kayzadv's gravatar image

Kayzadv
2516
accept rate: 0%

edited 01 Oct '14, 17:46


Other additional validations for enabling clustering -

DB Permissions -

Make sure that the permissions are set correctly on the Master and the child node DB servers so that these servers can access each other without any issues. Use the following commands on each server to enable appropriate permissions -

On the master node, log into mysql and run the following commands -

  1. Grant all privileges on <db_name>.* to '<username>'@<'childnodeIP/hostname>' identified by '<password>';
  2. Flush Privileges;

Similarly, the permissions on the child node DB server can be modified to enable the Master node to access the DB.

SecuronixDB connection type configuration on Master -

While creating the SecuronixDB connection type on the Master node, make sure that the URL in the connection has the IP/hostname of the master node specified on it rather than having 'localhost'. This is because the child nodes use this connection type details to connect to the Master node.

link

answered 07 Oct '14, 07:41

Aditya's gravatar image

Aditya
10017
accept rate: 6%

Along with the above mentioned commands, the following command can be executed-

  1. Grant super on <db_name>.* to '<username>'@<'childnodeIP/hostname>' identified by '<password>' with grant option;
  2. Flush Privileges;

Similarly, the permissions on the child node DB server can be modified to enable the Master node to access the DB.

link

answered 03 Sep '15, 11:06

Anusha's gravatar image

Anusha
151
accept rate: 0%

GRANT ALL PRIVILEGES ON . TO 'user'@'10.0.2.xxx' IDENTIFIED BY 'password';

GRANT SUPER ON . TO 'user'@'10.0.2.xxx' IDENTIFIED BY 'password';

flush privileges;

link

answered 25 Nov '15, 01:02

Praful's gravatar image

Praful ♦♦
1264923
accept rate: 5%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×4

Asked: 01 Oct '14, 14:43

Seen: 3,362 times

Last updated: 25 Nov '15, 01:02