Skip to main content


Showing posts from 2017

How to create RESTful API usig Node for processing HTTP requests.

Node.js® is a JavaScript runtime built on Chrome's V8 JavaScript engine. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient. Node.js' package ecosystem, npm, is the largest ecosystem of open source libraries.
Follow : Create RestFul API node.js and mysql :

MySQL multiple instances on Ubuntu

OS: Ubuntu 16.x edition– up to dateAlready has MySQL installed that comes default – you can easily install LAMP MySQL Server version: > 5.5You have OS root privilegesDefault MySQL is running on port 3306What will we do
Set up 1 more MySQL instances on ports 3407 Each instance will have their own config files, data directories and log directoriesStopping default MySQL instance
sudo service mysql stop sudo ps -A | grep mysqlCreating data directories
MySQL cannot share data directories, so we need to set up new onesdefault basedir = /usr, this can be shared across instancesdefault instance port = 3306 and data dir = /var/lib/mysqlnew instance       port = 3408 and datadir = /var/lib/mysql3408MySQL must own data dirswe need to set rules in apparmor to let MySQL access the new dirssudo mkdir /var/lib/mysql3408 sudo chown -R mysql /var/lib/mysql3408 Creating log directories
create separate log dirs for new MySQL instancesdefault log dir = /var/log/mysqlnew log dir for 3307 = /var/…

Setting up MySQL SSL and secure connections

There are different articles on how to setup MySQL with SSL but it’s sometimes difficult to end up with a good simple one. Usually, setting up MySQL SSL is not really a smooth process due to such factors like “it’s not your day”, something is broken apparently or the documentation lies...

Read this article : Setting up MySQL SSL and secure connections

Pre-requisite :
Creating SSL Certificates and Keys Using openssl