Results 1 to 2 of 2

Thread: Help for a newbie

  1. #1

    Question Help for a newbie

    Hello Everybody,

    I am having a MySQL 5.0.22 on RHEL 3 Update 8. The tables are mostly MyISAM. At present we are not creating any binary logs.

    We are planning to use the community edition of Zmanda 2.0 to create backups of the databases and store them on a different server available on the LAN. After going through a few documents on Zamanda we are feeling a bit confused. The tasks that we want to accomplish are noted below. Will somebody kindly give us some hints on how we should go about the tasks?

    1) We need different backup schedule for different databases. Some should be backed up once a day. Others need more frequent backups.
    2) We would like to ensure that the database being backed up remains online (hot backup).
    3) We would prefer to have different retension policy for different databases.
    4) The backup being taken is to be stored on a server other than the server running the databases.
    5) To save on space we would like to have incremental backup.

    Kindly help us to do the proper configuration.

    With regards,

    Goutam

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Quote Originally Posted by goutambaul View Post
    Hello Everybody,

    I am having a MySQL 5.0.22 on RHEL 3 Update 8. The tables are mostly MyISAM. At present we are not creating any binary logs.

    We are planning to use the community edition of Zmanda 2.0 to create backups of the databases and store them on a different server available on the LAN. After going through a few documents on Zamanda we are feeling a bit confused. The tasks that we want to accomplish are noted below. Will somebody kindly give us some hints on how we should go about the tasks?

    1) We need different backup schedule for different databases. Some should be backed up once a day. Others need more frequent backups.
    You need to put them in different backup sets. For each backup set, you can specify a backup schedule.

    2) We would like to ensure that the database being backed up remains online (hot backup).
    You will have to use LVM snapshot or ZFS snapshot as the backup method.

    3) We would prefer to have different retension policy for different databases.
    For each backup set, you can specify retention policy. So all databases that require different policy should be in different backup set.

    4) The backup being taken is to be stored on a server other than the server running the databases.
    Yes. ZRM supports backups of databases on remote machines.

    5) To save on space we would like to have incremental backup.
    You will need to enable binary logs to take incremental backups.

    Take a look at the [URL=http://www.zmanda.com/zrm-over-internet.html]whitepaper[/URL] that discusses backups of remote MySQL servers.

    Paddy

Tags for this Thread

Posting Permissions

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