[MDEV-16062] Galera Node is rejoined with SST after backup - restore with mariabackup Created: 2018-04-30  Updated: 2023-06-06  Resolved: 2023-06-06

Status: Closed
Project: MariaDB Server
Component/s: Backup, Galera
Affects Version/s: 10.3.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Ramesh Sivaraman
Resolution: Won't Fix Votes: 0
Labels: need_verification
Environment:

CentOS 7.4 , Galera 3 Nodes

Issue Links:
Relates
relates to MDEV-15067 Node fails to rejoin mdb cluster afte... Closed

 Description   

Galera Node is rejoined with SST after backup - restore with mariabackup

Galera Node should be rejoined with IST after backup - restore with mariabackup
but it appears that the galera grastate.dat file is not in mariabackup and Node is joined
with SST.
That may cause huge data transfer between Nodes and may increase the delay in the cluster.
If save galera grastate.dat and copy it manually to the restored data-dir, Node is joined
faster with IST.

desync Node from the cluster and perform mariabackup with options
--galera-info and --no-lock options
in both cases of restoring data:
A. Restore data (prepare and apply) on the local Node
B. Restore data (prepare and apply) on another Node
the Recovered Node is joined with SST

set wsrep_desync and FTWRL on the Node.
get mariabackup with options --galera-info and --no-lock options
unlock tables , disable wsrep_desync .
Use the backuped data to be restored either on the same Node or on some other Node

Below mariabackup restored on the same Node

# service mysql stop
 
[root@t4w5 ~]# rm -rf /var/lib/mysql/*
 
[root@t4w5 ~]#
 
[root@t4w5 ~]# mariabackup -u root -p1 --copy-back --galera-info --target-dir /var/mariadb/backup/B1
 
mariabackup based on MariaDB server 10.3.6-MariaDB Linux (x86_64)
 
180430 18:25:01 [01] Copying ibdata1 to /var/lib/mysql/ibdata1
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./fi/people.ibd to /var/lib/mysql/fi/people.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./fi/db.opt to /var/lib/mysql/fi/db.opt
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./fi/people.frm to /var/lib/mysql/fi/people.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysqlslap/ff1.ibd to /var/lib/mysql/mysqlslap/ff1.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysqlslap/db.opt to /var/lib/mysql/mysqlslap/db.opt
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysqlslap/ff1.frm to /var/lib/mysql/mysqlslap/ff1.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/nation.ibd to /var/lib/mysql/tpch/nation.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/region.ibd to /var/lib/mysql/tpch/region.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/part.ibd to /var/lib/mysql/tpch/part.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/supplier.ibd to /var/lib/mysql/tpch/supplier.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/partsupp.ibd to /var/lib/mysql/tpch/partsupp.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/customer.ibd to /var/lib/mysql/tpch/customer.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/orders.ibd to /var/lib/mysql/tpch/orders.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/lineitem.ibd to /var/lib/mysql/tpch/lineitem.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/db.opt to /var/lib/mysql/tpch/db.opt
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/nation.frm to /var/lib/mysql/tpch/nation.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/region.frm to /var/lib/mysql/tpch/region.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/part.frm to /var/lib/mysql/tpch/part.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/supplier.frm to /var/lib/mysql/tpch/supplier.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/partsupp.frm to /var/lib/mysql/tpch/partsupp.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/customer.frm to /var/lib/mysql/tpch/customer.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/orders.frm to /var/lib/mysql/tpch/orders.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./tpch/lineitem.frm to /var/lib/mysql/tpch/lineitem.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/lib/mysql/mysql/gtid_slave_pos.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/transaction_registry.ibd to /var/lib/mysql/mysql/transaction_registry.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/roles_mapping.frm to /var/lib/mysql/mysql/roles_mapping.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/roles_mapping.MYI to /var/lib/mysql/mysql/roles_mapping.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/roles_mapping.MYD to /var/lib/mysql/mysql/roles_mapping.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/servers.MYI to /var/lib/mysql/mysql/servers.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/servers.MYD to /var/lib/mysql/mysql/servers.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_topic.MYI to /var/lib/mysql/mysql/help_topic.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_topic.MYD to /var/lib/mysql/mysql/help_topic.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_category.MYI to /var/lib/mysql/mysql/help_category.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_category.MYD to /var/lib/mysql/mysql/help_category.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_relation.MYI to /var/lib/mysql/mysql/help_relation.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_relation.MYD to /var/lib/mysql/mysql/help_relation.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_keyword.MYI to /var/lib/mysql/mysql/help_keyword.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/help_keyword.MYD to /var/lib/mysql/mysql/help_keyword.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_name.MYI to /var/lib/mysql/mysql/time_zone_name.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_name.MYD to /var/lib/mysql/mysql/time_zone_name.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone.MYI to /var/lib/mysql/mysql/time_zone.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone.MYD to /var/lib/mysql/mysql/time_zone.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_transition.MYI to /var/lib/mysql/mysql/time_zone_transition.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_transition.MYD to /var/lib/mysql/mysql/time_zone_transition.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/lib/mysql/mysql/time_zone_transition_type.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/lib/mysql/mysql/time_zone_transition_type.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/lib/mysql/mysql/time_zone_leap_second.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/lib/mysql/mysql/time_zone_leap_second.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/table_stats.frm to /var/lib/mysql/mysql/table_stats.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/table_stats.MYI to /var/lib/mysql/mysql/table_stats.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/table_stats.MYD to /var/lib/mysql/mysql/table_stats.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/column_stats.frm to /var/lib/mysql/mysql/column_stats.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/column_stats.MYI to /var/lib/mysql/mysql/column_stats.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/column_stats.MYD to /var/lib/mysql/mysql/column_stats.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/index_stats.frm to /var/lib/mysql/mysql/index_stats.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/index_stats.MYI to /var/lib/mysql/mysql/index_stats.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/index_stats.MYD to /var/lib/mysql/mysql/index_stats.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/gtid_slave_pos.frm to /var/lib/mysql/mysql/gtid_slave_pos.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/transaction_registry.frm to /var/lib/mysql/mysql/transaction_registry.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/plugin.MYI to /var/lib/mysql/mysql/plugin.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/host.frm to /var/lib/mysql/mysql/host.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/plugin.MYD to /var/lib/mysql/mysql/plugin.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/host.MYD to /var/lib/mysql/mysql/host.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/host.MYI to /var/lib/mysql/mysql/host.MYI
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./boxoffice_mdb/dim_date.ibd to /var/lib/mysql/boxoffice_mdb/dim_date.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./boxoffice_mdb/dim_person.ibd to /var/lib/mysql/boxoffice_mdb/dim_person.ibd
 
180430 18:25:02 [01]        ...done
 
180430 18:25:02 [01] Copying ./boxoffice_mdb/dim_showtime.ibd to /var/lib/mysql/boxoffice_mdb/dim_showtime.ibd
 
180430 18:25:03 [01]        ...done
 
180430 18:25:03 [01] Copying ./boxoffice_mdb/dim_theater.ibd to /var/lib/mysql/boxoffice_mdb/dim_theater.ibd
 
180430 18:25:03 [01]        ...done
 
180430 18:25:03 [01] Copying ./boxoffice_mdb/dim_theater_mdc.ibd to /var/lib/mysql/boxoffice_mdb/dim_theater_mdc.ibd
 
180430 18:25:03 [01]        ...done
 
180430 18:25:03 [01] Copying ./boxoffice_mdb/dim_ticket_type.ibd to /var/lib/mysql/boxoffice_mdb/dim_ticket_type.ibd
 
180430 18:25:03 [01]        ...done
 
180430 18:25:03 [01] Copying ./boxoffice_mdb/dim_title.ibd to /var/lib/mysql/boxoffice_mdb/dim_title.ibd
 
180430 18:25:03 [01]        ...done
 
180430 18:25:03 [01] Copying ./boxoffice_mdb/fact_crew.ibd to /var/lib/mysql/boxoffice_mdb/fact_crew.ibd
 
180430 18:25:04 [01]        ...done
 
180430 18:25:04 [01] Copying ./boxoffice_mdb/fact_tickets.ibd to /var/lib/mysql/boxoffice_mdb/fact_tickets.ibd
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/db.opt to /var/lib/mysql/boxoffice_mdb/db.opt
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_date.frm to /var/lib/mysql/boxoffice_mdb/dim_date.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_person.frm to /var/lib/mysql/boxoffice_mdb/dim_person.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_showtime.frm to /var/lib/mysql/boxoffice_mdb/dim_showtime.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_theater.frm to /var/lib/mysql/boxoffice_mdb/dim_theater.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_theater_mdc.frm to /var/lib/mysql/boxoffice_mdb/dim_theater_mdc.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_ticket_type.frm to /var/lib/mysql/boxoffice_mdb/dim_ticket_type.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_title.frm to /var/lib/mysql/boxoffice_mdb/dim_title.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/fact_crew.frm to /var/lib/mysql/boxoffice_mdb/fact_crew.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./boxoffice_mdb/fact_tickets.frm to /var/lib/mysql/boxoffice_mdb/fact_tickets.frm
 
180430 18:25:08 [01]        ...done
 
180430 18:25:08 [01] Copying ./sbtest/sbtest1.ibd to /var/lib/mysql/sbtest/sbtest1.ibd
 
180430 18:25:09 [01]        ...done
 
180430 18:25:09 [01] Copying ./sbtest/sbtest10.ibd to /var/lib/mysql/sbtest/sbtest10.ibd
 
180430 18:25:10 [01]        ...done
 
180430 18:25:10 [01] Copying ./sbtest/sbtest2.ibd to /var/lib/mysql/sbtest/sbtest2.ibd
 
180430 18:25:10 [01]        ...done
 
180430 18:25:10 [01] Copying ./sbtest/sbtest3.ibd to /var/lib/mysql/sbtest/sbtest3.ibd
 
180430 18:25:11 [01]        ...done
 
180430 18:25:11 [01] Copying ./sbtest/sbtest4.ibd to /var/lib/mysql/sbtest/sbtest4.ibd
 
180430 18:25:12 [01]        ...done
 
180430 18:25:12 [01] Copying ./sbtest/sbtest5.ibd to /var/lib/mysql/sbtest/sbtest5.ibd
 
180430 18:25:13 [01]        ...done
 
180430 18:25:13 [01] Copying ./sbtest/sbtest6.ibd to /var/lib/mysql/sbtest/sbtest6.ibd
 
180430 18:25:13 [01]        ...done
 
180430 18:25:13 [01] Copying ./sbtest/sbtest7.ibd to /var/lib/mysql/sbtest/sbtest7.ibd
 
180430 18:25:15 [01]        ...done
 
180430 18:25:15 [01] Copying ./sbtest/sbtest8.ibd to /var/lib/mysql/sbtest/sbtest8.ibd
 
180430 18:25:16 [01]        ...done
 
180430 18:25:16 [01] Copying ./sbtest/sbtest9.ibd to /var/lib/mysql/sbtest/sbtest9.ibd
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/db.opt to /var/lib/mysql/sbtest/db.opt
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest1.frm to /var/lib/mysql/sbtest/sbtest1.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest10.frm to /var/lib/mysql/sbtest/sbtest10.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest2.frm to /var/lib/mysql/sbtest/sbtest2.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest3.frm to /var/lib/mysql/sbtest/sbtest3.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest4.frm to /var/lib/mysql/sbtest/sbtest4.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest5.frm to /var/lib/mysql/sbtest/sbtest5.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest6.frm to /var/lib/mysql/sbtest/sbtest6.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest7.frm to /var/lib/mysql/sbtest/sbtest7.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest8.frm to /var/lib/mysql/sbtest/sbtest8.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./sbtest/sbtest9.frm to /var/lib/mysql/sbtest/sbtest9.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/cputable.ibd to /var/lib/mysql/resourcestresser/cputable.ibd
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/iotable.ibd to /var/lib/mysql/resourcestresser/iotable.ibd
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/iotablesmallrow.ibd to /var/lib/mysql/resourcestresser/iotablesmallrow.ibd
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/locktable.ibd to /var/lib/mysql/resourcestresser/locktable.ibd
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/db.opt to /var/lib/mysql/resourcestresser/db.opt
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/cputable.frm to /var/lib/mysql/resourcestresser/cputable.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/iotable.frm to /var/lib/mysql/resourcestresser/iotable.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/iotablesmallrow.frm to /var/lib/mysql/resourcestresser/iotablesmallrow.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./resourcestresser/locktable.frm to /var/lib/mysql/resourcestresser/locktable.frm
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./md_15252/BRc273a13dfd.ibd to /var/lib/mysql/md_15252/BRc273a13dfd.ibd
 
180430 18:25:17 [01]        ...done
 
180430 18:25:17 [01] Copying ./md_15252/CA9176ed2945.ibd to /var/lib/mysql/md_15252/CA9176ed2945.ibd
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/CA24ade621e4.ibd to /var/lib/mysql/md_15252/CA24ade621e4.ibd
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/DAc955f09819.ibd to /var/lib/mysql/md_15252/DAc955f09819.ibd
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/DAebf122c2a3.ibd to /var/lib/mysql/md_15252/DAebf122c2a3.ibd
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/OP3605a09ed5.ibd to /var/lib/mysql/md_15252/OP3605a09ed5.ibd
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/PR03645fd534.ibd to /var/lib/mysql/md_15252/PR03645fd534.ibd
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/VA13db63946f.ibd to /var/lib/mysql/md_15252/VA13db63946f.ibd
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/db.opt to /var/lib/mysql/md_15252/db.opt
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/BRc273a13dfd.frm to /var/lib/mysql/md_15252/BRc273a13dfd.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/CA9176ed2945.frm to /var/lib/mysql/md_15252/CA9176ed2945.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/CA24ade621e4.frm to /var/lib/mysql/md_15252/CA24ade621e4.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/DAc955f09819.frm to /var/lib/mysql/md_15252/DAc955f09819.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/DAebf122c2a3.frm to /var/lib/mysql/md_15252/DAebf122c2a3.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/OP3605a09ed5.frm to /var/lib/mysql/md_15252/OP3605a09ed5.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/PR03645fd534.frm to /var/lib/mysql/md_15252/PR03645fd534.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./md_15252/VA13db63946f.frm to /var/lib/mysql/md_15252/VA13db63946f.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./test/db.opt to /var/lib/mysql/test/db.opt
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./tpch1/db.opt to /var/lib/mysql/tpch1/db.opt
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./ffr/db.opt to /var/lib/mysql/ffr/db.opt
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./ffr/f.MYI to /var/lib/mysql/ffr/f.MYI
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./ffr/f.MYD to /var/lib/mysql/ffr/f.MYD
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./ffr/f.frm to /var/lib/mysql/ffr/f.frm
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./aria_log_control to /var/lib/mysql/aria_log_control
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./aria_log.00000001 to /var/lib/mysql/aria_log.00000001
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./xtrabackup_galera_info to /var/lib/mysql/xtrabackup_galera_info
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 [01] Copying ./xtrabackup_binlog_pos_innodb to /var/lib/mysql/xtrabackup_binlog_pos_innodb
 
180430 18:25:21 [01]        ...done
 
180430 18:25:21 completed OK!

  1. service mysql start --wsrep_cluster_address=gcomm://192.168.104.196
    Starting mysql (via systemctl): [ OK ]

018-04-30 18:29:46 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
 
2018-04-30 18:29:46 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
 
2018-04-30 18:29:46 0 [Note] WSREP: wsrep_load(): Galera 25.3.22(r3764) by Codership Oy <info@codership.com> loaded successfully.
 
2018-04-30 18:29:46 0 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm.
 
2018-04-30 18:29:46 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
 
2018-04-30 18:29:46 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
 
2018-04-30 18:29:46 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.104.195; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; p
 
2018-04-30 18:29:46 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1
 
2018-04-30 18:29:46 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
 
2018-04-30 18:29:46 0 [Note] WSREP: wsrep_sst_grab()
 
2018-04-30 18:29:46 0 [Note] WSREP: Start replication
 
2018-04-30 18:29:46 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
 
2018-04-30 18:29:46 0 [Note] WSREP: protonet asio version 0
 
2018-04-30 18:29:46 0 [Note] WSREP: Using CRC-32C for message checksums.
 
2018-04-30 18:29:46 0 [Note] WSREP: backend: asio
 
2018-04-30 18:29:46 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
 
2018-04-30 18:29:46 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
 
2018-04-30 18:29:46 0 [Note] WSREP: restore pc from disk failed
 
2018-04-30 18:29:46 0 [Note] WSREP: GMCast version 0
 
2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
 
2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
 
2018-04-30 18:29:46 0 [Note] WSREP: EVS version 0
 
2018-04-30 18:29:46 0 [Note] WSREP: gcomm: connecting to group 'cluster1', peer '192.168.104.191:,192.168.104.195:,192.168.104.196:'
 
2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') connection established to 5053de41 tcp://192.168.104.195:4567
 
2018-04-30 18:29:46 0 [Warning] WSREP: (5053de41, 'tcp://0.0.0.0:4567') address 'tcp://192.168.104.195:4567' points to own listening address, blacklisting
 
2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') connection established to 6eedf2b3 tcp://192.168.104.196:4567
 
2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.104.191:4444
 
2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') connection established to 675af5b8 tcp://192.168.104.191:4444
 
2018-04-30 18:29:47 0 [Note] WSREP: declaring 675af5b8 at tcp://192.168.104.191:4444 stable
 
2018-04-30 18:29:47 0 [Note] WSREP: declaring 6eedf2b3 at tcp://192.168.104.196:4567 stable
 
2018-04-30 18:29:47 0 [Note] WSREP: Node 675af5b8 state prim
 
2018-04-30 18:29:47 0 [Note] WSREP: view(view_id(PRIM,5053de41,97) memb {
 
        5053de41,0
 
        675af5b8,0
 
        6eedf2b3,0
 
} joined {
 
} left {
 
} partitioned {
 
})
 
2018-04-30 18:29:47 0 [Note] WSREP: save pc into disk
 
2018-04-30 18:29:47 0 [Note] WSREP: discarding pending addr without UUID: tcp://192.168.104.191:4567
 
2018-04-30 18:29:47 0 [Note] WSREP: gcomm: connected
 
2018-04-30 18:29:47 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
 
2018-04-30 18:29:47 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
 
2018-04-30 18:29:47 0 [Note] WSREP: Opened channel 'cluster1'
 
2018-04-30 18:29:47 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
 
2018-04-30 18:29:47 0 [Note] WSREP: Waiting for SST to complete.
 
2018-04-30 18:29:47 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70
 
2018-04-30 18:29:47 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70
 
2018-04-30 18:29:47 0 [Note] WSREP: STATE EXCHANGE: got state msg: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70 from 0 (t4w5)
 
2018-04-30 18:29:47 0 [Note] WSREP: STATE EXCHANGE: got state msg: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70 from 1 (garb)
 
2018-04-30 18:29:47 0 [Note] WSREP: STATE EXCHANGE: got state msg: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70 from 2 (t4w6)
 
2018-04-30 18:29:47 0 [Note] WSREP: Quorum results:
 
        version    = 4,
 
        component  = PRIMARY,
 
        conf_id    = 96,
 
        members    = 2/3 (joined/total),
 
        act_id     = 137764,
 
        last_appl. = -1,
 
        protocols  = 0/7/3 (gcs/repl/appl),
 
        group UUID = b4c974d2-49fe-11e8-b950-9b4c947b49f6
 
2018-04-30 18:29:47 0 [Note] WSREP: Flow-control interval: [28, 28]
 
2018-04-30 18:29:47 0 [Note] WSREP: Trying to continue unpaused monitor
 
2018-04-30 18:29:47 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 137764)
 
2018-04-30 18:29:47 2 [Note] WSREP: State transfer required:
 
        Group state: b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764
 
        Local state: 00000000-0000-0000-0000-000000000000:-1
 
2018-04-30 18:29:47 2 [Note] WSREP: New cluster view: global state: b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764, view# 97: Primary, number of nodes: 3, my index: 0, protocol version 3
 
2018-04-30 18:29:47 2 [Warning] WSREP: Gap in state sequence. Need state transfer.
 
2018-04-30 18:29:47 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '192.168.104.195' --datadir '/var/lib/mysql/'   --parent '436'  '' '
 
WSREP_SST: [INFO] Streaming with xbstream (20180430 18:29:48.014)
 
WSREP_SST: [INFO] Using socat as streamer (20180430 18:29:48.017)
 
WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | pv -f  -i 10 -N joiner -F '%N => Rate:%r Avg:%a Elapsed:%t %e Bytes: %b %p'  | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20180430 18:29:48.074)
 
2018-04-30 18:29:48 2 [Note] WSREP: Prepared SST request: mariabackup|192.168.104.195:4444/xtrabackup_sst//1
 
2018-04-30 18:29:48 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
 
2018-04-30 18:29:48 2 [Note] WSREP: REPL Protocols: 7 (3, 2)
 
2018-04-30 18:29:48 2 [Note] WSREP: Assign initial position for certification: 137764, protocol version: 3
 
2018-04-30 18:29:48 0 [Note] WSREP: Service thread queue flushed.
 
2018-04-30 18:29:48 2 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (b4c974d2-49fe-11e8-b950-9b4c947b49f6): 1 (Operation not permitted)
 
         at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.
 
2018-04-30 18:29:48 0 [Note] WSREP: Member 0.0 (t4w5) requested state transfer from '*any*'. Selected 2.0 (t4w6)(SYNCED) as donor.
 
2018-04-30 18:29:48 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 137764)
 
2018-04-30 18:29:48 2 [Note] WSREP: Requesting state transfer: success, donor: 2
 
2018-04-30 18:29:48 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764
 
   joiner: => Rate:[ 215 B/s] Avg:[ 215 B/s] Elapsed:0:00:00
 
WSREP_SST: [INFO] NOTE: Joiner-Recv-gtid took 0 seconds (20180430 18:29:48.725)
 
WSREP_SST: [INFO] Proceeding with SST (20180430 18:29:48.742)
 
WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | pv -f  -i 10 -N joiner -F '%N => Rate:%r Avg:%a Elapsed:%t %e Bytes: %b %p'  | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20180430 18:29:48.745)
 
WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20180430 18:29:48.747)
 
removed ‘/var/lib/mysql/ibdata1’
 
removed ‘/var/lib/mysql/fi/people.ibd’
 
removed ‘/var/lib/mysql/fi/db.opt’
 
removed ‘/var/lib/mysql/fi/people.frm’
 
removed directory: ‘/var/lib/mysql/fi’
 
removed ‘/var/lib/mysql/mysqlslap/ff1.ibd’
 
removed ‘/var/lib/mysql/mysqlslap/db.opt’
 
removed ‘/var/lib/mysql/mysqlslap/ff1.frm’
 
removed directory: ‘/var/lib/mysql/mysqlslap’
 
removed ‘/var/lib/mysql/tpch/nation.ibd’
 
removed ‘/var/lib/mysql/tpch/region.ibd’
 
removed ‘/var/lib/mysql/tpch/part.ibd’
 
removed ‘/var/lib/mysql/tpch/supplier.ibd’
 
removed ‘/var/lib/mysql/tpch/partsupp.ibd’
 
removed ‘/var/lib/mysql/tpch/customer.ibd’
 
removed ‘/var/lib/mysql/tpch/orders.ibd’
 
removed ‘/var/lib/mysql/tpch/lineitem.ibd’
 
removed ‘/var/lib/mysql/tpch/db.opt’
 
removed ‘/var/lib/mysql/tpch/nation.frm’
 
removed ‘/var/lib/mysql/tpch/region.frm’
 
removed ‘/var/lib/mysql/tpch/part.frm’
 
removed ‘/var/lib/mysql/tpch/supplier.frm’
 
removed ‘/var/lib/mysql/tpch/partsupp.frm’
 
removed ‘/var/lib/mysql/tpch/customer.frm’
 
removed ‘/var/lib/mysql/tpch/orders.frm’
 
removed ‘/var/lib/mysql/tpch/lineitem.frm’
 
removed directory: ‘/var/lib/mysql/tpch’
 
removed ‘/var/lib/mysql/mysql/innodb_table_stats.ibd’
 
removed ‘/var/lib/mysql/mysql/innodb_index_stats.ibd’
 
removed ‘/var/lib/mysql/mysql/gtid_slave_pos.ibd’
 
removed ‘/var/lib/mysql/mysql/transaction_registry.ibd’
 
removed ‘/var/lib/mysql/mysql/func.MYD’
 
removed ‘/var/lib/mysql/mysql/procs_priv.MYD’
 
removed ‘/var/lib/mysql/mysql/db.MYI’
 
removed ‘/var/lib/mysql/mysql/roles_mapping.frm’
 
removed ‘/var/lib/mysql/mysql/roles_mapping.MYI’
 
removed ‘/var/lib/mysql/mysql/roles_mapping.MYD’
 
removed ‘/var/lib/mysql/mysql/tables_priv.MYD’
 
removed ‘/var/lib/mysql/mysql/servers.frm’
 
removed ‘/var/lib/mysql/mysql/servers.MYI’
 
removed ‘/var/lib/mysql/mysql/servers.MYD’
 
removed ‘/var/lib/mysql/mysql/tables_priv.MYI’
 
removed ‘/var/lib/mysql/mysql/procs_priv.MYI’
 
removed ‘/var/lib/mysql/mysql/procs_priv.frm’
 
removed ‘/var/lib/mysql/mysql/help_topic.frm’
 
removed ‘/var/lib/mysql/mysql/help_topic.MYI’
 
removed ‘/var/lib/mysql/mysql/help_topic.MYD’
 
removed ‘/var/lib/mysql/mysql/help_category.frm’
 
removed ‘/var/lib/mysql/mysql/help_category.MYI’
 
removed ‘/var/lib/mysql/mysql/help_category.MYD’
 
removed ‘/var/lib/mysql/mysql/help_relation.frm’
 
removed ‘/var/lib/mysql/mysql/help_relation.MYI’
 
removed ‘/var/lib/mysql/mysql/help_relation.MYD’
 
removed ‘/var/lib/mysql/mysql/help_keyword.frm’
 
removed ‘/var/lib/mysql/mysql/help_keyword.MYI’
 
removed ‘/var/lib/mysql/mysql/help_keyword.MYD’
 
removed ‘/var/lib/mysql/mysql/time_zone_name.frm’
 
removed ‘/var/lib/mysql/mysql/time_zone_name.MYI’
 
removed ‘/var/lib/mysql/mysql/time_zone_name.MYD’
 
removed ‘/var/lib/mysql/mysql/time_zone.frm’
 
removed ‘/var/lib/mysql/mysql/time_zone.MYI’
 
removed ‘/var/lib/mysql/mysql/time_zone.MYD’
 
removed ‘/var/lib/mysql/mysql/time_zone_transition.frm’
 
removed ‘/var/lib/mysql/mysql/time_zone_transition.MYI’
 
removed ‘/var/lib/mysql/mysql/time_zone_transition.MYD’
 
removed ‘/var/lib/mysql/mysql/time_zone_transition_type.frm’
 
removed ‘/var/lib/mysql/mysql/time_zone_transition_type.MYI’
 
removed ‘/var/lib/mysql/mysql/time_zone_transition_type.MYD’
 
removed ‘/var/lib/mysql/mysql/time_zone_leap_second.frm’
 
removed ‘/var/lib/mysql/mysql/time_zone_leap_second.MYI’
 
removed ‘/var/lib/mysql/mysql/time_zone_leap_second.MYD’
 
removed ‘/var/lib/mysql/mysql/proc.frm’
 
removed ‘/var/lib/mysql/mysql/general_log.frm’
 
removed ‘/var/lib/mysql/mysql/general_log.CSM’
 
removed ‘/var/lib/mysql/mysql/general_log.CSV’
 
removed ‘/var/lib/mysql/mysql/slow_log.frm’
 
removed ‘/var/lib/mysql/mysql/slow_log.CSM’
 
removed ‘/var/lib/mysql/mysql/slow_log.CSV’
 
removed ‘/var/lib/mysql/mysql/innodb_table_stats.frm’
 
removed ‘/var/lib/mysql/mysql/innodb_index_stats.frm’
 
removed ‘/var/lib/mysql/mysql/proxies_priv.frm’
 
removed ‘/var/lib/mysql/mysql/proxies_priv.MYI’
 
removed ‘/var/lib/mysql/mysql/proxies_priv.MYD’
 
removed ‘/var/lib/mysql/mysql/table_stats.frm’
 
removed ‘/var/lib/mysql/mysql/table_stats.MYI’
 
removed ‘/var/lib/mysql/mysql/table_stats.MYD’
 
removed ‘/var/lib/mysql/mysql/column_stats.frm’
 
removed ‘/var/lib/mysql/mysql/column_stats.MYI’
 
removed ‘/var/lib/mysql/mysql/column_stats.MYD’
 
removed ‘/var/lib/mysql/mysql/index_stats.frm’
 
removed ‘/var/lib/mysql/mysql/index_stats.MYI’
 
removed ‘/var/lib/mysql/mysql/index_stats.MYD’
 
removed ‘/var/lib/mysql/mysql/gtid_slave_pos.frm’
 
removed ‘/var/lib/mysql/mysql/transaction_registry.frm’
 
removed ‘/var/lib/mysql/mysql/func.MYI’
 
removed ‘/var/lib/mysql/mysql/proc.MYI’
 
removed ‘/var/lib/mysql/mysql/db.MYD’
 
removed ‘/var/lib/mysql/mysql/plugin.MYI’
 
removed ‘/var/lib/mysql/mysql/host.frm’
 
removed ‘/var/lib/mysql/mysql/columns_priv.MYI’
 
removed ‘/var/lib/mysql/mysql/event.MYD’
 
removed ‘/var/lib/mysql/mysql/plugin.MYD’
 
removed ‘/var/lib/mysql/mysql/columns_priv.MYD’
 
removed ‘/var/lib/mysql/mysql/event.MYI’
 
removed ‘/var/lib/mysql/mysql/event.frm’
 
removed ‘/var/lib/mysql/mysql/user.MYD’
 
removed ‘/var/lib/mysql/mysql/columns_priv.frm’
 
removed ‘/var/lib/mysql/mysql/host.MYD’
 
removed ‘/var/lib/mysql/mysql/tables_priv.frm’
 
removed ‘/var/lib/mysql/mysql/db.frm’
 
removed ‘/var/lib/mysql/mysql/user.MYI’
 
removed ‘/var/lib/mysql/mysql/user.frm’
 
removed ‘/var/lib/mysql/mysql/func.frm’
 
removed ‘/var/lib/mysql/mysql/plugin.frm’
 
removed ‘/var/lib/mysql/mysql/host.MYI’
 
removed ‘/var/lib/mysql/mysql/proc.MYD’
 
removed directory: ‘/var/lib/mysql/mysql’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_date.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_person.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_showtime.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_theater.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_theater_mdc.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_ticket_type.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_title.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/fact_crew.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/fact_tickets.ibd’
 
removed ‘/var/lib/mysql/boxoffice_mdb/db.opt’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_date.frm’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_person.frm’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_showtime.frm’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_theater.frm’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_theater_mdc.frm’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_ticket_type.frm’
 
removed ‘/var/lib/mysql/boxoffice_mdb/dim_title.frm’
 
removed ‘/var/lib/mysql/boxoffice_mdb/fact_crew.frm’
 
removed ‘/var/lib/mysql/boxoffice_mdb/fact_tickets.frm’
 
removed directory: ‘/var/lib/mysql/boxoffice_mdb’
 
removed ‘/var/lib/mysql/sbtest/sbtest1.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest10.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest2.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest3.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest4.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest5.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest6.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest7.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest8.ibd’
 
removed ‘/var/lib/mysql/sbtest/sbtest9.ibd’
 
removed ‘/var/lib/mysql/sbtest/db.opt’
 
removed ‘/var/lib/mysql/sbtest/sbtest1.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest10.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest2.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest3.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest4.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest5.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest6.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest7.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest8.frm’
 
removed ‘/var/lib/mysql/sbtest/sbtest9.frm’
 
removed directory: ‘/var/lib/mysql/sbtest’
 
removed ‘/var/lib/mysql/resourcestresser/cputable.ibd’
 
removed ‘/var/lib/mysql/resourcestresser/iotable.ibd’
 
removed ‘/var/lib/mysql/resourcestresser/iotablesmallrow.ibd’
 
removed ‘/var/lib/mysql/resourcestresser/locktable.ibd’
 
removed ‘/var/lib/mysql/resourcestresser/db.opt’
 
removed ‘/var/lib/mysql/resourcestresser/cputable.frm’
 
removed ‘/var/lib/mysql/resourcestresser/iotable.frm’
 
removed ‘/var/lib/mysql/resourcestresser/iotablesmallrow.frm’
 
removed ‘/var/lib/mysql/resourcestresser/locktable.frm’
 
removed directory: ‘/var/lib/mysql/resourcestresser’
 
removed ‘/var/lib/mysql/md_15252/BRc273a13dfd.ibd’
 
removed ‘/var/lib/mysql/md_15252/CA9176ed2945.ibd’
 
removed ‘/var/lib/mysql/md_15252/CA24ade621e4.ibd’
 
removed ‘/var/lib/mysql/md_15252/DAc955f09819.ibd’
 
removed ‘/var/lib/mysql/md_15252/DAebf122c2a3.ibd’
 
removed ‘/var/lib/mysql/md_15252/OP3605a09ed5.ibd’
 
removed ‘/var/lib/mysql/md_15252/PR03645fd534.ibd’
 
removed ‘/var/lib/mysql/md_15252/VA13db63946f.ibd’
 
removed ‘/var/lib/mysql/md_15252/db.opt’
 
removed ‘/var/lib/mysql/md_15252/BRc273a13dfd.frm’
 
removed ‘/var/lib/mysql/md_15252/CA9176ed2945.frm’
 
removed ‘/var/lib/mysql/md_15252/CA24ade621e4.frm’
 
removed ‘/var/lib/mysql/md_15252/DAc955f09819.frm’
 
removed ‘/var/lib/mysql/md_15252/DAebf122c2a3.frm’
 
removed ‘/var/lib/mysql/md_15252/OP3605a09ed5.frm’
 
removed ‘/var/lib/mysql/md_15252/PR03645fd534.frm’
 
removed ‘/var/lib/mysql/md_15252/VA13db63946f.frm’
 
removed directory: ‘/var/lib/mysql/md_15252’
 
removed ‘/var/lib/mysql/test/db.opt’
 
removed directory: ‘/var/lib/mysql/test’
 
removed ‘/var/lib/mysql/tpch1/db.opt’
 
removed directory: ‘/var/lib/mysql/tpch1’
 
removed ‘/var/lib/mysql/performance_schema/db.opt’
 
removed directory: ‘/var/lib/mysql/performance_schema’
 
removed ‘/var/lib/mysql/ffr/db.opt’
 
removed ‘/var/lib/mysql/ffr/f.MYI’
 
removed ‘/var/lib/mysql/ffr/f.MYD’
 
removed ‘/var/lib/mysql/ffr/f.frm’
 
removed directory: ‘/var/lib/mysql/ffr’
 
removed ‘/var/lib/mysql/aria_log_control’
 
removed ‘/var/lib/mysql/aria_log.00000001’
 
removed ‘/var/lib/mysql/ib_buffer_pool’
 
removed ‘/var/lib/mysql/xtrabackup_info’
 
removed ‘/var/lib/mysql/xtrabackup_binlog_pos_innodb’
 
removed ‘/var/lib/mysql/ib_logfile1’
 
removed ‘/var/lib/mysql/mysql.sock’
 
WSREP_SST: [INFO] Waiting for SST streaming to complete! (20180430 18:29:48.999)
 
2018-04-30 18:29:49 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') connection to peer 5053de41 with addr tcp://192.168.104.195:4567 timed out, no messages seen in PT3S
 
2018-04-30 18:29:50 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') turning message relay requesting off
 
   joiner: => Rate:[24.7MiB/s] Avg:[24.7MiB/s] Elapsed:0:00:32
 
WSREP_SST: [INFO] NOTE: Joiner-Recv-SST took 33 seconds (20180430 18:30:21.633)
 
2018-04-30 18:30:21 0 [Note] WSREP: 2.0 (t4w6): State transfer to 0.0 (t4w5) complete.
 
2018-04-30 18:30:21 0 [Note] WSREP: Member 2.0 (t4w6) synced with group.
 
WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql//.sst (20180430 18:30:21.644)
 
WSREP_SST: [INFO] Evaluating mariabackup --innobackupex   --apply-log $rebuildcmd ${DATA} &>${DATA}/innobackup.prepare.log (20180430 18:30:21.649)
 
WSREP_SST: [INFO] NOTE: Xtrabackup prepare stage took 1 seconds (20180430 18:30:22.148)
 
rm: cannot remove ‘/var/lib/mysql//innobackup.prepare.log’: No such file or directory
 
rm: cannot remove ‘/var/lib/mysql//innobackup.move.log’: No such file or directory
 
WSREP_SST: [INFO] Moving the backup to /var/lib/mysql/ (20180430 18:30:22.152)
 
WSREP_SST: [INFO] Evaluating mariabackup --innobackupex       --move-back --force-non-empty-directories ${DATA} &>${DATA}/innobackup.move.log (20180430 18:30:22.157)
 
WSREP_SST: [INFO] NOTE: Xtrabackup move stage took 0 seconds (20180430 18:30:22.214)
 
WSREP_SST: [INFO] Move successful, removing /var/lib/mysql//.sst (20180430 18:30:22.217)
 
WSREP_SST: [INFO] Galera co-ords from recovery: b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764 (20180430 18:30:22.224)
 
WSREP_SST: [INFO] Total time on joiner: 1 seconds (20180430 18:30:22.228)
 
WSREP_SST: [INFO] Removing the sst_in_progress file (20180430 18:30:22.231)
 
2018-04-30 18:30:22 0 [Note] WSREP: SST complete, seqno: 137764
 
2018-04-30 18:30:22 0 [Note] InnoDB: For Galera, using innodb_lock_schedule_algorithm=fcfs
 
2018-04-30 18:30:22 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2018-04-30 18:30:22 0 [Note] InnoDB: Uses event mutexes
 
2018-04-30 18:30:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
 
2018-04-30 18:30:22 0 [Note] InnoDB: Using Linux native AIO
 
2018-04-30 18:30:22 0 [Note] InnoDB: Number of pools: 1
 
2018-04-30 18:30:22 0 [Note] InnoDB: Using generic crc32 instructions
 
2018-04-30 18:30:22 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
 
2018-04-30 18:30:22 0 [Note] InnoDB: Completed initialization of buffer pool
 
2018-04-30 18:30:22 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2018-04-30 18:30:22 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes
 
2018-04-30 18:30:22 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes
 
2018-04-30 18:30:22 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
 
2018-04-30 18:30:22 0 [Note] InnoDB: New log files created, LSN=68977130702
 
2018-04-30 18:30:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2018-04-30 18:30:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2018-04-30 18:30:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2018-04-30 18:30:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2018-04-30 18:30:22 0 [Note] InnoDB: Waiting for purge to start
 
2018-04-30 18:30:22 0 [Note] InnoDB: 5.7.21 started; log sequence number 68977131020; transaction id 822534
 
2018-04-30 18:30:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
 
2018-04-30 18:30:22 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2018-04-30 18:30:22 0 [Note] Server socket created on IP: '0.0.0.0'.
 
2018-04-30 18:30:22 0 [Note] WSREP: Signalling provider to continue.
 
2018-04-30 18:30:22 0 [Note] WSREP: SST received: b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764
 
2018-04-30 18:30:22 0 [Note] WSREP: 0.0 (t4w5): State transfer from 2.0 (t4w6) complete.
 
2018-04-30 18:30:22 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 137764)
 
2018-04-30 18:30:22 0 [Note] WSREP: Member 0.0 (t4w5) synced with group.
 
2018-04-30 18:30:22 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 137764)
 
2018-04-30 18:30:22 9 [Note] WSREP: Synchronized with group, ready for connections
 
2018-04-30 18:30:22 9 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
 
2018-04-30 18:30:22 0 [Note] Reading of all Master_info entries succeded
 
2018-04-30 18:30:22 0 [Note] Added new Master_info '' to hash table
 
2018-04-30 18:30:22 0 [Note] /usr/sbin/mysqld: ready for connections.
 
Version: '10.3.6-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
 
2018-04-30 18:30:23 0 [Note] InnoDB: Buffer pool(s) load completed at 180430 18:30:23



 Comments   
Comment by Jan Lindström [ 2023-06-06 ]

10.3 is EOL soon.

Generated at Thu Feb 08 08:26:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.