OpenSolaris and MySQL
By Jennifer Glore on Oct 13, 2008
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.
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.