We are evaluating WSO2 Identity Server, and are trying to understand how WSO2 Identity Server scales across multiple nodes.
The document https://docs.wso2.com/display/CLUSTER44x/Clustering+Identity+Server+5.1.0+and+5.2.0 explains steps to follow to enable clustering, however the document links to database setup documentation that is common to the whole WSO2 suite, and not specifically for Identity Server.
I understand from the documentation that all WSO2 Identity Server nodes are required to share a set of clustered LDAP servers (when an LDAP server is in use).
Is each node in a WSO2 Identity Server cluster required to share a set of clustered SQL servers in addition to the above?
Alternatively, is it fine to have each node use a local database in the expectation that WSO2 Identity Server will communicate with other members of the cluster in order to keep all databases in sync?