using EA shared model (DBMS, VC) in multiple sites

[dzikus]

Hi,
What is recommended strategy for working with EA in multiple sites?
Lets assume we have 1 master site and 3 other sites B, C, D (about 30 / 40 developers each).
My first idea is to have master DBMS in master site, and slave DBMS's in B, C and D. For DB replication use native DB replication (if we want to use MySQL replication is one way - so all changes needs to be done on master database).
We have one VC repository located in master site (is it possible to use CM Synergy as repository?)
If one wants to make changes locally in B he makes changes in local DBMS, creates baseline (VC) and tells integrator in master site to put changes into master database.
Will it work or should we setup another solution for multi site purpose?

Thanks in advance for help
Best regards
   Dominik

[«Midnight»]

Hi Dominik,

There's a pretty good - at least to get you started - white paper on the Sparx Resources page. I've provided the URL of the entire page, since you might want to read more than one. I suggest you check out the deployment and version control papers first, perhaps together.

There's a lot more advice in the forum, but you'll need to search for it (several times, using different keywords). The white papers will go a long way towards getting you going first, and will also help you narrow your search to the things you really want to know.

I won't try to be more specific, since the appropriate solution - even the general approach - will be heavily dependent on your specific situation.

David

[dzikus]

Of course - I have already read EA white papers and searched the forum for revelant topic's.
I know different deployment scenarios (in theory).
Currently we have one DBMS in master site, but this solution is too slow - se I'm looking towards local DBMS and database replication.
But my situation is a little bit specific. I need to have:
- EA working fast in all sites
- synchonization between sites
- versioning system working well in all sites

Hi Dominik,

There's a pretty good - at least to get you started - white paper on the Sparx Resources page. I've provided the URL of the entire page, since you might want to read more than one. I suggest you check out the deployment and version control papers first, perhaps together.

There's a lot more advice in the forum, but you'll need to search for it (several times, using different keywords). The white papers will go a long way towards getting you going first, and will also help you narrow your search to the things you really want to know.

I won't try to be more specific, since the appropriate solution - even the general approach - will be heavily dependent on your specific situation.

David

[«Midnight»]

Quite a while back someone on the forum had a replication scheme working, I think with MS SQL Server. Right then I got blindsided with other stuff and never got the time to follow up. This was probably last calendar year.

You could search the forum and see if you can find a thread or two on the subject, then post there to see if the original players are still working on this.