DB本身是可以做HA
可以怎麼做
就要視版本而定
不過我看不懂你所謂"透過兩台實體機上做虛擬機來達到資料庫的HA"是什麼意思
在兩台PHYSICAL MACHINE 裝VM ,再在VM 上裝SQL SERVER 做HA~?
如你所言,請選SQL SERVER VERSION 先~
physical A裡開兩台VM 有AP+DB
然後physical B裡也一樣
是這個意思嗎???
回enen1980
預計裝SQL 2014,請問Standard版本就可以嗎?還是需要其他版本?
回select
是的兩台都一樣,然後裡面的SQL要用always技術。
感覺版大好像沒有明白Microsoft Windows Server clusters和ESXi clusters 是根本不同的
http://www.books.com.tw/products/F012980625
Given the prevalence of Microsoft Windows Server in today's datacenters, the use of the term cluster often draws IT professionals into thoughts of Microsoft Windows Server clusters. Windows Server clusters are often active-passive or active-active-passive clusters. However, ESXi clusters are fundamentally different, operating in an active-active mode to aggregate and combine resources into a shared pool. Although the underlying concept of aggregating physical hardware to serve a common goal is the same, the technology, configuration, and feature sets are quite different between VMware ESXi clusters and Windows Server clusters.
您好:
我做過AlwaysOn,SQL 2014 & 2014都可以用,操作步驟雷同
希望對您有幫助
以下是我的文章 --
超簡易設定步驟 -- Windows Server (FailOver Cluster) + SQL 2012 AlwaysOn,感謝MVP: Edwin Sarmiento分享
http://www.dotblogs.com.tw/mis2000lab/archive/2013/12/16/sql_2012_alwayson_availability_group-again.aspx
使用率不高的系統,不要搞太複雜,直接用虛擬化的HA來作就好。還可以把一些老舊主機都虛擬化,省電環保。
1.買兩台主機
2.買一台效能好的Storage
3.虛擬化軟體用Xen Server或VM Ware都可以
4.找個服務好的廠商