Databases and ZFS

ZFS 尽管有上佳的表现,但是在数据库应用上还是必须“应库而异”。

这篇文章介绍的5个要点可以说是每个 SA 必须了解的。

  1. Match the database block size with ZFS record size.
  2. If you have a write heavy workload, you are better off by separating the log files on a separate pool
  3. Tune down the vdev_cache using ztune.sh until 6437054 is fixed
  4. Tune vq_max_pending using ztune.sh until 6457709 is fixed
  5. Let ZFS auto-tune. It knows best. In cases were tuning helps, expect ZFS to incorporate that fix in future releases of ZFS