英文:
Is there any reason for a beginner to use InnoDB when starting out with MySQL
问题
我正在自学SQL，并选择MySQL进行学习。我记得大学时有几门课程使用过MySQL，它似乎非常直观。
话虽如此，安装过程中询问我是否要使用InnoDB或者一个“独立的MySQL服务器”。我不明白描述这两个选项的术语。
独立是默认选项，可能是有充分理由的。然而，我想知道选择InnoDB的一些优势，用一个初学者能理解的方式来说明。我已经阅读了选项的描述，但不理解其中的术语。
所以问题是：从一个全新学习者能理解的角度来看，选择其中一个选项而不是另一个的一些优势是什么？
英文:
I'm teaching myself SQL, and have chosen MySQL to learn on. I think I remember a couple classes using MySQL back in college and it seemed pretty straight forward.
That being said, the installation wants to know if I want to use InnoDB or a 'Standalone MySQL Server'. I do not understand the jargon describing the two options.
Standalone is the default, and probably for good reason. However, I wanted to know some of the pros for going with InnoDB, in terms that a beginner can understand. Again, I have read the description of the options and do not understand the jargon.
So the question is: What are some of the pros of choosing one option over the other in terms that a brand new learner can understand?
答案1
得分: 0
数据库可以在单个服务器上组织（从一开始您可以选择）或者在集群中（如果您选择这样做，您还可以尝试使用多个服务器进行复制或仅仅是共享工作负载。
"InnoDB"这个术语是具有误导性的。
每个数据库和表都可以使用InnoDB。
关于InnoDB和MyISAM之间的区别有一个主要讨论：
https://stackoverflow.com/questions/20148/myisam-versus-innodb
来自MySQL网站的信息：
独立的MySQL服务器 / 经典的MySQL复制（默认）
选择此选项以配置一个MySQL实例作为独立的数据库服务器运行。如果您打算稍后设置经典复制，然后将此服务器包括在您的自定义解决方案中，这个选项是理想的。其余的配置步骤在接下来的部分中描述，从“类型和网络”开始。
和
InnoDB集群
选择此选项以创建或扩展基于MySQL Group Replication的InnoDB集群解决方案（请参阅介绍InnoDB集群）。您可以配置（或重新配置）至少三个服务器实例来执行一个基本设置，作为仅用于测试的沙盒集群，可以在单台计算机上或在本地网络内创建一个生产集群。
英文:
Databases can be organized in a single server(your choice for the start) or clusters( if you go all the way, you want also try to use Multiple servers for replication or simply to share the workload.
The term Innodb is missleading.
Every database and Table can be InNodb.
there is a main discussion what the diffrences betweEn innoDb aND M<ISAM ARE:
https://stackoverflow.com/questions/20148/myisam-versus-innodb
From the MySQL Website
>Standalone MySQL Server / Classic MySQL Replication (default)
>Select this option to configure one MySQL instance to run as a standalone database server. This option is ideal if you intend to set up classic replication later and then to include this server in your custom solution. The remaining configuration steps are described in the sections that follow, starting with Type and Networking.
And
>InnoDB cluster
>Select this option to create or extend an InnoDB cluster solution that is based on MySQL Group Replication (see Introducing InnoDB Cluster). You can configure (or reconfigure) a minimum of three server instances to perform a basic setup as a test-only sandbox cluster on a single computer or to create a production cluster inside a local network.
专注分享java语言的经验与见解，让所有开发者获益！
评论