[Приложение 1] Проверка статуса базы данных ECSS-10

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)"
}

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)"
}

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

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

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

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

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

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
Просто щелкайте Enter не вводя пароль
q - выход из просмотра таблицы (если необходимо)
таблица нод на мастере по ecss_storekeeper_db
таблица нод на слейве по ecss_storekeeper_db
таблица коннекций на мастер по 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_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)