- MySQL 8 for Big Data
- Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
- 169字
- 2021-08-20 10:06:11
Blackhole
This storage engine accepts data but does not store it. It discards data after every INSERT instead of storing it.
The following example shows the BLACKHOLE table process:
mysql> CREATE TABLE user(id INT, name CHAR(10)) ENGINE = BLACKHOLE;
Query OK, 0 rows affected (0.07 sec)
mysql> INSERT INTO USER VALUES(1,'Kandarp'),(2,'Chintan');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM USER;
Empty set (0.00 sec)
Now what is the use of this storage engine? Why would anybody use it? Why would we run an INSERT query that doesn't insert anything into the table?
This engine is useful for replication with large amount of servers. A blackhole storage engine acts as a filter server between the master and slave server, which do not store any data but only apply replicate-do-* and replicate-ignore-* rules and write a binlogs. These binlogs are used to perform replication in slave servers. We will discuss this in detail in Chapter 7, Replication for building highly available solutions.
推薦閱讀
- Extending Jenkins
- Learning Java Functional Programming
- C++程序設計(第3版)
- PyTorch自動駕駛視覺感知算法實戰
- Elastic Stack應用寶典
- Practical Game Design
- Unity Shader入門精要
- Teaching with Google Classroom
- Python算法詳解
- 軟件測試教程
- Hands-On Full Stack Development with Spring Boot 2.0 and React
- Python編程:從入門到實踐(第3版)
- 測試架構師修煉之道:從測試工程師到測試架構師
- PHP+MySQL動態網站開發從入門到精通(視頻教學版)
- Mastering ASP.NET Core 2.0