Is it possible or even recommended to run CMSMS setup with DB on separate server

[pbrady]

Hi,

I am running Debian Lenny (5.2.x) and have a specific system configuration issues that has a direct impact on CMSMS. My IT dept. wants to have me move my MySQL DB from my debian box LAMP setup and put it on a database network segment to provide more security (they also plan a web server and application server network).

1) Is it possible to run CMSMS with apache on one server and the MySQL database it uses running on another LAN segment on another server?

2) Is this recommended? That is, will it have detrimental effects on my CMSMS performance and operation?

Any help is greatly appreciated. My complete config is listed below:


----------------------------------------------

Cms Version: 1.5.2

Installed Modules:

    * CMSMailer: 1.73.14
    * FCKeditorX: 1.0.5
    * MenuManager: 1.5.3
    * ModuleManager: 1.2.1
    * News: 2.9.2
    * nuSOAP: 1.0.1
    * ThemeManager: 1.0.8
    * MysqlDump: 1.2.3
    * Uploads: 1.3.0
    * TinyMCEAdv: 2.2.2
    * FileManager: 0.4.3
    * Printing: 0.2.6
    * FrontEndUsers: 1.6.5
    * SelfRegistration: 1.2.1
    * CustomContent: 1.5.3
    * TinyMCE: 2.4.11
    * TemplateExternalizer: 1.0.4
    * Comments: 1.8.1
    * FCKeditorX: 1.0.3
    * CGExtensions: 1.9
    * Uploads: 1.3.0
    * CompanyDirectory: 1.1.1
    * Glossary: 0.6.2
    * FLVPlayer: 1.0.3
    * NMS: 2.2
    * FormBuilder: 0.5.5
    * CustomContent: 1.5.3
    * FormBuilder: 0.5.11
    * TemplateManager: 0.2


Config Information:

    * php_memory_limit:
    * process_whole_template: true
    * max_upload_size: 20000000
    * default_upload_permission: 664
    * assume_mod_rewrite: false
    * page_extension:
    * internal_pretty_urls: false
    * use_hierarchy: false


Php Information:

    * phpversion: 5.2.6-1+lenny3
    * md5_function: On (True)
    * gd_version: 2
    * tempnam_function: On (True)
    * magic_quotes_runtime: Off (False)
    * memory_limit: 256M
    * max_execution_time: 60
    * safe_mode: Off (False)
    * session_save_path: /var/lib/php5 (1733)


Server Information:

    * Server Api: apache2handler
    * Server Db Type: MySQL (mysql)
    * Server Db Version: 5.0.51a


----------------------------------------------

[replytomk3]

Of course possible. Fe, on 1and1 hosting, database is on db*.perfora.net, and that is what you would change on config.php.

[pbrady]

Ok. Thanks for the reply. But is the performance as good? Assuming you have a robust/speedy connection between the web server and DB server (ours would be 100Mbps in my network) and they are segmented on different LANs, would a simple LAMP setup with Web Server and DB on same box be faster?

[jmcgin51]

would a simple LAMP setup with Web Server and DB on same box be faster?

would it be faster?  yes (probably)

would it be noticeably faster?  that depends on a number of variables

[alby]

Ok. Thanks for the reply. But is the performance as good? Assuming you have a robust/speedy connection between the web server and DB server (ours would be 100Mbps in my network) and they are segmented on different LANs, would a simple LAMP setup with Web Server and DB on same box be faster?

The variables are many ....
Is your debian box very good (hardware/server load/network link/low traffic from your box and gateway)?
Has your IT DB server good performance (same your box + load balancing)?
Has your IT WEB server good performance (same IT DB server)?

It's not simple evaluated

Alby

[pbrady]

Thanks Alby. I agree with you. It's not simple. And my concern with my IT dept. is that they want to go this migration to fit their 'model' and the only known 'best configuration' to me is what I have now. I have no idea what their setup will be and what speeds and configs they will employ and they probably won't readily share it.

Lot to think about. Thanks again.

-p