Hello,
we use Solidworks 2011 SP3 in combination with MaxxDB / (-->MySQL Community Edition; MS Srv. 2003) and backup our database
daily with the 'mysqldump.exe' - utility which is included in MySQL.
Now we are thinking about a solution that makes it possible to restore the data without losing a whole workday. A possibility would be
using the MySQL-Engine 'InnoDB' instead of 'MyISAM' in combination with 'percona-xtrabackup' which supports hot-backup without table locking. So users could work without interuption during the backup is done. The problem here is that MaxxDB doesn't work transactional, so the supports doesn't recommend the use of 'InnoDB'.
A second possibility would be setting up a Master/Slave - Replication which comes with more administrative work and leads to a more
complex environment as side-effects.
What Backup-Strategy for the database is recommenced in such an environment.
How do you archieve it?
Best Regards,
SolidworksGeneral