I have a VoIP server running 24x7. At low peak hour at lease 150+ users are connected. My server has MySQL running with InnoDB engine on Windows 2008 platform. I like to take at least 2 times full database backup without shutting down my service.
As per Peter Zaitsev - the founder of percona, mysqldump –single-transaction is not always good.
As I'm not a DBA, I like to know in my scenario, which would be best solution to take a database backup?