Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what are the GBase8s cm configuration methods?". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. CM1 alone. Create the sqlhosts.cm1 file in the $GBASEDBTDIR/etc directory as follows:

G_west group-iTunes 10

Ol_54_pri onsoctcp 192.168.152.25 23701 g=g_west

Ol_54_sds onsoctcp 192.168.152.26 23702 g=g_west

Cm_update group-- iTunes 12 cantilever 0

Oltp onsoctcp 192.168.152.25 25000 g=cm_update

two。 Create the onconfig.cm1 file in the $GBASEDBTDIR/etc directory as follows:

NAME cm1

LOGFILE ${GBASEDBTDIR} / tmp/cm1.log

CM_TIMEOUT 40

SECONDARY_EVENT_TIMEOUT 20

EVENT_TIMEOUT 30

SQLHOSTS LOCAL

LOG 1

DEBUG 1

CLUSTER main

{

GBASEDBTSERVER g_west

SLA oltp DBSERVERS=PRI+SDS WORKERS=16

FOC ORDER=ENABLED TIMEOUT=10 RETRY=1 PRIORITY=1

}

3. Start and stop CM

Start cm

Export GBASEDBTSQLHOSTS=$GBASEDBTDIR/etc/sqlhosts.cm1

Oncmsm-c $GBASEDBTDIR/etc/config.cm1

Close CM

Oncmsm-k cm1

Second, CM cluster 1. Configure the CM cluster:

Create sqlhosts.cm1: content on the primary node

G_west group-iTunes 10

Ol_54_pri onsoctcp 192.168.152.25 23701 g=g_west

Ol_54_sds onsoctcp 192.168.152.26 23702 g=g_west

Cm_update group-- iTunes 12 cantilever 0

Oltp_all1 onsoctcp 192.168.152.25 23000 g=cm_update

Oltp_all2 onsoctcp 192.168.152.26 23000 g=cm_update

Cm_read group-- iFourteen cymbals

Oltp_read1 onsoctcp 192.168.152.25 23001 g=cm_read

Oltp_read2 onsoctcp 192.168.152.26 23001 g=cm_read

two。 Create an etc/onconfig.cm1 file as follows:

NAME cm1

LOGFILE ${GBASEDBTDIR} / tmp/cm1.log

CM_TIMEOUT 40

SECONDARY_EVENT_TIMEOUT 20

EVENT_TIMEOUT 30

SQLHOSTS LOCAL

LOG 1

DEBUG 1

CLUSTER main

{

GBASEDBTSERVER g_west

SLA oltp_all1 DBSERVERS=PRI WORKERS=16

SLA oltp_read1 DBSERVERS=SDS WORKERS=16

FOC ORDER=ENABLED TIMEOUT=10 RETRY=1 PRIORITY=1

}

3. Change the permissions of the two sqlhosts.cm1,onconfig.cm1 files:

Chown GBASEDBT:GBASEDBT sqlhosts.cm1 onconfig.cm1

Chmod 660 sqlhosts.cm1 onconfig.cm1

4. Execute on the command line

Export GBASEDBTDIR=/home/54_For_SSC/

Export GBASEDBTSQLHOSTS=/home/54_For_SSC/etc/sqlhosts.cm1

5. Configure CM on the SDS node and create an etc/sqlhosts.cm2, as follows:

G_west group-iTunes 10

Ol_54_pri onsoctcp 192.168.152.25 23701 g=g_west

Ol_54_sds onsoctcp 192.168.152.26 23702 g=g_west

Cm_update group-- iTunes 12 cantilever 0

Oltp_all1 onsoctcp 192.168.152.25 23000 g=cm_update

Oltp_all2 onsoctcp 192.168.152.26 23000 g=cm_update

Cm_read group-- iFourteen cymbals

Oltp_read1 onsoctcp 192.168.152.25 23001 g=cm_read

Oltp_read2 onsoctcp 192.168.152.26 23001 g=cm_read

6. Create an etc/config.cm2 file as follows:

NAME cm2

LOGFILE ${GBASEDBTDIR} / tmp/cm2.log

CM_TIMEOUT 40

SECONDARY_EVENT_TIMEOUT 20

EVENT_TIMEOUT 30

SQLHOSTS LOCAL

LOG 1

DEBUG 1

CLUSTER main

{

GBASEDBTSERVER g_west

SLA oltp_all2 DBSERVERS=PRI WORKERS=16

SLA oltp_read2 DBSERVERS=SDS WORKERS=16

FOC ORDER=ENABLED TIMEOUT=10 RETRY=1 PRIORITY=2}

7. Change the permissions of the two sqlhosts.cm2,config.cm2 files:

Chown GBASEDBT:GBASEDBT sqlhosts.cm2 onconfig.cm2

Chmod 660 sqlhosts.cm2 onconfig.cm2

8. Execute the following statement on the SDS node

Export GBASEDBTDIR=/home/54_For_SDS/

Export GBASEDBTSQLHOSTS=/home/54_For_SDS/etc/sqlhosts.cm1

9. Start the cm1 manager on the PRI node:

Oncmsm-c / home/54_For_SSC/etc/config.cm1

Start the cm2 manager on the SDS node:

Oncmsm-c / home/54_For_SSC/etc/config.cm2

10. The cm status can be viewed at any node in the cluster.

Onstat-g cmsm

This is the end of the content of "what are the ways to configure GBase8s cm". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.