Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Issue to replicate modifications on both servers in load balancer configuration

nbisoft
Level 2
Level 2

Hi,

Our system is configurated in load balancing with 2 servers.

Everything is working fine (connections...) except that we have issues to replicate modifications on both servers at the same time. For example, if we add a new field and do an update on our oracle database, depending on the server we are actually connected, we could have an error showing that the new field does not exists. The error disapear completely only if the application is restarted the next day. So, if the restart is not done we have the error showing each time we are trying to access the new object.

Thanks in advance for your help,

Nbe

1 Accepted Solution
Vapsy
Correct answer by
Employee
Employee

Hi nbisoft,

It is a known behavior and design for Campaign.

When you make schema modifications, frontal servers actually keep an XML copy of all schemas on the File System.

Not all servers will get the new copy.

Anything which goes into the database will be readily available to all servers but anything picked from File System will not.

So, you will have to work with a change management plan.

Whenever rolling out a new change to the schema, please ask the server team to restart web module for both servers. There will be a downtime of 5-9 seconds but since the connection is load balanced, they can

1. Take server 1 out of LB

2. Restart web on server1

3. Add server1 back to LB and take out server2

4. Restart Server2 web module

5. Add server2 back to LB

Regards,
Vipul

View solution in original post

3 Replies
Adhiyan
Employee
Employee

Hello ,

Can you please share a bit more detail about the architecture.

1>. Do you have 2 app servers connected to a single DB

2>. 2 app servers connected to two different databases.

The issue should not happen if you have the config like 1

Regards,
Adhiyan

Vapsy
Correct answer by
Employee
Employee

Hi nbisoft,

It is a known behavior and design for Campaign.

When you make schema modifications, frontal servers actually keep an XML copy of all schemas on the File System.

Not all servers will get the new copy.

Anything which goes into the database will be readily available to all servers but anything picked from File System will not.

So, you will have to work with a change management plan.

Whenever rolling out a new change to the schema, please ask the server team to restart web module for both servers. There will be a downtime of 5-9 seconds but since the connection is load balanced, they can

1. Take server 1 out of LB

2. Restart web on server1

3. Add server1 back to LB and take out server2

4. Restart Server2 web module

5. Add server2 back to LB

Regards,
Vipul

View solution in original post

nbisoft
Level 2
Level 2

Hello Adhiyan and Vipul,

Thanks for the feedback.

Vipul Raghav​, is it compulsory to remove server from LB before restarting the web? Actually, we have tried restarting the web module and it did not help the situation. Is there any other easy mean to correct the issue?

Regards,

Nbe