[PVE-User] Cluster PVE and MS SQL Server

[Gilberto Nunes]

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

[Lindsay Mathieson]

Post by Gilberto Nunes
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???

We have several SQL servers running on Proxmox hosted Windows VM's, it
works quite well for us - but they aren't heavily loaded, just for
internal usage. 2005 - 2012 servers.

Tip: Disable ballon memory usage, it kills performance.

[Gilberto Nunes]

Hello Lindsay

NIce to hear that...
Do you have any case about cluster with Windows or with PVE, with those
server of yours??

Thanks

Post by Lindsay Mathieson

Post by Gilberto Nunes
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???

We have several SQL servers running on Proxmox hosted Windows VM's, it
works quite well for us - but they aren't heavily loaded, just for internal
usage. 2005 - 2012 servers.
Tip: Disable ballon memory usage, it kills performance.
--
Lindsay Mathieson
_______________________________________________
pve-user mailing list
http://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user

[Lindsay Mathieson]

Post by Gilberto Nunes
Do you have any case about cluster with Windows or with PVE, with those
server of yours??

Sorry, not sure what you mean by that

[Gilberto Nunes]

I meant, do you have MS Cluster with MS SQL Server or PVE Cluster or none!

Post by Lindsay Mathieson

Post by Gilberto Nunes
Do you have any case about cluster with Windows or with PVE, with those
server of yours??

Sorry, not sure what you mean by that
--
Lindsay Mathieson
_______________________________________________
pve-user mailing list
http://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user

[Lindsay Mathieson]

Post by Gilberto Nunes
I meant, do you have MS Cluster with MS SQL Server or PVE Cluster or none!

Ah - PVE cluster hosting a Windows AD Domain with several MS Sql servers

[Adam Thompson]

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
<***@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-***@pve.proxmox.com
http://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user

[Alexandre DERUMIER]

Post by Adam Thompson
* 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.net>
À: "proxmoxve" <pve-***@pve.proxmox.com>, "Gilberto Nunes" <***@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
<***@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-***@pve.proxmox.com
http://pve.proxmox.com/cgi-bin/mailman/listinfo/pve-user

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