- 4 Microsoft SQL Servers (new hardware for 2 of them)
- 11 IIS Web Servers (new hardware)
- 2 Redis Servers (new hardware)
- 3 Tag Engine servers (new hardware for 2 of the 3)
- 3 Elasticsearch servers (same)
- 4 HAProxy Load Balancers (added 2 to support CloudFlare)
- 2 Networks (each a Nexus 5596 Core + 2232TM Fabric Extenders, upgraded to 10Gbps everywhere)
- 2 Fortinet 800C Firewalls (replaced Cisco 5525-X ASAs)
- 2 Cisco ASR-1001 Routers (replaced Cisco 3945 Routers)
- 2 Cisco ASR-1001-x Routers (new!)
همگام سازی دو دیتابیس در سی شارپ - Sync Two Databases using Microsoft Sync Framework in C#
ما میتوانیم دو پایگاه داده SQL Server را با راههای مختلفی همگام سازی کنیم، امروز در مورد چارچوب Microsoft Sync Framework صحبت میکنیم. از Microsoft Sync Framework برای همگام سازی دو پایگاه داده که در دو سرور مختلف قرار دارند استفاده میشود. در این مقاله ما در مورد چگونگی همگام سازی پایگاههای داده با استفاده از این فریم ورک بحث میکنیم.
کتاب 45 نکته برای بهبود کارآیی بانکهای اطلاعاتی مخصوص برنامه نویسها
Criteria | GUIDs | Seq. GUIDs | BIGINT | INT |
Storage | 16 bytes | 16 bytes | 8 bytes | 4 bytes |
Insert/Update performance | Slowest | Comparable but the index keys are larger in size. For wider tables, this would be slower than Integer values. | Faster than sequential GUIDs | Fastest |
Hotspot contention | Very rare | Yes | Yes | Highest, due to smaller size of RIDs |
Fragmentation/Page Splits | High | Minimal | Minimal | Minimal |
JOIN Performance/SORT operations | Least performance (Rank 4 = Least performance) | Better than random GUIDs due lesser fragmentation (Rank: 3) | High performance (Rank: 2) | High Performance (Rank: 1) |
Logical reads | Rank 4=Highest | Rank 3 | Rank 2 | Rank 1=Least |
Merging data across servers | Beneficial | Beneficial | Difficult | Difficult |
Uniqueness | Rare chance of duplicates | Globally unique. Virtually no chance of collisions | Limited by range of BIGINT | Limited by range of INT |