mysql:architures

参考

https://www.slideshare.net/TuyenVuongDinh/mysql-architectures

https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html

https://www.oreilly.com/library/view/high-performance-mysql/9781449332471/ch01.html

mysql server : 即 mysql instance

mysql server 运行起来 就是一个 mysql instance

同一台 machine 允许运行多个 mysql instance
但是对于每个instance 来说， 都是一个独立的 mysql 服务， 因此必须 隔离开来， 包括： 不同的 data dir ，不同的进程编号， 不同的 tcp/ip 监听端口等， 总之， 类似于在多台machine上运行 mysql 服务；

mysql: client-server 设计

image.png

storage engine： with optimizer

The optimizer does not really care what storage engine a particular table uses, but the storage engine does affect how the server optimizes the query. The optimizer asks the storage engine about some of its capabilities and the cost of certain operations, and for statistics on the table data. For instance, some storage engines support index types that can be helpful to certain queries. You can read more about indexing and schema optimization in Chapter 4 and Chapter 5.

storage engine: statistics on the table data