Cloud Computing, Software and System Performance

MySQL Replication Deadlock Detection and Recovery (The code inside)

2012-02-05T04:30:00.000-08:00

The best practice to handle deadlocks (after eliminating them from the code) is recovering from them. Unfortunately, if you ever came across the "SHOW SLAVE STATUS\G" Error 'Deadlock...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

MySQL and Lucene: Server Side Cursors or Client Side Cursors?

2012-01-05T02:12:00.000-08:00

What is the Default? Client Side Cursors: this method returns the client the whole result set upon a SQL request. What is Faster? Client Side Cursors: once you get the...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

5 Options to Backup Your MySQL and Keep Your Service Online

2011-12-29T01:52:00.000-08:00

An old customer was facing a major issue. They just expanded their service from a local shop to a global "follow the sun" service, providing SaaS to worldwide customers. Their MySQL server were the...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

How to Install MySQL on an Ubuntu Based Machine

2011-11-28T07:37:00.000-08:00

It is a common question: "How should I install MySQL on an Ubuntu based machine?" To make it easier for you, I documented the procedure: 1. Uninstall current MySQL packages sudo dpkg...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

Adding One More MySQL Slave to Cloud Based System (Amazon AWS)

2011-10-30T07:20:00.000-07:00

MySQL Replication tends to be complex. Creating a new slave to support your system expansion is not easier: coping large data files over the LAN, recovering replication,...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

MySQL CentOS and Amazon Web Services (AWS)

2011-10-03T04:32:00.000-07:00

Many Linux experts prefer CentOS. The reason is clear, Redhat's RHEL is probably the best Linux server distribution and CentOS is very much a like (except for the yearly fees). This distribution...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

MySQL Unit Testing and Re-factoring Verification

2011-09-29T04:13:00.000-07:00

If your software is highly dependent on a database, data intensive processes re-factoring verification can be a pain in the a$$. Yet, you probably would like to avoid a production...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

Sharding is Now COTS

2011-08-31T13:07:00.000-07:00

I wrote here a lot in the past regarding SQL Server and MySQL sharding. I wanted to update you that ScaleBase, which is led by the industry veterans Liran Zelkha and Doron Levari announced that...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

MySQL Statement Profiling Is Easier Now!

2011-07-10T12:23:00.000-07:00

If you has always wanted to know why your SQL statement runs so slow and you are a MySQL DBA, you probably used the explain command to understand the estimated execution plan. Yet, how...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

What should I do when MySQL storage files are getting too large?

2011-06-16T05:48:00.000-07:00

As MySQL is the internet and cloud de-facto database, we dedicate another post regarding what should you do before getting to the money time. Some methods including stored data compression and...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

Monitoring and Taking Care of MySQL Replication

2011-05-09T09:53:00.000-07:00

If you get your slave into production soon, your should make sure that you know how take care of it when something goes wrong. Knowing that the slave is stuck can monitored using open source...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

my.cnf and MySQL Tuning

2011-04-07T08:24:00.000-07:00

You have an urgent performance case in a MySQL system and you have to get several low hanging fruits fast. What should you do? MySQL Tuner is Your First Try! MySQL Tuner is an open source Perl...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

How to Replicate Part of the Tables in MySQL

2011-04-06T03:44:00.000-07:00

When you build a DWH or another intensive processing on a database slave copy, you may not want to replicate the whole database. How can you replicate only some of the tables or even part...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

MySQL Partitioning. One step before Sharding.

2011-03-28T05:15:00.000-07:00

Many of you may consider Sharding to meet your large scale database demands. However, in some cases it seems too early since you may not have the needed bandwidth in the current phase or you just...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

MySQL DRP Done Right

2011-03-22T05:30:00.000-07:00

When your systems are up and running and money is getting into the bank, it is the best time to ask yourself: What if my system fails? What if my data center (yes, even your cloud one) goes...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

Faster Website? CDN Might be the Answer!

2011-03-06T03:34:00.000-08:00

Why Our Japanese Users are Angry? A common question when you setup a new SaaS or just a fancy website is "Why do my remote users have hard time with my application?" while when I'm in a...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

DRP, Cloud and Some Tips

2011-02-28T13:55:00.000-08:00

\One of the most popular use cases for cloud computing is DRP. Why DRP? DRP is one of the costly operations in systems life cycle. Not only you need to keep a similar instance of every server...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

MySQL. An Internet Standard.

2011-01-22T07:29:00.000-08:00

As you probably already know, last week I gave a presentation at the Database2011 conference on how MySQL become an Internet Standard? Database2011 my sql sharding View more presentations from...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

Prepare for Database2011

2010-12-31T06:30:00.000-08:00

Hi, Raphael Fogel invited me to give a lecture at Database2011, the central databases conference in Israel. The event will take place on Jan 13 at the Avenue Conference Center. So...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

Cloud Computing Design and Best Practices

2010-11-16T11:40:00.000-08:00

Today I presented "Cloud Computing Design and Best Practices" in CloudCon, one of the largest cloud events in Israel. It was a great lecture and I would like to share with you some of the...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

The Path to the Cloud

2010-10-11T01:03:00.000-07:00

You decided to make the big decision and migrate to the cloud. What Should You Do Now?Well, migrating an active system between two hosting providers (and even from your small desktop under...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

Sharding Again

2010-09-16T13:19:00.000-07:00

Click on the post title to read the full post and the comments. It was a long time since we last discussed Sharding. Yesterday the Twitter sharding case study was presented at...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

How to Monitor Your Cloud Service Provider

2010-08-28T08:37:00.000-07:00

Click on the post title to read the full post and the comments. The emergence of cloud computing and Everything as a Service in last few years, raised many issues in enterprises that started to...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

Open is the New Black (hmm.... Standard)

2010-07-25T14:16:00.000-07:00

Click on the post title to read the full post and the comments. Only few years ago when a technological company was lagging behind in a new niche that was turned into a mainstream, it had a magic...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material

New Blog Announcement: The VP R&D Handbook Blog

2010-07-10T13:12:00.000-07:00

Click on the title to view the full post, comments and add your own comment Last month I opened a new blog Are You Leaving Us? No. The focus of the two blogs are totally different, I'll...

This is a content summary only, read the full post in the site: http://top-performance.blogspot.com, plus comments and extra material