Author: Sriram Sanka
-
Upgrade MySQL Server from 5.7 to 8 CentOS 7 Linux
Quote from Mysql Website Upgrade Paths Reference: https://dev.mysql.com/doc/refman/8.0/en/upgrade-paths.html Download the Required RPM and place them in the Server. Take the Backup of all the Databases and stop the MySQL Service. Run the Following from Local Directory using yum localinstall mysql-community-{server,client,common,libs}-* This completes the Upgrade from 5.7 to 8.0(Or Latest) Start the Service again and verify.…
-
Docker Part 1 – Install Docker CE and Docker Compose in Oracle Linux Server 8.6 – OCI-IAAS
In this Post, lets see how to Install Docker CE . I am using Oracle Linux Server 8.6 (Free Instance Offered by Oracle Cloud) . Docker lets you build, test, and deploy applications quickly, Docker is a software platform that allows you to build, test, and deploy applications quickly. Docker packages software into standardized units…
-
Install & Configure SSL for Apache-Nginx using Lets Encrypt-CertBot.
One can Install Apache and Nginx using YUM Or DNF in the Selected Unix flavor whereas by default it is a non-secure sub-domain when you access. Lets encrypt offers free SSL which can be configured to get the SSL for your domain irrespective of Private Or Public Domains. In case of Private Domains , you…
-
Python Basics – Part 1
Language Introduction Python is a dynamic, interpreted (bytecode-compiled) language. There are no type declarations of variables, parameters, functions, or methods in source code. This makes the code short and flexible, and you lose the compile-time type checking of the source code. Python tracks the types of all values at runtime and flags code that does…
-
SQL Formatter – Using Java/PL/SQL by Sayan Malakshinov

It is very easy to Format SQL using Third Party tools, Recently I found one source to get the SQL Formatted from the Sql prompt without connecting to any Third Party GUI Tools. I prefer to use SQLPLUS more than GUI tools., You can see the code formatted beautifully and very readable. Step 1: Load…
