MySQL Performance Audits

We are excited to announce that we are now providing highly competitive MySQL performance audits which include a complete overview of your current MySQL setup.

The MySQL performance audit includes our recommendations to help you maximise the performance of your existing investment and to build additional capacity for future growth.

The following describes the headings of a typical MySQL performance audit report:

  • Server hardware health check
  • Operating system review
  • Application and system architecture
  • Table and query design
  • Indexing performance and coverage
  • Current capacity vs. future demands
  • Identification of current bottlenecks and any emergency remedial work required
  • Our recommendations and summary

Our workflow process involves accessing your system onsite or remotely, gathering the necessary data and then constructing a report. We are also happy to quote for our expert engineers to perform any or all of the required changes we identify.

We can perform two types of audit; non-invasive and standard. Non-invasive requires that we do not install any audit tools and collect no identifiable information (such as table names) or slow query logs. A standard audit will involve running basic python scripts to automate the collection of certain configuration data.

A non-invasive audit will require a certain amount of additional time to gather the necessary data manually. The amount of extra time is dependent on the number of servers and data collection required. We may be limited in what we can do regarding optimising of table and index design; this depends on the level of access we are permitted which can be discussed prior to work beginning.

It is important to note that both audit types do not take copies of actual table data. We only collect global configuration data, MySQL configuration data and anonymous counters (such as number of unauthorised access attempts and slow query log %).

We can also provide other services such as scale-out and scale-up consultancy, Master-Master replication and Cluster configuration, benchmarking and capacity checks and architectural design guidance.

Being AWS approved consultants we have experience with Amazon RDS, both in standard mode and coupled with Auto Scale, so if you are considering Cloud managed services as an option for your next MySQL deployment, please get in touch to see how we can help you.

For more information about our MySQL Performance Audit services please email us (sales@buckhill.co.uk) or call us on +44 (0)1903 238012

Tags:

MySQL AWS Cloud

Published by: Stuart Buckell

Published on: 28.11.2016

"Buckhill Ltd is very knowledgeable and works quickly. We got bogged down and stuck trying to implement SAML on our own but Buckhill Ltd stepped in and immediately executed a working setup and made insightful recommendations for enhanced security."

Ken Snyder - Chief Technology Officer
Sharpr, Salt Lake City, Utah, USA

"I was impressed by the enthusiasm and professionalism of the Buckhill team and their 'can do' attitude."

Matthew Oliver - Director
M3 Corporate Finance LLP, Bristol, United Kingdom

"Working with Buckhill was a pleasure. Right from the consultation process, through to their depths of knowledge & obvious enterprise experience - I would have no hesitation recommending their services."

Reece Griffin, Technical Director
TBA Digital, Canada

"We were working with one of our vendors to configure SSO via ADFS to access their web application. We needed additional expertise and guidance to move the project forward so we contacted Buckhill Ltd. In a matter of days they had their developers working on it. They quickly determined the configuration issues we were having and provided explanation on how to get them resolved. We were very impressed with their knowledge, professionalism and diligence in assisting us on this project."

David O'Boyle CCNA, MCSE - Technology Services
The Richards Group, Dallas, Texas, USA

"I contacted Buckhill as I needed expert advice regarding a complex SAML integration requirement. The project involved integration with the US Health Care API (Obamacare eligibility). The developers assigned to the project were highly capable and professional, with real passion and determination to see the project through to completion even when issues presented themselves. Looking forward to working with you guys in the future, you're awesome! All the best, Carlos."

Carlos Arias - Owner
Carlos Ja Design, Florida, USA

"Buckhill provided us with consultancy to implement SimpleSamlPHP and configure it for use with a major client's SSO.
They were incredibly helpful, easy to work with and delivered in very short timescales within our agreed budget.
I am extremely happy with the service they provided."

Eddie Robins - Technical Director
Groovy Gecko, London, UK

"We asked Buckhill to provide us with a robust, reliable and faster server infrastructure so that we could deliver a better and more consistent service to our customers. Buckhill delivered results quickly, in a friendly and professional manner. We have been impressed by the knowledge they bring to the table and with the honest and helpful communication throughout the process. We are happy to receive continued support and maintenance for a core part of the business."

Brian Kavanagh
Field Gibson Media Ltd, UK

"We have been using Buckhill for several years for all our industry software requirements.

Their systems are reliable and affordable and the team are always friendly and knowledgeable.

If you're looking for an innovative software solutions provider, I would highly recommend them."

Mandy Brown, Director
Litigation Protection, UK

"Working with Buckhill was a pleasure. Right from the consultation process, through to their depths of knowledge & obvious enterprise experience - I would have no hesitation recommending their services."

Reece Griffin, Technical Director
TBA Digital, Canada

"Buckhill provided us with excellent service throughout our project. From the detailed initial meeting, to explaining the process, to final delivery, prompt response and assistance with follow up questions. We have been thoroughly impressed.

Kevin Hoggard, Director
CRM Innovations, Canada

"I must say that working with Buckhill has been a pleasure. The C2MS system has really helped us get our wholesale division up and running and the features within the system are very comprehensive. It allows us to trade with our brokers the way our brokers want to trade with various trading options available. I especially like the way Buckhill respond to you new idea’s and do look to implement them in days rather than months."

Hassan Soyer, Director
Nova Insurance, UK

"Buckhill were very helpful scoping up a vastly improved and flexible server environment - from the very first phone call we were able to define the problem and agree on a route towards solution. The project was completed with the minimum of fuss, on time and on budget. Real time technical support was available throughout the process and we now have a vastly improved operational environment that is future proofed for our strategic objectives. We are very happy with the results and have quickly realised the ROI."

Iain Wilcox, Marketing Director
Digitonic, UK

"We are delighted with our choice of service provider, and have nothing but good things to say about Buckhill. Stuart and his team have acted with a high level of professionalism and competence in all respects. We cannot recommend them highly enough ..."

Matthew Dickinson, Director
Linex Systems, UK

"Buckhill was able to bring a solution in a complex interoperability problem (ADFS/SAML with SOAP between Linux/Windows platform). I was often impressed by the level of their expertise and deep knowledge. When problems arose they were able to find creative solutions with an emphasis on reliability and security. I can say that during the whole project Buckhill was never the bottleneck, our success with this project is definitely due to Buckhill's talented team."

David Wulliamoz, Head of IT Services
Compassion Suisse, Switzerland

Our Partners

VMware Partner
Learn more about Reseller and Partnership opportunities

Join the Partner Program

Our offices are open 8.30am - 7pm GMT, Monday to Friday - but you can always contact us via email. When we receive your email during opening hours, we aim to respond within 30 minutes or less. Should your email reach us out of hours, we will contact you when the office re-opens.

You can contact us using live chat

Contact Information

Speak to an expert on +44(0)1903 250250, email us at contact@buckhill.co.uk, or start a live chat, located in the bottom right

Alternatively, complete the form below

We're happy to talk

Our offices are open 8.30am - 7pm GMT, Monday to Friday - but you can always contact us via email. When we receive your email during opening hours, we aim to respond within 30 minutes or less. Should your email reach us out of hours, we will contact you when the office re-opens.

You can contact us using live chat

Buckhill