vCenter DB mirroring

dave330idave330i Member Posts: 2,091 ■■■■■■■■■■
in Virtualization
For various reasons we don't have a SQL failover cluster setup. Our current SQL DB failover is DB mirroring. Is there a way to setup vCenter so that it recognize mirrored DB as backup server? Did some search online and all results came back relating to failover cluster.
2018 Certification Goals: Maybe VMware Sales Cert
"Simplify, then add lightness" -Colin Chapman
· Share on FacebookShare on Twitter

Comments

  • jibbajabbajibbajabba Member Posts: 4,317 ■■■■■■■■□□
    dave330i wrote: »
    For various reasons we don't have a SQL failover cluster setup. Our current SQL DB failover is DB mirroring. Is there a way to setup vCenter so that it recognize mirrored DB as backup server? Did some search online and all results came back relating to failover cluster.

    Don't think it is possible per-se, first google hit shows an option though :)

    Technology Nuggets: VMware Vcenter redundancy using database mirroring technology

    You'll obviously have to setup a witness server to have the automated failover sorted.
    My own knowledge base made public: http://open902.com :p
    · Share on FacebookShare on Twitter
  • dave330idave330i Member Posts: 2,091 ■■■■■■■■■■
    jibbajabba wrote: »
    Don't think it is possible per-se, first google hit shows an option though :)

    Technology Nuggets: VMware Vcenter redundancy using database mirroring technology

    You'll obviously have to setup a witness server to have the automated failover sorted.

    Thanks. Looked at the link. Didn't even think about doing something like that. We should have SQL failover clustering setup within a month or so. Probably easiest to wait until that's setup.
    2018 Certification Goals: Maybe VMware Sales Cert
    "Simplify, then add lightness" -Colin Chapman
    · Share on FacebookShare on Twitter
  • jibbajabbajibbajabba Member Posts: 4,317 ■■■■■■■■□□
    To be honest though, you may as well use your infrastructure and virtualise SQL and vCenter and depending on licenses make use of HA/DRS or even FT
    My own knowledge base made public: http://open902.com :p
    · Share on FacebookShare on Twitter
  • meadITmeadIT Member Posts: 581 ■■■■□□□□□□
    jibbajabba wrote: »
    To be honest though, you may as well use your infrastructure and virtualise SQL and vCenter and depending on licenses make use of HA/DRS or even FT

    Unfortunately, FT is not supported for vCenter due to only supporting 1 vCPU.
    CERTS: VCDX #110 / VCAP-DCA #500 (v5 & 4) / VCAP-DCD #10(v5 & 4) / VCP 5 & 4 / EMCISA / MCSE 2003 / MCTS: Vista / CCNA / CCENT / Security+ / Network+ / Project+ / CIW Database Design Specialist, Professional, Associate
    · Share on FacebookShare on Twitter
  • dave330idave330i Member Posts: 2,091 ■■■■■■■■■■
    jibbajabba wrote: »
    To be honest though, you may as well use your infrastructure and virtualise SQL and vCenter and depending on licenses make use of HA/DRS or even FT

    Thanks for the advice. I had SQL as VM in a DRS cluster at previous employment. Unfortunately hardware at new employment is forcing us to keep SQL physical.
    2018 Certification Goals: Maybe VMware Sales Cert
    "Simplify, then add lightness" -Colin Chapman
    · Share on FacebookShare on Twitter
Sign In or Register to comment.