MySQL 8.0 の薄い本／リンク集（第 7 章）

8.0.18 対応版はこちら

8.0.17 対応版はこちら

8.0.16 対応版はこちら

8.0.15 対応版はこちら

7.1 バイナリログ／リレーログ暗号化

https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption.html

https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html

https://www.s-style.co.jp/blog/2019/03/3771/

https://mysqlhighavailability.com/binary-log-encryption-at-rest/

https://mysqlhighavailability.com/how-to-manually-decrypt-an-encrypted-binary-log-file/

https://mysqlhighavailability.com/rotating-binary-log-master-key-online/

https://mysqlhighavailability.com/binary-log-encryption-encryption-of-temporary-capture-files/

https://qiita.com/hmatsu47/items/96980d508f79f9510aa2

7.2 バイナリログ有効期限の指定⽅法変更

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_expire_logs_seconds

https://yoku0825.blogspot.com/2018/04/mysql-803-expirelogsdays.html

https://www.s-style.co.jp/blog/2019/11/5440/

https://labs.gree.jp/blog/2019/10/19616/

https://labs.gree.jp/blog/2019/10/19628/

https://labs.gree.jp/blog/2019/11/19752/

https://labs.gree.jp/blog/2019/11/19832/

https://labs.gree.jp/blog/2019/11/19898/

7.3 InnoDB Cluster

https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-userguide.html

https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-working-with-cluster.html

https://www.s-style.co.jp/blog/2018/11/2722/

https://www.s-style.co.jp/blog/2018/11/2890/

https://www.s-style.co.jp/blog/2018/11/2899/

https://www.s-style.co.jp/blog/2018/11/2904/

https://www.s-style.co.jp/blog/2018/12/2962/

https://www.s-style.co.jp/blog/2018/12/3028/

https://www.s-style.co.jp/blog/2019/02/3489/

https://mysqlserverteam.com/mysql-shell-8-0-whats-new/

https://mysqlserverteam.com/mysql-innodb-cluster-changing-cluster-topology-modes-live/

https://www.youtube.com/watch?v=8JqJpVN3XqY

https://mysqlhighavailability.com/mysql-innodb-cluster-automatic-node-provisioning/

https://mysqlhighavailability.com/a-breakthrough-in-usability-automatic-node-provisioning/

https://dasini.net/blog/2019/09/10/mysql-innodb-cluster-easy-recovering-and-provisioning/

7.4 グループレプリケーション

https://dev.mysql.com/doc/refman/8.0/en/group-replication.html

https://mita2db.hateblo.jp/entry/Group_Replication%5F%E3%82%92%E8%A9%A6%E3%81%99%281%29_%E5%B0%8E%E5%85%A5%E7%B7%A8

https://mita2db.hateblo.jp/entry/Group_Replication%5F%E3%82%92%E8%A9%A6%E3%81%99%282%29_%E3%83%AD%E3%83%83%E3%82%AF%E3%81%AE%E6%8C%99%E5%8B%95

https://mita2db.hateblo.jp/entry/Group_Replication%5F%E3%82%92%E8%A9%A6%E3%81%99%283%29_%E9%9A%9C%E5%AE%B3%E6%99%82%E3%81%AE%E6%8C%99%E5%8B%95

https://mita2db.hateblo.jp/entry/Group_Replication%5F%E3%82%92%E8%A9%A6%E3%81%99%284%29_%E3%83%AA%E3%82%AB%E3%83%90%E3%83%AA

7.4.1 グループレプリケーションの新機能

https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-primary-member.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-mode.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_exit_state_action

https://mysqlhighavailability.com/automatic-member-fencing-with-offline_mode-in-group-replication/

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_member_expel_timeout

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_autorejoin_tries

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_consistency

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_member_weight

https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html

https://dev.mysql.com/doc/refman/8.0/en/start-group-replication.html

https://dev.mysql.com/doc/refman/8.0/en/stop-group-replication.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html

https://mysqlhighavailability.com/improved-handling-of-different-member-versions-in-group-replication/

https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html

https://mysqlhighavailability.com/automatic-provisioning-in-group-replication/

https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-socket-layer-support-ssl.html

https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-ipv6.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_recovery_compression_algorithm

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_recovery_zstd_compression_level

https://dev.mysql.com/doc/refman/8.0/en/group-replication-flow-control.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_flow_control_applier_threshold

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_flow_control_certifier_threshold

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_flow_control_hold_percent

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_flow_control_max_commit_quota

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_flow_control_member_quota_percent

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_flow_control_min_quota

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_flow_control_min_recovery_quota

https://dev.mysql.com/doc/refman/8.0/en/group-replication-ip-address-whitelisting.html

https://mysqlhighavailability.com/group-replication-delivery-message-service/

https://dev.mysql.com/doc/refman/8.0/en/group-replication-group-write-consensus.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-maximum-consensus.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_communication_debug_options

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_communication_max_message_size

https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_message_cache_size

https://mysqlserverteam.com/the-complete-list-of-new-features-in-mysql-8-0/

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-summary-tables.html

https://dev.mysql.com/doc/refman/8.0/en/threads-table.html

https://dev.mysql.com/doc/refman/8.0/en/memory-summary-tables.html

https://dev.mysql.com/doc/refman/8.0/en/setup-instruments-table.html

https://dev.mysql.com/doc/refman/8.0/en/replication-group-member-stats-table.html

https://dev.mysql.com/doc/refman/8.0/en/replication-group-members-table.html

https://www.s-style.co.jp/blog/2020/03/5861/ 【第 2 冊で追加】

7.5 MySQL Router

https://www.mysql.com/jp/products/enterprise/router.html

7.5.1 MySQL Router の新機能

https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-conf-options.html#option_mysqlrouter_dynamic_config

https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-conf-options.html#option_mysqlrouter_max_connect_errors

https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter_plugin_info.html

https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-conf-options.html#option_mysqlrouter_ttl

https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-conf-options.html#option_mysqlrouter_routing_strategy

https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html#option_mysqlrouter_report-host

https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html#option_mysqlrouter_account-host

https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-conf-options.html#option_mysqlrouter_destinations

https://lefred.be/content/mysqlrouter-8-0-17-and-the-rest-api/

https://dev.mysql.com/worklog/task/?id=10799

7.6 MySQL Shell

https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html#admin-api

https://mysqlserverteam.com/mysql-shell-adminapi-whats-new-in-8-0-19/

※コメント訂正 【第 2 刷で訂正済】

• 誤：8.0.17 で追加、8.0.19 で InnoDB ReplicaSet（後述）などをサポート
• 正：8.0.17 で機能向上、さらに 8.0.19 で InnoDB ReplicaSet（後述）などをサポート

https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-replicasets.html

https://mysqlserverteam.com/introducing-mysql-innodb-replicaset/

https://www.s-style.co.jp/blog/2020/02/5817/ 【第 2 刷で追加】

https://qiita.com/hmatsu47/items/6f3d512f092e86b7c1cc

https://mysqlserverteam.com/mysql-shell-plugins-introduction/

https://dev.mysql.com/doc/refman/8.0/en/clone-plugin.html

https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-clone-deployment.html

https://mysqlserverteam.com/clone-create-mysql-instance-replica/

https://yoku0825.blogspot.com/2019/07/mysql-8017clone.html

https://yoku0825.blogspot.com/2019/07/mysql-8017clone-instance-from.html

https://qiita.com/huato/items/5ad03b37313c0b41efbc

https://www.s-style.co.jp/blog/2019/09/5090/

https://www.s-style.co.jp/blog/2019/11/5452/

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-parallel-table.html

https://elephantdolphin.blogspot.com/2019/08/parallel-table-importer-in-mysql-shell.html

https://www.s-style.co.jp/blog/2019/10/5248/

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-pluggable-password-store.html

https://mysqlserverteam.com/mysql-shell-8-0-12-whats-new/

https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python.html

https://mysqlserverteam.com/mysql-shell-8-0-12-whats-new/

https://mysqlserverteam.com/mysql-shell-8-0-14-whats-new/

https://dev.mysql.com/doc/x-devapi-userguide/en/

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-using-pager.html

https://mysqlserverteam.com/mysql-shell-8-0-whats-new/

https://mysqlserverteam.com/mysql-shell-api-command-line-integration-for-devops/

7.7 その他のレプリケーション新機能・変更

https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html

https://gihyo.jp/dev/serial/01/mysql-road-construction-news/0088

https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_row_value_options

https://dev.mysql.com/doc/refman/8.0/en/reset-master.html

https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_transaction_dependency_tracking

https://dev.mysql.com/doc/refman/8.0/en/replication-options-slave.html#sysvar_slave_parallel_type

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-1.html

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_row_metadata

https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html#option_mysqlbinlog_print-table-metadata

https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html#sysvar_gtid_purged

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-2.html

https://dev.mysql.com/doc/refman/8.0/en/replication-compatibility.html

https://dev.mysql.com/doc/refman/8.0/en/replication-options-master.html#sysvar_original_server_version

https://dev.mysql.com/doc/refman/8.0/en/replication-options-master.html#sysvar_immediate_server_version

https://dev.mysql.com/doc/refman/8.0/en/start-slave.html

https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-slave-halt.html

https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#option_mysqld_binlog-row-event-max-size

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_cache_size

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_binlog_stmt_cache_size

https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html#option_mysqlbinlog_compression-algorithms

https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html#option_mysqlbinlog_zstd-compression-level

https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html

https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html

https://mysqlhighavailability.com/replication-with-restricted-privileges/

https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html

https://dev.mysql.com/doc/refman/8.0/en/replication-options-master.html

https://www.percona.com/blog/2020/01/23/making-sense-of-group-replication-consistency-levels/ 【第 2 冊で追加】

https://yoku0825.blogspot.com/2020/02/innodb-cluster.html 【第 2 冊で追加】

https://dev.mysql.com/doc/refman/8.0/en/replication-options-slave.html

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html#sysvar_log_bin_use_v1_row_events

https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html#function_wait-until-sql-thread-after-gtids