Scale MS-SQL horizontally across any number and class of servers with real-time federation
Microsoft's focus with OOB solutions within MS-SQL has been High Availability - not scale. SQLFed is most like Peer to Peer Replication - where many servers can operate RW against the same data, with changes shared between nodes in near-real-time - but with support for many more servers, at a far lower cost. With SQLFed, you can service very large workloads with commodity server hardware by federating horizontally using Express, Web or Standard licensing.
Federate any SQL Server edition or version - including Express. Mix and Match editions, versions and server capabilities
Easily support 10,000+ Transactions per Minute (TPM) with 300ms synchronzation times. Span your workloads seamlessly across servers and datacenters.
Free for research purposes, testing and non-commercial use.
Enterprise plan available for commercial use.
Fully based in MS-SQL tables, triggers, stored procedures and jobs - which you can see, edit and directly manage.
Support includes implementation, customization and troubleshooting services.
Easily federate across geographically diverse datacenters, regardless of link speed and quality. Span between On-Prem, Private and Public Cloud.
SQLFed's focus is horizontal scaling, with all the add-on high availability benefits of having many SQL nodes share the same data with a sub-300ms RPO. SQLFed is simple to install and simple to manage, with a very low cost to run.
Max Active RW Nodes | Total RW+RO Nodes Supported | MS-SQL License Cost each 16 Core Xeon server |
Synch / Asynch | Failover | Offline Operation | Quirks | |
---|---|---|---|---|---|---|---|
SQLFed | No limit | No limit | Asynch | Manual | YES | ||
Clustering (WSFC / FCIs) - Standard | 1 | 2 | $63k | Synch | Automatic | NO | Shared storage is a single point of failure |
Clustering (WSFC / FCIs) - Enterprise | 1 | 16 | $242k | Synch | Automatic | NO | Shared storage is a single point of failure |
Always On - Standard | 1 | 2 | $63k | BOTH | Automatic | YES | |
Always On - Enterprise | 1 | 9 | $242k | BOTH | Automatic | YES | |
Mirroring | 1 | 2 | $242k | BOTH | Automatic | NO | Deprecated |
Log Shipping | 1 | No limit | Asynch | Manual | YES | ||
Replication - Peer to Peer - Enterprise | 15 | 15 | $242k | Asynch | Manual | NO | IDENTITY columns are not supported |
Replication - Transactional - Standard | 1 | No limit | $63k | Asynch | Manual | YES | |
Replication - Transactional - Enterprise | 1 | No limit | $242k | Asynch | Manual | YES | |
Replication - Merge - Standard | 500 | 500 | $63k | Asynch | Manual | YES | Each subscriber requires a different data partition |
Replication - Merge - Enterprise | 500 | 500 | $242k | Asynch | Manual | YES | Each subscriber requires a different data partition |
Replication - Snapshot - Standard | 1 | No limit | $63k | Asynch | Manual | YES | Interval updates, not continuous |
Replication - Snapshot - Enterprise | 1 | No limit | $242k | Asynch | Manual | YES | Interval updates, not continuous |