Mysql server windows or linux

MySQL on Windows or Linux [closed]

Want to improve this question? Update the question so it can be answered with facts and citations by editing this post.

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!

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'». 🙂

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.

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.

Implement first. Six months down the road, rethink the schema, OS, MySQL/MariaDB, etc. By then you will understand the requirements better.

2 Answers 2

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

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.

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

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

Источник

differences between mysql on linux vs windows [closed]

I was wondering if anyone could help me get the picture right. My Questions are :

1. are there really differences on performance between MySQL running on linux and Windows server? I’ve browsed for some views, but have found different opinions. If there are some differences, what causing them?
2. what key aspect that affect the performance for a mysql server running on windows xp or windows 2008 server? I mean I don’t need the server configuration stuff anyway, right?

( My team has been working with both windows and linux servers, so no problem with the capabilities issue ).

3 Answers 3

This is a question for which you will not receive an absolute right or wrong answer, as it is left to subjective opinions based on user experience, that’s why people are voting to close it.

However, to assist you, I would recommend that you use MySQL on Linux. There are a number of reasons why Linux is a better choice over windows, but some of the big ones are; security, stability, and total operating costs. Granted, with Linux it may be more complicated to set-up configs and daemons to ensure your server is running properly, but in the end, it is worth the setup.

To decide which OS on which to develop the app depends on your dev shop’s code expertise and experience. If they can finish the better project in a shorter duration using windows, then that’s what you should opt for.

Источник

PHP, MySQL | Windows vs Linux

Well the title does the explaination. Which one is faster PHP/MySQL on Linux or on Windows. Question 1 I know that MySQL is slower on Windows, because i tried to run a C++ program on Windows to access MySQL, it took a year every time it had to open a connection. When i ported the exact copy into the linux enviornment it was lightning fast. Im not sure why the difference is, Maybe cause when we talk about Linux every thing is million times faster, but it would be good to know why such a massive difference. Question 2 I have set up PHP on IIS and mySQL on Windows ive just tested a very small application on this setup and it seems fine. What i really want to know is that is there any performance issues for PHP in Windows rather than Linux? Edit Windows Vista Was the OS i tried on Originally, Havent Tested W7. Fedora 10 was the Linux 😀

5 Answers 5

They should be the same speed eventually. If you do an unscientific, unfair test, you might show a difference.

Process startup speed might be different. In particular, process startup might be slower on Windows. This shouldn’t matter too much in production unless you’re using a model which creates new processes on a very frequent basis, which will be inefficient on either.

Run a performance test of your actual application, with a large number of requests, over a significant length of time, on production-grade hardware. It’s the only way to tell.

Needless to say, I can safely say that almost nobody chooses Windows vs Linux based on performance. Usually it’s what they are capable of managing in production and have hardware / software support for.

If you’re going to install 1000 boxes in production, Windows server licencing might get expensive (depending on your deal with MS). If you are only going to install a few, it probably doesn’t matter (supporting the servers will be much more expensive).

Источник

Overview of SQL Server Requirements on Linux and Comparison with Windows SQL Server

In a previous article, Introduction to SQL Server on Linux, we learned about the SQL Server on Linux overview, features, performance, and high-availability concepts at a high level. Traditionally, SQL Server is a Windows-based relational database engine. Microsoft introduced SQL Server 2017 in both Windows and Linux platforms. The question is how they compare.

This article will walk through the differences. Let’s begin our journey into SQL Server on Linux.

Note: This article focuses on SQL Server 2019 version for comparisons on both Linux and Windows SQL.

Supported platforms for SQL Server on Linux are the following:

• Red Hat Enterprise Linux 7.7 – 7.9, or 8.0 – 8.3 Server
• SUSE Enterprise Linux Server v12 SP3 – SP5
• Ubuntu 16.04 LTS, 18.04 LTS, 20.04 LTS
• Docker Engine 1.8+ on Windows, Mac, or Linux

What are the system requirements for SQL Server on Linux?

SQL Server has the following minimum requirements for SQL Server for Linux:

• Processors: x-64 compatible
• Memory: 2 GB
• Number of cores: 2 cores
• Processor speed: 2 GHz
• Disk space: 6 GB
• File system: XFS or EXT4
• Network File System (NFS): NFS version 4.2 or higher

Note: You can only mount the /var/opt/mssql directory on the NFS mount.

What are the supported editions of SQL Server on Linux?

In this section, we talk about different editions of SQL Server on Linux, and their use-cases. These editions are similar to the SQL Server on Windows environment.

The Enterprise edition is Microsoft’s premium offering for relational databases. It offers all high-end data center capabilities for mission-critical workloads along with high availability and disaster recovery solutions.

The Standard edition has an essential data management and business intelligence database.

The Developer Edition has all features of the enterprise edition. It cannot be used in production systems. However, it can be used for development and test environments.

The Web edition is a low-cost database system for Web hosting and Web VAPs.

The Express edition is a free database for learning and building small data-driven applications. It is suitable for software vendors, developers.

Editions of SQL Server on Linux and Windows

The editions specified below apply to both Windows SQL Server and Linux:

Maximum relational database size

Maximum compute capacity – DB engine

Maximum compute capacity – Analysis or Reporting service

Always On failover cluster instance

Always On availability groups

Clusterless availability group

Dedicated admin connection

Yes, it requires a trace flag

Performance data collector

Full-text and semantic search

Note: You can refer to Microsoft documentation for detailed features details and comparison.

Features not supported by SQL Server on Linux

The following SQL Server features are not supported on Linux.

• Merge replication
• Distributed query with 3rd-party connections
• File table, FILESTREAM
• Buffer Pool Extension
• Backup to URL (page blobs)

• SQL Server Browser
• Analysis service
• Reporting service
• R services
• Data Quality Services
• Master data service

• AD Authentication for Linked Servers
• AD Authentication for Availability Group (AG) Endpoints
• Extensible Key Management (EKM)

There is no difference in the licensing for Windows and SQL Server Linux. You can use the licenses on the cross-platforms. For example, if you have a Windows-based license, you can use it for Linux SQL Server.

Yes, we can use it. However, the SQL Server Management Studio ( SSMS) can be installed on a Windows server and remotely access the Linux SQL Server.

No, you can move your existing databases in any version of SQL Server from Windows to Linux.

Yes, you can use SQL Server Migration Assistant (SSMA) for migrating from Microsoft Access, MySQL, DB2, Oracle or SAP ASE to SQL Server on Linux.

No, Linux Subsystem for Windows 10 is not supported.

Yes, you can install Azure Data Studio on Linux as well. It is a cross-database platform tool with rich features for development, such as below.

• Code editor with IntelliSense
• Code snippets
• Customizable Server and Database Dashboards
• Integrated Terminal for Bash, PowerShell, sqlcmd, BCP, and ssh
• Extensions for additional features

You can refer to Microsoft documentation for more details on Azure Data Studio.

SQL Server Configuration Manager lists down SQL Services, their status, network protocols, ports, file system configurations in a graphical window for Windows.

SQL Server Linux includes a command-line utility mssql-conf for these configurations.

Yes, you can configure and use AD credentials to connect SQL Server on Linux with AD authentications.

Yes, you can use read scale replicas for one-way data replication between Windows to Linux SQL or vice versa.

Conclusion

It is essential to know the SQL Server on Linux edition, features and how it is different from SQL Server running on WIndows. Therefore, this article provided a comparison between SQL Server on Windows and Linux operating systems. You should understand the differences and evaluate your requirements while planning to move your databases to SQL Server on Linux.

Related Products

Источник