New users considering switching to Bacula are often curious about how large other Bacula installations are: how many clients, how much data is being backed up, how large the catalog database gets, etc. While such questions usually get one or two people answering, I thought it would be nice to try and generate a quantitative set of data to give people a clearer picture.
This perl script will run a handful of queries against your catalog, and print the resulting statistics. Open the script file, and edit the first few lines to reflect your configuration, including the database username, password, and driver. It was written and tested against MySQL 4.1, but uses standard SQL so should work against other engines.
If you would like your results to be included, you can either add yourself to the list below or just email them to me directly at the email address at the bottom of the page (note the anti-spam obfuscation). Please include the output of the script, along with the version of bacula and basic statistics of the servers you are running your storage daemon and catalog on (operating system, CPU, memory), and what kind of and version database you are running (MySQL, Postgresql, SQLite).
— Frank Sweetser 2006/01/29 16:56
These are just a few preliminary results, thrown up by hand, to give a flavor of what the final results will look like. The finished product should also have some basic statistics, sorting, etc.
Bacula Version | Data Backed Up | Clients Backed Up | File Table Size (rows) | Database | Server |
---|---|---|---|---|---|
5.0.1 | 600 GB | 14 | 120,421,825 | MySQL 5.0.26 | SLES 10 SP2 (x86_64) 2.6.16.60-0.21-smp, SunFire X2100, Dual-Core Opteron, 2GB RAM, LTO-4 |
3.0.2 | 579 GB | 29 | 5157539 | MySQL 5.0.26 | SLES 10 (i586) 2.6.16.46-0.12-bigsmp, 4x Intel(R) Xeon(R) CPU 5120 @ 1.86GHz, 4 GB RAM |
3.0.2 | 536 GB | 11 | 3529875 | 5.0.51a-24+lenny2 (Debian): Mysql | Debian Lenny, Kernel 2.6.18-6-xen-amd64, 1x Intel(R) Xeon(R) CPU 5110 @ 1.60GHz, 1 GB RAM |
2.4.3 | 634 TB | 869 | 1,787,983,209 | Postgresql 8.3 | Linux 2.6 Debian Lenny 8x2Ghz Xeon 12GB RAM |
2.0.3 | 1.95 TB | 67 | 627,800,732 | MySQL 4.1.20 | RHEL 4 ProLiant DL385 G1 AMD Opteron 6GB RAM |
3.0.2 | 94.1 TB | 222 | 114,205,399 | PostgreSQL 8.1.11 | Debian Etch 2x Intel(R) Xeon(TM) Dual Core HT 3Ghz (8 logical Cores), 4GB RAM |
2.0.3 | 993 GB | 124 | 39,405,723 | MySQL 5.0.27 | SLES 9 HP DL380, Intel(R) Xeon(TM) CPU 3.20GHz with 3GB RAM |
3.1.4 | 513 GB | 16 | 16,722,868 | MySQL 5.0.45 | Linux 2.6 500Mhz Athlon 512M RAM |
1.38.4 | 23 GB | 8 | 2,951,916 | PostgresQL 8.1.2 | FreeBSD 6.0 dual 2.8G Xeon 1G RAM |
2.0.2 | 579 GB | 24 | 3,576,838 | MySQL 5.0.27 | FC 6 quad 3.3G Xeon 4G RAM |
1.38.2 | 815 GB | 1 | 9,978,624 | MySQL 4.1.14 | Linux 2.6 dual 800MHz PIII 1G RAM |
1.38.5 | 39.65 TB | 32 | 42,096,529 | MySQL 4.0.21 | Solaris 10 Sun Fire-V240 dual UltraSPARC-IIIi 1.3GHz 6G RAM |
1.38.4 | 428 GB | 38 | 73,476,698 | MySQL 4.1.12 | RHEL 4 2.1GHz Athlon 512MB RAM |
1.38.10 | 182 GB | 11 | 12,097,443 | MySQL 4.1.13 | Suse 10.0 AMT Opteron 146 2G RAM |
1.38.11 | 472 GB | 19 | 17,998,707 | MySQL 4.1.21 (servers catalog) | Linux 2.6 Gentoo, IBM Xseries 345 Xeon 2.66GHz 1Go RAM |
1.38.11 | 3 GB | 12 | 45,356 | (workstations catalog) | |
1.38.11 | 1.8 TB | 68 | 19,725,279 | MySQL 4.1.20 | CentOS release 4.4 (Final) Pentium III 1 GHz, 1GB RAM |
2.0.0 | 56 GB | 5 | 121,269 | MySQL 5.0.27 | FreeBSD 6.2-PRERELEASE, Dual PIII 850MHz, 640MB |
1.39.18 | 804 GB | 46 | 6,121,070 | Postgresql 8.1.6-1.fc5 | Linux 64bit (AMD), 2GB Mem |
2.0.3 | 1.6 TB | 34 | 278,904,852 | Mysql 5.0.37 | 2 x Dual Core CPU Xeon 2Ghz 4Gb RAM, Fedora Core 6 |
2.0.2 | 12 GB | 2 | 1,538,935 | MySQL | Athlon64 3700+ 1GB Mem |
2.0.3 | 420 GB | 17 | 12,680,084 | PostgreSQL 8.2.4 | SUSE SLES 9 Quad Dual-Core Opterons 2.6 GHz 32 GB RAM |
2.0.3 | 120 GB | 4 | 4,079,992 | MySQL 5.0.27 | FC6 P4 2.4Ghz 1GB RAM |
2.2.5 | 52.7 TB | 92 | 148,839,684 | PostgreSQL 8.1.9 | Debian 4.0 64Bit Dual-Core AMD Opteron 2 GB RAM |
2.2.0 | 389 GB | 85 | 14,514,660 | MySQL 4.1.14 | Slackware 9.1 Dual Pentium III 1Ghz 1GB Mem |
2.0.3 | 183 GB | 4 | 9,250,092 | PostgreSQL 7.4.17 | Debian Etch 64Bit @ Dual-Core Intel(R) Xeon(R) CPU 3060 2.40GHz 2 GB RAM |
2.2.7 | 45 GB | 12 | 2,572,839 | MySQL v4.1.22 | Sun Microsystems sun4u Sun Enterprise 450 (3 X UltraSPARC-II 296MHz) 896MB |
2.2.7 | 2.1 TB | 7 | 15,959,428 | MySQL 5.0.45 | OpenSUSE 10.3 on AMD X2 5600 with 4.0Gb RAM |
2.2.8 | 1.6 TB | 67 | 73,027,753 | MySQL 5.0.51a | Debian 4.1 on 4 x Intel(R) Xeon(R) CPU 3.00GHz 20G Ram |
5.0.3 | 17 TB | 140 | 116,778,421 | MySQL 5.1.49 | Debian 6.0 amd64 Dualcore-Dual-Opteron 2.4 GHz 16 GB RAM |
2.5.40 | 6.1 TB | 30 | 72,753,936 | MySQL 5.0.47 | CentOS 5.2 i386 2x Dual-Core Intel(R) Xeon(TM) 5160 3Ghz, 8GB RAM |
2.4.4 | 979.542 GB | 16 | 46,210,098 | Postgres 8.3.9 | Debian 5.0 2.6.26-2-686 bigmem Quad-Core Intel(R) Xeon(TM) L5410 @ 2.33Ghz, 4GB RAM |