[dba-SQLServer] [AccessD] MySQL

Hi John

In that case, run MySql on Windows. It works great, and underneath you have a platform you are familiar with - with RDP access, Active Directory, well-known tools, etc. I've given up on the Linux and Solaris server OS'es - you always "miss something" and it just doesn't pay off to spend the time necessary to learn these reaching a level where you feel you are in control. If you really need it, team up with a Linux guy who is not afraid of Windows.

/gustav


>>> jwcolby at colbyconsulting.com 21-09-2011 12:27 >>>
Thanks for that Hans.

I have zero experience with Linux but my inclination is to recommend that to this client.  It just 
makes sense for a vanilla server that is going to sit in the corner and run MySQL and be a file server.

The biggest problem is very simply that they and I have zero experience.  So there is that nagging 
"what if something goes wrong" in the back of our heads.  We know Windows, we are comfortable in 
Windows, we have tons of experience recognizing, categorizing and dealing with Windows problems.  It 
just *feels like* if we have a problem, even a year down the road, we could spend a fortune learning 
enough to figure out what is wrong and fixing it.

The other nagging, back of the head issue is, "how well does it play in an otherwise all windows 
network.  And how well does the windows network play with it?

John W. Colby
www.ColbyConsulting.com 

On 9/21/2011 2:29 AM, Hans-Christian Andersen wrote:
> John,
>
> My best recommendation is to use either Ubuntu or Debian (for an even more
> minimalist experience). I work daily with these systems and their
> installation is fairly trivial. But, I suppose, if you've never dealt with
> anything outside the Windows eco-system, it could be a bit daunting with all
> the different terminology and so forth at first.
>
> Regarding partitioning, if you want to keep it simple, just always select
> "Guided partitioning". This means the system will just go with the most
> obvious, simplest choice (which is usually to install the system onto one
> drive using as much disk space as possible and only using one partition).
>
> IT professionals and experienced Linux users will know that there are very
> good reasons to plan how to lay out your partitions, so the system will
> present you that option during the installation process. For
> instance, separating your home partition is often a good plan. Moving your
> swap partition to another physical drive is another good idea... Then there
> is drive encryption or logical volume management and so forth. Sometimes,
> selecting a filesystem type is very important as well (when plain ext3 isn't
> quite what you need for performance reasons). etc etc.
>
> But if you want a plain old vanilla system, which will be enough to perform
> well as a server, then using the defaults with "Guided partitioning" is good
> enough.
>
> Once you set up your basic Debian/Ubuntu install, all you have to do is run
> from the command line:
> # apt-get install mysql-server-5.0
> and then mysql will install and be prepared for you.
>
> It doesn't get simpler than that. If you continue to have issues, let me
> know. This is my bread and butter and I've built an entire companies
> infrastructure around Debian Linux, with over 20 1/2 U servers, hosting over
> 50-60 vm's, so I know a thing or two about this sort of thing.
>
> Hans-Christian