怎么选择和规划数据库服务器啊?

如何规划和选择数据库服务器?
如何考虑如下方面?服务器?内存?CPU?磁盘?I/O?网络?
参与2

1同行回答

张东焕张东焕技术总监IBM官方授权讲师
Balance the System Resources:– Allocate 4 GB – 8 GB of system memory per CPU core– For Business Intelligence systems, 200 GB -300 GB ofactive raw data per CPU core– I/O Capacity should be measured in Megabytes persecond or I/Os per second, not am...显示全部
Balance the System Resources:
– Allocate 4 GB – 8 GB of system memory per CPU core
– For Business Intelligence systems, 200 GB -300 GB of
active raw data per CPU core
– I/O Capacity should be measured in Megabytes per
second or I/Os per second, not amount of disk space
– At least 10 – 20 disks per CPU core
• For example, for a 4-way system, use 8 disk arrays with 8
disk drives in each array for a total of 64 disks (ratio 16
disk :1 CPU core)
– For Systems with high rates of logged changes,
dedicate disks to the database logs:
• A RAID-1 pair of disks can provide enough logging
throughput for up to 400 transactions per second.
• A RAID-10 array with write caching can be used to support
higher logging rates收起
IT咨询服务 · 2013-05-16
浏览465

提问者

liliy
其它北京
擅长领域: 数据库分布式系统大数据

相关问题

问题状态

  • 发布时间:2013-05-16
  • 关注会员:1 人
  • 问题浏览:1792
  • 最近回答:2013-05-16
  • X社区推广