April 18, 2017

Whats New on WhatsApp 2.17.146

WhatsApp messenger is a application to send and receive message via chat, pictures, audio, document files and video message. Another function from WhatsApp messenger for voice call and Video call. WhatsApp messenger available for Android and other Smartphone OS. 

WhatsApp Function

NO HIDDEN COST: Once you and your companions download the application, you can utilize it to visit as much as you need. Send a million messages a day to your companions for nothing! WhatsApp utilizes your Internet association: 3G/EDGE or Wi-Fi when accessible. 

MULTIMEDIA: Send Video, Images, and Voice notes to your companions and contacts. 

GROUP CHAT: Enjoy bunch discussions with your contacts. 

NO INTERNATIONAL CHARGES: Just like there is no additional cost to send a worldwide email, there is no cost to send WhatsApp messages globally. Talk with your companions everywhere throughout the world the length of they have WhatsApp Messenger introduced and maintain a strategic distance from those troublesome worldwide SMS costs. 

SAY NO TO PINS AND USERNAMES: Why much try remembering yet another PIN or username? WhatsApp works with your telephone number, much the same as SMS would, and incorporates perfectly with your current telephone address book. 

NO NEED TO LOG IN/OUT: No more perplexity about getting logged off from another PC or gadget. With push notices WhatsApp is ALWAYS ON and ALWAYS CONNECTED. 

NO NEED TO ADD BUDDIES: Your Address Book is utilized to consequently interface you with your contacts. Your contacts who as of now have WhatsApp Messenger will be consequently shown. 

OFFLINE MESSAGES: Even on the off chance that you miss your push notices or kill your telephone, WhatsApp will spare your messages disconnected until you recover them amid the following application utilize. 

AND MUCH MORE: Share area, Exchange contacts, Custom backdrop, Custom notice sounds, Landscape mode, Precise message time stamps, Email visit history, Broadcast messages and MMS to many contacts on the double and a whole lot more!

Whats New on WhatsApp 2.17.146 release date on April 11, 2017 :

  • Set a text-only update in WhatsApp User Profile, tap the menu setting and then WhatsApp Profile name to edit.
  • Search for the perfect files animated such as GIF right within WhatsApp Application.

April 10, 2017

MySQL Cluster on Ubuntu 17.04
MySQL provide software database cluster on MySQL Cluster to keep high availability for database node. MySQL Cluster contain 3 important function. NDB, NDB_MGM, SQL Node.
Management Node (ndb_mgmd) : MySQL Cluster to maintain two or mode node server. ndb_mgmd function to monitoring and configuring all nodes.
Data Node (ndbd) : MySQL Cluster Data Node used to store the data and pro automatic sharding and handled by replication.
SQL Node (mysqld) : MySQL Server connected to the ndb_mgmd to create query to all nodes in the cluster.

In this tutorial, I will show you how to install a 'MySQL Cluster' on Ubuntu 17.04.
Server Configuration :
4 nodes with Ubuntu server 17.04    management-node    node1    node2    sql
Root privileges on the nodes (sudo -s).

Configuration to all Node

Download MySQL Cluster Installer
wget http://dev.mysql.com/get/Downloads/MySQL-Cluster-7.4/mysql-cluster-gpl-7.4.12-linux-glibc2.5-x86_64.tar.gz
unpack MySQL Cluster Installer
tar -xzvf mysql-cluster-gpl-7.4.12-linux-glibc2.5-x86_64.tar.gz
Rename mysql cluster installer 
mv mysql-cluster-gpl-7.4.12-linux-glibc2.5-x86_64/ mysql/
go to mysql
cd ~/mysql/
copy all files inside bin/ directory to /usr/local/bin
cp bin/ndb_mgm* /usr/local/bin/
Give the executable permission with +x
chmod +x /usr/local/bin/ndb_mgm*
Remove bin/* files existing, and create a new symlink
rm -rf bin/

ln -s /usr/local/bin /usr/local/mysql/
Change the directory ownership
chown -R root:mysql .

chown -R mysql data
Install MySQL Cluster package denpendecy 
apt-get install libaio1
Create New User and Group mysql
groupadd mysql

useradd -g mysql mysql
Configuration by Function
1. MySQL Cluster Management Node
Create new directory /var/lib/mysql-cluster/
mkdir -p /var/lib/mysql-cluster/
Create configuration file for MySQL Management Node (config.ini)
vim /var/lib/mysql-cluster/config.ini
[ndbd default]

[mysqld default]
[ndb_mgmd default]
[tcp default]
# Cluster Control / Management node
# Data Node 1
DataDir= /var/lib/mysql-cluster
# Data Node 1
# SQL Node
Start MySQL Cluster Management Node :
ndb_mgmd -f /var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster/
Check Management node Serivce Status
Management Service Status

2. MySQL Cluster Data Node
Create new file configuration my.cnf inside /etc/ :
nano /etc/my.cnf
Node Configuration :
# MySQL Config

# Run ndb storage engine
# IP address management node
# IP address management node
# MySQL Pid and Log
save and exit.

Crate MySQL Cluster Data Node Directory :
mkdir -p /var/lib/mysql-cluster/

chown -R mysql /var/lib/mysql-cluster
Start MySQL Cluster Data Node :
ndbd --initial

systemctl start mysql
ndbd initial

Configure MySQL Cluster User and Password :
Repeat to second node with same step configuration.
related Artickle : MySQL Replication
3. MySQL Cluster SQL Node Configuration.
Create new File my.cnf
nano /etc/my.cnf
# MySQL Config

# Run ndb storage engine
# IP address management node
# IP address management node
# MySQL Pid and Log

Start MySQL Cluster SQL Node
systemctl start mysql
Setting MySQL Cluster User and Password
Testing :
Logon to MySQL Cluster SQL Node 
login so mysql server 
mysql -u root -p

SQL Node

Test to create new Database 
create database db_michaelsean;
ndb_mgm status

note : nodegroup: 0, * is primary Node MySQL Cluster, trying to shutdwon the primary node, the database will be automatically move to secondary node.

Thank you.

April 5, 2017

Docker for Beginner, Install Docker on Ubuntu 16.10 Yakkety Yak
Docker is a new application can makes easy and simple to run image os, application or other service application in an small container. Docker combined like a virtual machine running inside computer or server, with a little bit proccess usage, portable and dependent by operating system host.

Docker have two metods for running Docker on ubuntu 16.10. First method is installing docker on existing installation running on operating system. Second, with spinning up server with docker tool the developer called Docker Machine.

In this article, we will give an example of installation process on ubntu 16.10. 

Install Docker From Repository

Docker Installation packer supported by Ubuntu 16.10 Official, but not be the latest version. To install the latest docker set ubuntu repository with docker repository

But first, let's update the package database:

sudo apt-get update
Now let's install Docker. Add the GPG key for the official Docker repository to the system:

sudo apt-key adv --keyserver hkp://p80.pool.sks-keyservers.net:80 --recv-keys 58118E89F3A912897C070ADBF76221572C52609D

Add the Docker repository to APT sources:

sudo apt-add-repository 'deb https://apt.dockerproject.org/repo ubuntu-yakkety main'

Verify the Docker repo instead of the default Ubuntu 16.10 repo:

apt-cache policy docker-engine
Verify Docker Repo

Finally, install Docker:

sudo apt-get install -y docker-engine

Verify Docker Running status

sudo systemctl status docker
Docker Service Status

You can search for images available on Docker Hub by using the docker command with the search subcommand. For example, to search for the Ubuntu image, type:

docker search ubuntu
Docker Search Ubuntu

By Typing command docker search ubuntu, we get all of the information about container with name ubuntu, choose the package what you want and what you need.  
Docker pull ubuntu
Docker Pull Ubuntu

To Install docker container like ubuntu images, type the install command with pull, for example docker pull ubuntu. Its mean we install ubuntu container. after this, using docker run ubuntu or docker run -it ubuntu for running ubuntu images as docker container.

Related Article : Bash On Ubuntu on Windows

Check The IP address of Docker Container 

Docker install apache and get IP address
Docker IP Address

We test to install apache server on ubuntu container, using normal command apt-get install apache2, and start apache service. We got an information about IP Address of ubuntu image. Dokcer using NAT to access container.

Test Apache 

Test Apache Service

We test the container ubuntu images for running apache web server using web browser and access it by ip address. 

Docker Stop

Docker Stoped

For stopping the container, user exit command, automatically the container will be stoped and cannot be access. 

Service Apache stop

Service Apache Stop

This is a simple way learning about docker, if you want install some service or aoplication, you can search in docker repository. Docker very usefully for system admin to create a test environment and team developer too.

April 3, 2017

Kernel-Based Virtual Machine - KVM running on Ubuntu 17.04
KVM - Kernel-based Virtual Machine is a hypervisor for full Virtualization software solution for Linux OS on Intel 64 or AMD 64 Hardware. KVM included Linux Kernel since Linux Kernel 2.6.20 version and its stable for handle most workloads traffict.

KVM Support :
- Virtual CPU Proccessor hot add : KVM can provides an ability to increase CPU Proccessor as needed for Virtual Machine running without downtime ( Zero Downtime)
- Disk I/O throttling : Disk of Virtual Machine have ability set a limit of I/O disk usage.
- NUMA Balancing : Performance of NUMA Hardware, improved for applications running.
- Thin Provisioning : Virtual Machine have a flexible storage allocation, size disk based on file used.
- Over-committing : Virtual machine have allocating more vCPUs and Memory than available resources on KVM Host.
There is more improvement for KVM features.

1. Install KVM Package :

KVM Package

apt-get install qemu-kvm libvirt-bin virtinst bridge-utils cpu-checker

2. Verify Machine can be used for KVM

KVM check

$ kvm-ok
INFO: /dev/kvm exists
KVM acceleration can be used

3. Installing Virtual Manager

Virtual Manager

Installing Virtual Machine Manager using apt-get install virt-manager command. Virtual Machine Manager use to Manage KVM Virtual Machine.

4. Open VirtManager

Virtual Machine Manager

After Installting Virtual machine Manager, open search console and open Virtual Machine Manager.

5. Virtual Manager Console 

Virtual Machine Manager Console show a QEMU KVM Server.

6. Create New VM

New VM

Craeting Virtual Machine have 4 ways, via iso file, Network FTP, Network Boot (PXE) and using existing Virtual disk image.

7. New VM Disk

Virtual Machine Disk

For Virtual Disk Format, KVM have some type of virtual disk :

- raw : The raw format is a plain binary image of the disc image, and is very portable. On filesystems that support sparse files, images in this format only use the space actually used by the data recorded in them.
- cloop : Compressed Loop format, mainly used for reading Knoppix and similar live CD image formats.
- cow : Copy-on-write format, supported for historical reasons only and not available to QEMU on Windows.
- qcow : The old QEMU copy-on-write format, supported for historical reasons and superseded by qcow2.
- qcow2 : QEMU copy-on-write format with a range of special features, including the ability to take multiple snapshots, smaller images on filesystems that don't support sparse files, optional AES encryption, and optional zlib compression.
- vmdk : VMware 3 & 4, or 6 image format, for exchanging images with that product.
- vdi : VirtualBox 1.1 compatible image format, for exchanging images with VirtualBox.
- vhdx : Hyper-V compatible image format, for exchanging images with Hyper-V 2012 or later.
- vpc : Hyper-V legacy image format, for exchanging images with Virtual PC / Virtual Server / Hyper-V 2008.
source : Wikipedia

Dont miss it : MySQL Replication on Ubuntu 17.04

8. New VM Memory

Virtual Machine Memory

Adjust Virtual Machine Momory based on Host KVM Capacity.

9. VM Name
Virtual Machine Name
Fill in the Virtual Machine Name, setting Network Option for Virtual Machine :
- Private Virtual Bridge : You want to set up a private network between 2 or more virtual machines. This network won't be seen from the other virtual machines nor from the real network.
- User Networking : You don't need to access your guest from the network or from another guest.
- Public Bridge : You want to assign IP addresses to your virtual machines and make them accessible from your local network
- Nat : A NAT network will allow your guests to fully access the network, allow networking between your host and guests, but prevent the guests from being directly visible on the physical network.
source : kvm

10. Virtual Machine Ready

Virtual Machine Ready to Use

Your KVM Virtual Machine Ready to use.

March 30, 2017

Setup MySQL Replication Server
MySQL Replication combined two server of MySQL server Database to allow replication process to easily manage one or more databases. replicate from the Master Database server to Slave Database Server. One of the reason you need setup MySQL Replication is to load balance traffict to databases and you need keep the backup of MySQL DB.

In this toutorial i will capture my recent configuration using Ubuntu 17.04 beta 2 server amd64. Using two server called Mysql01 and Mysql02 :
Mysql01 =
Mysql02 =

Setup Master Mysql01

1. Install Mysql-server mysql-client

MySQL Server Installation

Using apt-get Install mysql-server mysql-client, you should connect your server to the internet and you need to update package using apt-get update

Root Set Password

Setup Mysql root password for login to Mysql Console.

2. Login to Mysql Server, change bind Address

Change bind-address

For Master Database, change the parameter bind-address =, it will be make your MySQL Database listen on IP

3. Edit Server ID 

set server-id
For Master Database, change parameter server-id = 1, and uncomment parameter log_bin, binlog_do_db. in parameter include_database_name, put your target database to create a database replica. After change the Parameter, restart the mysql service using service mysql restart.

4. Grant Slave Permission.

Grant Replication

Next, login to Mysql using command mysql -u root -p type your password. Create a slave user using sql query 
This command explain to create user with name slave to all source IP Address  with password mysqlpass

5. Show Master Status

Show master Status

Show Master status explain a DB with binlog_do_DB employees.

6. Export employees database
Transfer File
after you export the database using mysqldump -u root -p --opt emplyees > employees.sql, send this file via scp to slave server using scp command.

Related Article : SQL Server 2016

Setup MySQL Slave Mysql02

1. Change Bind Address and Server ID
Slave Server

Change the server-id parameter value 2, uncomment log_bin, binlog_do_db.

2. Import employees.sql

Import sql file
Import employees.sql in to Mysql02 Server to actived Slave Server using command mysql -u root -p employees < home/db/employees.sql

3. Active Slave Server

Active Slave Server
Set the master server on MySQL02 using command 

4. Check The Slave Server

Check Slave Server

Check the slave status using SHOW SLAVE STATUS\G

This is a simple way to setup MySQL replication between two server using Ubuntu 17.04.

Thank you. 

Related Article : Linux System Logging

March 29, 2017

System Center 16 Labs - Install and Configure SQL Server 2016
After finished Configure Active directory on Windows server 2016, next step is installing SQL Server 2016 for System Center Configuration Manager 16. SQL Server 2016 for back end or Database server stores a data user, computer, software and  etc.

This is step-by-step SQL Server 2016 installation :

1. Add .Net Framework 3.5

.Net Framework 3.5

2.  Create ConfigMgr Group using Active Directory Users and Computer

Group for System Center ConfigMgr 16

Create group ConfigMgr to manage database server and SCCM 16 administrator.

3. Open SQL Server 2016 and run Setup.exe

SQL Server 2016

launching setup.exe for sql server, we used Softawre evaluation from Microsoft.

4. Menu Feature Selection

Select Database Engine Service and Reporting Service - Native in menu Feature Selection.

5. Server Configuration

SQL Service User

In Server Configuration Menu, put an SQL User. In this step, we need create user dedicated for SQL Server, sql_svc. Next, running step by step until Press button install release. For Detail SQL Server Configuration 

System Center 16 Labs - Install and Configure Active Directory on Windows Server 2016
Active Directory Domain Services ( AD DS) is main of the cornerstone in Windows Domain Network. In AD DS stores all the information about computer, user and some settings of the application. Primary Domain Controller (PDC) is main of the Windows Domain Network. Client PC and Server Connected via Network. For System Center Configuration Manager 16, AD DS function to manage Boundary, Discover client and device.

In This Section, we will learn about install Active Directory Domain Services with domain name systemcenter.labs.

1. Add Roles and Features wizard.

Add Roles and Feature

Add Roles and Features wizard menu started on Windows Server 2012, it a new dashboard to manage computer.

2. Active Directory Domain Services Roles Selection.

AD DS Roles Selection

Next Step on Server Roles is select "Active Directory Domain Servies", check the menu and press next button.

3. Install AD DS Roles.

AD DS Installation

Skip Features menu and make a default AD DS add in menu, press install button and waiting the process until finished.

4. Promote This Server to a Domain Controller.

Promote Server to a Domain Controller

After installation process is finished, next step is clieck "Promote this Server to a Domain Controller". This step describe how to configure AD DS via User Interface guide.

5. Create New Forest

Create New Forest

In menu deployment Configuration, select option "Add a new Forest", type a domain what you want. We created domain name "systemcenter.lab".

6. Type the Directory Services Restore Mode (DSRM)


Next step is typing DSRM, DSRM have a function if you want to remove or demote this server or remove the domain name. Press button Next for menu DNS Option, Additional Option, Path, Review Option until button Install is release. Click Install and systemcenter.lab starting to configure. Wait until the process is finish and you need reboot the server for completion process. Then you will logon to domain with name "SYSTEMCENTER\administrator".

7. Active Direcotry User and Computer
If the installation process is finish, you need test to open Active Directory Users And Computers.

Active Directory Server ready to used for Install System Center ConfigMgr 16.

March 8, 2017

Facebook trial a new feature a "Dislike" button
Facebook Social Media
Social Media
Facebook has been rolled out the new feature to a small user on the facebook messanger application, the user of facebook messanger have an option to respond message from other user. The big social media company wants facebook user can using emojis to message in similar way to explain a "reactions" new feature on his timeline.


The online networking giant had already disregarded requires the "dislike" catch because of fears the element may be utilized as a type of tormenting and would be disagreeable with enormous brands. Facebook is however resolute this is to a greater extent a "no" catch and it is being tried to check whether the response is useful for when aggregate discussions need to vote, for example. "We're continually trying approaches to make Messenger more fun and locks in. This is a little test where we empower individuals to share an emoji that best speaks to their emotions on a message," a Facebook delegate told TechCrunch. Facebook propelled responses right around one year back and the component has turned out to be prevalent. More than 300 billion responses have been sent to date and "love" is the most as often as possible utilized, as per New York magazine. The Independent has reached Facebook for input.