LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices


Reply
  Search this Thread
Old 02-25-2005, 03:43 AM   #1
stoffell
Member
 
Registered: Apr 2003
Location: belgium
Distribution: debian
Posts: 72

Rep: Reputation: 15
multiple mysql servers on 1 server


I'm about to be using multiple mysql servers running on 1 server, the reason for this is, I want to use the replication feature of MySQL to replicate some masters to this 1 slave.. (the slave is a webserver of wich 'some' databases get populated by other MySQL servers)

I can start 1 server on port 3306 fine (each has it's own pid, sock and datadir), but when I want the 2nd (or 3rd, ...) server to start, the only way to get it working is by starting it from the command line (mysqld with all the options).

Am I overlooking anything or is there no easier (cleaner?) way? I have been looking through the dev.mysql.com site and found the use of 1 cnf is possible, but I cannot get the mysql init script adjusted properly.


Thanks for any hints..

Ps: distro is Debian sarge.
 
Old 03-01-2005, 08:28 AM   #2
stoffell
Member
 
Registered: Apr 2003
Location: belgium
Distribution: debian
Posts: 72

Original Poster
Rep: Reputation: 15
Ouch, it 'is' a tough question?
Any opinions or pointers more than welcome. (just start mysqld --with-parameters seems so 'dirty' to me)
 
  


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
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
Multiple servers acasaamj Linux - General 1 06-10-2005 01:09 AM
Multiple mysql server in linux wood Linux - General 1 02-19-2005 03:30 PM
Setting up multiple mail servers on one server tumana Linux - Newbie 5 03-12-2004 08:38 PM
multiple X servers acid_kewpie Linux - General 1 11-11-2001 04:06 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian

All times are GMT -5. The time now is 04:59 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration