Re: how to check which mysql server deals with SQL requests?

------=_Part_568_953919958.1268397014453
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

You can ask the server its name.

admin@linux14 (none)> show global variables like 'hostname';
+---------------+---------+
| Variable_name | Value   |
+---------------+---------+
| hostname      | linux14 |
+---------------+---------+
1 row in set (0.00 sec)
Cheers,

Ronald.

Op vrijdag, 12 maart 2010 07:31 schreef mqboss <[email protected]>:
> 
>  
> 
> Hi all, 
>  
> I want to test the mode of Master/Slave for mysql.
> Also I want to separate the write and read of sql requests, that is, I want to make Slave server of mysql to handle read requests and make Master server to handle write requests.
>  
> I configured the JDBC URL as "jdbc:mysql:replication://master,slave1,slave2/test" to implement the separation of write/read, I want to check whether it works. So I need to know how to check which mysql server deals with SQL requests. 
> 
> My question is about it, could you tell me how to check which mysql server deals with SQL requests? 
> Please give me some advice.
> 
> Thanks,
> Peter
> 
> 
> 
> 


------=_Part_568_953919958.1268397014453--