Dedicated MySQL services
Brightbox provides shared MySQL clusters for use by customers, with each Brightbox virtual machine including a quota of concurrent connections. Whilst the shared MySQL service enables a low barrier-to-entry and is perfect for many customers, there are situations where it is preferable for customers to have their own dedicated optimised MySQL server(s).
We provide two options for dedicated MySQL: a single dedicated MySQL server or a dedicated HA (High Availability) cluster…
Option 1 – Dedicated MySQL server
From only £85/month, you can have your very own dedicated MySQL server, optimised by the expert Brightbox systems team and located on our proven cloud platform. Benefits include increased performance and guaranteed CPU/RAM resources.
Option 2 – Dedicated and High Availability MySQL cluster
From only £169/month, we’ll provide you with a pair of HA MySQL instances, again optimised by the expert Brightbox systems team, located on separate physical hardware within our cloud platform. Benefits of the dedicated HA MySQL product include increased performance, guaranteed CPU/RAM resources and resilience.
All Brightbox dedicated MySQL services are monitored 24/7 and come with managed backups.
Dedicated MySQL Q & A
How do I buy a dedicated MySQL product?
Simply login to your Brightbox account, follow the “Buy Extra Services” link on the left hand side, choose which product you wish to purchase and click “Buy now”.
Do I need to make changes to my application?
Once you’ve migrated your databases onto your dedicated MySQL service, you should only need to update your config/database.yml and redeploy.
What version of MySQL is used?
We currently offer version 5.0, but will soon be adding version 5.1 as an option.
Do the dedicated MySQL servers support InnoDB?
Absolutely, and we highly recommend using InnoDB for reliability.
Are there any restrictions or peculiarities with the MySQL config?
We fully manage the config for you, based on the RAM size of the cluster with a focus on InnoDB use. We can tweak the memory settings for other storage engines if required.
The HA cluster increases auto-increment fields by 2 or more each time (to avoid replicated primary key clashes).
Do you provide backups of the dedicated MySQL servers?
Yes, daily backups are taken and weekly and monthly archives are retained. The backups are also replicated offsite for full disaster recovery.