Data Storage

Most of the sites we develop involve database programming. DDA programmers (myself included) commonly use MySQL Databases. MySQL has a many configurable options (i.e. what type of storage engine). We use many tools to manipulate table structures, fields, and data such as DBTools Manager Professional, PHPMyAdmin, Microsoft SQL Server Management Studio, and MYSQL Administrator. We mostly use the default one MyIsam or InnoDB, which is currently very popular. Since it is important that databases function properly at all times, we perform several backups throughout the day and perform weekly off-site backups to ensure that if information is deleted accidentally or the data gets corrupted, the records can be restored.