MySQL / Windows

[Andi]

Hi all, it's been a while since I posted on here due to moving jobs, but I'll try and get back into it.

 

Currently we only offer the option of SQL databases here but we're thinking of expanding this to allow MySQL onto our network. Does anyone have experience of how this works? Other than just installing it onto the necessary servers?

 

The primary things I'm looking at are:

Backups - can MySQL be backed up using Backup Exec (my research so far tells me not directly using an agent but can be using scripts to stop and start the relevant services).

 

Patches - currently we patch our servers using WSUS, presumably this won't support MySQL databases, but is there a similar option available to centrally patch these databases?

 

Security - are there any security issues with having MySQL running on a primarily windows network?

 

Thanks as usual for any advice that can be given.

[Michael]

Patches - currently we patch our servers using WSUS, presumably this won't support MySQL databases, but is there a similar option available to centrally patch these databases?

 

WSUS will only work on Windows Server's internal database or MS SQL. It won't work with MYSQL. The only other option would be scripting updates or using Windows Update on each machine As for security, just take a look at what versions of MYSQL hosting providers use.

[Andi]

Yeah I guessed that WSUS wouldn't support MySQL.

 

I'll look into anyways of keeping the databases patched automatically rather than manually running updates all the time.

 

Thanks.