LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 10-28-2011, 10:47 AM   #1
jason.rohde
Member
 
Registered: Aug 2005
Location: Chicago
Distribution: RHEL5,CENTOS
Posts: 62

Rep: Reputation: 15
mysqld_multi errors when starting servers, servers start when run manually


I am setting up multiple instances of mysql 5.5 server on a single host and trying to manage the instances using the mysqld_multi tool. Ia m able to get each instance to run without issue when I start each manually via nthe following command.

Code:
mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/$HOSTNAME.pid --socket=/var/lib/mysql/mysql.sock --port=3306 &
  
mysqld_safe --datadir=/usr/local/mysql/var2 --pid-file=/usr/local/mysql/var2/$HOSTNAME.pid2 --socket=/tmp/mysql.sock2 --port=3308 &

mysqld_safe --datadir=/usr/local/mysql/var3 --pid-file=/usr/local/mysql/var2/$HOSTNAME.pid3 --socket=/tmp/mysql.sock3 --port=3309 &
Code:
 netstat -ntpl | grep mysql
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LIS
tcp        0      0 0.0.0.0:3308                0.0.0.0:*                   LIS
tcp        0      0 0.0.0.0:3309                0.0.0.0:*                   LIS
I have also verified seperate instances are running using ps -eaf, but will spare you the output.


When I try to run them with the mysqld_multi I get:

Code:
 mysqld_multi start 1-3 --verbose 
WARNING: mysqld_safe is being used to start mysqld. In this case you may need to pass
"ledir=..." under groups [mysqldN] to mysqld_safe in order to find the actual mysqld binary.
ledir (library executable directory) should be the path to the wanted mysqld binary.
/etc/my.cnf
Code:
[mysqld_multi]
mysqld         =/usr/bin/mysqld_safe
mysqladmin     =/usr/bin/mysqladmin

[mysqld1]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K


[mysql2]
socket          =/tmp/mysql.sock2
port            =3308
pid-file        =/usr/local/mysql/var2/$HOSTNAME.pid2
datadir         =/usr/local/mysql/var2

[mysql3]
socket          =/tmp/mysql.sock3
port            =3309
pid-file        =/usr/local/mysql/var3/$HOSTNAME.pid3
datadir         =/usr/local/mysql/var3
any tips to help trouble shoot this or configuration pointers would be appreciated
 
Old 10-29-2011, 05:29 AM   #2
vasile002
Member
 
Registered: Oct 2011
Posts: 51

Rep: Reputation: Disabled
I believe the problem is that you missed the "d" letter from the 2nd and 3rd mysqld groups:
[mysqld2]
[mysqld3]

Please try that
 
Old 10-29-2011, 08:18 AM   #3
jason.rohde
Member
 
Registered: Aug 2005
Location: Chicago
Distribution: RHEL5,CENTOS
Posts: 62

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by vasile002 View Post
I believe the problem is that you missed the "d" letter from the 2nd and 3rd mysqld groups:
[mysqld2]
[mysqld3]

Please try that
Everything I read implied that the 'd' wasn't necessary, I tried it and get the same error..back to the drawing board.
I appreciate the help though
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Are IBM servers the Best Servers, for a music download website.? mixhypnatist General 30 09-16-2009 09:26 PM
Starting multiple X servers prashant112358 Linux - Newbie 4 05-21-2009 02:23 AM
Problem starting multiple X Servers rh_bomani Linux - General 1 07-13-2006 10:01 PM
Starting servers sathyan *BSD 5 05-03-2003 09:04 AM


All times are GMT -5. The time now is 04:25 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration