How to make MID server failover

[Jae1]

Hello Team,

I have a question regarding failover cluster configuration for MID server.

The customer is using external data sources(JDBC connection) with the MID server.

Per product document,

For performance and reliability reasons, these data sources should not be used with MID Server clusters.

Using MID Server clusters for JDBC data sources can cause duplicate and out-of-date data

https://docs.servicenow.com/bundle/paris-servicenow-platform/page/product/mid-server/task/t_ConfigureAMIDServerCluster.html

What could be the best suggestion for the customer to make High availability of mid servers in the event of a MID server down ? 

[Hitoshi Ozawa]

Hi Jae,

I'll use the docker container or put the MID server on a virtualization environment such as vSphere and have the platform switch over in case the container or a vm instance fails.

[VivekSattanatha]

hi,

You can load balance the MID Servers. I am not talking about the load balancing within servicenow. if you more than one mid server then give to load balancer like cisco or f5 which will give you virtual ip. so the customer they always the virtual ip to connect the instance. The f5 load balancer would automatically load balance or failover based on its configuration. Check with your network team they would be able to help you

Regards,

Vivek

[VaranAwesomenow]

as part of scheduled import script its a good idea to always check if a midserver is up before using it on a datasource, so you can create a script that checks for midservers without issues or which is up and assign that midserver to the datasource, that way you can always ensure that datasource has an up and running midserver.