Sign In
Register
Help
G'Evening ...
Urgent need to know how to access a mysql database, using a named pipe.
My situation:
* 2 servers : server1 - ip1 / server2 - ip2
* with 2 databases DB_clt and DB_serv
* sja.exe (version 5.15) with xml configuration files
The "DB_clt" has a mysql service named Mysql_db2 listening on port 3301
and the "DB_serv" is used by a software, which access it by a named pipe : named "MYSQL".
I'd like to synchronize my 2 databases, but i don't know how should i put the named pipe parameter; and not even know if SJA support this ... hope it is!
PS: i've tried to put the name of the pipe in stead of the port number, doesn't work.
i've thinkied about the http tuneling, but i don't know if it will work and how should i do.
Hope i'll hear from you asap. Thx
Best Regards
MuphoOx
Page 1 of 1
Help About Sja & Named Pipe ...
MultiQuote
#2
peterlaursen 
- Advanced Member
-
- Group: Admin
- Posts: 6,551
- Joined: 01-June 03
- Gender:Male
- Location:Skagen, Denmark
- Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!
Posted 30 August 2006 - 03:23 PM
SQLyog and SJA only connects to MySQL using TCP-IP and neither 'named pipes' (on Windows) or 'socket' (on *nix)
You have some other software using a 'named pipe' on port 3301. However that should not prevent you from using TCP-IP too on (typically) port 3306.
Is the Server configured not to used TCP-IP? Any particular reason for that? You can cooment-out 'disable-networking' in MySQL cofiguration then (you will need to retart the server).
BTW: I think that it is well known that 'named pipes' on Windows are less efficient that TCP. On some *nix systems 'socket' is most efficient.
You have some other software using a 'named pipe' on port 3301. However that should not prevent you from using TCP-IP too on (typically) port 3306.
Is the Server configured not to used TCP-IP? Any particular reason for that? You can cooment-out 'disable-networking' in MySQL cofiguration then (you will need to retart the server).
BTW: I think that it is well known that 'named pipes' on Windows are less efficient that TCP. On some *nix systems 'socket' is most efficient.
Computers make your grey hair come off ....
Peter Laursen
Webyog
Peter Laursen
Webyog
#3
MuphoOx
- Member
-
- Group: Members
- Posts: 17
- Joined: 28-August 06
- Location:Paris - France
Posted 30 August 2006 - 03:51 PM
thx for your answer, Peter;
i was writing an update of this situation ...
actually, i've changed the parameters; i've commented-out 'disable-networking' in MySQL and used a tcp port, and have put a 'bind-address=127.0.0.1' clause to keep my server secure.
I was using the "named pipe" 'cause our clients when they have a firewall, it block the communication port of mysql, so no more connexion to the data base is possible; then the software is not working... and the client complain ...
. The named pipe was used cause it doesn't use any communication port ...
Anyway, with the bind-address, the sync job works well; but i have to find a solution to avoid the firewall... or to add a rule on every well knwon firewall.... but it's an other task...
i was writing an update of this situation ...
actually, i've changed the parameters; i've commented-out 'disable-networking' in MySQL and used a tcp port, and have put a 'bind-address=127.0.0.1' clause to keep my server secure.
I was using the "named pipe" 'cause our clients when they have a firewall, it block the communication port of mysql, so no more connexion to the data base is possible; then the software is not working... and the client complain ...
. The named pipe was used cause it doesn't use any communication port ...Anyway, with the bind-address, the sync job works well; but i have to find a solution to avoid the firewall... or to add a rule on every well knwon firewall.... but it's an other task...
Page 1 of 1