Selective Replication.Need Advise

HCL Domino Domino Forum
1

Hello All,

We have a db which has over 1 billion documents and has replikas across 10 servers.(So all the replicas holding 1 billion documents!.)

Due to performance problems, I would like to main db to still hold all the documents while replicas only holding the documents where they are created.Basicly, when a user created a document on replica db residing on A server, it will be only on A server and main server, not on another replica db residing on B server.

So I thought giving each server a role, and keeping this role information on each documents and using Readers to be able to Replicas to hold the data belonging their servers.Or I might use Replica Formula instead of Readers.But in both ways, I need to update all the documents in order to flag the documents with their server role.?

I hope it is clear what I want to do.Has anyone tried to do this before?.And What is the best way to do it?.Any advise will be really appreciated.

Thanks in advance.

2

Subject: Selective Replication.Need Advise

At each ‘spoke’ server, go into the database’s replication\settings. There is a space savers tab where you can select “Documents that meet a selection formula”. In there, at each spoke, you’ll need to enter a formula like:myFieldXYZ = “Houston”

or…

if you don’t have a field that differentiates each spoke already, perhaps you have lists of user names in specific groups for each spoke location. Then you could do something like:

bigList := @DbLookup(… get your list of users for this server);

@Contains(bigList; @Name([CN];@Author));

^ that should only pull down docs that were created by people at that site.

Of course, you’ll have to run some similar agents or something once at each spoke to remove all docs that weren’t created by people at that site.

hope this helps!