MySQL Database Consulting

Oracle MySQL is in use by many organisations around the world including Facebook, NASA, Booking.com, PayPal, LinkedIn and many others as a low-cost, high performance, scalable database platform providing enhanced features such as replication and partitioning out of the box.

With over 15 years of hands-on experience designing, maintaining and tuning MySQL database systems ranging from large 20Tb analysis solutions, to high performance systems with 30k transactions per second. I am able to help you diagnose performance issues and suggest tuning options such as;

  • Additional indexes
  • Application query redesign
  • Partitioning and sharding
  • Data type optimisation
  • Server optimisations

I am also able to provide on-going support and assistance as your systems grow, advising on server and database configuration options, and planning for future expected growth. 

MySQL Consulting is not limited to the Oracle MySQL database platform, but also extends to Percona Server , MariaDB and AWS RDS MySQL/Aurora, all of which are compatible with Oracle MySQL, but each have their own functionality and performance enhancements.

Emergency remote support assistance is also available should that be required in your time of need!

AWS Platform Migration

Amazon Web Services (AWS) is a platform offering a wide range of services from data storage (S3) to content delivery (CloudFront) and databases (RDS). The services offered are powerful and flexible, allowing you to increase the capacity that you use at the times that you need to handle anticipated demand from a forthcoming marketing push.

Working with the AWS platform since early 2015 has given us a great understanding of the many varied services that are on offer, and an in-depth knowledge of a number of them, ranging from security groups, identity and access management, through to CloudFront and relational database provision such as MySQL on RDS, and Aurora.

Combining the services provided by AWS with automation tools such as Terraform and Ansible allow complete infrastructure provision for products such as a database backed, subscription based web product to be created through Infrastructure as Code techniques, and then continuously monitored and repaired should anything go wrong with any of the individual components.

Email me at info@analysisbydesign.co.uk if you wish discuss any of the above services.