Upgrade MySQL 5.6 to 5.7 on Centos 7

Reference: http://linuxresolved.com/upgrade-mysql-5-6-mysql-5-7-centos/ 1. # service mysql stop 2. Important backup your databases before upgrade. Create a backup of the original MySQL data. mv /var/lib/mysql /var/lib/mysql.original 2. Download the MySQL 5.7 RPM wget http://repo.mysql.com/mysql57-community-release-el7.rpm -P /tmp/ 3. Remove the MySQL-Community RPM that contains MySQL 5.6 yum remove mysql-community-release 4. Install the MySQL 5.7 RPM rpm -ivh /tmp/mysql57-community-release-el7.rpm … Continue reading Upgrade MySQL 5.6 to 5.7 on Centos 7

Advertisements

PostgreSQL notes

In Ubuntu, the server is run as a service called postgresql (configured in /etc/init.d/postgresql). The postgresql service is started automatically upon startup. Like all other services, you could: $ sudo service postgresql stop // Stop the service $ sudo service postgresql start // Start the service $ sudo service postgresql restart // Stop and restart the service $ sudo service postgresql reload … Continue reading PostgreSQL notes

Test JDBC connectivity to Oracle using Java

This blogs shows how to connect to Oracle database to test a JDBC connection: https://www.quickprogrammingtips.com/java/connecting-to-oracle-database-in-java.html Put the below java code in a text file in linux called: OracleSample.java -------------------------------------------------------------------------------------------------------------------- // Example Java Program - Oracle Database Connectivity import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class OracleSample { public static final … Continue reading Test JDBC connectivity to Oracle using Java

Streamsets install Oracle JDBC driver in External Library for CDH

This blog will show how to install the Oracle JDBC driver to the Streamsets External Library in a Cloudera Hadoop system.  Environment: Cloudera CDH 5.12, Streamsets 3.1.2 TASK: Update the Oracle JDBC driver inside Streamsets https://streamsets.com/documentation/datacollector/latest/help/#datacollector/UserGuide/Configuration/ExternalLibs.html#concept_pdv_qlw_ft Step 1. Set Up an External Directory  Setting Up for Cloudera Manager In Cloudera Manager, select the StreamSets service and then … Continue reading Streamsets install Oracle JDBC driver in External Library for CDH

Query Cloudera Hadoop Hive using Oracle SQL Developer.

Environment: Oracle SQL Developer Version 18.1.0.095 on Windows 64bit and Hive on Cloudera Hadoop CDH 5.12.x. Config steps: First download and install the popular free tool Oracle SQL Developer for Windows from Oracle website. Read this blog for a good idea about connecting Oracle SQL Developer to Hadoop Hive:   https://blogs.oracle.com/bigdataconnectors/move-data-between-apache-hadoop-and-oracle-database-with-sql-developer Note when configuring Cloudera-Hive JDBC drivers … Continue reading Query Cloudera Hadoop Hive using Oracle SQL Developer.

MariaDB vs MySQL

CentOS — MariaDB 5.5 replaced MySQL in CentOS 7 Debian — Jessie includes MariaDB 10.0, Stretch includes MariaDB 10.1 as default. Fedora — MariaDB 5.5 became the default relational database in Fedora 19. Fedora 26 includes MariaDB 10.1.[1] Red Hat Enterprise Linux — MariaDB 5.5 has been the default "MySQL" database since RHEL 7 SUSE Linux Enterprise — MariaDB 10.0 is the default relational database option on 12-SP2. Ubuntu —MariaDB 5.5 was included in Trusty … Continue reading MariaDB vs MySQL

Install MySQL on RHEL or Centos

<<<NEXT STEPS>>>______________ check if mysql is already installed earlier. Login as root and run: root># rpm -ql mysql package mysql is not installed root># rpmquery mysql package mysql is not installed check linux version: /root># cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.9 (Santiago) root># sudo yum install mysql-server Installed: mysql-server.x86_64 0:5.1.73-8.el6_8 Dependency Installed: mysql.x86_64 0:5.1.73-8.el6_8                          … Continue reading Install MySQL on RHEL or Centos