MySQL and Acronis True Image

Discussion in 'Acronis True Image Product Line' started by raypo, Sep 27, 2006.

Thread Status:
Not open for further replies.
  1. raypo

    raypo Registered Member

    Joined:
    Sep 27, 2006
    Posts:
    3
    Hello All, we are having MySQL 5.0 using Innodb engine. Database size is about 2GB running on Windows 2000 server. We would like to find how best to use the Acronis True Image to backup the database on the 6hourly and daily basis. Here are some questions:

    Q1. We was told to use NET STOP MYSQL and NET START MYSQL and input into the before/after data capture commands. Can we use FLUSH TABLES WITH READ LOCK/UNLOCK TABLES instead?

    Q2. What is the duration of interruption the user will face with NET STOP/NET START? What is the duration of interruption the user will face with FLUSH TABLE?

    Q3. What other precaution we need to take beside backup all those binary logs?

    Thank you.
    Raymond.
     
  2. Ralph_D

    Ralph_D Registered Member

    Joined:
    Sep 27, 2006
    Posts:
    4
    We are in the same predicament since we use both MySQL and MS SQL and I rather backup the data while it is in use instead of stopping the services akin to what Veritas can do. Hopefully my query regarding files in use will be answered - https://www.wilderssecurity.com/showthread.php?t=148422
     
  3. raypo

    raypo Registered Member

    Joined:
    Sep 27, 2006
    Posts:
    3
    Here is an update....we have tested and the NET STOP and NET START as advised and it does not stop the MySQL services. Some process is holding it up therefore hold up the server.

    We are testing the FLUSH TABLE and see how well Acronis work with it. The other option we have will be to use mysqldump.

    Thanks.
     
  4. raypo

    raypo Registered Member

    Joined:
    Sep 27, 2006
    Posts:
    3
    Below is the part of the log on the error of NET START MYSQL which cause the backup not to work.

    <?xml version="1.0" encoding="UTF-8" ?>
    <log build="3666" product="Acronis True Image Enterprise Server" uuid="BDF0CF05-683A-4AB6-90B4-77DF2A54EC66" version="9.1">
    <event code="2" id="1" message="The &quot;WM8 Database Full Backup 12&quot; operation started" module="100" time="1159433261" type="2" />
    <event code="11" id="2" message="Priority changed to Low priority" module="100" time="1159433261" type="3" />
    <event code="120" id="3" message="Starting carrying out the before data capture command: net stop mysql" module="100" time="1159433263" type="2" />
    <event code="1023" id="4" message="System error occurred while executing: net stop mysql (0x103FF)
    Tag = 0x858CC05F488A8C54
    The system cannot find the file specified. (0xFFF0)
    code = FFFFFFFF80070002
    Tag = 0xBD28FDBD64EDB816" module="1" time="1159433264" type="3" />
    <event code="121" id="5" message="Carrying out of the before-data-capture command failed! Error code: 1" module="100" time="1159433264" type="4" />

    Hope that someone can tell me what is the problem with this. We tried the FLUSH TABLES WITH READ LOCK and it works fine.

    What is the impact between this two?

    Thanks.
     
Thread Status:
Not open for further replies.