Database Management

Databases are the lifeblood of most websites. The performance and usage of those databases will directly translate to its stability and how well your site will perform.  If you do not have adequate database management, your site can be a ticking time bomb.

sensu_logo_large-c92d73dbAt Contegix, we will work in concert with your DBAs in order to tune your database service, all based on your needs and workload. Once in place, we will continue to work with you to fine-tune things based upon the metrics we gather for PostgreSQL, MySQL, MSSQL and more. Don’t see the database platform you use mentioned above? Not a problem. Our custom-built monitoring system allows us to create new monitors to gather metrics and availability for whatever comes our way.

Our monitoring system can help provide metrics to support the tuning process. We can also look at system-level metrics to further diagnose any problem areas that need tweaking. When you reach the limits of what tuning the configuration and environment can provide, our engineers can intelligently recommend the hardware your environment needs.

MySQL

MySQL is a free, open-source RDBMS (Relational Database Management System) which has a proven track record for performance and reliability. Many of the largest web applications are written on a LAMP (Linux Apache MySQL and PHP) platform. Choose our Managed MySQL database service for the always-on, responsive performance your application demands.

Basic MySQL Management Service

Our basic MySQL management service includes many of the basic day-to-day items along with expert advice and consultation. We’ve installed and configured small to large scale deployments.

  • Installation
  • Configuration
  • Basic Troubleshooting Assistance
  • Optional Database Backup Agent
  • Expert Advice and Consultation

 

Advanced MySQL Management Service

Advanced MySQL Management is for demanding projects which require more than basic installation and configuration. Our seasoned DBA’s optimize your database from the operating system up to the database engine.

  • Advanced Configuration and Installation Options
  • Configuration of Replication (Master/Master and Master/Slave)
  • Initial Database Environment Assessment (including MySQL and OS-Specific Performance Tuning)
  • Slow Query Analysis
  • Query Tuning and Index Recommendations

 

MSSQL

End-user experience relies heavily on performance and uptime of your business application. Microsoft SQL Server enables lightning-fast data management along with a variety of flexible durability options. Microsoft SQL Server consistently leads performance tests by the Transaction Processing Council for OLTP workloads.

Basic Microsoft SQL Management Service

Our basic Microsoft SQL management service includes many of the basic day-to-day configurations with expert advice and consultation. We’ve installed and configured small to large scale deployments.

  • Installation
  • Configuration Assistance
  • Basic Troubleshooting Assistance
  • Optional Database Backup Agent
  • Expert Advice and Consultation

 

Advanced Microsoft SQL Management Service

Advanced Microsoft SQL Management is for demanding projects which require more than basic installation and configuration. Our seasoned DBA’s optimize your database from the operating system up to the database engine.

  • Advanced Configuration and Installation Options
  • Configuration of Replication (Transactional, Merge and Snapshot)
  • Initial Database Environment Assessment (including MSSQL and OS-Specific Performance Tuning)
  • Slow Query Analysis
  • Query Tuning and Index Recommendations