No.

Checklist itemCommandExpected result

Recommendations
for achieving the
expected result

Testing the started services

1

Checking the status of MySQL database service

ON EACH HOST

sudo systemctl list-units --all |\ 
grep mysql | awk '{print $1, $3"("$4")"}' |\
 jq -R 'split(" ")|{service:.[0], status:.[1]}'


{
  "service": "mysql.service",
  "status": "active(running)"
}

Make sure all services from the list are active (running)

Start the service which status is:

inactive (dead), or different from active (running)

No.

Checklist itemCommandExpected result

Recommendations
for achieving the
expected result

Testing the started services

1

Checking the status of MySQL database serviceON EACH HOST

sudo systemctl list-units --all |\ 
grep mysql | awk '{print $1, $3"("$4")"}' |\
 jq -R 'split(" ")|{service:.[0], status:.[1]}'


{
  "service": "mysql.service",
  "status": "active(running)"
}

Make sure all services from the list are active (running)

Start the service which status is:

inactive (dead), or different from active (running)

2

Checking MySQL replication statusON EACH HOST

sudo mysql -uroot -p -e 'show slave status \G' | grep -E "Running|Second" | 
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
        Seconds_Behind_Master: 0
      Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates

Make sure that the first two fields are set to "Yes" and that "Seconds_Behind_Master" is set to 0.

Slave_SQL_Running_State must not show any errors.







ECSS-10 versionRelevance

3.11

+

3.14.{9-14}

+
3.14.15.x+
3.14.16.x+

3.17.x

-
3.18-

No.

Checklist itemCommandExpected result

Recommendations
for achieving the
expected result

Testing the started services

1

Checking the status of the Postgres containerON EACH HOST

sudo docker ps --format="{{.Names}} : {{.Status}}" | grep postgres


ecss-postgres-bdr-ssw-postgres-container-1 : Up 3 months
Make sure this container is in the Up state.


No.

Checklist itemCommandExpected result

Recommendations
for achieving the
expected result

Testing the started services

1

Checking the status of the Postgres containerON EACH HOST

sudo docker ps --format="{{.Names}} : {{.Status}}" | grep postgres


ecss-postgres-bdr-ssw-postgres-container-1 : Up 3 months

Make sure this container is in the Up state.


2

Checking the status of the Postgres replicationON ECSS1

sudo /srv/ecss/ecss-postgres-bdr-ssw/postgresbdr_ssw.sh check


Enter master ip please
Like 10.150.150.15
<IP_ecss1>
Enter slave ip please
<IP_ecss2>
Press enter with empty password
q - stop viewing the table (if necessary)
node table on master according to ecss_storekeeper_db
node table on slave according to ecss_storekeeper_db
connections table on master according to ecss_storekeeper_db
     conn_sysid      |                                       conn_dsn
---------------------+---------------------------------------------------------------------------------------
 7569499877813944343 | host=<IP_ecss1> port=5439 dbname=ecss_storekeeper_db user=postgres password=postgres1
 7569514001040228374 | host=<IP_ecss2> port=5439 dbname=ecss_storekeeper_db user=postgres password=postgres1
(2 rows)

connections table on slave according to ecss_storekeeper_db
     conn_sysid      |                                       conn_dsn
---------------------+---------------------------------------------------------------------------------------
 7569499877813944343 | host=<IP_ecss1> port=5439 dbname=ecss_storekeeper_db user=postgres password=postgres1
 7569514001040228374 | host=<IP_ecss2> port=5439 dbname=ecss_storekeeper_db user=postgres password=postgres1
(2 rows)


ECSS-10 versionRelevance

3.11

-

3.14.{9-14}

-
3.14.15.x-
3.14.16.x-

3.17.x

+

3.18+


  • Нет меток