構築中。

名古屋のITインフラお守り係です。ITイベントへの参加記録などを残していきます。

MySQL 8.0 の薄い本/リンク集(第 7 章)8.0.15

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

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

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

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

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

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/

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

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

http://mita2db.blogspot.com/2016/12/group-replication-1.html

http://mita2db.blogspot.com/2017/01/group-replication-2.html

http://mita2db.blogspot.com/2017/01/group-replication-3.html

http://mita2db.blogspot.com/2017/01/group-replication-4.html

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://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_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/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-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://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://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/cond-instances-table.html

https://dev.mysql.com/doc/refman/8.0/en/mutex-instances-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

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://dev.mysql.com/worklog/task/?id=10799

7.6 MySQL Shell

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://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/replication-options-binary-log.html#sysvar_binlog_transaction_dependency_tracking

https://dev.mysql.com/doc/refman/8.0/en/replication-options-slave.html#option_mysqld_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-delayed.html

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