Hi all here, I want to ask some question about using Firebird in a production environment for a web application. My experience is more then 12 years with Firebird for our client server application and have to say is a very good experience. Now that application is being ported to web by a complete rewrite. From an architectural point the database is single instance and multi-tenant, using logical tenant ids. The application is a rather standard JavaEE one. This means that all of our customers will have all their data together and obviously my main concerns are reliability, availability, performance and maintainability. The application is mostly interactive in an OLTP fashion, with little or no datawarehousing. We expect to have a production database of more or less 200 GB in size. The system will be Linux-based hosted somewhere by our provider. We now have to choose between Firebird and other engines, so I have to asses: - tools available for effective remote monitoring, analysis, tuning and troubleshooting I'm told that here standard names are nagios, cacti, SNMP and others - experience by someone that had worked or is working on system of this kind
My intention is to stay with Firebird because my experience is positive and like to stay in an environment that take simplicity as a value, but I want to do what will need to be done well, anyway. Any help is greatly appreciated. Mirco
