Fedora Linux Support Community & Resources Center
  #1  
Old 4th October 2007, 04:54 AM
warnockm Offline
Registered User
 
Join Date: Aug 2004
Posts: 36
help with mysqld_multi

I'm running Fedora 7, and i've been running mysql for a while. My server has 2 IP addresses, and would like to run two instances of mysql, one on each IP address. I am using the [mysqld_multi] group in my.cnf. I use [mysqld] and [mysqld2] for my two server settings. I'm using the canned init.d script to start mysqld. When i start mysql, the server starts, but it is only binding to the first IP. How do i get [mysqld2] running? also, when i run ps ax | grep my, i see mysqld_safe and mysqld running. Here is my my.cnf:

[mysqld_multi]
mysqld = /usr/libexec/mysqld
mysqladmin = /usr/bin/mysqladmin
user = mysql

[mysqld]
#mysqld=/usr/libexec/mysqld
#mysqladmin=/usr/bin/mysqladmin
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
pid-file = /usr/bin/mysql/hostname.pid
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_allowed_packet=32M
bind-address=192.168.0.60
#user=mysql

[mysqld2]
#mysqld=/usr/libexec/mysqld
#mysqladmin=/usr/bin/mysqladmin
datadir=/var/lib/mysql-dev
#socket=/var/lib/mysql/mysql-dev.sock
## Default to using old password format for compatibility with mysql 3.x
## clients (those using the mysqlclient10 compatibility package).
#old_passwords=1
#max_allowed_packet=32M
pid-file = /usr/bin/mysql/hostname-dev.pid
bind-address=192.168.0.62
#user-mysql

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Reply With Quote
  #2  
Old 5th October 2007, 01:18 PM
warnockm Offline
Registered User
 
Join Date: Aug 2004
Posts: 36
i changed [mysqld] to [mysqld1] and tried using the "mysqld_multi start 1" and 2, but still can't get both databases working. Does my.cnf look correct?
Reply With Quote
Reply

Tags
mysqldmulti

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


Current GMT-time: 11:20 (Thursday, 23-05-2013)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat