Convert Existing MySQL Database to Innodb

  Converting existing MySQL Database Tables from MyISAM to InnoDB can be done from PHPMyAdmin but if there are too many tables the following script will help you to convert all the tables of a particular database to InnoDB Pre-requisites: 1. This tutorial assumes that you have .my.cnf configured with MySQL credentials for auto-login 2. […]

Setting Up MySQL Replication (Master-Slave) – PART 2

  Setting Up MySQL Replication (Master-Slave) – PART 2 My Environment : MySQL Server 01 – Master : 192.168.10.10 MySQL Server 02 – Slave : 192.168.10.11 DB To Replicate – hdada Things to Remember : 1. MySQL version should be the same on Master and Slave 2. During configuration of Replication once the DBDump is […]

Setting Up MySQL Replication (Master-Slave) – PART 1

  Setting Up MySQL Replication (Master-Slave) – PART 1 My Environment : MySQL Server 01 – Master : 192.168.10.10 MySQL Server 02 – Slave : 192.168.10.11 DB To Replicate – hdada Things to Remember : 1. MySQL version should be the same on Master and Slave 2. During configuration of Replication once the DBDump is […]

Install PHP ImageMagick cPanel

  Installation on latest version of WHM/cPanel with EasyApache4 (EA4)   1. Install the following packages using YUM yum install ImageMagick ImageMagick-devel   2. Install on EA4 PHP 5.5 /opt/cpanel/ea-php55/root/usr/bin/pecl install imagick   3. Install on EA4 PHP 5.6 /opt/cpanel/ea-php56/root/usr/bin/pecl install imagick   4. Install on EA4 PHP 7.0 /opt/cpanel/ea-php70/root/usr/bin/pecl install imagick   5. Install […]

SSL Installation on Tomcat Server

  Generate CSR for Tomcat Server: 1. Generate the private key with the below command keytool -genkey -alias website -keyalg RSA -keysize 2048 -keystore example_com.jks -dname “CN=example.com,OU=IT, O=Example Pvt Ltd, L=Hyderabad, ST=Telangana, C=IN” 2. Generate the CSR using the below command keytool -certreq -alias website -file example_com.csr -keystore example_com.jks 3. Once the certificate is signed, […]

Install PHP OCI8 extension to connect to remote Oracle Databases

Installtion on EasyApache 3: 1. Install Oracle Instaclient Basic and Devel packages from here [[email protected] ~]# rpm -ivh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm Preparing… ########################################### [100%] package oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64 is installed [[email protected] ~]# rpm -ivh oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm Preparing… ########################################### [100%] package oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm is installed 2. Download OCI8 package wget -4 https://pecl.php.net/get/oci8-2.0.5.tgz 3. Untar the archive tar -xvf oci8-2.0.5.tgz cd oci8* 4. […]

www.hostingdada.net © 2016