Microsoft supports SQL replication of the profiles database and of the transactions database in one configuration when you run Microsoft Commerce Server 2007 Service Pack 1 together with Microsoft SQL Server 2005 Service Pack 2.
Microsoft has tested peer-to-peer transactional replication in a multiple-instance cluster. The multiple-instance cluster consisted of two pods. Each pod contained the following:
- Twelve Web servers.
- Two database servers. The first database server contained the profiles database and the transactions database. The second database server contained the other databases.
- Six load clients.
- A storage area network (SAN).
By using this test architecture, replication was reliable at the test rate of 22 transactions per second and 130 profiles per second per pod, concurrently. The performance effect of both the CPU and of the disk I/O was less than five percent. High network latency has a significant effect on the commit time.
Back to the top
