I have a MySQL master-master replication with second master in read-only mode. My questions reg backup are:
I have 10 databases so should I take daily backup as one dump containing all the databases, if yes when restoring will I be able to restore each database from the full dump which has all the databases? Or taking one db at a time is the good way to go?
Should I take backup from active master or read-only master? If read-only master is the case, then what if before the replication had broken and the backup has been taken from read-only - it will not have the updated data until the replication is active again right? So backing up from active master is fine?
How to go about backing binary logs since im not aware of it much.? What is the process to take binary log backup.?