2020 年 3月随笔档案 - jinzhenshui

续：MONyog 8.9.1：IderaSQLDiagnosticManagerForMySQL-Windows-x86 8.9.1：无限期试用：变相破解

摘要：原理：重置 MONyog 安装时关键配置文件的create-time。至于怎么重置，方法有n多种，我喜欢用touch (网上下的) 实现： @echo off set path=.;%path% net stop monyog touch.exe -acmx -R %ALLUSERSPROFILE% 阅读全文

posted @ 2020-03-30 11:26 jinzhenshui 阅读(1118) 评论(0) 推荐(0) 编辑

续：SQLyog Trial v13.1.5 x64：无限期试用：变相破解

摘要：原理：删除 SQLyog Trial 版在安装时在注册表内的标记：实现：注册表代码如下，拷贝另外为.reg文件，双击导入注册表即可。 Windows Registry Editor Version 5.00 [-HKEY_CURRENT_USER\Software\{d58cb4b1-47f3-4 阅读全文

posted @ 2020-03-30 11:19 jinzhenshui 阅读(6507) 评论(3) 推荐(1) 编辑

Mysql：Changes in MySQL 5.6.2 (2011-04-11, Developer Milestone)

摘要：Changes in MySQL 5.6.2 (2011-04-11, Developer Milestone) Note This is a milestone release, for use at your own risk. Upgrades between milestone releas 阅读全文

posted @ 2020-03-29 11:21 jinzhenshui 阅读(144) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.1 (Not released, Milestone 5)：--log -> --general-log ...

摘要：Changes in MySQL 5.6.1 (Not released, Milestone 5) Functionality Added or Changed Incompatible Change: The following obsolete constructs have been rem 阅读全文

posted @ 2020-03-29 11:12 jinzhenshui 阅读(142) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.0 (Not released, Milestone 4)：Global UUID

摘要：Changes in MySQL 5.6.0 (Not released, Milestone 4) Globally Unique Server IDs Replication: Globally unique IDs for MySQL servers were implemented. A U 阅读全文

posted @ 2020-03-29 11:05 jinzhenshui 阅读(159) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.4 (2011-12-20, Milestone 7)：微秒支持、Innodb全文索引支持

摘要：Changes in MySQL 5.6.4 (2011-12-20, Milestone 7) Fractional Seconds Handling Incompatible Change: MySQL now permits fractional seconds for TIME, DATET 阅读全文

posted @ 2020-03-29 10:56 jinzhenshui 阅读(145) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.6 (2012-08-07, Milestone 9)：Group-Commit等等：重大变化版本！

摘要：Changes in MySQL 5.6.6 (2012-08-07, Milestone 9) Note This is a milestone release, for use at your own risk. Upgrades between milestone releases (or f 阅读全文

posted @ 2020-03-29 10:48 jinzhenshui 阅读(161) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.9 (2012-12-11, Release Candidate)：GTID-based variables have been 【renamed】

摘要：Changes in MySQL 5.6.9 (2012-12-11, Release Candidate) Functionality Added or Changed Incompatible Change; Replication: A number of variable and other 阅读全文

posted @ 2020-03-29 10:32 jinzhenshui 阅读(123) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.13 (2013-07-31, General Availability)：不再支持可能引起混乱的【选项缩略】写法！

摘要：Changes in MySQL 5.6.13 (2013-07-31, General Availability) Functionality Added or Changed Previously, program options could be specified in full or as 阅读全文

posted @ 2020-03-29 10:20 jinzhenshui 阅读(141) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.22 (2014-12-01, General Availability)：【sql-log-bin】

摘要：Changes in MySQL 5.6.22 (2014-12-01, General Availability) Deprecation and Removal Notes Replication: The global scope for the sql_log_bin system vari 阅读全文

posted @ 2020-03-29 10:05 jinzhenshui 阅读(85) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.30 (2016-04-11, General Availability)：--ssl-mode：

摘要：Changes in MySQL 5.6.30 (2016-04-11, General Availability) Security Notes The linked OpenSSL library for the MySQL Commercial Server has been updated 阅读全文

posted @ 2020-03-29 09:55 jinzhenshui 阅读(163) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.6.34 (2016-10-12, General Availability)：secure-file-priv

摘要：Changes in MySQL 5.6.34 (2016-10-12, General Availability) Security Notes Incompatible Change: The secure_file_priv system variable is used to limit t 阅读全文

posted @ 2020-03-29 09:47 jinzhenshui 阅读(104) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 8.0.13 (2018-10-22, General Availability)：utf8mb3 ->utf8mb4

摘要：Changes in MySQL 8.0.13 (2018-10-22, General Availability) Deprecation and Removal Notes ... InnoDB: Support for TABLESPACE = innodb_file_per_table an 阅读全文

posted @ 2020-03-28 13:52 jinzhenshui 阅读(176) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 8.0.17 (2019-07-22, General Availability)：是mysqld 内在转变的版本！！！

摘要：Changes in MySQL 8.0.17 (2019-07-22, General Availability) Deprecation and Removal Notes FLOAT(M,D) and DOUBLE(M,D) syntax to specify the number of di 阅读全文

posted @ 2020-03-28 13:38 jinzhenshui 阅读(270) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 8.0.19 (2020-01-13, General Availability):（\!）可以在windows下正常工作了！

摘要：Changes in MySQL 8.0.19 (2020-01-13, General Availability) Deprecation and Removal Notes Setting the hash_join optimizer switch (see optimizer_switch 阅读全文

posted @ 2020-03-28 13:25 jinzhenshui 阅读(1141) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)：innodb_buffer_pool_size parameter is 【dynamic】

摘要：InnoDB Notes Incompatible Change: The InnoDB storage engine can no longer be disabled. The --skip-innodb option is deprecated and has no effect, and i 阅读全文

posted @ 2020-03-27 20:54 jinzhenshui 阅读(123) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.7.7 (2015-04-08, Release Candidate)：The innodb_file_format default value was changed to Barracuda

摘要：Changes in MySQL 5.7.7 (2015-04-08, Release Candidate) Functionality Added or Changed Important Change; InnoDB: The following changes were made to Inn 阅读全文

posted @ 2020-03-27 20:43 jinzhenshui 阅读(135) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.7.9 (2015-10-21, General Availability)：很重要的版本！

摘要：Changes in MySQL 5.7.9 (2015-10-21, General Availability) Server Administration A new SHUTDOWN SQL statement is available. This provides an SQL-level 阅读全文

posted @ 2020-03-27 20:30 jinzhenshui 阅读(195) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.7.13 (2016-06-02, General Availability)：maximum length of MySQL user names was increased from 16 to 32 characters

摘要：Changes in MySQL 5.7.13 (2016-06-02, General Availability) Account Management Notes In MySQL 5.7.8, the maximum length of MySQL user names was increas 阅读全文

posted @ 2020-03-27 20:22 jinzhenshui 阅读(488) 评论(0) 推荐(0) 编辑

Mysql：Changes in MySQL 5.7.22 (2018-04-19, General Availability)：These compatibility 【SQL modes】 are now deprecated and will be removed

摘要：Changes in MySQL 5.7.22 (2018-04-19, General Availability) Deprecation and Removal Notes These compatibility SQL modes are now deprecated and will be 阅读全文

posted @ 2020-03-27 20:06 jinzhenshui 阅读(92) 评论(0) 推荐(0) 编辑

Mysql：Row-based Replication：运维：一直更新中...

摘要：记住：永远使用：binlog_format=row 记住：尽量使max_allowed_packet大，如：max_allowed_packet=32M：sets max size of any single message between the MySQL server and clients 阅读全文

posted @ 2020-03-25 20:51 jinzhenshui 阅读(543) 评论(0) 推荐(0) 编辑

Mysql：Stored Object：视图、触发器、调度事件、存储过程、存储函数：【复合语句】语法

摘要：begin [...] end 复合语句，可以为“空”的begin end复合语句复合语句内可以包含0+其他语句，包括复合语句复合语句内包含的语句需要以分号 " ; " 分割整个复合语句必须作为一个完整的整体字符串发送给mysqld服务器去处理，因此，客户端必须要能正确处理批命令结束符，尤其是阅读全文

posted @ 2020-03-25 15:57 jinzhenshui 阅读(233) 评论(0) 推荐(0) 编辑

Mysql：Stored Object：视图、触发器、调度事件、存储过程、存储函数

摘要：Terminology used in this document reflects the stored object hierarchy: Stored routines include stored procedures(L1-1-1) and functions(L1-1-2). Store 阅读全文

posted @ 2020-03-25 15:32 jinzhenshui 阅读(234) 评论(0) 推荐(0) 编辑

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 阅读(149) 评论(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 阅读(164) 评论(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 阅读(263) 评论(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 阅读(133) 评论(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 阅读(227) 评论(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 阅读(207) 评论(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 阅读(1331) 评论(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 阅读(273) 评论(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 阅读(307) 评论(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 阅读(2256) 评论(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 阅读(404) 评论(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 阅读(409) 评论(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 阅读(428) 评论(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 阅读(221) 评论(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 阅读(226) 评论(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 阅读(675) 评论(0) 推荐(0) 编辑

端口映射工具En化版：PortMap_Gold_Edition_Premium_3.4：可以绑定特定的网卡NIC

摘要：一切权利属于原作者，本人仅仅是：（1）翻译那些不认识的语言为English （2）美化各个窗体控件及列表的大小、对齐方式，美化美化（3）该软件的“remote connect”功能不知是不是纯粹样子而已，本人测试发现它没有什么真正的功能附件下载：PortMap_Gold_Edition_Pre 阅读全文

posted @ 2020-03-19 16:47 jinzhenshui 阅读(138) 评论(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 阅读(523) 评论(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 阅读(414) 评论(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 阅读(172) 评论(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 阅读(212) 评论(0) 推荐(0) 编辑

Mysql：The CSV Storage Engine

摘要：注意： 1）表定义（换句话说）数据列必须不能为空Null！ 2）修复表，极有可能丢失数据 16.4 The CSV Storage Engine 16.4.1 Repairing and Checking CSV Tables 16.4.2 CSV Limitations The CSV stora 阅读全文

posted @ 2020-03-17 08:46 jinzhenshui 阅读(272) 评论(0) 推荐(0) 编辑

Mysql：The Memory Storage Engine

摘要：16.3 The MEMORY Storage Engine The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memo 阅读全文

posted @ 2020-03-17 08:45 jinzhenshui 阅读(182) 评论(0) 推荐(0) 编辑

Mysql：The Merge Storage Engine：类【union all】联合视图存储引擎

摘要：16.7 The MERGE Storage Engine 16.7.1 MERGE Table Advantages and Disadvantages 16.7.2 MERGE Table Problems The MERGE storage engine, also known as the 阅读全文

posted @ 2020-03-16 19:45 jinzhenshui 阅读(253) 评论(0) 推荐(0) 编辑

Mysql：The Federated Storage Engine：联合（联盟）存储引擎：【远程连接】服务器引擎

摘要：重点：目前该引擎仅仅支持Mysqld服务器；如果能支持其他rdbms系统就完美了！ 16.8 The FEDERATED Storage Engine 16.8.1 FEDERATED Storage Engine Overview 16.8.2 How to Create FEDERATED Ta 阅读全文

posted @ 2020-03-16 19:12 jinzhenshui 阅读(664) 评论(0) 推荐(0) 编辑

Mysql：16.11.1 Pluggable Storage Engine Architecture

摘要：16.9 The EXAMPLE Storage Engine The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL sour 阅读全文

posted @ 2020-03-16 18:35 jinzhenshui 阅读(278) 评论(0) 推荐(0) 编辑

Mysql：Server Logs：mysqld服务器的各种日志

摘要：比较新的知识点：DDL log，以前没注意到 5.4 MySQL Server Logs 5.4.1 Selecting General Query Log and Slow Query Log Output Destinations 5.4.2 The Error Log 5.4.3 The Ge 阅读全文

posted @ 2020-03-16 16:20 jinzhenshui 阅读(618) 评论(0) 推荐(0) 编辑

Mysql：InnoDB Table Compression and InnoDB Page Compression：适用于InnoDB的：表压缩 & 页压缩

摘要：15.9 InnoDB Table and Page Compression 15.9.1 InnoDB Table Compression 15.9.2 InnoDB Page Compression This section provides information about the Inno 阅读全文

posted @ 2020-03-16 15:44 jinzhenshui 阅读(1112) 评论(0) 推荐(0) 编辑

Mysql：Redo Log

摘要：15.6.5 Redo Log The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During norm 阅读全文

posted @ 2020-03-16 12:53 jinzhenshui 阅读(194) 评论(0) 推荐(0) 编辑

Mysql：DoubleWrite Buffer：类似于redo-log：提高data写性能，间接提高data写安全性！

摘要：15.6.4 Doublewrite Buffer The doublewrite buffer is a storage area in the system tablespace where InnoDB writes pages that are flushed from the buffer 阅读全文

posted @ 2020-03-16 12:38 jinzhenshui 阅读(276) 评论(0) 推荐(0) 编辑

Mysql：UNDO Tablespaces && UNDO Logs

摘要：15.6.3.4 Undo Tablespaces Undo tablespaces contain undo logs, which are collections of undo log records that contain information about how to undo the 阅读全文

posted @ 2020-03-16 12:33 jinzhenshui 阅读(1171) 评论(0) 推荐(0) 编辑

Mysql：Temporary Tablespaces

摘要：重点： Session Temporary Tablespaces：用户session临时表空间的管理 15.6.3.5 Temporary Tablespaces InnoDB uses session temporary tablespaces and a global temporary ta 阅读全文

posted @ 2020-03-16 11:21 jinzhenshui 阅读(416) 评论(0) 推荐(0) 编辑

Mysql：innodb engines：Moveing Tablespace Files when mysqld server is Offline!

摘要：15.6.3.6 Moving Tablespace Files While the Server is Offline The innodb_directories option, which defines directories to scan at startup for tablespac 阅读全文

posted @ 2020-03-16 11:16 jinzhenshui 阅读(606) 评论(0) 推荐(0) 编辑

Mysql：账号与权限

摘要：6.2 Access Control and Account Management 6.2.1 Account User Names and Passwords 6.2.2 Privileges Provided by MySQL 6.2.3 Grant Tables 6.2.4 Specifyin 阅读全文

posted @ 2020-03-16 10:26 jinzhenshui 阅读(1603) 评论(0) 推荐(0) 编辑

Mysql：Information_schema：信息构架 or 数据字典 or 系统目录

摘要：Chapter 25 INFORMATION_SCHEMA Tables 25.1 Introduction INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server suc 阅读全文

posted @ 2020-03-16 10:09 jinzhenshui 阅读(291) 评论(0) 推荐(0) 编辑

Mysql：General Tablespace：一般（普通）（用户共享）表空间

摘要：15.6.3.3 General Tablespaces A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. General tablespace cap 阅读全文

posted @ 2020-03-15 20:42 jinzhenshui 阅读(732) 评论(0) 推荐(0) 编辑

Mysql：innodb：File-Per-Table Tablespace：最大的弊病（每次增长仅仅4M）：碎片、慢！

摘要：15.6.3.2 File-Per-Table Tablespaces A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system 阅读全文

posted @ 2020-03-15 20:38 jinzhenshui 阅读(368) 评论(0) 推荐(0) 编辑

Mysql：as of 8.0.14+：--admin-address、--admin-port、--create-admin-listener-thread

摘要：【不指定】该--admin-address选项（系统变量），则不会起该管理监听！！！ admin_address PropertyValue Command-Line Format --admin-address=addr Introduced 8.0.14 System Variable admi 阅读全文

posted @ 2020-03-15 19:16 jinzhenshui 阅读(542) 评论(0) 推荐(0) 编辑

Mysql：Group Replication & Replication

摘要：Chapter 18 Group Replication Table of Contents 18.1 Group Replication Background 18.1.1 Replication Technologies 18.1.2 Group Replication Use Cases 18 阅读全文

posted @ 2020-03-15 18:51 jinzhenshui 阅读(1084) 评论(0) 推荐(0) 编辑

Mysql：Replication & Group Replication

摘要：Chapter 17 Replication Table of Contents 17.1 Configuring Replication 17.1.1 Binary Log File Position Based Replication Configuration Overview 17.1.2 阅读全文

posted @ 2020-03-15 18:49 jinzhenshui 阅读(671) 评论(0) 推荐(0) 编辑

Mysql：Plugin：clone=mysql_clone：as of 8.0.17

摘要：5.6.7 The Clone Plugin 5.6.7.1 Installing the Clone Plugin 5.6.7.2 Cloning Data Locally 5.6.7.3 Cloning Remote Data 5.6.7.4 Cloning Encrypted Data 5.6 阅读全文

posted @ 2020-03-15 14:10 jinzhenshui 阅读(506) 评论(0) 推荐(0) 编辑

Mysql：来源于Mariadb的【审计】插件：server_audit

摘要：一：直接从mariadb的GA版本中提取server_audit{.so|.dll}，根据测试，不支持 Mysql 8+ 主要的、最近的版本都已经是 1.4.4+：完整的功能了。 CONNECT, QUERY, TABLE, QUERY_DDL, QUERY_DML, QUERY_DCL, QU 阅读全文

posted @ 2020-03-14 18:51 jinzhenshui 阅读(1152) 评论(0) 推荐(0) 编辑

Mysql：--init-file && --init-connect

摘要：init_file PropertyValue Command-Line Format --init-file=file_name System Variable init_file Scope Global Dynamic No SET_VAR Hint Applies No Type File 阅读全文

posted @ 2020-03-13 21:33 jinzhenshui 阅读(354) 评论(0) 推荐(0) 编辑

Mysql：8.0.19：Upgrading Mysql：升级

摘要：2.11 Upgrading MySQL 2.11.1 Before You Begin 2.11.2 Upgrade Paths 2.11.3 What the MySQL Upgrade Process Upgrades 2.11.4 Changes in MySQL 8.0 2.11.5 Pr 阅读全文

posted @ 2020-03-13 20:26 jinzhenshui 阅读(1538) 评论(0) 推荐(0) 编辑

Mysql：8.0.19：新特性、过期、已经删除的

摘要：1.4 What Is New in MySQL 8.0 1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 1.4 What Is New in MySQL 8.0 This 阅读全文

posted @ 2020-03-13 20:18 jinzhenshui 阅读(1120) 评论(0) 推荐(0) 编辑

Mysql：5.5-5.6：Components & Plugins

摘要：5.5 MySQL Server Components 5.5.1 Installing and Uninstalling Components 5.5.2 Obtaining Server Component Information 5.5.3 Error Log Components MySQL 阅读全文

posted @ 2020-03-13 19:51 jinzhenshui 阅读(391) 评论(0) 推荐(0) 编辑

Mysql：As of 8.0.16：--validate-config：新增的服务器配置验证特效：good！

摘要：5.1.3 Server Configuration Validation As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to b 阅读全文

posted @ 2020-03-13 19:24 jinzhenshui 阅读(387) 评论(0) 推荐(0) 编辑

Mysql：FIPS：Federal Information Processing Standards 140-2：世上有不透风的墙么？！

摘要：6.5 FIPS Support MySQL supports FIPS mode, if compiled using OpenSSL 1.0.2, and an OpenSSL library and FIPS Object Module are available at runtime. FI 阅读全文

posted @ 2020-03-13 19:16 jinzhenshui 阅读(230) 评论(0) 推荐(0) 编辑

Mysql：6.4.2-6.4.8：Security Plugins & Component & Enterprise-Extend

摘要：6.4.2 The Connection-Control Plugins 6.4.3 The Password Validation Component 6.4.4 The MySQL Keyring 6.4.5 MySQL Enterprise Audit 6.4.6 The Audit Mess 阅读全文

posted @ 2020-03-13 19:06 jinzhenshui 阅读(2360) 评论(0) 推荐(0) 编辑

Mysql：Using Encrypted Connection：SSL、TLS、SSH：通讯安全

摘要：6.3 Using Encrypted Connections 6.3.1 Configuring MySQL to Use Encrypted Connections 6.3.2 Encrypted Connection TLS Protocols and Ciphers 6.3.3 Creati 阅读全文

posted @ 2020-03-13 18:31 jinzhenshui 阅读(767) 评论(0) 推荐(0) 编辑

Mysql：Authentication Plugins：插件式（权限）认证

摘要：6.4 Security Components and Plugins 6.4.1 Authentication Plugins 6.4.2 The Connection-Control Plugins 6.4.3 The Password Validation Component 6.4.4 Th 阅读全文

posted @ 2020-03-13 18:18 jinzhenshui 阅读(2738) 评论(0) 推荐(0) 编辑

Mysql：通过SSH隧道方式实现安全通讯

摘要：6.3.4 Connecting to MySQL Remotely from Windows with SSH This section describes how to get an encrypted connection to a remote MySQL server with SSH. 阅读全文

posted @ 2020-03-13 13:36 jinzhenshui 阅读(392) 评论(0) 推荐(0) 编辑

Mysql：Chapter 6 Security（直接复制的）

摘要：Chapter 6 Security Table of Contents 6.1 General Security Issues 6.1.1 Security Guidelines 6.1.2 Keeping Passwords Secure 6.1.3 Making MySQL Secure Ag 阅读全文

posted @ 2020-03-13 13:31 jinzhenshui 阅读(447) 评论(0) 推荐(0) 编辑

Mysql：logging 安全问题：server & client

摘要：6.1.2.3 Passwords and Logging Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. If such statements 阅读全文

posted @ 2020-03-13 13:13 jinzhenshui 阅读(337) 评论(0) 推荐(0) 编辑

Mysql：set password

摘要：13.7.1.10 SET PASSWORD Statement SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_ 阅读全文

posted @ 2020-03-13 11:57 jinzhenshui 阅读(577) 评论(0) 推荐(0) 编辑

Mysql： DNS Lookup Optimization and the Host Cache：skip-host-cache\skip-name-resolve

摘要：8.12.4.2 DNS Lookup Optimization and the Host Cache The MySQL server maintains a host cache in memory that contains information about clients: IP addr 阅读全文

posted @ 2020-03-13 11:09 jinzhenshui 阅读(512) 评论(0) 推荐(0) 编辑

Mysql：skip-name-reslove

摘要：skip_name_resolve PropertyValue Command-Line Format --skip-name-resolve[={OFF|ON}] System Variable skip_name_resolve Scope Global Dynamic No SET_VAR H 阅读全文

posted @ 2020-03-13 10:55 jinzhenshui 阅读(333) 评论(0) 推荐(0) 编辑

Mysql 8.0.19：skip-grant-table：新变化：坑

摘要：--skip-grant-tables PropertyValue Command-Line Format --skip-grant-tables[={OFF|ON}] Type Boolean Default Value OFF This option affects the server sta 阅读全文

posted @ 2020-03-13 10:37 jinzhenshui 阅读(1099) 评论(0) 推荐(0) 编辑

Mysql：就地升级：mysql_upgrade

摘要：重点来了：完整的物理备份。参数配置 [mysqld] # 最基本的配置了 basedir=D:/mysql-5.7.29-winx64 datadir=D:/mysql-5.7.29-winx64/data # 临时升级检测用 innodb-buffer-pool-size=2G #可选，默认很阅读全文

posted @ 2020-03-12 12:46 jinzhenshui 阅读(3784) 评论(0) 推荐(0) 编辑

nginx-1.16：Module ngx_stream_upstream_module

摘要：阅读全文

posted @ 2020-03-02 21:01 jinzhenshui 阅读(273) 评论(0) 推荐(0) 编辑

nginx-1.16：Module ngx_stream_core_module

摘要：阅读全文

posted @ 2020-03-02 20:51 jinzhenshui 阅读(365) 评论(0) 推荐(0) 编辑

nginx-1.16：Module ngx_stream_proxy_module

摘要：阅读全文

posted @ 2020-03-02 20:49 jinzhenshui 阅读(434) 评论(0) 推荐(0) 编辑

nginx-1.16：Module ngx_http_autoindex_module

摘要：阅读全文