官术网_书友最值得收藏!

Summary

Building a database server with good performance is hard work. There are many individual components that are available in multiple quality levels and corresponding costs. Also there are plenty of small details you must get right or you'll risk data corruption. Luckily, you don't have to start from scratch. Stick to common, well understood components with known good performance, while keeping an eye on reliability too, and you can build a well balanced database server for a reasonable budget. Always make sure to run your own benchmarks on the result though. It's very easy to sabotage even good equipment with the wrong configuration when running a database.

  • Allocating your hardware budget among CPUs, memory, and disks is very application dependent.
  • Carefully selecting and configuring your controller and disk caches is critical for reliable database operation.
  • Make sure you are monitoring components in your server that are likely to fail or have a known lifetime, particularly hard drives and the batteries in disk controller cards.
  • Any disk write caches in your system must be confirmed to properly support the write flushing mechanism the database uses, or database corruption can result.
  • The maximum rate that database clients can commit transactions can be very low without a properly implemented write-back cache.
主站蜘蛛池模板: 栾城县| 淅川县| 塔河县| 黄龙县| 湟源县| 盈江县| 汝城县| 安阳市| 长丰县| 恭城| 威信县| 丰县| 五家渠市| 冕宁县| 三明市| 灵台县| 南漳县| 上犹县| 手机| 武隆县| 淮安市| 丰都县| 三江| 望奎县| 灵山县| 红桥区| 潜山县| 松溪县| 阳朔县| 育儿| 永和县| 阳城县| 五常市| 龙里县| 阜康市| 华池县| 安宁市| 衡东县| 新野县| 邵武市| 当涂县|