Results 1 to 9 of 9

Thread: Why does zimbra need its own mysql server

  1. #1
    Peter_V is offline New Member
    Join Date
    Jan 2006
    Posts
    3
    Rep Power
    9

    Default Why does zimbra need its own mysql server

    And why does it need two of them, logger and zimbra (with mailbox mm) ? Cant it be installed into mysql sever who is allready installed on the machine? At least, why cant logger and zimbra share one? Now I got 3 mysql servers running om my server, Isnt that a overkill or what. What am I missing here..

    Peter

  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

    Zimbra's MySQL DB's should be considered internal to the application. This allows us to tune this specfically for Zimbra's use. The mailbox DB and logger DB have quite different usage so by being seperate we can tune them for their particular use. For each Zimbra store there is a mailbox DB, but there only needs to be a single logger DB for the entire system. So for a single node install you'll get two on the same host. For larger installs the logger may be on it's own host.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  3. #3
    Peter_V is offline New Member
    Join Date
    Jan 2006
    Posts
    3
    Rep Power
    9

    Default one more..

    Hi again
    Okey, thank you for your answer. Now I know why it has 2 of them. I dont have so many people using e-server so I wonder if it is possible to merge this two db:s into my own db. Memory/RAM is a big issue here, I have 2Gb of it but that is all. My mysql server takes a big bite from it and so do Apache (tomcat). I have allso more ram eating programs on this server so really need to make Zimbra to Zimbra lite if you know what I mean. Dont get me wrong, I really like Zimbra but right now it is killing me. Whould it be much work to get it into my own db and can you point me in the right direction where I need tho change the code if it is feasible.

  4. #4
    marcmac is offline Expert Member
    Join Date
    Sep 2005
    Posts
    2,103
    Rep Power
    13

    Default smaller footprint

    If you want a smaller footprint for zimbra:

    First, remove the logger - you don't need it (though you lose all statistics):
    zmloggerctl stop
    zmprov ms -zimbraServiceEnabled logger

    If you can live without spell checking, you can turn off that service, too.

  5. #5
    Peter_V is offline New Member
    Join Date
    Jan 2006
    Posts
    3
    Rep Power
    9

    Default

    thanks marcmac for your answer. Not the fix I was looking for but its helps for now. i really want to merge the servers into one but that will take some time... Time i dont have.... damn.

  6. #6
    Verbunk is offline Active Member
    Join Date
    Feb 2006
    Location
    Boston
    Posts
    38
    Rep Power
    9

    Default

    I too would like to explore using mysql with other applications. My situation is that I'm using debian so once Zimbra is installed debian complains that mysql is already installed when I try to install the debian provided package and it doesn't seem that I can properly hook anything else up to it. ...

    Since the mysql zimbra installs is for zimbra, which is 'ok', it doesn't need to be standard at all, as in, doesn't inform debian it's installed and can run on a infrequently used port. I mean if it's off limits to other uses it doesn't need to be in the way right?

    Does anyone know of a way to get the mysql zimbra installs for debian out of the way? Changing the port isn't enough I think ... I welcome any suggestions.

    -J

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

    Default

    I don't use Debian but the mysql that zimbra install shouldn't get in the way of another instance of mysql. I have CentOS (RHEL ES) with zimbra installed and another instance of mysql installed without problems, the zimbra mysql does use a non-standard port.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  8. #8
    lfarkas is offline Active Member
    Join Date
    Nov 2005
    Location
    Hungary
    Posts
    38
    Rep Power
    9

    Default

    Quote Originally Posted by marcmac
    If you want a smaller footprint for zimbra:

    First, remove the logger - you don't need it (though you lose all statistics):
    zmloggerctl stop
    zmprov ms -zimbraServiceEnabled logger
    this second command not working for me. are you sure this is the right syntax?
    thanks.

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

    Default

    It's missing the sever name.

    zmprov ms SERVER -zimbraServiceEnabled logger
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 21
    Last Post: 02-04-2010, 10:06 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. upgrade woes -made into new thread
    By JustinHarlow in forum Installation
    Replies: 18
    Last Post: 06-08-2007, 12:11 PM
  4. 4.5 Upgrade failure
    By brained in forum Installation
    Replies: 9
    Last Post: 03-03-2007, 03:30 PM
  5. Replies: 16
    Last Post: 09-07-2006, 06:39 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
  •