Info

Logicworks provides Managed Database Services (MDS) for a flat monthly fee for Oracle, Microsoft, and MySQL database platforms. The database is the center of the today's dynamic Internet applications, and while other systems can usually be restored from a prior backup, the database requires much more stringent care. For a revenue-generating Internet application, restoring from last night's backup usually means losing a day's worth of business, which is completely unacceptable. Logicworks' MDS is focused on minimizing downtime in the event of failure, as well as ensuring that no transactions are lost in the process of recovery. Logicworks fulfills the role of the Systems Database Administrator, installing database applications and configuring relevant parameters, configuring and attaching filesystems, and setting up both clustering and replication, and database backups. On an ongoing basis, Logicworks assumes responsibility for database health monitoring and effecting failover for both clusters and replicas. Logicworks' database specialists work in partnership with either in-house technical resources or Logicworks' Solutions Partners, for tablespace maintenance, warehousing, and optimization. Logicworks will also assist in the strategic planning and database migration for ,no transactions lost' cut-overs from existing environments for new clients, including migrating to new versions of a database platform. Logicworks' clients typically deploy databases in either master+replica or cluster+replica configurations, where the replica has equivalent processing power as the primary server (so that it can reliably act in its place). A second replica may be added to provide an additional layer of redundancy and fault tolerance. Logicworks can also implement multi-replica read-only topologies for applications with high read-write ratios, or database sharding to provide horizontal scaling for highly transaction-intensive database applications. Database backups are written to a local filesystem for performance reasons, and then copied off-server. As part of the set up procedure, working with your internal technical resources, Logicworks will collaboratively design and implement a full suite of health tests which can determine not only if your database instance is up and running, but if it is behaving as expected. In the event of database failure or catastrophic event, Logicworks steps in on a 24x7 basis to recover data, initiate a manual fail-over, ensure that dynamic failover has executed properly, or monitor the cluster for capacity, adding nodes as necessary. Thereafter, upon restoration and configuration of the master, Logicworks will initiate failback and restoration of cluster and/or replica functionality. Access to expertise is a key benefit of Logicworks managed database services. Our vendor-certified Oracle Certified Master, Microsoft Certified Database Administrators, and MySQL Professionals have vast experience with the full range of configurations options and are actively involved in the pre-sales process. They can provide insight on both initial configuration, ongoing maintenance and operations, including advice that falls well beyond the scope of Logicworks' services. Our engineers truly become an extension of your internal operations.