6 Replies Latest reply on Jan 25, 2010 9:22 AM by balazska

    MySQL 5.1 or PostgreSQL 8.4 in Production (with JBoss 5.1 + Seam 2.2)

    balazska

      Hy!


      I would like to ask advice/experience for choosing database (latest mysql or postgres ) with JBoss 5.1 and Seam 2.2 environment.


      thx.

        • 1. Re: MySQL 5.1 or PostgreSQL 8.4 in Production (with JBoss 5.1 + Seam 2.2)
          balazska

          any advice?

          • 2. Re: MySQL 5.1 or PostgreSQL 8.4 in Production (with JBoss 5.1 + Seam 2.2)
            idyoshin

            Well, I guess it's a matter of taste|flavor. Both have pros and cons.


            As for me, I preffer PostgreSQL because of its lightweightness :) and because of Bucardo. Actually PostgreSQL seems to me more "enterprise-level" RDBMS than MySQL. And PostgreSQL seems to me more stable than MySQL - actually I have PostgreSQL server which wasn't rebooted over 460 days (actually even PostgreSQL service wasn't stopeed) So I recommend PostgreSQL.


            But if your logic isn't coupled to database (i.e. no triggers, stored procedures and so on) just measure the performance on both (Hibernate has statistics :) )


            Regards,


            Ilya Dyoshin

            • 3. Re: MySQL 5.1 or PostgreSQL 8.4 in Production (with JBoss 5.1 + Seam 2.2)
              balazska

              Do you know which one is performer better?
              As I have seen a lot of company choosen mysql instead of postgres. (th seam in production page)

              • 4. Re: MySQL 5.1 or PostgreSQL 8.4 in Production (with JBoss 5.1 + Seam 2.2)
                aleseam

                I think the choice of a database should not be made based on percentage points of performance difference, but considering the totality of characteristics required in a project.


                I have the impression that much company choose mysql mainly because they don't known postgresql.


                Also I would remember that PostgreSQL 8.2 was supported on Windows only from the 8.2 version (unfortunately most company use windows).


                Sincerely i think the postgresql is fantastic, you have a ton of feautures with a ligth environment (a lot more light then Oracle despite obviously there are some lack on some functionality).


                Also the license of Postgresql is very good.


                MySQL with the add of more future is became more bigger and this is in contrast with its original purpose to be something light and functional.


                In the future, for small project with few data i think will be nice eventually a derived project from postgresql with less feautures (that don't exist) or eventually take a look at the fork of MySQL (MariaDB)

                • 5. Re: MySQL 5.1 or PostgreSQL 8.4 in Production (with JBoss 5.1 + Seam 2.2)
                  idyoshin

                  Max Wunderbaum wrote on Jan 24, 2010 09:04:


                  Do you know which one is performer better?
                  As I have seen a lot of company choosen mysql instead of postgres. (th seam in production page)


                  Well for small database - MySQL is performing a bit faster. But from stability and managibility point of view I'd suggest the PostgreSQL. If you have a web-application in JSF and have delay in query of 10ms in MySQL and 15ms in PostgreSQL - that's actually doesn't matter for the whole application (+-5ms doesn't make a weather). (the numbers isn't exact results - just a numbers to compare).


                  But PostgreSQL's way of locking tables is more powerfull than MySQL's one, so the data constintency in case of hardware fault would be better in PostgreSQL (I know from my own experience when on the same server with MySQL and PostgreSQL after power-loss - MySQL (with InnoDB) became unusable and in contrast PostgreSQL was just fine).


                  So my choice PostgreSQL - and now my application is on it.



                  Regards,


                  Ilya Dyoshin

                  • 6. Re: MySQL 5.1 or PostgreSQL 8.4 in Production (with JBoss 5.1 + Seam 2.2)
                    balazska

                    Thanks so much for your answers.


                    I look for management softwares (that shows what occur actually in the db:running queries, etc.. fot maintanence issues) to mysql and postgres, but for postgres I didn't find usefull things.


                    What I found to postgres: pgtop and some tool for http://pgfoundry.org/.
                    I think mysql has a lot of benefit from maintenence ascpect.