Document Centos6 with Mysql Slave and Replication setup

Auto-generated from the uploaded PDF Document_Centos6_with_Mysql_Slave_and_Replication_setup.pdf. This is an extracted-text rendering for searchability; see the original PDF for exact formatting, diagrams, tables, and images.

Centos 6 + Mysql
 Installation at
 Radico Rampur

Table of Contents


Installation of centos 6.10 radico khitan ltd.

* Boot from centos cd.

* follow basic step step of installation.

* Make partition.
* Standard partition.
 /boot -200mb
 swap -2048MB
 /boot/efi -200mb

* LVM partition.
 /    -20480mb
 /var -435200mb

* Status df -hT
 Filesystem        Type Size Used Avail Use% Mounted on
 /dev/mapper/VolGroup-LogVol00
             ext4 20G 7.8G 11G 42% /
 tmpfs           tmpfs 7.8G 22M 7.8G 1% /dev/shm
 /dev/sda2        ext4 190M 39M 141M 22% /boot
 /dev/sda1        vfat 200M 264K 200M 1% /boot/efi
 /dev/mapper/VolGroup-LogVol01
             ext4 418G 15G 383G 4% /var


* Installation minimal Desktop.


Mysql 8.0.12 Installation

* After the OS installation install mysql 8.0.12 community Server (specifically we have downloaded
this version becaisue of master sql has a same version).

Download mysql-community 8.0.12
     •     # wget http://repo.mysql.com/yum/mysql-8.0-community/el/6/x86_64//mysql-community-
         client-8.0.12-1.el6.x86_64.rpm
     •     # wget http://repo.mysql.com/yum/mysql-8.0-community/el/6/x86_64//mysql-community-
         common-8.0.12-1.el6.x86_64.rpm

       •      # wget http://repo.mysql.com/yum/mysql-8.0-community/el/6/x86_64//mysql-community-
            libs-8.0.12-1.el6.x86_64.rpm
       •      # wget http://repo.mysql.com/yum/mysql-8.0-community/el/6/x86_64//mysql-community-
            libs-compat-8.0.12-1.el6.x86_64.rpm
       •    # wget http://repo.mysql.com/yum/mysql-8.0-community/el/6/x86_64//mysql-community-
            server-8.0.12-1.el6.x86_64.rpm

install mysql and configuration
   •         #yum localinstall mysql-community-server-8.0.12-1.el6.x86_64.rpm mysql-community-
           common-8.0.12-1.el6.x86_64.rpm mysql-community-libs-8.0.12-1.el6.x86_64     .rpm mysql-
           community-libs-compat-8.0.12-1.el6.x86_64.rpm mysql-community-client-8.0.12-
           1.el6.x86_64.rpm
   •         #service mysqld start
   •         #service mysqld status
   •         #grep 'temporary password' /var/log/mysqld.log

Changing root password is mandatory

       •     #mysql -uroot -p
       •      #ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
       •    #create user 'root'@'%' IDENTIFIED BY 'root';