Is anyone using an open source database like MySql or Postgres for their applications? I'd like some feedback on how they work. Any problems getting them setup, scalability, etc.
We run a non mission-critical portion of our project on J2EE RI and MySql on a SuSE 6.2 installation in a two-way Siemens Primergy 600 (Mylex RAID etc., full works). It is a project management site with a simple help-desk and some sophisticated configuration management. We have had a few glitches but nothing major. The load is low but we have tested it under stress: 100 concurrent users, 20 times the usual load.