Oracle Listener Like Functionality

[Sam Peterson]

We are designing a new solution and I have not been able to find
functionality anywhere in the MySQL documentation or literature.
 
With an Oracle database you can bring up the database, recover what is
needed, all while leaving the listener down.  The listener in Oracle
just allows clients to connect if it is up.  With the listener down no
external clients can connect to the DB.  Is there similar functionality
in MySQL?
 
Right now my work around is to bring up servers by default on a
different port than 3306 so that clients aren't connecting to a slave or
a master in a 'Not Ready' state.  Once the database is recovered then
I'm reconfiguring the port.  Has anyone else done something similar to
this?  I'm new to MySQL so any better suggestions would be appreciated.
 
Sam Peterson
 

Re: Oracle Listener Like Functionality

[Dan Nelson]

In the last episode (Apr 29), Sam Peterson said:
 We are designing a new solution and I have not been able to find
 functionality anywhere in the MySQL documentation or literature.
  
 With an Oracle database you can bring up the database, recover what
 is needed, all while leaving the listener down.  The listener in
 Oracle just allows clients to connect if it is up.  With the listener
 down no external clients can connect to the DB.  Is there similar
 functionality in MySQL?

Start it up with --skip-networking, and do your maintenance via the
Unix socket.  Another option is to use your OSes firewall software to
block port 3306 (this method doesn't require you to bounce mysql to
en/disable the port).

-- 
Dan Nelson
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]