Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Using a separate MySQL server?

  1. #1
    RoyK is offline Senior Member
    Join Date
    Sep 2009
    Posts
    51
    Rep Power
    5

    Default Using a separate MySQL server?

    Hi all

    I have a small environment consisting of one server running MySQL and KVM virtualisation with a few VMs. These VMs are webservers, general 'toy' servers and a Zimbra VM. Since the host is already running MySQL, and has better I/O than a VM will ever have, how can I have the Zimbra VM use the external MySQL server and not its own?

    roy

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

    Default

    Quote Originally Posted by RoyK View Post
    ...how can I have the Zimbra VM use the external MySQL server and not its own?
    The simple answer is, you can't. Zimbra is designed and installed as a complete package (the packages are tuned for the requirements of Zimbra) and should be installed on a server without any other applications running on it.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    RoyK is offline Senior Member
    Join Date
    Sep 2009
    Posts
    51
    Rep Power
    5

    Default

    Quote Originally Posted by phoenix View Post
    The simple answer is, you can't. Zimbra is designed and installed as a complete package (the packages are tuned for the requirements of Zimbra) and should be installed on a server without any other applications running on it.
    I don't get it - it's just MySQL running here, and running MySQL separately for a separate application is far from optimal. Database servers should run separately, so what I'm talking about is true tuning. Most other systems have a common config file or something into which changes can be made.

    Where can I find this for Zimbra? I hope you're not going to tell me all that is hardcoded?

    roy

  4. #4
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Sorry; but as Phoenix has already indicated the MySQL instance has been built for and configured for Zimbra's use and hence it is deployed as part of the complete package. One reason will be versioning as it allows Zimbra to ensure that what they ship has passed all QA controls.

  5. #5
    fcash is offline Elite Member
    Join Date
    Jun 2007
    Location
    BC, Canada
    Posts
    281
    Rep Power
    8

    Default

    Think of Zimbra as a black-box, forget about its internal components. It's one, single unit, and should be treated as one single unit.

    Don't try to make Zimbra work with a separate Postfix install.
    Don't try to make Zimbra work with a separate Spamassassin install.
    Don't try to make Zimbra work with a separate MySQL install.
    Don't try to make Zimbra work with a separate OpenLDAP install.
    etc

    Install Zimrba, use Zimbra, look at Zimbra, there's nothing but Zimbra. It truly is greater than the sum of its parts.
    Freddie

  6. #6
    bofh is offline Elite Member
    Join Date
    May 2010
    Posts
    272
    Rep Power
    5

    Default

    but i agree that it isnt optimal.

    i understand the blackbox concept BUT databaseserver are an different animal specially mysqldatabases and their behaivior.

    theres a lot todo which CANT be tuned out of the box (since zimbra cannot know ever how many user/ram on my db server is) for example.

    or disksystem.. on high performance mysql server i would not recommend using a raid 5 while i do recommend it for a regular storage server like zimbra


    but about the seperate mysql instance theres one thing you shoudl think about:
    Never ever you can loose the connection to the DB server or many things can go wrong in zimbra

    also performance might not be better (can go even much worse) since simbra is talking with its db by socket not IP (which is a lot faster) and you will not run intro trouble with persistent connection/or to many open tcp requests (you know 65k on one machine and its frozen to death)

    so tehre are actually many cons having a dedicated mysql server away from the zimbra server itself BUT it should be possible

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

    Default

    Quote Originally Posted by bofh View Post
    or disksystem.. on high performance mysql server i would not recommend using a raid 5 while i do recommend it for a regular storage server like zimbra
    It's not recommended to use RAID5 at all (except for the smallest installations and even then I wouldn't recommend it): Performance Tuning Guidelines for Large Deployments - Zimbra :: Wiki
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  8. #8
    bofh is offline Elite Member
    Join Date
    May 2010
    Posts
    272
    Rep Power
    5

    Default

    its not recommended for zimbra but it is for normal storage operations.
    in zimbra its obiviouse. mysql and ldap performance dropping to nowheres land in worst case :-)

  9. #9
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    raid 5 while i do recommend it for a regular storage server like zimbra
    that is contentious as it depends on whether you require quick writes or quick reads. Have to bear in mind that Zimba, AFAIK, does cache via Java so quicker writes would be of more benefit.

  10. #10
    mr.Trash is offline New Member
    Join Date
    Sep 2010
    Posts
    4
    Rep Power
    4

    Default And is it good?

    I was hoping to find a solution to this problem!
    Nothing special in mySQL server from this blackbox, but some time need use DBMS from one place.
    Very need to move the server in another location, but impossible. I so disappointment...

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Separate Web Client into different server? Possible?
    By tansyuan in forum Installation
    Replies: 1
    Last Post: 03-23-2009, 02:55 AM
  2. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  3. Need separate server to handle mail that Zimbra doesn't
    By danfluidmind in forum Administrators
    Replies: 2
    Last Post: 06-02-2007, 11:37 AM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. more fedora install problems
    By jlynch3 in forum Installation
    Replies: 13
    Last Post: 09-14-2005, 09:37 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
  •