In my experience, a clustered database makes no difference to a client connecting to it - and in this case Mendix is a database client. There should be a single SID to connect to the database instance.
All the resilience magic that happens at the backend should be invisible to the client.