Using a separate MySQL server?

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
RoyK
Posts: 24
Joined: Sat Sep 13, 2014 12:43 am

Using a separate MySQL server?

Post by RoyK »

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
phoenix
Ambassador
Ambassador
Posts: 27272
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

Using a separate MySQL server?

Post by phoenix »

[quote user="RoyK"]...how can I have the Zimbra VM use the external MySQL server and not its own?[/QUOTE]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

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
RoyK
Posts: 24
Joined: Sat Sep 13, 2014 12:43 am

Using a separate MySQL server?

Post by RoyK »

[quote user="10330phoenix"]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.[/QUOTE]
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
uxbod
Ambassador
Ambassador
Posts: 7811
Joined: Fri Sep 12, 2014 10:21 pm

Using a separate MySQL server?

Post by uxbod »

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.
fcash
Outstanding Member
Outstanding Member
Posts: 263
Joined: Fri Sep 12, 2014 10:37 pm

Using a separate MySQL server?

Post by fcash »

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.
10424bofh
Outstanding Member
Outstanding Member
Posts: 285
Joined: Sat Sep 13, 2014 1:15 am

Using a separate MySQL server?

Post by 10424bofh »

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
phoenix
Ambassador
Ambassador
Posts: 27272
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

Using a separate MySQL server?

Post by phoenix »

[quote user="10424bofh"]

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[/QUOTE]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

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
10424bofh
Outstanding Member
Outstanding Member
Posts: 285
Joined: Sat Sep 13, 2014 1:15 am

Using a separate MySQL server?

Post by 10424bofh »

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 :-)
uxbod
Ambassador
Ambassador
Posts: 7811
Joined: Fri Sep 12, 2014 10:21 pm

Using a separate MySQL server?

Post by uxbod »

[quote]raid 5 while i do recommend it for a regular storage server like zimbra[/quote]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.
mr.Trash
Posts: 4
Joined: Sat Sep 13, 2014 1:27 am

Using a separate MySQL server?

Post by mr.Trash »

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. :mad:

Very need to move the server in another location, but impossible. I so disappointment...
Post Reply