Bug 171852
| Summary: | [PATCH] databases/mysql55-server: add support for multiple instances (profiles) | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Ports & Packages | Reporter: | Frank Wall <freebsd> | ||||||
| Component: | Individual Port(s) | Assignee: | Alex Dupre <ale> | ||||||
| Status: | Closed Feedback Timeout | ||||||||
| Severity: | Affects Only Me | CC: | eugen, freebsd, pi, w.schwarzenfeld | ||||||
| Priority: | Normal | ||||||||
| Version: | Latest | ||||||||
| Hardware: | Any | ||||||||
| OS: | Any | ||||||||
| Attachments: |
|
||||||||
Responsible Changed From-To: freebsd-ports-bugs->ale Over to maintainer (via the GNATS Auto Assign Tool) Hi,
>>Category: ports
>>Responsible: freebsd-ports-bugs
>>Synopsis: [PATCH] databases/mysql55-server: add support for
>> multiple instances (profiles)
>>Arrival-Date: Fri Sep 21 18:50:08 UTC 2012
attached is an updated version of the original patch.
Few more changes were required to make it work in
real world.
Bye
- Frank
@Alex Dupre: Any objections? It's basically the same functionality we have in the postgresql ports for several years. I would like to see this included in the mysql server ports. I'd be willing to provide updated patches for all current mysql-server ports if the assignee/maintainer agrees to add this functionality. (In reply to Frank Wall from comment #5) If you are still in position to supply patches for modern MySQL server version, I'd suggest you fill new distinct PR for never version of server having another maintainer so it would aware of your patches. Maintainer feedback? Submitter and maintainer feedback timeout. |
This patch adds support for multiple MySQL instances ("profiles"). It's based upon the profile support in databases/postgresql91-server. It does NOT violate POLA, because the ports works the same until you define mysql_profiles="a b c" in /etc/rc.conf. This patch changes two things among the profile support: 1.) Add "mysql_bindip" tunable to allow profiles to bind to different IP addresses. It defaults to 0.0.0.0, just like not defining it at all. 2.) Add "mysql_port" tunable to allow profiles to listen on different TCP ports. It defaults to 3306, of course. 3.) In case profile support is enabled, make sure either "mysql_bindip" or "mysql_port" is defined to avoid having multiple profiles using the same (conflicting) default configuration. You may wonder: "Why add profile support? There is mysqld_multi included!" Well, mysqld_multi does not handle startup and shutdown of instances on system startup/shutdown. The approach of using profiles will just do that. And it's proven to work, since profiles are already used in databases/postgresql91-server and www/apache22. In case you agree to commit this patch I would provide a patch for databases/mysql51-server with a new PR. Fix: Patch attached with submission follows: How-To-Repeat: apply the patch