Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Informatica ActiveVOS 9.2.7
  • All Products

Table of Contents

Search

  1. Preface
  2. Apache Tomcat
  3. WebLogic
  4. IBM Websphere
  5. JBoss
  6. SameSite attribute in cookies

Server Installation, Configuration, and Deployment

Server Installation, Configuration, and Deployment

Back Next

MySQL Multisite Setup

MySQL Multisite Setup

On each site, complete all Process Server prerequisites as well as the following:
  • Step One
    : Configure WS-Security.
  • Step Two
    : Set Up the MySQL Server.
  • Step Three
    : Install the Process Server database schema for the MySQL database
  • Step Four
    : Test MySQL set up using Process Server-provided scripts.
  • Step Five
    : Configure and deploy Process Server.
  • Step Six
    : Add the MultiSite license.
  • Step Seven
    : Configure and enable MultiSite properties.

Step One: Configure WS-Security (Optional)

If desired, configure WS-Security in each server node in each site to enable the MultiSite WS-Security property for site communication. For details, refer to
Configuring Process Server for WS-Security
 elsewhere in this help. Alternately, go to
activevos.com
 to link to the product documentation.

Step Two: Set Up the MySQL Server

You will need to perform the actions described in the following list on each target server. Note that the minimum MySQL version is 5.5.
  1. Create a MySQL config file for each server based on the following file: 
    my-innodb-heavy-4G.ini
    Copy this information to your
    activevos.ini
     files.
  2. Start the server and log in as root.
  3. Create a user who will have permissions to perform replication. For example:
    User:
    replication
     Password:
    activevos
  4. Assign the following rights to the
    replication
     user:
    • RELOAD
    • REPLICATION CLIENT
    • REPLICATION SLAVE
    • SUPER

Step Three: Install the Process Server Database Schema for the MySQL Database

  1. Login in using your administrator password.
  2. Create
    activevos
     schema and install Process Server tables and views.
  3. Stop the MySQL server.
  4. Edit the
    activevos.ini
     file on each server as follows:
    On Server A
    : 
    
server-id = 1
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 1
master-connect-retry = 60

sync_binlog=1
log-bin = C:\mysql\log\log-bin.log # change this to a path/name appropriate to your system
relay-log=MySQLStreamA-relay-bin
# replicate all changes to activevos database, but ignore specific tables
replicate-ignore-table=activevos.AeCounter
replicate-ignore-table=activevos.AeMetaInfo
replicate-ignore-table=activevos.AeLock
replicate-ignore-table=activevos.AeURNValues
    On Server B
    : 
    
server-id = 2
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 2
master-connect-retry = 60
sync_binlog=1
log-bin = C:\mysql\log\log-bin.log # change this to a path/name appropriate to your system
relay-log=MySQLStreamB-relay-bin
# replicate all changes to activevos database, but ignore specific tables
replicate-ignore-table=activevos.AeCounter
replicate-ignore-table=activevos.AeMetaInfo
replicate-ignore-table=activevos.AeLock
replicate-ignore-table=activevos.AeURNValues
  5. Perform the following query on each database: 
    
CHANGE MASTER TO MASTER_HOST='
    [ip address or hostname of master]
    ', 
    MASTER_USER='replication', MASTER_PASSWORD='activevos'
  6. On each database, start replication using the following statement:
    START SLAVE

Step Four: Test MySQL Set Up Using Process Server-provided Scripts

After completing database replication for all databases in your sites, you can test the replication process to determine if your configuration is successful.
Note:
 Multisite setup is based on the default configuration of privileges granted to users in MySQL. If you have revoked privileges from users, such as from the PUBLIC user, you may experience replication problems.
Process Server MultiSite Test Utility
Process Server has a utility that verifies database replication. Essentially, the utility performs inserts and deletes within each site’s database tables and verifies synchronization of the data. To use this utility, you must modify a configuration file to provide parameters describing your environment. Then run the utility with the provided batch file. For details on using this utility, see the
readme.txt
 file. The test files are located in: 
mysql_config\bin\multisite_test
Note:
Be sure that no Process Servers are running when you are testing.

Step Five: Configure and Deploy Process Server

Configure and deploy Process Server by following the instructions in
Process Server and Resource Configuration
.

Step Six: Add the MultiSite license

Launch the Process Console and add the MultiSite license, as described in server and resource configuration. You only need to add the license to one server. The license is replicated to other sites.

Step Seven: Configure and Enable MultiSite Properties

Configure and enable MultiSite properties in Process Console on the
Admin > MultiSite > Site Properties
 page. Some properties are site independent and others are replicated. For information, see the Process Console Help.
0 COMMENTS
We’d like to hear from you!