Get the App
SLTechnology News&Howtos  ›  Database  › 

Cobar mysql High availability

Shulou Source: shulou.com Published: 2022-06-01 07:15:24 11月21日 Update

-

Server2 IP:172.25.38.2

Server5 IP:172.25.38.5

-

1) install mysql [server2], [server5]

Yum install-y mysql-server

Rpm-qa | when grep mysql## is installed, you can see the installed packages

Mysql-libs-5.1.71-1.el6.x86_64

Mysql-5.1.71-1.el6.x86_64

Mysql-server-5.1.71-1.el6.x86_64

[server2] # # Edit mysql configuration file

Vim / etc/my.cnf

[mysqld]

Datadir=/var/lib/mysql

Socket=/var/lib/mysql/mysql.sock

User=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

Symbolic-links=0

Server-id=2

Binlog-do-db=dbtest

Binlog-ignore-db=mysql

Log-bin=mysql-bin

Master-host=172.25.38.5

Master-user=ly

Master-password=westos

Master-port=3306

Replicate-ignore-db=mysql

Replicate-do-db=dbtest

[mysqld_safe]

Log-error=/var/log/mysqld.log

Pid-file=/var/run/mysqld/mysqld.pid

When configuring server2 as the master and server5 as the slave, remove the # that starts with #

[server5]

Vim / etc/my.cnf

[mysqld]

Datadir=/var/lib/mysql

Socket=/var/lib/mysql/mysql.sock

User=mysql

Symbolic-links=0

Server-id=5

Log-bin=mysql-bin

Binlog-do-db=dbtest

Binlog-ignore-db=mysql

# master-host=172.25.38.2

# master-user=ly

# master-password=westos

# master-port=3306

# replicate-ignore-db=mysql

# replicate-do-db=dbtest

[mysqld_safe]

Log-error=/var/log/mysqld.log

Pid-file=/var/run/mysqld/mysqld.pid

Log-error=/var/log/mysqld.log

/ etc/init.d/mysqld start## Open the database

Mysqladmin-u root password westos## set password

[root@server5 ~] # mysql-packs # enter database settings

Enter password:

Mysql > create user ly@'172.25.38.5' identified by 'westos';## create the user and set the password

Mysql > grant all on *. * to ly@'172.25.38.5';## Grant permissions

Mysql > flush privleges;## refresh

Mysql > show master status;## master node status

+-+

| | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | |

+-+

| | mysql-bin.000004 | 254 | dbtest | mysql | |

+-+

1 row in set (0.00 sec)

[root@server2] # mysql-p

Enter password:

Mysql > change master to master_host='172.25.38.2',master_user='ly',master_password='westos'

Mysql > start slave;## enable slave node

Mysql > show slave status\ Gternal status # View the status of slave

* * 1. Row *

Slave_IO_State: Waiting for master to send event

Master_Host: 172.25.38.5

Master_User: ly

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000004

Read_Master_Log_Pos: 254

Relay_Log_File: mysqld-relay-bin.000005

Relay_Log_Pos: 399

Relay_Master_Log_File: mysql-bin.000004

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB: dbtest

Replicate_Ignore_DB: mysql

# # do the same, and finally make a two-way master-slave synchronization

[root@server2] # mysql-p

Enter password:

Mysql > create user ly@'172.25.38.2' identified by 'westos'

Mysql > grant all on *. * to ly@'172.25.38.2'

Mysql > flush privileges

Mysql > show master status

+-+

| | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | |

+-+

| | mysql-bin.000012 | 106 | dbtest | mysql | |

+-+

1 row in set (0.00 sec)

[root@server5] # mysql-p

Enter password:

Mysql > change master to master_host='172.25.38.2',master_user='ly',master_password='westos'

Mysql > start slave

Mysql > show slave status\ G

* * 1. Row *

Slave_IO_State: Waiting for master to send event

Master_Host: 172.25.38.5

Master_User: ly

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.0000012

Read_Master_Log_Pos: 254

Relay_Log_File: mysqld-relay-bin.0000013

Relay_Log_Pos: 106

Relay_Master_Log_File: mysql-bin.0000012

Slave_IO_Running: Yes

Slave_SQL_Running: Yes

Replicate_Do_DB: dbtest

Replicate_Ignore_DB: mysql

-

2) install heartbeat [server2], [server5]

Get the following installation package

Heartbeat-3.0.4-2.el6.x86_64.rpm

Heartbeat-devel-3.0.4-2.el6.x86_64.rpm

Heartbeat-libs-3.0.4-2.el6.x86_64.rpm

Ldirectord-3.9.5-3.1.x86_64.rpm

Yum install openssl perl-Net-SSLeay perl-TimeDate perl-libwww-perl perl-Compress-Zlib perl-HTML-Parser perl-HTML-Tagset ipvsadm-yearly # solves dependencies

Rpm-ivh heartbeat-libs-3.0.4-2.el6.x86_64.rpm ldirectord-3.9.5-3.1.x86_64.rpm heartbeat-3.0.4-2.el6.x86_64.rpm heartbeat-devel-3.0.4-2.el6.x86_64.rpm

Vim / etc/ha.d/ha.cf## Editing configuration

34 logfacility local0

48 keepalive 2

56 deadtime 30

61 warntime 10

71 initdead 60

76 udpport 694 port

91 bcast eth0 # Linux

157 auto_failback on

211 node server5.example.com

212 node server2.example.com

222 ping 172.25.38.250 gateway # an ping-capable IP on the same network segment, preferably a gateway

255 respawn hacluster / usr/lib64/heartbeat/ipfail

261 apiauth ipfail gid=haclient uid=hacluster

Vim / etc/ha.d/haresources## resource configuration

Server5.example.com IPaddr::172.25.38.100/24/eth0 drbddisk::example Filesystem::/dev/drbd1::/var/lib/mysql::ext4 mysqld

Vim / etc/ha.d/authkeys

Auth 1

1 crc

# 2 sha1 HI!

# 3 md5 Hello!

The configuration of the two sets is the same, just scp it directly.

-

3) configure drbd

Add hard drives to two hosts, preferably the same size, easy to operate

/

Get the following package

Drbd-8.4.2.tar.gz

Or 8 installation packages as follows

Drbd-8.4.2-2.el6.x86_64.rpm

Drbd-xen-8.4.2-2.el6.x86_64.rpm

Drbd-udev-8.4.2-2.el6.x86_64.rpm

Drbd-utils-8.4.2-2.el6.x86_64.rpm

Drbd-pacemaker-8.4.2-2.el6.x86_64.rpm

Drbd-heartbeat-8.4.2-2.el6.x86_64.rpm

Drbd-bash-completion-8.4.2-2.el6.x86_64.rpm

Drbd-km-2.6.32_431.el6.x86_64-8.4.2-2.el6.x86_64.rpm

Install as a tar package as follows:

Rpm-ivh drbd-*

Yum install gcc flex rpm-build kernel-devel-y

Cp / root/drbd-8.4.0.tar.gz / root/rpmbuild/SOURCES/

Tar zxf drbd-8.4.0.tar.gz

Cd drbd-8.4.0

. / configure-- enable-spec

. / configure-enable-spec-with-km

Get two files in the current directory

Drbd.spec drbd-km.spec

Rpmbuild-bb drbd.spec

Rpmbuild-bb drbd-km.spec

Cd / root/rpmbuild/RPMS/x86_64

Rpm-ivh *

Scp / root/rpmbuild/RPMS/x86_64/* 172.25.38.5:/root

And execute rpm-ivh drbd-*

Vim / etc/drbd.d/example.res

1 resource example {

2 meta-disk internal

3 device / dev/drbd1

4 syncer {

5 verify-alg sha1

6}

7 on server5.example.com {

8 disk / dev/vdb

9 address 172.25.38.5:7789

10}

11 on server2.example.com {

12 disk / dev/vdb

13 address 172.25.38.2:7789

14}

15}

Drbdadm create-md example

/ etc/init.d/drbd start

Drbdadm primary example

Cat / proc/drbd# view synchronization status on two hosts

Create a file system after mkfs.ext4 / dev/drbd1# data synchronization finishes

Mount / dev/drbd1 / var/www/html# mount file system

-

4) install jdk

Get

Jdk-6u32-linux-x64.bin

Sh jdk-6u32-linux-x64.bin

Mv jdk-6u32-linux-x64 java

Mv java / usr/local

Vim / etc/profile

Export JAVA_HOME=/usr/local/java

Export CLASSPATH=.:$JAVA_HOME/bin:$JAVA_HOME/jre/lib

Export PATH=$PATH:$JAVA_HOME/bin

Source / etc/profile

Cd / home/

Test:

Vim test.java

Class test {

Public static void main (String [] args)

{

System.out.println ("Hello world!")

}

}

Java test

-

5) install cobar

Cobar-server-1.2.6.zip

Unzip cobar-server-1.2.6.zip

Cd / root/cobar-server-1.2.6/conf

Vim schema.xml

172.25.38.5:3306/dbtest

172.25.38.5:3306/dbtest

Root

Westos

STRICT_TRANS_TABLES

Vim server.xml

Westos

Dbtest

Id

two

five hundred and twelve

Cd / root/cobar-server-1.2.6/bin

[root@server2 bin] #. / startup.sh

"/ usr/local/java/bin/java"-Dcobar.home= "/ root/cobar-server-1.2.6"-classpath "/ root/cobar-server-1.2.6/conf:/root/cobar-server-1.2.6/lib/classes:/root/cobar-server-1.2.6/lib/cobar-common-1.2.6.jar:/root/cobar-server-1.2.6/lib/cobar-config-1.2.6.jar : / root/cobar-server-1.2.6/lib/cobar-net-1.2.6.jar:/root/cobar-server-1.2.6/lib/cobar-parser-1.2.6.jar:/root/cobar-server-1.2.6/lib/cobar-route-1.2.6.jar:/root/cobar-server-1.2.6/lib/cobar-server-1.2.6.jar:/root/cobar-server-1.2. 6/lib/log4j-1.2.16.jar:/root/cobar-server-1.2.6/lib/slf4j-api-1.6.4.jar:/root/cobar-server-1.2.6/lib/slf4j-log4j12-1.6.4.jar "- server- Xms1024m-Xmx1024m-Xmn256m-Xss128k-XX:+AggressiveOpts-XX:+UseBiasedLocking-XX:+UseFastAccessorMethods-XX:+DisableExplicitGC-XX:+UseParNewGC-XX:+UseConcMarkSweepGC-XX:+CMSParallelRemarkEnabled-XX:+UseCMSCompactAtFullCollection-XX:+UseCMSInitiatingOccupancyOnly-XX:CMSInitiatingOccupancyFraction=75 com .alibaba.cobar.CobarStartup > > "/ root/cobar-server-1.2.6/logs/console.log" 2 > & 1 &

[root@server2 bin] # / etc/init.d/drbd start

Starting DRBD resources: [

]

.

[root@server2 bin] # ip addr show

1: lo: mtu 16436 qdisc noqueue state UNKNOWN

Link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

Inet 127.0.0.1/8 scope host lo

Inet6:: 1/128 scope host

Valid_lft forever preferred_lft forever

2: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000

Link/ether 52:54:00:f6:11:cd brd ff:ff:ff:ff:ff:ff

Inet 172.25.38.2/24 brd 172.25.38.255 scope global eth0

Inet 172.25.38.100/24 brd 172.25.38.255 scope global secondary eth0

Inet6 fe80::5054:ff:fef6:11cd/64 scope link

Valid_lft forever preferred_lft forever

[root@server2 bin] # df

Filesystem 1K-blocks Used Available Use% Mounted on

/ dev/mapper/VolGroup-lv_root 15006084 1723528 12520292 13% /

Tmpfs 203008 0 203008 / dev/shm

/ dev/vda1 495844 33452 436792 8% / boot

/ dev/drbd1 4128284 95208 3823372 3% / var/lib/mysql

[root@server2 bin] #. / shutdown.sh

[root@server5 conf] # df

Filesystem 1K-blocks Used Available Use% Mounted on

/ dev/mapper/VolGroup-lv_root 17069948 1602508 14600320 10%

Tmpfs 251136 0 251136 / dev/shm

/ dev/vda1 495844 33467 436777 8% / boot

/ dev/drbd1 4128284 95232 3823348 3% / var/lib/mysql

[root@server5 conf] # ip addr show

1: lo: mtu 16436 qdisc noqueue state UNKNOWN

Link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

Inet 127.0.0.1/8 scope host lo

Inet6:: 1/128 scope host

Valid_lft forever preferred_lft forever

2: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000

Link/ether 52:54:00:6e:00:88 brd ff:ff:ff:ff:ff:ff

Inet 172.25.38.5/24 brd 172.25.38.255 scope global eth0

Inet 172.25.38.100/24 brd 172.25.38.255 scope global secondary eth0

Inet6 fe80::5054:ff:fe6e:88/64 scope link

Valid_lft forever preferred_lft forever

-

Tags: Configuration file data status routing synchronization host password database best system node two master-slave dependency function two-way size field beginning Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno OPPO Reno MySQL Docker Shulou Tech Info NVidia