The Right MySQL Engine for High Capacity Servers
April 22, 2009
As you may know there are many storage engines in MySQL MyISAM, InnoDB, Falcon, CSV, Blackhole, Archive, etc...There is a storage engine that comes with the MySQL Max Download called the "Blackhole Engine". According to the documentation it basically dumps it's storage to /dev/null. A storage engine that doesn't store anything? What good could that be?
Well if you run in a high volume production system where you may have one or more master databases for writes/updates/deletes and a whole farm of slaves reading the log from that master than this may be of interest to you. The concept is pretty simple. You have a Master database that is in charge of all your inserts, deletes, updates which in turn has connections to all those slaves. That means network traffic, disk I/O, CPU power all taking up resources that you really want for the Master's primary goal of collecting and maintaining data.
This is where the Blackhole Engine comes in. The actual process of logging the SQL statements that hit the Master database that the slaves consume lives above the storage engine level in the main MySQL server level. So with the Blackhole Engine piping data to /dev/null you can actually use it as a proxy to your slaved databases without the need to duplicate the data on that machine (it could very well be on the same machine!). See below for an example image...

What you then have is the Master only replicating to one database, increasing the Master's capacity to process transactions. The slaves consume the log file from the Blackhole server. It acts as a proxy at this point, with the benefit of freeing up resources on the Master's server. This could also benefit multi continent replication set ups where you can have farms of blackhole servers farming data to farms of slaves around the global for faster local access times. The possibilities are endless!
Well if you run in a high volume production system where you may have one or more master databases for writes/updates/deletes and a whole farm of slaves reading the log from that master than this may be of interest to you. The concept is pretty simple. You have a Master database that is in charge of all your inserts, deletes, updates which in turn has connections to all those slaves. That means network traffic, disk I/O, CPU power all taking up resources that you really want for the Master's primary goal of collecting and maintaining data.
This is where the Blackhole Engine comes in. The actual process of logging the SQL statements that hit the Master database that the slaves consume lives above the storage engine level in the main MySQL server level. So with the Blackhole Engine piping data to /dev/null you can actually use it as a proxy to your slaved databases without the need to duplicate the data on that machine (it could very well be on the same machine!). See below for an example image...

What you then have is the Master only replicating to one database, increasing the Master's capacity to process transactions. The slaves consume the log file from the Blackhole server. It acts as a proxy at this point, with the benefit of freeing up resources on the Master's server. This could also benefit multi continent replication set ups where you can have farms of blackhole servers farming data to farms of slaves around the global for faster local access times. The possibilities are endless!
replica gucci handbags says:
January 29, 2010 @ 19:21 — Reply
Comment pending moderation
Torrents Search says:
February 25, 2010 @ 02:13 — Reply
Comment pending moderation
Buy Cisco says:
March 23, 2010 @ 00:01 — Reply
Comment pending moderation
Timeshare News says:
March 31, 2010 @ 06:07 — Reply
Comment pending moderation
small business advertising says:
April 1, 2010 @ 13:37 — Reply
Comment pending moderation
sheds says:
April 2, 2010 @ 10:39 — Reply
Comment pending moderation
afa concentrate says:
April 2, 2010 @ 11:27 — Reply
Comment pending moderation
affordable diploma says:
April 3, 2010 @ 04:12 — Reply
Comment pending moderation
cheap web templates says:
April 4, 2010 @ 20:26 — Reply
Comment pending moderation
cheap web templates says:
April 4, 2010 @ 20:28 — Reply
Comment pending moderation
transglobal projects says:
April 6, 2010 @ 11:47 — Reply
Comment pending moderation
sales training courses says:
April 6, 2010 @ 21:13 — Reply
Comment pending moderation
Darth Lightsaber says:
April 14, 2010 @ 04:01 — Reply
Comment pending moderation
Links of London Jewellery says:
April 14, 2010 @ 07:33 — Reply
Comment pending moderation
blu ray ripper says:
April 18, 2010 @ 04:59 — Reply
Comment pending moderation
bespoke wedding stationery says:
April 18, 2010 @ 10:56 — Reply
Comment pending moderation
michel jackson says:
April 21, 2010 @ 21:13 — Reply
Comment pending moderation
bed bugs exterminators says:
April 23, 2010 @ 08:15 — Reply
Comment pending moderation
underwater digital cameras says:
May 2, 2010 @ 13:04 — Reply
Comment pending moderation
convert hd video says:
May 4, 2010 @ 23:57 — Reply
Comment pending moderation
louboutin slingback says:
May 10, 2010 @ 03:04 — Reply
Comment pending moderation
Manolo blahnik says:
May 14, 2010 @ 05:15 — Reply
Comment pending moderation
obagi skin products says:
May 14, 2010 @ 21:42 — Reply
Comment pending moderation
cook careers says:
May 14, 2010 @ 21:47 — Reply
Comment pending moderation
642-067 says:
May 19, 2010 @ 00:18 — Reply
Comment pending moderation
virbram five fingers says:
June 4, 2010 @ 21:09 — Reply
Comment pending moderation
Stromlieferant Nordrhein Westfalen NRW says:
June 7, 2010 @ 05:06 — Reply
Comment pending moderation
Gucci bags says:
June 7, 2010 @ 18:06 — Reply
Comment pending moderation
adjustable beds says:
June 7, 2010 @ 23:39 — Reply
Comment pending moderation
new gadgets says:
June 8, 2010 @ 04:14 — Reply
Comment pending moderation
LOUIS VUIttON OnlinE says:
June 9, 2010 @ 22:32 — Reply
Comment pending moderation
men's pendant says:
June 11, 2010 @ 20:33 — Reply
Comment pending moderation
CT0-101 says:
June 12, 2010 @ 02:04 — Reply
Comment pending moderation
http://www.litfuel.net/plush/?postid=107 says:
June 14, 2010 @ 00:36 — Reply
Comment pending moderation
hardy t shirt says:
June 14, 2010 @ 00:38 — Reply
Comment pending moderation
air force 1 says:
June 15, 2010 @ 00:56 — Reply
Comment pending moderation
surpa shoes says:
June 15, 2010 @ 00:59 — Reply
Comment pending moderation
asics shoes says:
June 15, 2010 @ 01:03 — Reply
Comment pending moderation
good pick up lines says:
June 15, 2010 @ 06:03 — Reply
Comment pending moderation
Louis Vuitton handbags says:
June 16, 2010 @ 00:33 — Reply
Comment pending moderation
christian louboutin shoes says:
June 16, 2010 @ 08:38 — Reply
Comment pending moderation
Juicy Couture says:
June 18, 2010 @ 05:27 — Reply
Comment pending moderation
evening dresses says:
June 18, 2010 @ 08:14 — Reply
Comment pending moderation
replica watches says:
June 21, 2010 @ 07:10 — Reply
Comment pending moderation