English
| Showing entries 1 to 9 |
Today’s blog post diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you to Kyle Oppenheim at Groupon for contributing to this project and post. We’ll be posting Part 2 on Thursday. I’ll be at the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me there – I’d love to connect and talk more about MySQL buffer pools or anything else that’s on your mind!
There
[Read more...]I think it’s worth noting that since January 2012 there was no changes to MHA (0.53). Yoshinori Matsunobu made two releases in December (release notes), one in time for my Percona Live London 2012 talk. Thanks Yoshi! Totally download MHA 0.55 which is still be actively developed & used in production at multiple locations.
Related posts:
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.
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:
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
[Read more...]
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:
http://www.skysql.com/how-to-buy
MySQL in the Cloud
MySQL Consulting and Services
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
[Read more...]| Showing entries 1 to 9 |
