Results 1 to 10 of 10

Thread: mySql is the fatal flaw of zimbra

  1. #1
    Join Date
    Oct 2005
    Posts
    5
    Rep Power
    0

    Default mySql is the fatal flaw of zimbra

    I would start using this right now if it used PostgreSQL instead of MySQL which is less stable for very high activity long term use (been burned too many times so I Never use it for mission critical apps). If someone knows how to change Zimbra to use PostgreSQL, FirebirdSQL or other please advise. Thank you.
    Last edited by pcatiprodotnet; 10-16-2005 at 10:18 AM.

  2. #2
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    Quote Originally Posted by pcatiprodotnet
    I would start using this right now if it used PostgreSQL instead of MySQL which is less stable for very high activity long term use. If someone knows how to change Zimbra to use Postgres please advise. Thank you.
    There is no easy way to *switch* to Postgres from MySQL. Not that it can't be done it's just not something we designed for out of the box yet.

    BTW: In all our lab and trial tests MySQL has held up just fine. Have you done testing with Zimbra to prove otherwise?

  3. #3
    anand is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    274
    Rep Power
    9

    Default see also


  4. #4
    mallah_rajesh is offline Junior Member
    Join Date
    May 2010
    Posts
    7
    Rep Power
    5

    Default

    Yes MySQL is the weakest link on the otherwise Excellent Zimbra Product.
    To prove it just pull out the power cord of the server while zimbra is busy
    processing mails. You will surely get the desired results , if not the first
    time itself , just give one more try. Try the same with PostgreSQL (once
    some kind person ports it).

  5. #5
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,491
    Rep Power
    56

    Default

    Quote Originally Posted by mallah_rajesh View Post
    Yes MySQL is the weakest link on the otherwise Excellent Zimbra Product.
    To prove it just pull out the power cord of the server while zimbra is busy
    processing mails.
    If you're serious about protecting your data wouldn't a UPS be a good idea. If you pull the plug on any server you may end up with problems other than MySQL, file system problems ring a bell?

    Quote Originally Posted by mallah_rajesh View Post
    Try the same with PostgreSQL (once
    some kind person ports it).
    Well if you feel the need for PostgreSQL then have a go at porting it, this is an open source project. You can see how much interest there is for this as there's been no input from the original poster in this thread.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  6. #6
    mallah_rajesh is offline Junior Member
    Join Date
    May 2010
    Posts
    7
    Rep Power
    5

    Default postgresql porting

    Even if the most advanced UPS systems are put one cannot rule
    out the hitting 'power plug pulling' situation altogether.

    Agreed Filesystem and many other software components
    can get corrupt due to such outage , but every system as
    got a system of recovering from it. Eg FS have their journal,
    mysql and postgresql also have their transaction logs.
    From my usage experience I find that MySQL is more prone to
    get corrupt in such situations . In the same machine I have
    postgresql database also , PostgreSQL *never* got corrupted
    and MySQL got thrice.

    In past incidences i was able to recover mysql data by forcing
    inno recovery level to 6 , then dumping the tables and reloading
    but this time the same method did not work. As a result 1.5 hrs
    of emails were lost.

    Regarding porting , I have seen other posts suggesting exactly where
    to start , I saw the well structured code files and i am hopeful to attempt
    some work regarding that . BTW can you suggest the forum where i can ask what kind of environment a developer should setup to make code modifications and test ?

    regds
    Rajesh Kumar Mallah.

  7. #7
    digger is offline Junior Member
    Join Date
    May 2010
    Location
    UK
    Posts
    5
    Rep Power
    5

    Default

    Quote Originally Posted by KevinH View Post
    There is no easy way to *switch* to Postgres from MySQL. Not that it can't be done it's just not something we designed for out of the box yet.

    BTW: In all our lab and trial tests MySQL has held up just fine. Have you done testing with Zimbra to prove otherwise?
    Noted you said yet

    If other databases will be a consideration in the future, hope this will include Oracle.

  8. #8
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,491
    Rep Power
    56

    Default

    Quote Originally Posted by digger View Post
    Noted you said yet

    If other databases will be a consideration in the future, hope this will include Oracle.
    You can see how old the post is that you've quoted, if you want to see any other database then file an RFE in Bugzilla Main Page - Zimbra (merely commenting here won't get to the developers attention) but don't get too excited about it happening any time soon.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  9. #9
    ballard is offline Beginner Member
    Join Date
    Jun 2010
    Posts
    1
    Rep Power
    5

    Thumbs up RE: mySql is the fatal flaw of zimbra

    Respectfully to faithful believers in MySQL, MySQL is difficult to support effectively in mission-critical enterprises. Email is definitely mission-critical in most instances. Postgresql, although not a de-facto platform default, has major advantages in this regard including being a transactional, object relational database management system.

    This is analogous to the common refrain of "just use { /bin/cp or storage snapshots } for backup" when backup agents and app/db notifications (similar to the "evil empire's" Hardware VSS) are often absolutely necessary to both provide an audit trail and ensure provable consistency in real, OLTP-style services.

    References:

    1 MySQL vs PostgreSQL - WikiVS

    2 Book: Enterprise Rails (Postgresql and MySQL compared)

    3 How Volume Shadow Copy Service Works

  10. #10
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,491
    Rep Power
    56

    Default

    Quote Originally Posted by ballard View Post
    Respectfully to faithful believers in MySQL, MySQL is difficult to support effectively in mission-critical enterprises. Email is definitely mission-critical in most instances. Postgresql, although not a de-facto platform default, has major advantages in this regard including being a transactional, object relational database management system.

    This is analogous to the common refrain of "just use { /bin/cp or storage snapshots } for backup" when backup agents and app/db notifications (similar to the "evil empire's" Hardware VSS) are often absolutely necessary to both provide an audit trail and ensure provable consistency in real, OLTP-style services.
    Feel free to add your comments an justifications for your comments to the bug report in Bugzilla Main Page - Zimbra, that would be the correct place to put your reasons for using another database instead of MySQL. While posting in the forums is useful it does not get to the attention of the development teams.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Clamav problem ? What's happening ?
    By aNt1X in forum Installation
    Replies: 23
    Last Post: 02-14-2008, 05:43 AM
  2. zmtlsctl give LDAP error
    By sourcehound in forum Administrators
    Replies: 5
    Last Post: 03-11-2007, 03:48 PM
  3. 4.5 Upgrade failure
    By brained in forum Installation
    Replies: 9
    Last Post: 03-03-2007, 03:30 PM
  4. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  5. port 7071 not listening OS X install
    By leeimber in forum Installation
    Replies: 7
    Last Post: 03-21-2006, 10:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •