Preparing Microsoft Failover Cluster for Second Data Tier Installation

With the first data tier installed, you can complete the configuration of the failover cluster to handle all the tasks involved in switching the two data tier nodes between active and passive states.

1. On the active cluster node, verify that all SAP Mobile Platform database services are started:
   • SAP Mobile Platform CacheDB
   • SAP Mobile Platform ClusterDB
   • SAP Mobile Platform LogDataDB
2. In Windows Explorer, navigate to the folder in which you installed the database when you installed the first data tier.
   If you did not change the default location, this folder is SMPData\CDB, where SMPData is the data folder you added to the cluster share disk.
3. Open each *errorlog.txt file and look for Now accepting requests as the last line.

   If you see error messages, there is a problem with the installation that you must fix before proceeding.

   If you do not check the error logs immediately after installing the data tier, the log contains pairs of lines beginning Starting checkpoint... and Finished checkpoint.... As long as these are the only lines logged after Now accepting requests, the database is operating properly.

4. On the active cluster node, stop all SAP Mobile Platform database services.
5. In Windows Services panel, set all SAP Mobile Platform database services to be started manually:
   • SAP Mobile Platform CacheDB
   • SAP Mobile Platform ClusterDB
   • SAP Mobile Platform LogDataDB

   Set these services to start manually so that Microsoft Failover Cluster can have full control over starting and stopping them.

6. In the Microsoft Failover Cluster, define a managed cluster resource group, and add the database services to it, so that they move from the current active node to the new active node when the active node fails over.
   For details, refer to the Microsoft Failover Cluster documentation.
7. Verify that all the database services stop when you take the resource group offline, and start when you take the resource group online.
8. Verify that services switch to the new active node when active and passive nodes are switched.
   1. Fail over to the other node to make it active.
   2. Verify that all SAP Mobile Platform database services shut down on the current passive node.
   3. Go to the desktop on the active node and fail that node over to the first node.
   4. Go to the desktop on the new active node and check the database log files.
      There should be no errors.
9. Fail over to the other node to make it active.