История страницы

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)

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)

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

Убедиться что первые 2 поля имеют значения Yes, 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.

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

Make sure this container is in the Up state.

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 - выход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)