Installing Ubuntu in Level 1 for this Stairway to SQL Server on Linux

SQL Server 2017 is a first SQL Server version which could be installed on Windows, Linux together with a Docker container. This stairway series serves as a guide for ones experienced SQL Server DBA to own skills info on this platform.

Basically the first article in a very new stairway series that would explore SQL Server on Linux utilizing the most common suggestions and comparing each versions for Windows and Linux.

This series enshrouds the following topics:

Linux installation
Linux commands for DBA
SQL Server installation
Using the brand SQL Server instance
Installing as well as using SQL Server Agent on Linux
HA/DR basics: Log Shipping
Monitoring SQL Server on Linux
Troubleshooting
Advanced HA/DR: AlwaysOn Availability Groups

For this first installment of such a stairway series, let’s experience the first step: the Linux server installation.
Which Linux distribution to get?

SQL Server 2017 is currently supported only on these Linux distributions:

RedHat Enterprise Linux 7.3 o 7.4
Ubuntu 16.04
Suse Linux Enterprise Server v12 SP2

SQL Server 2017 also is supported for a Docker image, which might run on Docker Engine on Linux or Docker for Windows/Mac. The docker image is centered on Ubuntu 16.04.

But, the best idea Linux distribution any type of those supported by SQL Server 2017 ? Well, all depends on what you needs as well as confidence level you may already have with the supported Linux distros.

Today, Linux isn’t necessarily a free OS, but a platform for running business applications. When comparing the best Linux distros, corporate Linux users usually be aware not only about the feature matrix based on that distro, furthermore about support and lifelong of the product.

Red Hat has become the market leaders of Linux distributions. Red Hat Enterprise Linux, or RHEL, entered many data centers via support mainly deals with hardware and software vendors. Today is regarded as a stable, proven foundation that’s versatile enough for rolling out new applications, virtualizing environments, and coming up with a secure hybrid cloud. RHEL 7.x deliver Several of support, with 5 and a half years of Full support, 1 year of so-called Maintenance Support 1 and additional 3 years and half for any Maintenance Support 2.

Ubuntu serves as a free and open source operating system and Linux distribution influenced by Debian. Canonical, the company behind Ubuntu, is known for a mission to make free available to people everywhere, generates revenue out from the sale of professional services for the distribution. New releases of Ubuntu occur each, while long-term support (LTS) releases occur every a couple of years.

Suse Linux Enterprise Server (SLES) works as a Linux-based operating system developed by SUSE. Major versions are released at an interval of 3-4 years, while minor versions (called “Service Packs”) are let go about every 1 . 5 years. From a technical perspective, SUSE Linux a lot more accessible as opposed to the other supported Linux distributions. SUSE is also the most administrator-friendly, through its integrated YaST platform. SUSE is just about the main developers for Pacemaker High Availability, the standard tool for high-availability clusters with all current Linux distributions, used also by SQL Server 2017 to apply AlwaysOn or Failover clustering. Continual support towards the supported version (v12 with SP2) is 31 March 2021.

Out of the SQL Server DBA point of view, you don’t see any significant differences one of many three os and choosing one example of these could be according to your internal knowledge, should your company have definitely a Linux-based machine, and also the list of component . you want to implement with each of your SQL Server.

For this series I decided on to install an Ubuntu server 16.04. Essential, this distribution is well-know for most of the included services like OpenStack cloud services, Ceph scalable distributed file system as well as Metal-as-a-Service (MAAS) tool, which are often used to easily deploy OpenStack or any other server types on bare-metal, all programmatically. We don’t need almost all these services for your purposes, but readily use Ubuntu Server even if it’s easy to setup, well-documented and supported on the list of Linux communities.
Installing Ubuntu

Prepare Ubuntu alone machine, either physical or virtual, work with to the past releases download page: http://releases.ubuntu.com/16.04.4/ simply because that the current release certainly is the 18.04 LTS, is not supported by Microsoft.

I’d like to point out that may be very important to buy a server to choose the long-term support (LTS) release of the Linux distribution, because it’s more stable and supported relating to the years to come by its vendor, with further security or feature updates.

Before commencing the installation, let’s study the prerequisites: Ubuntu needs a minimum of 512MB of RAM and 5GB of disk space, while SQL Server itself requires in any case 3.25GB of RAM and extra 3GB of disk for binaries. Considering that much more have more than space for them to save OS and SQL Server logs, system databases plus some other things, I would not create a server with under 4GB of RAM and 20GB of disk space.

Within later degree of this series we’ll see which guidelines we should attempt to find our new SQL Server on Linux, including a multiple disk configuration to spread our documents, transaction logs and TempDB files. For right now, we are assuming what a very basic server configuration.

Let’s start off with the installation: boot the product from the media containing the ISO file (including an USB key an excellent a physical server) or connect the ISO onto the virtual machine everyone who is creating a virtual server.

During the boot prompt you should be asked to go for a language for your setup.

Via the main boot menu you will choose further choices to install Ubuntu in relation to your system, carry out some check or rescue a broken system. We’ll cover only the basic setting up a fresh Ubuntu server.

The installer asks which language is should use along with keyboard layout (by auto-detecting customized for specific cultures or simply by entering manually).

The installer then discovers the hardware configuration and configures the network settings creating a DHCP server or provide you with the option to configure it manually by for the past and selecting the alternative “Configure the network manually”.

Next, the installer requests the system’s name and puts a new user which will have root access over the sudo utility. You are required to choose and ensure username and password.

For Windows users: allow me to explain some concepts before you go further. Inside a Linux operating system root would be the user name that automatically has access to all the commands and files, prefer the Administrator user during a Windows operating system.

Now of the installation, we are going to providing the system the naming of a new unprivileged user to use for everyday tasks. When folks need superpowers, we’re able still managed a command using the sudo utility, which elevates the privileges onto the root user level and runs site command. It may be like the “RunAs Administrator” command in Windows.

You’ll certainly be asked then to encrypt your home directory, or perhaps something stored files commonly are not readable generally if the computer is stolen.

Fresh articles daily:

Buy the SQL Server Central newsletter and grab a new SQL Server article day by day. Get Database Weekly for just about any roundup of all the biggest SQL news from around the web.
No thanks
Spruce up your SQL Server knowledge daily to comprehend articles by email.

Thank this author by sharing:
1

(not necessarily rated) Rate this Join the discussion Incorporate into briefcase

Installing Ubuntu in Level 1 for this Stairway to SQL Server on Linux

By Danilo Dominici, 2018/08/15
The Series

This information is part of the Stairway Series: Stairway to SQL Server on Linux

It’s an introductory series to installing Linux and SQL Server on Linux.

SQL Server 2017 can be the first SQL Server version that usually can be installed on Windows, Linux as well as Docker container. This stairway series operates as a guide in your experienced SQL Server DBA to accumulate skills information on this platform.

Is actually the first article in a new stairway series that would explore SQL Server on Linux making use of the most common recommendations and comparing their versions for Windows and Linux.

This series will pay for the following topics:

Linux installation
Linux commands for DBA
SQL Server installation
Using the brand new SQL Server instance
Installing and ultizing SQL Server Agent on Linux
HA/DR basics: Log Shipping
Monitoring SQL Server on Linux
Troubleshooting
Advanced HA/DR: AlwaysOn Availability Groups

In the first installment of it stairway series, let’s brows through the first step: the Linux server installation.
Which Linux distribution to buy?

SQL Server 2017 is currently supported only on these Linux distributions:

RedHat Enterprise Linux 7.3 o 7.4
Ubuntu 16.04
Suse Linux Enterprise Server v12 SP2

SQL Server 2017 just happens to be supported just like a Docker image, that will run on Docker Engine on Linux or Docker for Windows/Mac. The docker image will be based upon Ubuntu 16.04.

But, the best Linux distribution a kind of supported by SQL Server 2017 ? Well, the treatment depends on what you needs together with the confidence level you can show with the supported Linux distros.

Today, Linux is not only just a free OS, but a platform to operate business applications. Comparing the best Linux distros, corporate Linux users usually be cautious not only about the feature matrix backed up by that distro, but additionally about support and lifetime of the product.

Red Hat has become market leaders of Linux distributions. Red Hat Enterprise Linux, or RHEL, entered many data centers via support discusses hardware and software vendors. Today may be a stable, proven foundation that’s versatile enough for rolling out new applications, virtualizing environments, and preparing a secure hybrid cloud. RHEL 7.x deliver 5 years of support, with 5 and a half years of Full support, 1 year of so-called Maintenance Support 1 and further 3 years and half for your Maintenance Support 2.

Ubuntu is seen as a free and open source operating system and Linux distribution dependant upon Debian. Canonical, the company behind Ubuntu, is known for a mission to make open source available to people everywhere, generates revenue out of your sale of professional services near the distribution. New releases of Ubuntu occur each, while long-term support (LTS) releases occur every two yearsrrr time.

Suse Linux Enterprise Server (SLES) serves as a Linux-based operating system produced by SUSE. Major versions are freed at an interval of 3¡§C4 years, while minor versions (called “Service Packs”) are let go about every Eighteen months. From a technical perspective, SUSE Linux is more accessible when compared with the other supported Linux distributions. SUSE is always the most administrator-friendly, as a result of its integrated YaST platform. SUSE is regarded as the main developers for Pacemaker High Availability, the standard tool for high-availability clusters in a variety of current Linux distributions, used also by SQL Server 2017 to apply AlwaysOn or Failover clustering. Lasting support to your supported version (v12 with SP2) is 31 March 2021.

Belonging to the SQL Server DBA point of view, there’s no significant differences among the three operating-system and choosing one particular could be dependant on your internal knowledge, when the company already a Linux-based machine, as well as list of a pleasant feature is you want to implement along with your SQL Server.

For this series I made the decision to install an Ubuntu server 16.04. Essentially, this distribution is well-know for some of the included services like OpenStack cloud services, Ceph scalable distributed file system as well as Metal-as-a-Service (MAAS) tool, that is used to easily deploy OpenStack or any other server types on bare-metal, all programmatically. We don’t need a lot of these services for the purposes, but you are able to use Ubuntu Server since it’s easy to setup, well-documented and supported one of several Linux communities.
Installing Ubuntu

To place Ubuntu with your machine, either physical or virtual, you must use to the past releases download page: http://releases.ubuntu.com/16.04.4/ considering that that the current release is most likely the 18.04 LTS, is not supported by Microsoft.

Let me point out that is very important to get a server to choose the long-term support (LTS) details the Linux distribution, because it’s more stable and supported for this years to come by its vendor, with further security or feature updates.

Before you begin the installation, let’s take a look at the prerequisites: Ubuntu swallows a minimum of 512MB of RAM and 5GB of disk space, while SQL Server itself requires at the least 3.25GB of RAM and other 3GB of disk in the binaries. Considering that much more have perhaps space in OS and SQL Server logs, system databases and certain other things, I wouldn’t create a server with only 4GB of RAM and 20GB of disk space.

For a later quantity of this series we’ll see which tips we should cover our new SQL Server on Linux, along with a multiple disk configuration to spread our information, transaction logs and TempDB files. In the meantime, we are assuming this is a very basic server configuration.

Let’s begin the installation: boot the gps device from the media containing the ISO file (as an example an USB key if you use a physical server) or connect the ISO towards virtual machine everyone who is creating a virtual server.

About the boot prompt you should be asked to purchase a language for those setup.

Belonging to the main boot menu you can easily choose further options to install Ubuntu with your system, complete a few check or rescue a damaged system. We’ll only cover the basic installation of a fresh Ubuntu server.

The installer asks which language is should use additionally, the keyboard layout (by auto-detecting design or by entering manually).

The installer then discovers the hardware configuration and configures the network settings by having a DHCP server or supplies you the option to configure it manually by moving back and selecting the opportunity “Configure the network manually”.

Next, the installer requests for the system’s name and installations a new user that could have root access through your sudo utility. You need to choose and ensure username and password.

For Windows users: okay explain some concepts beneficial . further. For a Linux os root will be the user name that automagically has access for all commands and files, which includes Administrator user for a Windows operating system.

By now of the installation, we are going to providing the system the naming of a new unprivileged user useful for everyday tasks. Whenever you need superpowers, we are able to still manage a command utilizing the sudo utility, which elevates the privileges about the root user level and runs specific command. Chose to like the “RunAs Administrator” command in Windows.

That you are asked then if you wish to encrypt your home directory, or perhaps something stored files usually aren’t readable in cases where the computer is stolen.

After being required to choose the timezone, you really are entered into the disk layout configuration. We all have four choices, which also has a guided partitioning method as well as manual one. I decided they would use the entire disk too up a Logical Volume Manager (LVM). Logical Volume Management serves as a storage device management technology delivers users the to pool and abstract the physical layout of component storage devices for easier and flexible administration. This is now like gathering existing storage devices into groups and allocate logical units out of your combined space when needed.

Logical volumes will offer meaningful names like “databases” or “backups”. Volumes could be resized dynamically as space requirements change and migrated between physical devices during the pool within a running system or exported easily. LVM has also advanced features like snapshotting, striping, and mirroring.

The Ubuntu base system installation then starts. Tough phase from the installation process, you may be given the possiblity to select additional software to setup, by selecting predefined collections of software (one example is DNS server or OpenSSH server) to quickly developed your computer to carry out various tasks. You’ll be able to simply “continue” and skip an expert, as we just have to have a base system.

A final step requires us place in the GRUB loader, and we all are ready to use our new server.

GRUB or GRand Unified Bootloader, is usually a multiboot boot loader. A boot loader certainly is the first software program that runs each time a computer starts. It is responsible for loading and transferring control on the operating system kernel software (including Windows or Linux). This could possibly add the flexibility, as one example, to run different operating-system from the same physical (or virtual) disk and even to run specialized Linux distributions (for example to troubleshoot an unsuccessful system so they can run diagnostic tools).

Right after the installation process, excellent asked to reboot the gps device to start within the new Ubuntu server.

Perhaps you have realized, this process is really straightforward and doesn’t require particular skills. There are a variety of options you can change by selecting the advanced installation, and we’ll examine some of them when we’ll be expounding on the best practices along with perfomance tuning.

Now, let’s log in and analyze our new Linux machine.

After rebooting the server, when prompted type sqladmin because username we have been using to go into the system and so the password you provided all through setup to input the machine.

Quite possibly the most evident differences moving from Windows to Linux is case sensitivity, specially creating or navigating a folder structure. The directory “Data” is not the equal to “data” !

Once logged in, you can easliy use a substantial amount of commands, which is available from the command-line interpreter, named shell), our company is using. The Bash shell is considered the most commonly used (yet you can obviously change it whenever you want).

Let’s wait and watch some example. Using the command pwd, short for print working directory, you are able to show where we are going to located in the directory tree and then suddenly moving, here is an example, to another directory utilize the cd command (change directory), like we all do in a Windows command prompt.

You can easlily create or edit written documents from the command shell by utilizing the program vi (visual editor), which will be included in Linux/UNIX os in this handset since its beginning, or switch to a “modern” editor like nano or vim.

We’ll converse about Linux commands within a future article: this brief introduction was intended simply show you the right way to log in the newly installed system and appearance if it works.

To be able to know more over the Ubuntu Server Linux and the do a particular task, use the official documentation site at help.ubuntu.com and then click 16.04 LTS version, which is supported edition at the time we are offering this article.
Summary

We learned techniques to setup a Linux machine with Ubuntu Server 16.04, taking into account which prerequisites we do need to shift to the next step: the SQL Server 2017 installation.

Leave a Reply

Your email address will not be published. Required fields are marked *