First, you should ensure that your GRANT permissions get set correctly for each system.

Your connection handler will need to look after which database to connect to depending 
on the type of query you ask for. So whatever you are using, java, php C, that is what 
will have to organize such

> -----Original Message-----
> From: Orr, Steve [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 07, 2002 7:40 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL Replication
> 
> 
> What's the best way to lock down a slave to ensure that only 
> select SQL
> queries are executed and that all command line SQL inserts, 
> updates, and
> deletes are performed only on the master?
> 
> TIA
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to