OpenSolaris and MySQL

If you use MySQL, you may want to give OpenSolaris a try. Why? It's open source and has great features, like ZFS and DTrace, which make life a lot easier for MySQL DBAs.  

  • ZFS is a 128-bit file system that automates common administrative tasks, protects data from corruption, provides compression, and allows for adding and removing storage easily (just to name a few things its capable of).  It is great for MySQL deployments in that DBAs can add or remove storage without restarting the database and fast snapshots are a breeze.  Additonally, ZFS shows better performance than UFS.  See these results performed by MySQL. 
  • DTrace helps administrators analyze, debug, and optimize their application environment.  It's a great tool for MySQL DBAs since it allows them to debug database performance issues (an example is being able to watch database queries for frequency and time spent in execution), trace and correlate system activities, like physical I/O, CPU, and memory, as a result of database activity, and  analyze the applications that are used within the MySQL environment.
People are already using the OpenSolaris + MySQL combination in production.  Check out this blog from SmugMug's CEO that details their success with OpenSolaris + ZFS + MySQL.

For those of you that don't know much about OpenSolaris....The OpenSolaris OS comes from the OpenSolaris community, where the next generation of Solaris is being built.  OpenSolaris releases are where you can find the latest results of these efforts. 

Comments:

Huh; interesting blog post by SmugMug about how he ran ZFS through its paces. Performance sounded good! Also, I agree with him about some of the painfully arcane naming conventions for packages that Solaris seems to have kept for OpenSolaris (e.g., "apache" being called "SUNWapch").

Posted by George Drapeau on October 14, 2008 at 07:25 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Jennifer Glore

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today