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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql