MySQL Red hat linux

How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?

This is the full step-by-step procedure to resync a master-slave replication from scratch: At the master: And copy the values of the result of the last command somewhere. Without closing the connection to the client (because it would release the read lock) issue the command to get a dump of the master: Now you can release the […]

Red hat linux

Install and configure LSYNCD on Centos 7

Enviroment: – Server01.192.168.30.201 – Server02.192.168.30.202 – Directory to be Sync : “/opt/web/htdocs/prompt and /opt/vxml ” 2.Step Key based authentication Configuration -Login to Master server & generate the public and Private keys using the following command:

2.Step Installation Lsyncd

3.Step Lsyncd Configuration

Start and enable the lsyncd service using the following commands:

[…]

MySQL Red hat linux

Upgrade MySQL to Version 5.6 in CentOS

Backup all the database and stop mysql

Download the Repo for MySql 5.6

Install the repository from the local file

Install the latest MySql

Configure MySQL to start automatically on Server Reboot

Need to apply some tweaks Its not like the previous versions that tweaks are not required. From Version […]

Red hat linux

How to Set up Nginx High Availability with Pacemaker and Corosync

Prerequisites 2 or more CentOS 7 Serverpre web01       10.0.15.10 web02       10.0.15.11 web03       10.0.15.12 Floating IP Address 10.0.15.15 Root Privileges What we will do: Map the Host File Install Epel Repository and Nginx Install and Configure Pacemaker, Corosync, and Pcsd Create and Configure the Cluster Disable STONITH and Ignore the Quorum Policy Add the Floating-IP and […]

Red hat linux

Setting up the Basic High-Availability Cluster on Centos/RHEL 7

Networking: We have two nodes that are reachable by below Networks: 10.1.1.0/24 : Cluster heartbeat vlan. 172.16.1.0/24 : LAN with access to the Internal LAN network and Internet. We have set the following hostnames:

We defined the Hostname and IP Address in “/etc/hosts” file(On both the nodes), as shown below;

To setting up […]

Red hat linux

Setting Up an NFS Server and Client on CentOS 7

I’m using two CentOS systems here: NFS Server: server.example.com, IP address: 192.168.1.100 NFS Client: client.example.com, IP address: 192.168.1.101 Configure the Firewall

Installing NFS and enable and start the nfs server service.(Client / Server)

Exporting Directories on the Server

Now we must modify /etc/exports where we “export” our NFS shares.

Mounting the […]

Sysadmin profile picture
Red hat linux

Adding a New Disk Drive to a CentOS 6 / 7 System

Finding the New Hard Drive in CentOS

Creating Linux Partitions

As instructed, switch off DOS compatible mode and change the units to sectors by entering the c and u commands:

In order to view the current partitions on the disk enter the p command:

As we can see from the above […]

MySQL

Install and Configure MySQL Cluster on CentOS 7

MySQL Cluster is designed to provide a MySQL compatible database with high availability and low latency. The MySQL Cluster technology is implemented through the NDB (Network DataBase) and NDBCLUSTER storage engines and provides shared-nothing clustering and auto-sharding for MySQL database systems. In the shared-nothing architecture, each of nodes has its own memory and disk, the […]