Hello Gleb,
thanks for your hint - I will try this workaround to get the replication up and running.
Is there a point on your TODO-List that sounds like 'splitting binary logs per database to enable replicating a single database instead of transfering Gigs of traffic and using only few bytes of it'? :-)
It also would be very useful to add a feature on the master to define which databases/tables should or shouldn't be logged into the bin-log.
Greetings from Germany
Lutz
----- Original Message ----- From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 09, 2004 3:49 PM
Subject: Re: How to bring up local replication / socket-error
Hello.
See: http://bugs.mysql.com/bug.php?id=3310
"Lutz Maibach" <[EMAIL PROTECTED]> wrote:Hi,
I'm trying to set up a replication client on the same server as the
master is running. Master is port 3306 and its socket
/mymaster/mysql.sock. I set up the repl-client to connect to localhost
(tried the ip-address too) on port 3306.
When I start the replication I get the following error:
Error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)' errno: 2002
The question is how to tell the replication client that the right socket
is located in /mysqlmaster. I tried to set a symbolic link from
/tmp/mysql.sock to mysqlmaster.sock but only got a fatal error 1236:
"Could not open logfile.."
Help would be appreciated
Greetz from Germany
Lutz Maibach
P.S: I only try to get up this strange looking constellation cause I
have to replicate a single database from the master to a customers
server. The customer may not have a look at the other databases running
on the master, but with normal replication he would get all the data
into his relaylog. So I want to replicate the customers database to the
local replication and the the customers server to replicate this local
replication where only his data is stored in the binlog.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
