How to do MySQL Community Edition tape backups

Instead of using mysqldump for taking backups from MySQL Community Edition you might want to try combining your tape backup system with pre - and postscripts which will do the as mysqldump

1. Execute tape backup system presscript which will
• log on as mysqlroot into mysql
• execute 'flush tables with read lock' - command
2. Do a file system backup or LVM snapshot of mysql /data
3. Execute tape backup system postscript which will
•   log on as mysqlroot into mysql
•   execute ‘unlock tables’ -command

Configuring SCAN and local listener for Active/Passive 11gr2 Oracle Grid Infrastructure cluster

1. Create cluster
• https://blogs.oracle.com/xpsoluxdb/entry/clusterware_11gr2_setting_up_an_activepassive_failover_configuration
• http://gjilevski.com/2012/01/09/build-active-passive-ha-configuration-for-single-instance-database-with-oracle-gi-11-2-0-3/
• http://mathijsbruggink.wordpress.com/2013/07/04/thoughts-on-adding-a-single-instance-to-oracle-clusterware-grid-infra/#more-308
2. Open firewall ports to application servers (if needed)
• I opened firewall ports to default TCP-1521 and to non-default port as my SCAN address was running on non-default port. 
3. Create TNS-entries for Database
• set SCAN-address as the hostname, use FQDN -name
4. Register scan address as remote_listener
5. Register local hostname as local_listener
• some servers can't understand 'localhost' so I used the servers real name e.g. dbserver-01.domain.fi
• there's an issue with this. Because active-passive cluster can failover, you must ensure that the the local_listener value is updated during failover in the ActionScript
6. Check output by 'lsnrctl services' from Database home, not GRID home.

You don't need to touch VIP-addresses at any point.