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.
