On 12/7/2016 5:45 AM, Josip Deanovic wrote: > On Wednesday 2016-12-07 10:20:56 Kern Sibbald wrote: >> Hello, >> >> Here are a few tips for you. >> >> - You absolutely need to understand what Pruning is. The best way to >> understand it is to read the manual. >> >> - If you are running MySQL as that catalog and you are having catalog >> performance issues, you should consider switching to Postgresql. > I'll add some thoughts and experiences on this matter... > > I usually use mysql as a catalog database and the only case where I have > experienced performance issues (e.g. even with a very small data sets it > takes half an hour or more just to get the prompt to browse files in > bconsole during the restore procedure) was actually a combination of > hardware issues (slow IO on the host machine that serves the virtual > machine) in combination with insufficient resources assigned to the > virtual machine (RAM or CPU). > > In my case as described above, the problem was always solved by adding > more resources to the virtual machine. > I have never experienced performance issues on the real hardware machine > when using mysql as a catalog database (database sizes from 1.5G to 50+G). > However I do pay some care to the configuration of my databases.
Also, pay some care to the physical disk drives that the db is using. Having the catalog db on the same physical disks that are also being used for Bacula's spool area can be very detrimental to performance. > > It's a good idea to make a backup server a dedicated machine (performance > as well as security-wise) and for most small/medium bacula setups the > catalog database could exist on the same server with other bacula daemons > in which case it could be better optimized for the specific bacula's > needs. > ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today.http://sdm.link/xeonphi _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
