My personal suggestion is to find out more! Now on MySQL, InnoDB is basically the best choice under normal circumstances. Even on Mariadb, the default xtradb storage engine is also known as the upgraded version of Innodb! Therefore, I think anyone who studies databases should learn Innodb. For example, development, DBA, testing, operation and maintenance must all be learned. You said that you are already engaged in this field, do you need to do some training on the Innodb storage engine? learn? You only need to pay attention to your learning ability and time schedule to adjust the depth of Innodb learning!
To do mysql development, understanding of storage engines is necessary, such as innodb, myisam, memory, etc. Understand their advantages and differences, and you will know how to choose when applying them to actual application scenarios. When building a distributed storage system, it depends on your specific application scenario. For example, there is master-slave replication, and dual-master replication is a typical MMM architecture. Others include the MHA architecture. To go more in-depth, there are sub-databases and sub-tables.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Innodb is just a storage engine of MySQL. What you need to know about distributed storage depends on what storage solution you plan to use.
My personal suggestion is to find out more! Now on MySQL, InnoDB is basically the best choice under normal circumstances. Even on Mariadb, the default xtradb storage engine is also known as the upgraded version of Innodb! Therefore, I think anyone who studies databases should learn Innodb. For example, development, DBA, testing, operation and maintenance must all be learned. You said that you are already engaged in this field, do you need to do some training on the Innodb storage engine? learn? You only need to pay attention to your learning ability and time schedule to adjust the depth of Innodb learning!
To do mysql development, understanding of storage engines is necessary, such as innodb, myisam, memory, etc. Understand their advantages and differences, and you will know how to choose when applying them to actual application scenarios. When building a distributed storage system, it depends on your specific application scenario. For example, there is master-slave replication, and dual-master replication is a typical MMM architecture. Others include the MHA architecture. To go more in-depth, there are sub-databases and sub-tables.