September 2017
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  

Categories

September 2017
M T W T F S S
 123
45678910
11121314151617
18192021222324
252627282930  

GlusterFS servers on RHEL 7 and Centos 7

GlusterFS servers on RHEL 7 and Centos 7

vi /etc/hosts

192.168.1.71 apache1.rmohan.com apache1 192.168.1.72 apache2.rmohan.com apache2 192.168.1.74 apache3.rmohan.com apache3

For this lab, we disabled both firewall and SELinux

vi /etc/selinux/config egrep “^SELINUX=” /etc/sysconfig/selinux SELINUX=disabled systemctl is-enabled firewalld disabled

systemctl disable firewalld yum update yum -y install wget openssh* net-tools ntp ntpdate -u 0.centos.pool.ntp.org

[…]

Replication Features in MySQL 8.0.1

MySQL 8.0.1 has just been released with a wonderful set of features across the board. Specifically in replication, there is plenty of new and exciting functionality as well as performance improvements. In this post I am going to summarize the replication features of this development milestone release.

The Group Replication plugin. You can now use […]

MySQL 5.7 vs MySQL 8.0 – What’s new in MySQL 8.0?

MySQL is arguably the most popular and common RDBMS. The last major release was MySQL 5.7 back in 2013.

As of today, several development milestones were declared for MySQL v8.0, but there is no official release available yet.

Tip: Do not click here if all your SQL queries are fast as lightning!

Even though there […]

expect,sshpass,pash

expect,sshpass,pash rpm -qa expect

yum install expect -y

useradd mohan

echo 123456|passwd –stdin mohan

su – mohan

ssh-keygen -t dsa -P ” -f ~/.ssh/id_dsa >/dev/null 2>&1

yum install lrzsz -y

cat mohan_sshkey.exp #!/usr/bin/expect if { $argc !=2 } { send_user “usage: expect mohan_sshkey.exp file host\n” exit } #define var set file [lindex $argv 0] set […]

mysqlcheck

[root@clusterserver1 software]# mysqlcheck mysql -uroot -p Enter password: mysql.columns_priv error : Table upgrade required. Please do “REPAIR TABLE `columns_priv`” or dump/reload to fix it! mysql.db OK mysql.event error : Table upgrade required. Please do “REPAIR TABLE `event`” or dump/reload to fix it! mysql.func OK mysql.general_log error : Table upgrade required. Please do “REPAIR TABLE `general_log`” […]

CENTOS 7 MySQL 5.7

CENTOS 7 MySQL 5.7

 

wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm

yum install -y mysql-community-server

 

systemctl start mysqld.service

[root@clusterserver1 software]# systemctl start mysqld.service [root@clusterserver1 software]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, […]