You need to start 2 instances of mysqld both on different ports and
different datadirs.
I recommend reading Paul Dubois MySQL second Edition- The definitive
guide to using, programming, and administering mysql 4 databases.
He has a section on replication + running multiple instances of mysqld.
---Original Message-
--From: Vico Timmermans [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, May 27, 2003 8:51 AM
--To: [EMAIL PROTECTED]
--Subject: replication - master and slave on the same computer
--
--
--Hi list,
--I have a question about replication in MySQL.
--I have mysql 4.0.12 (master and slave) on windows 2000.
--
--Can I make master and slave on the same computer?
--
--If I have the master on disk c, and the slave on disk d:
--1) When do I put the my.ini file of the slave?
--2) How can I stop and start the slave server? If I run the command
NET
--STOP
--Mysql it stop the server on disk c..
--
--Thanks very much
--Inbal
--
8
--
--I think it should be possible. Trying the same thing here
--under linux with a config like this:
--
--[mysqld_multi]
--mysqld = /usr/bin/safe_mysqld
--mysqladmin = /usr/bin/mysqladmin
--user = user
--password = pass
--
--[mysqld1]
--datadir = /var/lib/mysql
--socket = /var/lib/mysql/mysql.sock
--port= 3306
--pid-file= /var/lib/mysql/hostname.pid
--skip-locking
--skip-innodb
--set-variable= max_connections=300
--set-variable= key_buffer=512M
--set-variable= max_allowed_packet=1M
--set-variable= table_cache=384
--set-variable= sort_buffer=128M
--set-variable= join_buffer_size=64M
--set-variable= record_buffer=512M
--set-variable= net_buffer_length=8K
--set-variable= myisam_sort_buffer_size=256M
--log-bin
--server-id = 1
--
--[mysqld2]
--datadir = /var/lib/mysqlrep
--socket = /var/lib/mysqlrep/mysql.sock
--port= 3307
--pid-file= /var/lib/mysqlrep/hostname.pid
--skip-locking
--skip-innodb
--set-variable= max_connections=300
--set-variable= key_buffer=512M
--set-variable= max_allowed_packet=1M
--set-variable= table_cache=384
--set-variable= sort_buffer=128M
--set-variable= join_buffer_size=64M
--set-variable= record_buffer=512M
--set-variable= net_buffer_length=8K
--set-variable= myisam_sort_buffer_size=256M
--master-host = localhost
--master-user = repl
--master-password = password
--master-port = 3306
--server-id = 2
--replicate-do-db = nuria
--replicate-ignore-db = mysql
--
--[mysql.server]
--user=mysql
--basedir=/var/lib
--
--[safe_mysqld]
--err-log=/var/log/mysqld.log
--pid-file=/var/run/mysqld/mysqld.pid
--
--
--
--
--HOWEVER, although it seems to try and replicate there must still
--be something with this config, because i can run both daemons but
--not at the same time. E.g. mysqld_multi start 1 works fine but
--when I start the second the errorlog shows me this:
--
--
--030527 17:26:14 mysqld started
--/usr/libexec/mysqld: ready for connections
--030527 17:26:14 Slave thread: error connecting to master: Access
denied
--for user: '[EMAIL PROTECTED]' (Using password: YES) (0), retry in 60 sec
--mysqld got signal 11;
--This could be because you hit a bug. It is also possible that this
binary
--or one of the libraries it was linked against is corrupt, improperly
--built,
--or misconfigured. This error can also be caused by malfunctioning
--hardware.
--We will try our best to scrape up some info that will hopefully help
--diagnose
--the problem, but since we have already crashed, something is
definitely
--wrong
--and this may fail
--
--key_buffer_size=536866816
--record_buffer=536866816
--sort_buffer=134217720
--max_used_connections=0
--max_connections=300
--threads_connected=0
--It is possible that mysqld could use up to
--key_buffer_size + (record_buffer + sort_buffer)*max_connections =
4193097
--K
--bytes of memory
--Hope that's ok, if not, decrease some variables in the equation
--
--Attempting backtrace. You can use the following information to find
out
--where mysqld died. If you see no messages after this, something went
--terribly wrong...
--Cannot determine thread, fp=0x4001f40c, backtrace may not be correct.
--Stack range sanity check OK, backtrace follows:
--0x80e345c
--0x4007d618
--0x
--0x80e3a5b
--0x400782b6
--0x420de407
--New value of fp=(nil) failed sanity check, terminating stack trace!
--Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and
--follow
--instructions on how to resolve the stack trace. Resolved
--stack trace is much more helpful in diagnosing the problem, so please
do
--resolve it
--The manual page at http://www.mysql.com/doc/C/r/Crashing.html
contains
--information that should help you find out what is causing the crash
--
--Number of processes running now: 0
--
--
--
--Still looking into it.. Let me know when you find out anything.
--
MySQL General Mailing List
For list