SQL Server Replication

SQL Server Replication is designed to increase data availability by distributing the data across multiple database servers. Availability is increased by allowing applications to scale out the SQL Server read workload across databases. SQL Server offers enhanced replication using a peer to peer model that provides a topology in which databases can be synchronized transactionally with any identical peer database. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

MySQL Cluster combines the world's most popular open source database with a fault tolerant database clustering architecture which allows us to deliver mission-critical database applications with extremely high availability.

Designed for 99.999% Availability

MySQL Cluster provides a fault tolerant architecture that ensures your organization's mission critical applications achieve 99.999% availability. This means less than 5 minutes downtime per year, including scheduled maintenance time. MySQL Cluster implements automatic node recoverability to ensure an application automatically fails over to another database node that contains a consistent data set, if one or more database nodes fail. Should all nodes fail due to hardware faults for example, MySQL Cluster ensures an entire system can be safely recovered in a consistent state by using a combination of checkpoints and log execution. Furthermore, MySQL Cluster ensures systems are available and consistent across geographies by enabling entire clusters to be replicated across regions.

Extremely Fast Automatic Failover

MySQL delivers extremely fast failover time with sub-second response so your applications can recover quickly in the event of application, network or hardware failure. MySQL Cluster uses synchronous replication to propagate transaction information to all the appropriate database nodes so applications can automatically fail over to another node extremely quickly. This eliminates the time consuming operation of recreating and replaying log files required by 'Shared-Disk' architectures to fail over successfully. Plus, MySQL Cluster database nodes are able to automatically restart, recover, and dynamically reconfigure themselves in case of failures without having to program advanced features into the application.

Significantly Reduce Costly Downtime

MySQL Cluster not only lowers up-front license costs with affordable commercial licensing under a dual licensing mechanism, but it also significantly reduces system downtime - the number one contributor to the Total Cost of Ownership (TCO) of database software. Furthermore, a highly portable standards-based environment allows you to cost-effectively distribute your applications using commodity hardware and open source software infrastructure.

For SQL Server 2000 or 2005 database servers, Windows Server 2003 Network Load Balancing (NLB) and MS SQL Server Replication services share the total load between multiple SQL servers and also provides for retained uptime even in the event of a failed server. This option requires (2) Windows 2003 Standard Edition servers or (2-32) Windows 2003 Enterprise Edition servers - both with SQL 2000 or 2005. We provide a 2nd NIC for each server, crossover cable and setup the NLB environment with MS SQL Replication service.

Using MySQL Replication, organizations can cost-effectively deliver a high availability solution. Master/Slave Replication enables operations to manually fail-over to another server in the event of a hardware or software problem. In addition, with MySQL replication, organizations can incrementally scale out their infrastructure to accommodate exponentially growing capacity demands. MySQL Replication ships out of the box and is used by some of the world’s most highly trafficked Web sites including YouTube, Yahoo!, flickr, Wikipedia and craigslist.