I have written some posts about moving our Business Intelligence solution The Data warehouse to new hardware. We also upgrade the software and reshuffle some components, actually its like building a new system. The ETL server is now virtualized from Mandriva 2010 Linux to Mageia 2 Linux as we could not get tightVNC to work in Mageia 3! It seems like the history repeats itself from the Mandrake days, every second version has issues. Anyway Mageia 2 runs nicely so far, touch wood. When Mandrake, Mandriva, Mageia works these distros are second to none. So the ‘brain’ of the data warehouse runs on Mageia these days. With no problem at all I compiled PHP 5.5 RC2 together with the SAP rfc communications modules SAPRFC and SAPNWRFC . So we soon run a serious large scale production, (some 20,000 jobs a month), on Mageia 2 and PHP 5.5 RC2 - I love it. Now I have to come up with a way to upgrade MySQL from 5.5 to 5.6, we have a tricky Mysql setup , but I will find a way to do it. (In Mageia I run MariaDB Client against MySQL 5.5 at first I didn’t even notice).
This whole project revives the original spirit of the data warehouse project, new innovative and low budget. Year 2000 I set out on a journey to prove you can create high quality IT systems on a shoestring budget. I think I done it again. This time it’s way more expensive, my bosses forced me to spend much more money than I had in mind, how often does that happen? Still we have a very modest budget considering the application.