Multiple external MySql nodes in cluster for CA Performance Center

book

Article ID: 144738

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

When running the Sizing Tool wizard to allocate resources for CA Performance Management environment, under Fault Tolerance option, there is the option to configure the number of external CA Performance Center (PC) MySQL database nodes:



But when doing the CAPC install, there is no way to specify more than one instance of the MySql database for clustering purpose.

Cause

Although the Sizing Tool shows the ability to enter a given number of external database nodes, at this time only one CAPC is supported in CAPM environment, which would have one external MySql database only.

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration
Performance Center

Resolution

CAPC 3.7 added the possibility to externalize the MySql server, as explained in the documentation:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/performance-management/3-7/upgrading/upgrade-performance-center/migrate-the-ca-performance-center-database-to-a-separate-node.html 

However, at this time only one MySql server is supported in CA Performance Center. Clustering with MySql has not been tested.
So, although the Sizing Tool wizard have the choice to enter a given number for the "Number of external PC Database Nodes" option, actually only one external MySql node is supported. 

Additional Information

Reference for the Sizing Tool:
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=13061

Attachments