Results 1 to 6 of 6

Thread: How to connect to other MYSQL server in zimbra

  1. #1
    Join Date
    May 2007
    Posts
    4
    Rep Power
    8

    Question How to connect to other MYSQL server in zimbra

    I have installed zimbra in a server. Now I want to have separate mysql database at other server.

    How to I edit the mysql connect to another server? I have edited in /opt/zimbra/conf/my.cnf and /opt/zimbra/conf/my.logger.cnf to point to other mysql server. I just change the bind-address=localhost to IP address

    after i restart then mysql cant connect.
    I am wondering if I have leave out anything. Anyone have done this before?

    Thanks in advance.

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

    Default

    You are just trying to connect to another MySQL instance on another server? If that's what you're trying to do then you won't be able to do it, ZImbra requires it's own copy of MySQL.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    Join Date
    Nov 2005
    Posts
    477
    Rep Power
    9

    Default

    Quote Originally Posted by limleechin View Post
    I have installed zimbra in a server. Now I want to have separate mysql database at other server.

    How to I edit the mysql connect to another server? I have edited in /opt/zimbra/conf/my.cnf and /opt/zimbra/conf/my.logger.cnf to point to other mysql server. I just change the bind-address=localhost to IP address

    after i restart then mysql cant connect.
    I am wondering if I have leave out anything. Anyone have done this before?

    Thanks in advance.
    Are you trying to add a separate mysql instance to the box, or add tables to the existing mysql database? It's generally not a good idea to move the Zimbra database to a different instance because Zimbra's upgrade scripts might do weird things, and you might hit performance issues. As for a seperate mysql instance, I have one running on my test box, and because the ports are different, there is no problem with that. Adding tables to the Zimbra mysql database also leaves you at the risk of upgrade scripts, and performance problems, but it's possible.

  4. #4
    Join Date
    May 2007
    Posts
    4
    Rep Power
    8

    Default

    Yes, I am trying whether can put the mysql database at another server to increase performance.

    Have another done this before? thanks

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

    Default

    You don't need to move mysql to improve performance. If you have performance problems I'd look elsewhere for the problem. What's the specification of your hardware and is there anything else running apart from Zimbra?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  6. #6
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

    Default

    Your current hardware specs and user group size (max active simutaneously & total users) will help us the most.

    You could 'work your way down' this chart:

    Zimbra Collaboration Suite Configuration Options
    Small
    Medium
    Large
    Very Large
    All ZCS components installed on one server.
    See the Zimbra Installation Quick Start for installation instructions.
    • Zimbra LDAP and Zimbra message store on one server
    • Zimbra MTA on a separate server.
    • Possibly include additional Zimbra MTA servers configured
    • Zimbra LDAP on one server
    • Multiple Zimbra mailbox servers
    • Multiple Zimbra MTA servers
    • Zimbra LDAP server as master
    • LDAP replicas
    • Multiple Zimbra mailbox servers
    • Multiple Zimbra MTA servers

    you really shouldn't need it at your stage but it's out there:
    Performance tuning for large deployments

Similar Threads

  1. Replies: 21
    Last Post: 02-04-2010, 09:06 AM
  2. 4.5 Upgrade failure
    By brained in forum Installation
    Replies: 9
    Last Post: 03-03-2007, 02:30 PM
  3. Replies: 16
    Last Post: 09-07-2006, 06:39 AM
  4. port 7071 not listening OS X install
    By leeimber in forum Installation
    Replies: 7
    Last Post: 03-21-2006, 09:47 AM
  5. Uh oh...
    By agnOstos in forum Installation
    Replies: 26
    Last Post: 10-14-2005, 08:17 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
  •