Results 1 to 3 of 3

Thread: mysql question

  1. #1
    Join Date
    Mar 2003

    mysql question

    This question might have an obvious answer but I want to know how you guys would handle this.

    I want to run resource intensive queries on my production database, without affecting its overall performance.

    One solution I have which I had not implemented yet includes the following

    1. Disable ability to preform inserts/updates for said site/feature on the production database
    2. Replicate the databse to a different server.
    3. Run my queries on the replica db.
    4. Replicate these changes to the master.
    5. Re-enable insert/update ability on said site/feature

    What are your ideas or solutions?

  2. #2
    Join Date
    Dec 2005
    See the below link to know moreabout mysql replication.
    Senior Server Administrator

  3. #3
    Join Date
    Mar 2003
    Quote Originally Posted by linuxcares
    See the below link to know moreabout mysql replication.
    Yes I am well versed on using the MySQL manual, thanks for asking. This is not the kind of response I was looking for, but I guess I should have known better.

Posting Permissions

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