Results 1 to 4 of 4

Thread: Hi

  1. #1
    Join Date
    Jan 2004
    Posts
    3

    Unanswered: Hi

    Hi

    Can anybody tell me what are the possible causes when a client update request to a server fails..

    Some of the ones i suppose r

    1 Master server down
    2 Link Failure
    3 Update Request query syntax invalid

    Any more.................

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Login does not exist - permissions issue, database offline/suspect/corruption, locking issues...

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    I read your other post about replication concerns - do you have problems now ?

  4. #4
    Join Date
    Jan 2004
    Posts
    3
    Hi

    thnx a lot sir for responding to my second query...as far as the first is concened i am still facing the same problems...

    I understand the concept of master n slave relationship but have certain queries regarding this...

    1) In case the master is down i do i configure my sysem so that a present active slave becomes the master or any other way to tackle this situation.How does the clients know about this new server being set as the master .

    2)The master is run as a myslq demon . Now the slaves though being servers ..are run as clients of the master server with a definate usernme who has been granted REPLICATION SLAVE PERMISSion set at the master server??

    i.e do i run the slaves as mysql -h xxx -u xxxx -p ?? --mysql client ?

    3)Is it necessary t take a snapshot of the datadir at the serer , for the first time i set up replication ?/?


    Kindly help me out
    Thnx
    Varun

Posting Permissions

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