Mysql - 随笔分类(第4页) - jinzhenshui

Mysql：FAQ：A.14 Replication

摘要：A.14 MySQL 5.7 FAQ: Replication In the following section, we provide answers to questions that are most frequently asked about MySQL Replication. A.14 阅读全文

posted @ 2020-03-25 14:49 jinzhenshui 阅读(156) 评论(0) 推荐(0)

Mysql：How do I force the master to block updates until the slave catches up?

摘要：A.14.4. How do I force the master to block updates until the slave catches up? Use the following procedure: On the master, execute these statements: m 阅读全文

posted @ 2020-03-25 14:39 jinzhenshui 阅读(172) 评论(0) 推荐(0)

Mysql：FAQ：A.5 Triggers

摘要：A.5 MySQL 5.7 FAQ: Triggers A.5.1. Where can I find the documentation for MySQL 5.7 triggers? A.5.2. Is there a discussion forum for MySQL Triggers? A 阅读全文

posted @ 2020-03-25 14:14 jinzhenshui 阅读(270) 评论(0) 推荐(0)

Mysql：Where are stored {procedures | functions | triggers} ? （例程）存储过程、函数、触发器，存在哪儿？

摘要：A.4.7. Where are stored procedures stored? In the proc table of the mysql system database. However, you should not access the tables in the system dat 阅读全文

posted @ 2020-03-25 14:02 jinzhenshui 阅读(141) 评论(0) 推荐(0)

Mysql：5.7：all triggers are 【FOR EACH ROW】

摘要：A.5.3. Does MySQL 5.7 have statement-level or row-level triggers? In MySQL 5.7, all triggers are FOR EACH ROW; that is, the trigger is activated for e 阅读全文

posted @ 2020-03-25 13:54 jinzhenshui 阅读(241) 评论(0) 推荐(0)

Mysql：FAQ：A.4 Stored Procedures and Functiions

摘要：A.4 MySQL 5.7 FAQ: Stored Procedures and Functions A.4.1. Does MySQL 5.7 support stored procedures and functions? A.4.2. Where can I find documentatio 阅读全文

posted @ 2020-03-25 13:50 jinzhenshui 阅读(217) 评论(0) 推荐(0)

ANSI SQL 2003：美国国家标准：SQL-2003：该规范并不是free获取——你得花钱！

摘要：A.4.4. Where can I find the ANSI SQL 2003 specification for stored procedures? Unfortunately, the official specifications are not freely available (AN 阅读全文

posted @ 2020-03-25 13:38 jinzhenshui 阅读(1353) 评论(0) 推荐(0)

Mysql：可恨又可怜Query Cache特性：已死！莫用！

摘要：A.1.4. Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? Yes. (However, the query cache is deprecated as of MySQL 5.7.2 阅读全文

posted @ 2020-03-25 11:40 jinzhenshui 阅读(280) 评论(0) 推荐(0)

Mysql：Innodb Cluster【It's not NDB】：Based On Group Replication

摘要：Chapter 21 InnoDB Cluster Table of Contents 21.1 Introducing InnoDB Cluster 21.2 Creating an InnoDB Cluster 21.2.1 Deployment Scenarios 21.2.2 InnoDB 阅读全文

posted @ 2020-03-23 13:47 jinzhenshui 阅读(319) 评论(0) 推荐(0)

Mysql：read-only 配置

摘要：重点： super_read_only、read_only：不会从master传递（复制）到slave super_read_only=on隐含实现read_only=on read_only=off隐含实现super_read_only=off super_read_only PropertyVa 阅读全文

posted @ 2020-03-22 20:16 jinzhenshui 阅读(2351) 评论(0) 推荐(0)

Mysql：我自己总也记不住的【选项语法规则】： Command-Line-Options、Configure-Options、System-Variables、Status-Variables

摘要：横杠与下划线：-、_：At runtime, system variable names must be written using underscores, not dashes 前缀：--maximum- 大小写：布尔值：0、1、off、on、false、true：某些布尔值配置，在启动命令阅读全文

posted @ 2020-03-22 17:46 jinzhenshui 阅读(435) 评论(0) 推荐(0)

Mysql：Delayed Replication：延迟复制

摘要：语法很简单，意义却很重大！ 16.3.10 Delayed Replication MySQL 5.7 supports delayed replication such that a slave server deliberately lags behind the master by at le 阅读全文

posted @ 2020-03-22 16:23 jinzhenshui 阅读(427) 评论(0) 推荐(0)

Mysql：Semi-Synchronous Replication：大名鼎鼎的【半同步】复制

摘要：提示：配置很简单：安装插件，然后...没有什么然后，哈哈 master-side: SET GLOBAL rpl_semi_sync_master_enabled={0|1}; SET GLOBAL rpl_semi_sync_master_timeout={10000|N}; --10秒 slav 阅读全文

posted @ 2020-03-22 14:20 jinzhenshui 阅读(461) 评论(0) 推荐(0)

Mysql：Replication

摘要：Chapter 16 Replication Table of Contents 16.1 Configuring Replication 16.1.1 Binary Log File Position Based Replication Configuration Overview 16.1.2 阅读全文

posted @ 2020-03-22 12:42 jinzhenshui 阅读(228) 评论(0) 推荐(0)

Mysql：Group Replication：实战：注意事项

摘要：重点： GR中第1台必须使用group_replication_bootstrap_group=on 之后，手工start group_replication，自举创建第一个GR资源视图。随后的第2+台万万不可再使用该参数！ Configuring group_replication_bootstr 阅读全文

posted @ 2020-03-21 23:13 jinzhenshui 阅读(238) 评论(0) 推荐(0)

Mysql：Group Replication

摘要：Chapter 17 Group Replication Table of Contents 17.1 Group Replication Background 17.1.1 Replication Technologies 17.1.2 Group Replication Use Cases 17 阅读全文

posted @ 2020-03-21 09:46 jinzhenshui 阅读(754) 评论(0) 推荐(0)

Mysql：SQL Modes：最令我烦的sql-modes：一个标准它不香么？！

摘要：核心：所谓的各种sql mode就是mysqld的各种语法检查开关。原则：如果你不想有各种烦恼：不要去设置它！提示：如果你想设置它，尽量兼容国际标准。 The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_ 阅读全文

posted @ 2020-03-17 11:39 jinzhenshui 阅读(546) 评论(0) 推荐(0)

Mysql：Alternative Storage Engines：可替换存储引擎：mysqld的核心特性

摘要：请注意：NO_ENGINE_SUBSTITUTION Chapter 16 Alternative Storage Engines Table of Contents 16.1 Setting the Storage Engine Storage engines are MySQL componen 阅读全文

posted @ 2020-03-17 09:27 jinzhenshui 阅读(427) 评论(0) 推荐(0)

Mysql：The BLACKHOLE Storage Engine

摘要：Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated t 阅读全文

posted @ 2020-03-17 09:05 jinzhenshui 阅读(189) 评论(0) 推荐(0)

Mysql：The ARCHIVE Storage Engine

摘要：记录下，尚不知如何用？！ 16.5 The ARCHIVE Storage Engine The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in 阅读全文

posted @ 2020-03-17 08:57 jinzhenshui 阅读(233) 评论(0) 推荐(0)

随笔分类 - Mysql