Logicworks Managed Hosting Solutions

Logicworks engineers have deep operating experience in the major database platforms – Oracle, MS SQL, MySQL, and PostgreSQL – and participate in design, setup and configuration, migration, ongoing maintenance, and cluster and replication restoration. Logicworks DBAs collaborate heavily with clients’ internal teams to identify performance bottlenecks, advise and, where applicable, implement remedies. Components of Logicworks database services can include:

• Clustering Clusters allow for instantaneous automated failover from a primary to a secondary server, in only a few seconds without any loss of transactions written to disk. Logicworks provides a full suite of clustering solutions for the major database platforms (Oracle, MySQL and MS-SQL) as well as most file systems. Depending on the application secondary cluster members may also be accessed in read-only mode for reporting, backups or replication.
• Replication Replication strategies are applicable to databases and file systems, and typically involve manual intervention for failover. While the terminology for database replication schemes varies – standby server for Oracle, slave for MySQL, and mirror for MS-SQL, the concepts are relatively consistent. Replicas can be used for reporting or backups, or read-only server pools, without increasing load on the primary. Replicas can also be situated in an alternate datacenter, providing for multi-site fault tolerance.
• Storage Area Networks Logicworks provides Fibre Channel switches for Storage Area Networks (SANs) on a dedicated basis, ensuring that no other client’s I/O affects another’s. SANs enable shared storage required by database clustering, and provide the greatest possible flexibility in storage management. Logicworks also uses InfiniBand, a proven supercomputing interconnect technology, as a more robust substitute for Fibre Channel with 40Gb/s multi-pathed storage access.
• Multi-Site Redundancy True disaster recovery capability requires multi-site configurations, with duplicate hardware at a secondary facility. All servers at a single facility, regardless of whether they share no hardware, are subject to the same environmental conditions, which are mitigated only by a presence in one of Logicworks' alternate facilities.

Logicworks’ Database Administrators invariably work in close communications with Logicworks’ clients’ in-house teams. Keeping a database healthy goes beyond just keeping it up and running and requires making sure that poor database performance doesn’t drag down the performance of a whole Website. While Logicworks’ DBAs won’t rewrite queries for you or redesign your tablespace, they do drill down to find the root cause of performance issues, and help provide suggestions for optimal reconfiguration.