一台机器上的多个MySQL实例 [英] Multiple MySQL instances on a single machine

问题描述

如何在一台机器上配置多个MySQL实例?网络上有很多信息，但是它们不是很有用.

How to configure multiple MySQL instances on a single machine? There are a lot of information on the web, but they are not very useful.

我正在寻找一个可以指导我从头到尾的教程，而不是只有具有多年MySQL管理经验的人才能理解的常规信息.我希望能得到自给自足的答案或指针，也就是说，不需要从用户的角度来了解很多知识，而不是模糊的引用.

Instead of generic information that can only be understood by a mind with years of MySQL administrative experience, I am looking for a tutorial that guides me from begin to end. I would appreciate answers or pointers that are self-sufficient, i.e., don't require a lot of knowledge from the user's part, instead of obscure references.

推荐答案

好的，应该以与编程无关的问题结束此问题，这确实是即将到来的姐妹"网站的问题，但我将尝试并继续回答.现在，我从未使用过MySQL，也许有人可以做一个更好的答案.

OK, this question should be closed as not-programming-related, this is really a question for the upcoming "sister" site but I'm going to try and answer it anyway. Now I've never used MySQL and someone can probably do a better answer.

让我们以(5分钟后...只略读了几份结果后决定跳水)

(5 mins later... decided to take the plunge after only skim reading a couple of results)

• 下载+安装mysql基本软件包(mysql-essential-5.1.30-win32.msi)
• 运行配置向导
• 再次运行配置向导(修改数据库路径，端口号)
• 看看 http://dev. mysql.com/doc/refman/5.1/en/multiple-windows-services.html
• 看看my.ini(和备份)
• 确定我需要复制数据目录并将ini与备份ini文件合并，并且不需要运行配置向导两次.

















• 合并ini文件，修改服务名称
• 运行命令:mysqld --install mysql1，mysqld --install mysql2，net start mysql1，net start mysql2

• download + install mysql essential package (mysql-essential-5.1.30-win32.msi)
• run configuration wizard
• run configuration wizard again (modifying db path, port no)
• take a look at http://dev.mysql.com/doc/refman/5.1/en/multiple-windows-services.html
• take a look at my.ini (and the backup)
• figure out that I need to make a copy of the data dir and merge ini with backup ini file and didn't need to run the config wizard twice. Should have just edited the INI to begin with (but that would require reading the manual.. too much work! Ini file is pretty well documented anyway though)
• merge ini files, make service name modifications
• run commands: mysqld --install mysql1, mysqld --install mysql2, net start mysql1, net start mysql2

20分钟，完成.

现在我们有逐步的说明，用于在一台计算机上运行多个MySQL实例，下次任何人搜索它时，它可能会作为google中的第一个结果出现；)

Now we have step by step instructions for running multiple MySQL instances on a single machine, which will probably turn up as the first result in google next time anyone searches for it ;)

这篇关于一台机器上的多个MySQL实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！