Shard Realm Database

Question

How do I find out what database is being used by a realm that's on a 'shard'?

Answer

You can see if a realm is on a database shard by viewing Realm Properties.

1. Go to CUSTOMER CENTER > REALM MANAGEMENT > EDIT REALM.
2. Select the Realm.
3. Check the DB Profile.

If DB Profile is [NONE], then the selected realm is on the main database.  Otherwise, the database shard name will be displayed.

In addition, you can query the database.  The realm table in the registrations database has a column called 'realm_db_id'.  If the id is a value other than 0, that realm is on a shard.