Running MySQL on Windows

[Tabs]

A little background: We've recently purchased licences for IPB and the associated MSSQL driver to convert our Community Server 2007.1 installation and continue using MSSQL for IPB 3.1, however since Invision took the decision to disontinue support for MSSQL we're now going to need to look at using MySQL. We use a Windows server to host our current sites and would prefer to stick with this setup due to having experience in this area.

So a few of questions if I may... We'll be using the community edition of MySQL, again, is there anything we need to be aware with this version? Already discovered backups require the DB to be taken offline which presents some interesting decisions for how we're going to automate backups. [*] MySQL offers two types of Database usage modes; InnoDB and MyISAM - With these modes which operational mode is best for IPB; Multifunctional, Transactional or Non Transactional? [*] Our site is generally high traffic, with around 2-3000 users online, are there any performance considerations we should take note of? The server itself is dedicated and realtively high spec with 2 x Xeon 5420 processors and 16BG ram, running Windows 2008 x64 R2. It has served us well with IIS7.0 and MSSQL 2008 and it's a bloody shame we're having to move away from the latter - it's a great DB system. Having never used or dealt with MySQL in a production environment I'm a slightly anxious about how it will perform so any experience others can offer would be greatly received. Tabs

[*]Does anyone use a windows server and MySQL Community edition to host IPB? If so, is there anything we should be aware of? [*]

[Tabs]

Any help on this would be appreciated.

[AndyF]

I'll move your topic to Server Management as that might be a more appropriate location than the Lounge (although I'll move it back if you want as its not a specific support topic in itself). :smile:

Those who are able to offer advice are more likely to frequent this forum area, that's all.

[Cloaked]

I use mysql on Windows 2008 and 2008r2. No problems. I use innodb on a couple sites and myisam on the others. No problems with either.

You don't have to take the site offline to backup the data. I use batch files to do auto backups hourly and nightly backups are done with rsync for Windows which are transferred to another server. Sites remain online during the backups.

If you properly tune mysql it will run fine even on the highest traffic sites.

[Tabs]

Thanks for moving to the appropriate section.

Cloaked, thanks, we currently use a mix of MSSQL taks and batch files to facilitate backups at the moment so it's not too disimilar. WIll take a look at the link.

I'll get MySQL installed with the default settings and go from there.

What type of options are available to tune?

[Cloaked]

Once you have mysql setup and running for a few days post your stats from mysql and I can help you tune it up.