MemSQL Studio Upgrade Steps

In this blog post, I will demonstrate the Memsql upgrade steps in the Ubuntu server.  I have already explained about Memsql installation and configuration on this site. If you want to learn more about memsql then please go through the below post.

MemSQL Installation and Configuration

Here, I will explain about the Memsql studio upgrade from 1.8.0 to 1.9.0.

I have installed the MemSQL studio on the master aggregator, so log in to the master and execute the below command.

  1. First, stop the running Memsql studio for this execute below command.
      :~$ sudo systemctl stop memsql-studio

2. Update the package list

:~$ sudo apt update
Hit:1 http://azure.archive.ubuntu.com/ubuntu bionic InRelease

Get:2 http://azure.archive.ubuntu.com/ubuntu bionic-updates InRelease [88.7 kB]

Get:3 http://azure.archive.ubuntu.com/ubuntu bionic-backports InRelease [74.6 kB]                                                       

Get:4 http://security.ubuntu.com/ubuntu bionic-security InRelease [88.7 kB]                                                             

Get:5 https://packages.microsoft.com/ubuntu/18.04/prod bionic InRelease [3226 B]                                                        

Hit:6 https://repos.influxdata.com/ubuntu bionic InRelease                                                                              

Hit:7 https://release.memsql.com/production/debian memsql InRelease                                                             

Get:8 http://azure.archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages [740 kB]

Get:9 http://azure.archive.ubuntu.com/ubuntu bionic-updates/main Translation-en [266 kB]

Get:10 http://azure.archive.ubuntu.com/ubuntu bionic-updates/universe amd64 Packages [1006 kB]

Get:11 http://azure.archive.ubuntu.com/ubuntu bionic-updates/universe Translation-en [309 kB]

Get:12 https://packages.microsoft.com/ubuntu/18.04/prod bionic/main amd64 Packages [73.5 kB]

Get:13 http://security.ubuntu.com/ubuntu bionic-security/main amd64 Packages [516 kB]                  

Get:14 http://security.ubuntu.com/ubuntu bionic-security/universe amd64 Packages [607 kB]              

Fetched 3773 kB in 1s (3809 kB/s)                                                   

Reading package lists... Done

Building dependency tree       

Reading state information... Done

41 packages can be upgraded. Run 'apt list --upgradable' to see them.

 

3. Then update the MemSQL Studio package.

:~$ sudo apt install memsql-studio

Reading package lists... Done

Building dependency tree       

Reading state information... Done

The following packages were automatically installed and are no longer required:

  linux-azure-cloud-tools-5.0.0-1016 linux-azure-headers-5.0.0-1016 linux-azure-tools-5.0.0-1016

Use 'sudo apt autoremove' to remove them.

The following packages will be upgraded:

  memsql-studio

1 upgraded, 0 newly installed, 0 to remove and 40 not upgraded.

Need to get 18.2 MB of archives.

After this operation, 0 B of additional disk space will be used.

Get:1 https://release.memsql.com/production/debian memsql/main amd64 memsql-studio amd64 1.9.0 [18.2 MB]

Fetched 18.2 MB in 0s (40.5 MB/s) 

(Reading database ... 124436 files and directories currently installed.)

Preparing to unpack .../memsql-studio_1.9.0_amd64.deb ...

Unpacking memsql-studio (1.9.0) over (1.8.0) ...

Setting up memsql-studio (1.9.0) ...

4. From the above output, it is clear that we have updated the Memsql studio package without any error. next, start the service and make sure the process is running. Execute below commands to complete the upgrade.

:~$ sudo systemctl start memsql-studio

:~$ sudo systemctl status memsql-studio

 memsql-studio.service - MemSQL Studio

   Loaded: loaded (/lib/systemd/system/memsql-studio.service; disabled; vendor preset: enabled)

   Active: active (running) since Tue 2019-09-24 04:17:42 UTC; 7s ago

     Docs: https://docs.memsql.com/studio-redir/systemd

 Main PID: 112641 (memsql-studio)

    Tasks: 21 (limit: 19660)

   CGroup: /system.slice/memsql-studio.service

           └─112641 /usr/bin/memsql-studio

To confirm login to the Memsql studio and click on “About” left side panel “Question mark”. It displays an installed studio version.

 

 

Leave a Reply

Your email address will not be published.