MySQL Consulting

We are experts in MySQL server design, MySQL Cluster implementation, tuning and deployment, MySQL server load balancing and High-reliability, Fault tolerant system design on all Platforms, including Linux, Sun/Solaris, and others.

Architecture and Design

  • Physical/logical schema design/review;
  • Data normalization/denormalization;
  • Scale-out strategy;
  • High availability strategy;
  • Storage engine selection;
  • Backup and disaster recover strategy

Remote MySQL Support

  • Review your business and technical requirements;
  • Provide guidance on your architecture and design;
  • Install/patch/upgrade MySQL databases;
  • Implement/deploy the database schema;
  • Migrate your data to or from MySQL databases

High Availability

  • Analyze your high availability database requirements;
  • Identify potential issues and limitations;
  • Eliminate single point of failure both logically and physically;
  • Use MySQL cluster/NDB, FEDERATED Storage Engine to increase availabilities in certain scenarios;
  • Use remote replication as DR strategy

High Scalability

  • Analyze your current database infrastructure;
  • Analyze your high scalability database requirements;
  • Identify potential issues and limitations;
  • Scale your data vertically with table partition;
  • Scale your data horizontally with MySQL Cluster or application sharding;
  • Use load balancer and master/slave architecture to distribute data load evenly

MySQL Tuning

  • Review MySQL configuration file and provide recommendations;
  • Review problem queries and provide recommendations;
  • Review schema and provide recommendations;
  • Review indexing and provide recommendations;
  • Review storage engine selection and provide recommendations;
  • Review high level architecture and provide recommendations;
  • Assist with implementing recommendations in your test environment; and
  • Identify other factors that may negatively impact MySQL performance and provide recommendations.

Call us today to discuss our consulting services, or to schedule a pre-sales call with a technical expert.