List:General Discussion« Previous MessageNext Message »
From:Machiel Richards - Gmail Date:November 1 2012 10:28am
Subject:Mysql backup for large databases
View as plain text  
Hi All

      I am busy investigating some options relating to the backup for 
MySQL databases when they get quite large.

     When using the MySQL enterprise, there is the option to use the 
MySQL enterprise backup as it is part of the Enterprise license.

         However, when using the GA (freely available) versions, the 
options for backups on large databases seems to be a bit limited.

         Using mysqldump and restores on an 80-100GB database seems a 
bit unpractical as the restore times seems to get quite long as well as 
the backup times.



     Does anybody have some ideas on backup strategies that can be 
investigated in this regard?

     Just for information, the data in these databases are very crucial 
data and thus up to 2 years of data needs to be kept in the database for 
easy retrieval and thus archiving is limited to data older than 2 years 
while the database receives about 1mil entries per day.


     Any ideas would be appreciated.

Regards
Thread
Mysql backup for large databasesMachiel Richards - Gmail1 Nov
  • Re: Mysql backup for large databasesDimitre Radoulov1 Nov
  • Re: Mysql backup for large databasesReindl Harald1 Nov
    • RE: Mysql backup for large databasesRick James1 Nov
      • Re: Mysql backup for large databasesSinger Wang1 Nov
        • Re: Mysql backup for large databasesReindl Harald1 Nov
          • Re: Mysql backup for large databasesSinger Wang1 Nov
            • Re: Mysql backup for large databasesReindl Harald1 Nov
              • Re: Mysql backup for large databasesmachiel.richards1 Nov
  • Re: Mysql backup for large databasesKaren Abgarian1 Nov
    • Re: Mysql backup for large databasesManuel Arostegui2 Nov
  • Re: Mysql backup for large databasesKaren Abgarian2 Nov
Re: Mysql backup for large databasesReindl Harald1 Nov
RE: Mysql backup for large databasesRick James1 Nov