Some of our clients have asked us recently for an overview of our MySQL health check service. I wanted to take some time and summarize the MySQL health check service and some of the steps we take.
Special consideration must be given when making schema changes to large tables in MySQL that use the InnoDB or MyISAM storage engines. Specifically, both engines by default will lock the table entirely while schema changes are being performed. We're often asked by clients how changes to large tables can be made without blocking end user experiences...
Here at Bitlancer, we cannot over-emphasize the importance of being directly available to our clients via telephone. Bitlancer's extensive cloud infrastructure knowledge, thankfully, allows our customers to stay out of the fray and get support directly from Bitlancer. Most importantly, we are on call to handle any appropriate migrations/infrastructure replacement if needed.
Horizontal scalability refers to the ability to spread a workload over multiple servers, rather than increasing the capacity of a single server. This results in the ability to utilize more, less expensive pieces of hardware, rather than endlessly upgrading a single server at great cost.
Determining whether to migrate to cloud infrastructure (IaaS) or to a cloud platform (PaaS) requires a thorough understanding of the various recurring costs associated with one's existing infrastructure (not to the mention the one-time cost of auditing the footprint of any existing setup). Now, for anyone still in the planning stages of a start-up, the cloud can likely be a cost effective alternative to traditional hosting.