Be aware while backing up Mysql databases: triggers are included by default but NOT the stored procedures/functions. Do not forget to add the –routines switch when running a backup. mysqldump -u user -p my_database –routines backup.sql Check your backup scripts before running into a disaster recovery.
It is generally good practice to respect the two following points when backing up databases. The backup has to be: consistent fast Consistency is easily achieved putting a read lock on all tables beforehands. However, this isn’t always applied, and WILL definately lead to a database integrity problem at some stage. Once a lock has […]
This is related to Freeradius software but can be applied to any application that needs to encrypt Mysql traffic. Freeradius is compliant to Radius protocol characteristics, which give ability to accomplish various actions, such as authenticate users. Number of caveats have been found, not related to the software but to the protocol. Joshua Hill from […]