[PVE-User] Cluster PVE and MS SQL Server

[Alexandre DERUMIER]

>>* MSSQL cluster has faster ("zero-downtime") failover, and many extra 
>>features that you don't mention - but costs twice as much, you must use 
>>2 x Enterprise license (AFAIK), and is complicated to set up.

you can do it with standard edition too.

you need a shared disk, I think it could work with a virtio-scsi. 
(not virtio, I think sqlserver need to do some iscsi reservation)

But I never tested it.

it's not true zero-downtime, take 1-2 minutes, so maybe proxmox Ha is enough, 
as restarting the vm could be around the same time. 

The befinit with sqlserver cluster, is that you can do updates on standby node,
without disruption.


----- Mail original -----
De: "Adam Thompson" <athompso at athompso.net>
À: "proxmoxve" <pve-user at pve.proxmox.com>, "Gilberto Nunes" <gilberto.nunes32 at gmail.com>
Envoyé: Jeudi 19 Mai 2016 00:55:04
Objet: Re: [PVE-User] Cluster PVE and MS SQL Server

Gilberto, in this case you are comparing apples to oranges. 
PVE cluster and MSSQL cluster do very different things, solve very 
different problems. 

If you only think of MSSQL Cluster as high-availbility, then: 
* PVE HA is easier to setup, easier to manage, much cheaper to buy & run 
if you already have the shared-storage hardware (or you use CEPH). 
* MSSQL cluster has faster ("zero-downtime") failover, and many extra 
features that you don't mention - but costs twice as much, you must use 
2 x Enterprise license (AFAIK), and is complicated to set up. 

Newer versions of MSSQL are easier to set up, but newer versions of PVE 
are easier to set up, too... 

Nothing stops you from running MSSQL cluster on top of PVE HA-enabled 
cluster to get the benefits of both! 

-Adam 


On May 18, 2016 9:02:50 AM CDT, Gilberto Nunes 
<gilberto.nunes32 at gmail.com> wrote: 

Hello friends 

Someone here already deploy scenario with cluster and MS SQL Server?? 
Is ii better leave this task to Windows Cluster or PVE Cluster can do the 
job??? 

Thanks 
------------------------------------------------------------------------ 

pve-user mailing list 
pve-user at pve.proxmox.com 
http://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user 

_______________________________________________ 
pve-user mailing list 
pve-user at pve.proxmox.com 
http://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user