Hans-Christian Andersen
ha at phulse.com
Wed Sep 21 20:38:33 CDT 2011
John, The easiest thing to do, of course, is to stick with what you know. Especially if it's something you are going to have to support over time. If you don't feel comfortable with a Linux environment (even if what you are asking for would be pretty trivial to set up for someone like myself and distros like Debian, Ubuntu, OpenSuse, CentOS, etc are pretty straightforward these days), there is always a chance there will be bumps in the road somewhere down the line that requires you to open the the hood and take a deeper look. Same applies to Windows as well as Linux. That's where you need to ask yourself if you are prepared to make a bit of an investment in terms of learning how Linux works and also being prepared to have an experienced Linux admin to go to, if you are in way over your head. I can tell you this much in advance: MySQL + Linux/*BSD is the most natural fit and will perform the best. Optimisations for the Windows platform only came as an afterthought and I don't know if there is yet any parity performance-wise. This is an interesting question and perhaps I will try and do some sort of benchmark to see what the difference is, but I recommend you check out the following link in the meantime: http://dev.mysql.com/doc/refman/5.1/en/limits-windows.html If high performance isn't a requirement but just something that works decently, then I wouldn't worry too much about what platform to use and I'd recommend using those packaged Apache/PHP/MySQL stacks, such as WAMP or XAMPP (which is my personal recommendation), rather than installing MySQL alone. XAMPP is cross platform as well, so this makes things easier should you decide somewhere down the line to switch platforms. Everything is contained within a single directory, so migration is also trivial (on Linux and OS X, in my experience, anyways). It's just a matter of zipping (tar balling) up the XAMPP directory and dropping onto the new machine. Again, I only know for sure that this is the case on Linux and OS X. Regarding file sharing, SAMBA (the application on Linux that does SMB file sharing) is very powerful and flexible. It's pretty easy to knock up a simple setup that plays well in a Windows workgroup and many distros, like Ubuntu and OpenSuse, have made it as easy as simply right click on a folder and selection the option to share that directory. Things get more complicated, however, when you want it to do more advanced stuff, such as joining an Active Directory setup. I know that OpenSuse has a lead in this respect what with having user friendly GUI configuration of the more advanced SAMBA setups, but it is still worth considering that SAMBA is a different beast than what you are used to. Setting up MySQL on Linux is dead simple, but there's more of a learning curve with SAMBA (depending on what you want to do, of course). On the other hand (and I don't want to sound religious in saying this), but, typically with Linux, once you get a configuration nailed down, you should have a system that will be able to run pretty solid without many problems down the road. And the reason I believe this is because Linux is much more of a "static" system than Windows is, based more on configuration files and more of a separation of data, software and configuration as a matter of principle rather than complex software installations and registries and background processes doing x, y and z, etc that I often see for software on Windows. A distribution like Debian tends to be rather minimalist (especially if you install from the net boot iso), so you won't have a lot more stuff running in the background than is necessary for a shell to run, networking and whatever software you have selected to install, etc, if you catch my drift. From a security point of view, this is also great. If you keep your system setup to a minimum (OpenSSH server, MySQL server, Samba), then you will get less hassle with security updates. Saying that, if you are a competent Windows admin, then it is of course also possible to achieve a very robust system like that. I just think it takes a bit more effort and forethought. Perhaps that is debatable and may seem counterintuitive, but for the things that I deal with professionally, this is my experience. All in all, there is no reason you can't achieve exactly what you want and need with Linux. The question is, however, whether you are willing to make that investment. Think of it this way: Imagine an all Linux company which decides to install a Windows server, although they have little experience in doing so. While Windows is perfectly capable of doing what they need it to and may even be a better solution than the Linux one, it is still at a disadvantage. Problems with the Windows server may eventually translate into the perception that Windows is an inferior product that isn't capable of doing things correctly or is just difficult to maintain. It wouldn't be fair to say that, because, as you all know, Windows is anything but that. But I often deal with that sort of attitude from other people with regards to Linux, because they just don't understand it or are more suspicious of things that are different and hence more critical of it. So I've learnt to be careful when suggesting Linux to someone who, as you admit, has zero experience with it and is thinking of deploying it for a client who also has zero experience. It's easy for me to say something is simple to do, because I do it all the time, but thats not always going to be someone else's experience. Linux doesn't always offer the best solution, depending on what you want to do, and there are of course times where some piece of complex or buggy software may make it a frustrating experience. Finally, there is, of course, also the matter of the cost of buying a Windows Server license, which is another factor to take into account. If you do decide to go ahead with Linux, I will be happy to answer any questions. Relating to what Gustav suggested, I also know of another admin who I have worked with professionally and can vouch for who might be returning from the UK to Vancouver in the new year and also has experience with both Windows and Linux, so may be interested in consulting as well. Good luck. PS. >> 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? Incidentally, what exactly did you mean when you said you wonder if it plays well in an all windows network? On a networking level? Or regarding how well it integrates with AD and such? - Hans On 21 September 2011 15:26, jwcolby <jwcolby at colbyconsulting.com> wrote: > Good advice I think. > > > John W. Colby > www.ColbyConsulting.com > > On 9/21/2011 5:32 PM, Gustav Brock wrote: > >> 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 >> >> ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com> > >