How to add a new 'mysql' resource in pacemaker cluster where one 'mysql' resource is already configured ?

Issue

• Why do the newly created mysql cluster resource fails to start, while the first mysql resource starts without any issue ?
• While creating a new mysql resource in pacemaker cluster it fails to start, however there is an existing mysql resource already running under the same pacemaker cluster.