-1

I am new to the Database region while have to migrate the company's database from AWS RDS to AWS EC2 and subscribe MySQL Enterprise edition.

What I am confused now is which OS should I choose, Windows or Linux? The most important thing is the performance, which one would MySQL perform better? If its Linux, is it possible to use Ubuntu OS? Can anyone help to advise?

Really appreciate!

closed as primarily opinion-based by Evan Carroll, Colin 't Hart, hot2use, mustaccio, LowlyDBA Aug 17 '18 at 13:40

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    It is a heavily opinion-based question. Mysql typically performs better on Linux and you have a better control over what is going exactly in your system. The disadvantage is that you have to learn, how to control it. But fortunately you have StackExchange and StackOverflow for that. :-) You have also no licensing problems. But it is my opinion, and you know, "opinions are like ..., everybody has one but no one is curious to the others'". :-) – peterh Aug 17 '18 at 3:21
  • Choose what you have experience with or use most (or want to use) elsewhere in the company. Ubuntu is a reasonable OS to choose, but again, choose what you have experience with. – Colin 't Hart Aug 17 '18 at 7:45
  • Thanks guys. Really appreciated! Actually I really want to use Ubuntu as I feel like this would be more common and more control as well. Although as you said, I am not that confident especially when everyone else in the company is more familiar with Windows base. – Jupyterous Aug 19 '18 at 5:50
  • Implement first. Six months down the road, rethink the schema, OS, MySQL/MariaDB, etc. By then you will understand the requirements better. – Rick James Aug 26 '18 at 20:41
1

It depends on the person who is managing the server. you can make decision based on following points:

  • If you are familiar with commands based administrative tasks, then Ubuntu Server edition is a better choice, as finding and installing required tools is easier compared to other distros. Best part is reduced overhead of Licencing and GUI.

  • If you prefer GUI based administration, then windows is good choice.

  • I think getting familiar with commands based administrative tasks would be more helpful in the following career development and as for the GUI, I think I could still use the MySQL Workbench to connect via my local machine. Thanks – Jupyterous Aug 19 '18 at 5:52
  • Choosing linux for mysql is good idea. Yes you can use workbench from your local machine, but make sure that root user must be protected enough and can be used from allowed IPs only. – Kapil Bhagchandani Aug 20 '18 at 6:48
1

For tools such as MySQL is a better desition working with Linux operating systems, better compatibility, more tools to increase productivity, obviously costs licenses are important

There are facts like these to make a desition

  1. For open source technologies such as PHP, MySQL o MariaDB is a better way to choose Linux distros
  2. For closed technologies such as C#, SQL Server .NET a better way is Microsoft for performance and to gain compatibility

For example for tunning mysql server most of the tools are available for Linux distros

In the case for exa,mple of mariaDB for building a good dataware house, the most common tools are available for linux distros

For example in mariaDB if you want to use mariaDB Max Scale that is a columnar storage engine; the only supported opearting systems are

  1. RedHat CentOS
  2. Ubuntu
  3. Debian
  4. SLES

I mean how you can see if you choose windows over Linux you will be limited about using features of the Dtabase Engine

  • Thanks for sharing you hands-on experience. I feel like it is of more control to use linux as well. – Jupyterous Aug 19 '18 at 5:50
  • yeah because mysql/mariadb are oriented those platforms @Jupyterous – user158679 Aug 19 '18 at 5:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.