Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Posts
    8

    Unanswered: Delay in Master/Slave

    Hello,
    I just set up a master/slave in mysql and i had a php script which i benchmarked at 0.6 - 1 second when mysql and php are running on the same host.
    Then i configured the script to connect to the slave server and ran the script again the execution reached 5 seconds. Is that normal ?? Or is probably my hardware which needs to be upgraded ?

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    168

    Re: Delay in Master/Slave

    It really matters what kind of connection you ar using and the query or the script you are running.
    Please specify what kind of Master/Salve is your server, The medium of connection between them.

    Rajesh

    Originally posted by manjitr
    Hello,
    I just set up a master/slave in mysql and i had a php script which i benchmarked at 0.6 - 1 second when mysql and php are running on the same host.
    Then i configured the script to connect to the slave server and ran the script again the execution reached 5 seconds. Is that normal ?? Or is probably my hardware which needs to be upgraded ?

  3. #3
    Join Date
    Jan 2004
    Posts
    8
    the server is a pentium III 1.4Ghz and the slave is a Pentium II 600Mhz .. and are connected on a LAN by a cisco catalyst 1900.

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    168
    Your network don't seems to be slow, but the fact that the script is running through the network, matters. So I don't think there is any problem with your hardware. Normally the scripts running on the network takes little more time than on the Master. A lot of other services are involved when you run throught a network, os that may be the reason you script takes 5 seconds on the slave.

    Rajesh


    Originally posted by manjitr
    the server is a pentium III 1.4Ghz and the slave is a Pentium II 600Mhz .. and are connected on a LAN by a cisco catalyst 1900.

  5. #5
    Join Date
    Jan 2004
    Posts
    8

    so what else could it be ?

    tried pinging and all round trips were less than 1ms. the slave is running windows OS.. could that be it ?

  6. #6
    Join Date
    Jan 2004
    Location
    India
    Posts
    168

    Re: so what else could it be ?

    Yes that would be the probable reason.
    You may be knowing that windows OS is quiet slower than linux or rest. Windows uses lots of unwanted servies that makes the browsing or running the query through the network slower. Try installing a client for MYSQL on your slave and try executing the queries through the client or use telnet to coonect to your Master and execute some big queries in that check for the time in both master and slave

    Rajesh

    Originally posted by manjitr
    tried pinging and all round trips were less than 1ms. the slave is running windows OS.. could that be it ?

  7. #7
    Join Date
    Jan 2004
    Posts
    8
    sounds like a good idea..
    will try that.

  8. #8
    Join Date
    Jan 2004
    Posts
    8
    thanx by the way..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •