4.8 MySQL Planning

4.8.1 My SQL Disk Space Sizing

To determine the database size required, do the following:

  1. Allocate 25 GB as a base.

  2. Allocate 30 KB for indexed Net Folders.

  3. Allocate 20 KB for non-indexed Net Folders.

  4. Allocate 10 KB per user.

Formula

(F * 30 KB * indexed_NF )+(F * 20 KB * non-indexed_NF)+(U * 10 KB)=Size

Key:

  • F=Number of Files

  • NF=Net Folders

  • U=Number of Users       

Sample Organization Numbers

1,000,000 files (75% indexed; 25% non-indexed) and 1,000 users

Sample MySQL Database Estimate

750,000 files * 30 KB = 22,500,000 KB

250,000 files * 20 KB =  5,000,000 KB

1,000 Users * 10 KB = 10,000 KB

Initial Estimate of Database size is 26 GB.

4.8.2 MySQL Deployment Recommendation

The MySQL appliance is delivered to help you get started with the Filr system.

If you have an in-house Database Administrator and an enterprise MySQL installation, Novell recommends that you leverage that resource and take advantage of your existing infrastructure. Filr supports MySQL 5.0.96 through 5.5.x.