When SkySQL opened its doors two years ago, we purposely set out with the goal to build trusted and value-for-money services for users of MySQL and MariaDB databases. We focused on offering a quality alternative for those deploying open source systems - and we feel that we have succeeded. Our plan was to build a service business and customer base that will create a strong platform on which to develop our own products in collaboration with key customers. Red Hat is the only other successful start-up that I am aware of having taken a similar approach of first building a successful services business before developing products.

read more

High Availability is one of the hottest topics for MySQL DBAs. As a matter of fact, when we (SkySQL) are called by users and customers, the top two questions for our PS team are:

1. How can I make my MySQL database scalable?
2. How can I make my MySQL database highly available

Since MySQL is the most used online database, these two questions are totally appropriate. Although the two concepts walk together, they should not be confused.

We refer to scalability when we define that a system must sustain a specific workload, measured in different ways – response time, latency, transactions or operations per second to name few, or a combination of them. So, we define the level of scalability we want to achieve and we design a system that can scale to that level.

We refer to high availability when we define that a system must be available, within …

 

I just wanted to let you all know that MHA for MySQL (Master High Availability Manager and tools for MySQL) version 0.53 has been released.

Yoshinori Matsunobu discusses the release in much more detail here:

http://yoshinorimatsunobu.blogspot.com/2012/01/mha-for-mysql-053-released.html

The full MHA 0.53 changelogs are here:

http://code.google.com/p/mysql-master-ha/wiki/ReleaseNotes

MHA 0.53 can be downloaded from here:

http://code.google.com/p/mysql-master-ha/downloads/list

And if you would like support for MHA, simply contact SkySQL:

…

Call or SKYPE us in New York City: +1-212-533-6828

MySQL in the Cloud

• Deploying MySQL in the Cloud
• Cloud Security considerations for databases
• Deploying in multiple Availability Zones
• Deploying in multiple regions
• Deploying MySQL with multi-az
• Horizontal scalability in the cloud
• MySQL spinup scripts
• Deploying Amazon RDS
• Evaluating RDS
• Evaluating MySQL in the cloud
• EBS Performance considerations
• Tuning MySQL parameters in the cloud
• Backup types & options
• Mitigating against cloud server failure
• Vertical scalability & MySQL on EC2

MySQL Consulting and Services

• Backup & recovery
• MySQL master master replication
• MySQL replication & horizontal scaling
• MySQL …

Deploying in the Amazon cloud is touted as a great way to achieve high scalability while paying only for the computing power you use. How do you get the best scalability from the technology?

1. Use Auto-scaling

Auto-scaling is a unique feature of cloud computing and Amazon's EC2 offering. Setup a load balancer and a couple of webservers for your application as you normally would. Design your webserver based on a template AMI that you'll reuse over and over. Then setup auto-scaling and set thresholds based on the traffic you forecast. When a threshold is passed, AWS will spinup a new instance of your webserver, and roll it into the load balancer pool automatically. Once traffic falls below the scale back threshold, Amazon will take a server out of the pool for you.

Be sure to monitor this …

Today, SkySQL announced a partnership with Yoshinori Matsunobu, an Oracle ACE Director and the creator of the newly announced MySQL Master High Availability Manager and Tools (MySQL MHA) for automating MySQL master failover. With this partnership, SkySQL will be the first MySQL database commercial services company to provide technical support, professional services, and training, for MySQL MHA.

read more