Buy Percona ServicesBuy Now!

High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script

 | October 22, 2010 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Insight for DBAs, MySQL

This post is the fifth of a series that started here. From the previous posts of this series, we now have an instance restart script that can restart the database node in case of failure and automatically reconfigure Pacemaker and the other servers that needs to access the MySQL server. What we will cover in […]

Read More

MongoDB Approach to Availability

 | April 30, 2010 |  Posted In: Cloud and NoSQL, MySQL

Another thing I find interesting about MongoDB is its approach to Durability, Data Consistency and Availability. It is very relaxed and will not work for some applications but for others it can be usable in current form. Let me explain some concepts and compare it to technologies in MySQL space. First I think MongoDB is […]

Read More

Tokyo Tyrant -The Extras Part III : Write Bottleneck

 | November 12, 2009 |  Posted In: Benchmarks, Cloud and NoSQL, MySQL

This is part 3 of my Tyrant extra’s, part 1 focused on durability, part 2 focused on the perceived performance wall. #3.  Tokyo Cabinet Can have only a single writer thread, bottlenecking performance When writing an application using Tokyo Cabinet only one connection can be opened as a “writer”  while the rest are readers.  Tyrant […]

Read More

MySQL-Memcached or NOSQL Tokyo Tyrant – part 2

 | October 16, 2009 |  Posted In: Benchmarks, Cloud and NoSQL, MySQL

Part 1 of our series set-up our “test”  application and looked at boosting performance of the application by buffer MySQL with memcached.  Our test application is simple and requires only 3 basic operations per transaction 2 reads and 1 write.  Using memcached combined with MySQL we ended up nearly getting a 10X performance boost from […]

Read More