Currently I've set up RDM to connect to a central MSSQL Database which contains all the session entries and structure for administrating our servers/resources in all locations worldwide. RDM and this database is used by our Server Operations team which has members all over the world.
Turns out that the closer a team members is located to the database, running the RDM on his client machine/management server, the better the performance.
While within Europe the performance is acceptable, in Asia and Americas it's not. Hence team members are reluctant to use RDM and the benefits of a globally unified administrative structure.
After talking to one of our database guys, two possible options came up to mitigate the weak performance in Asia/Americas.
1. Replicate Database to Asia/Americas
- We expect mostly read traffic, so replication traffic could be neglected
- Problem: Unclear which tables to replicate, is there any recommendation/experience from Devolutions regarding RDM SQL DB replication?
2. Place regularly updated read only copies of the Database in Asia/Americas
- Not very comfortable for the users, but easy to implement
- Changes can only be performed on the Europe DB, e.g. Updating personal credentials, personal session entries. Small drawback for the users
- Question: Can RDM operate with read only access to the Database?
While the structure for "All Items" is administrated only by myself, other team members can and should administrate their Private Vault, storing credentials and personal sessions entries there, associating their individual credentials with folder/session entries in the "All Items" section.
Could you please answer the questions in the 2 proposed options and maybe provide me with a best practice approach on how to handle such a scenario?
Kind regards
Holger
-------------------
Remote Desktop Manager Enterprise Edition 12.6.6.0 64 Bit - Data Source: SQL Server
Running on Windows Server 2012R2 VMs with Remote Desktop Services feature, serving as common work environment for 30 Windows Server administrators
Hello,
The issue with partial replication is that it is inheritely incompatible with our historical/versioning features. There is also the fact that before editing an entry, the system performs a fetch just to ensure that the latest version is edited. You must therefore use full fledged bidirectional replication, the SQL terminology is Merge Replication, but I have read that there are options in Transaction Replication to support this.
As an interim method, one could imagine having the asia/america teams hitting the central database just once when they start their work shifts, then switching to the offline mode for the rest of the day. Obviously, this requires the read/write offline mode. They must also ensure to switch online at least once per 7 days, which is the default lifetime of the cache.
If indeed you need to move to replication, since you have latency, reaching full bidirectional replication may be a challenge.
Best regards,
Maurice
Hi Maurice,
to give you some feedback, I decided for for the Offline Mode method which works for all the guys around the globe. It requires some self discipline but is defnitely the better alternative to complicated replications.
-------------------
Remote Desktop Manager Enterprise Edition 12.6.6.0 64 Bit - Data Source: SQL Server
Running on Windows Server 2012R2 VMs with Remote Desktop Services feature, serving as common work environment for 30 Windows Server administrators