Two Servers One For Apache And One For Mysql
Mar 29, 2007
we plan to buy one server for apashe and one for mysql.
So first server will handle apache + cpanel + exim
Dual Processor Dual Core Xeon 5140 - 2.33GHz (Woodcrest) - 2 x 4MB cache
8 GB FB-DIMM
3 x 73GB 15k RPM SA-SCSI
Linux RHE 4 ES
second will handle only mysql
Dual Processor Quad Core Xeon 5345 - 2.33GHz (Clovertown) - 2 x 8MB cache
8 GB FB-DIMM
3 x 73GB 15k RPM SA-SCSI
Linux RHE 4 ES
Server will be used for forums about 4000, 5000 Simultaneous users.
View 3 Replies
ADVERTISEMENT
Mar 21, 2007
here's my current setup has my stuff running on 2 separate "self contained" servers (eg; each runs their own apache/php/mysql):
Main site/server:
content: mostly static content (no mysql, very little php). currently has about 4tb/m traffic. in the summer it could push up to 6tb/m
hardware: P4 2.8ghz. 1gb ram. this server has no problem handling the load. only problem is bandwidth (i have to get it off the current host)
Forums site/server:
content: running vBulletin. currently 400-500 peak (probably jump to 800 peak this summer) users active per 15 mins.
hardware: 64bit dual Opteron 242. 4gb ram. it's absolutely griding that to a halt at peak times. it acts like 4gb memery isn't enough (it will run fine then eat through most of the 4gb. grind to a halt, then recover) personally i think it was setup/configured wrong but i've had multiple people look at it and nobody can find anything wrong in the apache/mysql settings.
What I want to know:
what type of server setup should I start migrating to? should I keep both parts of the site separate? eg; main site on one server, forums on another server(s)?
what i've sorta been looking into is 3-server setup.
(server1) main apache/php server. probably on unmetered (honestly don't think i'll find anything else that offers high enough traffic). run the main site and the vB php from here
(server2) dedicated mysql 'read only' server (server3) dedicated mysql 'write only' server.
and have mysql read/write synced and have all 3 servers networked directly together. i have a friend running a single mysql driven site using this setup and it works really well for him.
is this overkill for me? should the current dual Opteron be able to handle the forums and i just need to hire someone smarter, or is there some other setup that would work better for me? i'm tight so i want to go cheap as possible, but I also realize i need room for summer traffic expansion that always hits us.
View 4 Replies
View Related
May 29, 2007
I currently have one server a
Dual Xeon 5130 2GHZ (woodcrest)
2GB Ram.
Running cPanel/WHM
Now I run a website that is VERY PHP & MySQL Intensive and MySQL is ALWAYS the top of the process list, hogging a ton of usage. It's getting to the point where the site is needed a second server and I know there's a few options; but I'm not sure which one would be the best.
They way I see it my two options are getting a 2nd server and setting up the two to do load balancing, or getting a 2nd server and setting one up for just Apache and the Other for MySQL and using the 2nd as a remote SQL server.
If I do the Apache on a seperate server would I need such a powerful server? And if I also would want to upgrade this server along with getting a 2nd server would I be better of upgrading to 4GB of RAM or upgrading the processors?
View 9 Replies
View Related
Mar 28, 2008
I was wondering if it is possible to cluster 2 web servers and 2 mysql servers with only one server working as load balancer.
I am planning to use LVS (ldirectord and heartbeat).
Let's say I have 3 IPs allocated to the load balancing server.
111.222.111.222 (Main IP)
111.222.111.223 (Web Load Balancing IP)
111.222.111.224 (MySQL Load Balancing IP)
If a connection is made to .223 it would pass the request to one of the web nodes.
If a connection is made to .224 it would pass the request to one of the MySQL nodes.
Is it possible to do this?
If not, can I run, for example, nginx on 223 IP address to provide forward proxy? (Then it would not be able to HA but the main point is to load balance so)
Also, what would be the best way to keep the data same on both web servers? This is a web cluster for a very high traffic forum with a lot of uploads every hour so it has to do real time synchronization. I heard that DRDB is only one way and not two way so I'm not going to be able to use this.
View 11 Replies
View Related
Oct 9, 2006
I'm working on transitioning to a new server. Long story short, I have about a database around 100MB in size that I need to get from a MySQL (4.0.25) server to MySQL 4.1.14 server. (Both machines are running Linux and are sitting in data centers with fast pipes.)
What's the easiest way to do this? I have full root access on both machines, ssh access, and phpMyAdmin on both. Is there a way to have one machine read the data directly from the other, say some command line tool? (What I plan to do is to use phpMyAdmin to 'export' it to a backup, download that to my desktop machine, upload it to the new machine, and import it. This seems quite inefficient.)
View 5 Replies
View Related
Jul 7, 2009
How do I setup a site to use two servers? One as a mysql server and the other as a web server.
At the moment I have the site on one server. When I get the second server what steps do I need to take to make this possible?
How do I secure the mysql server to only allow the web server to connect to it?
Do I need a control panel (i.e. cPanel) software on the mysql server?
View 14 Replies
View Related
Jun 29, 2007
Haven't seen much debate lately on what processors to use within dedicated database servers. We're currently considering Dell 2950s and 2970s with the following:
Two Dual Core AMD Opteron™ 2212
- 2.0GHz, 2X1MB Cache, 1Ghz HyperTransport
Two Quad Core Intel® Xeon® E5310
- 1.60GHz, 2x4MB Cache, 1066MHz FSB
8GB RAM, single SAS, 3.5-inch, 15K RPM Hard Drive for OS, single SAS, 3.5-inch, 15K RPM Hard Drive for SWAP, and four SAS, 3.5-inch, 15K RPM Hard Drives in a RAID10 array for database storage.
We'll be getting one server just for MySQL applications and one server for just PostgreSQL applications.
View 14 Replies
View Related
Nov 18, 2008
Here is what I am trying to do, to set up a WordPress powered site to be run across two servers for load balancing. The two servers are dedicated and I have the load balancing software installed and set up. I need to set up the site so that both of them are accessed, but to also have the same content. The main concern is for the same content.
WordPress uses a MySQL database to place all of the content there, so the main thing I would need is to set up the databases so they are synched on both servers, so that the same content is showing up on both of the servers, and so I don't have to manually upload data to the database every few hours, that would suck. I have already found a script to connect to a remote mysql server, it is called HyperDB, but I was wondering if there are any better ways.
View 11 Replies
View Related
Jun 2, 2008
I'm running a message board and it looks like I've outgrown the low end xeon 3040 1.86GHz dual core server, and the bulk of the CPU load is going to mysqld. I'm debating between offloading the DB to a dedicated server vs upgrading the existing server and hosting the web server and db on the same machine.
Any thoughts on the better approach? fwiw, the load from apache seems next to nothing right now, but I am also planning on adding an SMTP server for user registrations and general support email.
I'm also not super familiar with dual-core and dual processor machines. Does shifting mysql to a dual core or dual proc machine help (vs a single core/single proc machine)? since there is just one mysql daemon, does having a second core or proc. buy me anything?
View 10 Replies
View Related
Oct 14, 2009
I'm more of an application programming guy than network/internet guy so excuse any ignorance on my part.
I am currently using shared hosting on an IIS server.
I running SMF Forums and a business on the IIS server. I have a payment system that I've programmed tied into the MySQL SMF database. This payment system uses ASP.net. I'm a .Net programmer. SMF is also being currently ran on the IIS server, and it does ok.
I'm really wanting to start running my forums on a separate Unix Server.
So my question is, can i run my ASP.net scripts on my IIS server that access the MySQL database on a separate Apache server? The Apache server and IIS server would have different domains (I'm guessing that'd be required).
I think this is possible, but wondering what others think. All I should need to do is change some connection strings on my Web.config on my IIS server to point to the new SQL databases.
View 7 Replies
View Related
Sep 16, 2014
We have an Apache acting as a reverse-proxy and listening on the Internet ("Our URL" on port 443).
We would have two ways of accessing this reverse-proxy:
-From a mobile app (authentication would be based on a corporate certificate)
-From any browser (authentication would be a login form)
The question is: can Apache forward requests to either server 1 or server 2, depending on whether a certificate is sent by the client?
View 10 Replies
View Related
Jun 18, 2015
I am using apache 2.2 webserver and tomcat 6 as app server.
I have two unix boxes (let say A and B) where apache is installed for load balancing purpose.
The issue is now and then I see that on both the server reaches to 250 busy servers which makes my site very slow and after some time the site is unaccessible.
When I see this I restart apache on both unix boxes and also restart my app server.
But that does not work. As soon as I start apache the httpd process ramps up to 12 (ps -ef | grep httpd) within a minute and the busy servers still remains at 250.
The only I have to do is wait and watch till the busy servers goes down to 250 and then site is back to normal.
Some times it takes hours for busy servers to go down below 250.
I dont understand that why even restarting apache and tomcat doesn't work. why the busy servers are still at 250. even after I restart.
This is what I have in httpd.conf
<IfModule worker.c>
ServerLimit 80
StartServers 2
MaxClients 250
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
I tried to increase MaxClients to 300, which also didn't work and apache or httpd process shuts down by itself.
View 3 Replies
View Related
Feb 27, 2014
I have a total of 3 web servers:
x1 gateway.domain.com:443 (Using as a proxy to web1 and web2)
x1 web1.domain.com:443
x1 web2.domain.com:443
I was able to have gateway.domain.com play nicely with a wildcard certificate and handshake perfectly with web1 and web2. Now currently, web1 and web2 have their own SSL certificates while gateway has a wildcard cert for *.domain.com. Is it necessary to have certs on all 3 servers or just have the single wildcard cert on gateway.domain.com?
View 1 Replies
View Related
Nov 5, 2014
I need to configure multiple Apache Web Servers on redhat server. I have copied and extracted Apache 2.2 into redhat server and extracted but not able to install because I don't understand setting prefix. Please let me explain about prefix configuration and how to set it. At the same time I would like to know is it possible to setup 4 Apache Web Servers on same machine if possible then how to. Can we set up different versions of Apache HTTP Servers?
View 17 Replies
View Related
Feb 7, 2008
i am setting up a new load balanced cluster for the first time. It is turning out pretty well so far, I was wondering if you guys see any future problems with this setup. So far it is working well.
I have one server that is the dedicated network file server. Then two others that mount the file system from the NFS.
I have mysql and apache installed on both servers. They both share the NFS mount using read and write privs. I haven't put a load on the setup yet, but I was under the assumption that this couldn't be done with MySQL, but it seems to be working great. If this does work out, it seems MySQL would be scaled just as easy as apache. Everysite in the system could be setup to use localhost which would be the same server it is served up with apache.
View 4 Replies
View Related
Apr 30, 2007
I recently have got a VPS and it needs optimizing. Please would someone look at my specs and help me set some good values for a website that runs a fairly small forum.
Plesk 8.1.1
Guaranteed RAM 384MB
Maximum RAM 768MB
RedHat Enterprise 4 AS
MySQL 4
PHP 4
Apache2
my.cnf
Code:
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
httpd.conf
Code:
ServerTokens OS
ServerRoot "/etc/httpd"
PidFile run/httpd.pid
Timeout 120
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
<IfModule prefork.c>
StartServers 2
MinSpareServers 1
MaxSpareServers 5
ServerLimit 10
MaxClients 10
MaxRequestsPerChild 4000
</IfModule>
<IfModule worker.c>
StartServers 2
MaxClients 10
MinSpareThreads 1
MaxSpareThreads 4
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
Listen 80
LoadModule access_module modules/mod_access.so
LoadModule auth_module modules/mod_auth.so
LoadModule auth_anon_module modules/mod_auth_anon.so
LoadModule auth_dbm_module modules/mod_auth_dbm.so
LoadModule auth_digest_module modules/mod_auth_digest.so
LoadModule ldap_module modules/mod_ldap.so
LoadModule auth_ldap_module modules/mod_auth_ldap.so
LoadModule include_module modules/mod_include.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule env_module modules/mod_env.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule expires_module modules/mod_expires.so
LoadModule deflate_module modules/mod_deflate.so
LoadModule headers_module modules/mod_headers.so
LoadModule usertrack_module modules/mod_usertrack.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule mime_module modules/mod_mime.so
LoadModule dav_module modules/mod_dav.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule asis_module modules/mod_asis.so
LoadModule info_module modules/mod_info.so
LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule vhost_alias_module modules/mod_vhost_alias.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule imap_module modules/mod_imap.so
LoadModule actions_module modules/mod_actions.so
LoadModule speling_module modules/mod_speling.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule cache_module modules/mod_cache.so
LoadModule suexec_module modules/mod_suexec.so
LoadModule disk_cache_module modules/mod_disk_cache.so
LoadModule file_cache_module modules/mod_file_cache.so
LoadModule mem_cache_module modules/mod_mem_cache.so
LoadModule cgi_module modules/mod_cgi.so
Include conf.d/*.conf
User apache
Group apache
ServerAdmin root@localhost
UseCanonicalName Off
DocumentRoot "/var/www/html"
<Directory />
Options FollowSymLinks
AllowOverride None
</Directory>
<Directory "/var/www/html">
Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all
</Directory>
View 2 Replies
View Related
Feb 4, 2008
I am attempting to configure mod_auth_mysql on Mandriva linux. It seems that database is set well since if I attempt to log as a valid user with invalid password, the logs says "user xxx password mismatch. Thus it reads the database OK. If I provide correct password I got configuration error screen and log message "no Authn provider configured, configuration error: could not check access".
But I set AuthMySQLAuthoritative ON !!
I spend the full afternoon with this and I will be more then gratefull for some help.
Vaclav
<Directory /var/www/html/test>
AuthName "Awstats"
AuthType Basic
AuthMySQLUser apache
AuthMySQLHost localhost
AuthMySQLEnable On
AuthMySQLPassword xxxxx
AuthMySQLDB apache
AuthMySQLUserTable mysql_auth
AuthMySQLNameField username
AuthMySQLPasswordField passwd
AuthMySQLPwEncryption none
AuthMySQLAuthoritative On
require valid-user
</Directory>
LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule mime_module modules/mod_mime.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule info_module modules/mod_info.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule imagemap_module modules/mod_imagemap.so
LoadModule actions_module modules/mod_actions.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule cgi_module modules/mod_cgi.so
LoadModule env_module modules/mod_env.so
mod_auth_mysql is in extramodules
View 1 Replies
View Related
Mar 15, 2007
I was disappointed to discover how difficult it is to set up PHP, MySQL and virtual hosts on my MacBook Pro. I finally hired a computer science student to do it for me - but even he screwed it up.
Then I discovered a preconfigured packaged called MAMP. I downloaded the free version and now have Apache, PHP, MySQL and phpMyAdmin up and running. That still leaves the biggest obstacle of all - creating virtual hosts.
I checked out the MAMP Pro version ($50) at
[url]and read "You can set up many virtual hosts."
That doesn't make sense to me; shouldn't you be able to set up many virtual hosts even with the free version of MAMP? Or does MAMP somehow make it EASIER to create virtual hosts, and the Pro version simply allows you to make many of these simplified virtual hosts? If MAMP Pro does indeed make it easy to create virtual hosts, then I'll purchase it immediately.
I'd be interested in other comments about MAMP. Unfortunately, its support forums are awfully lame; that's why I decided to post my questions here.
View 3 Replies
View Related
May 16, 2007
I just got a new box, can someone tell me the recommend values for Apache and MySQL config? It's a Xeon 3060, 2GB of memory, 2x250GB SATAII. I have a few static sites and a high traffic mysql/php forum with ~600,000 posts and about 60 members active in 15 minute intervals.
View 1 Replies
View Related
Dec 5, 2007
I am running a few sites (business with modernbill, vbulletin forums) and wish to upgrade to...
apache 2
mysql 5
php 5 w/ phpsuexec
Any warnings on upgrading on a production server to apache 2 and mysql 5?
View 8 Replies
View Related
Feb 1, 2013
I can configure mysql and apache hadoop for distributed computing?
I would need to run an application with the implementation of many nodes "it must be scalable".....
It's a possible????
View 1 Replies
View Related
May 10, 2008
I am facing an very typical problem, when I start apache and mysql both my site works good for half and hour or so then start getting slower and slower to load and after sometime becomes completely inactive. Then i have to restart both mysql and apache to get my site back.
When sites became inactive I have to restart only apache to see it back.Restarting only mysql dont help at that time.
Apache runs without any problem when running alone .(mysql stoped.)
View 7 Replies
View Related
Jun 28, 2008
I've got a server that was running Apache 2.0/PHP 5.2.5 & MysQL 5.0 just fine, however I needed to upgrade to a newer version of MySQL.
So I uninstalled MySQL 5.0 and installed MySQL 5.1, copied the MySQLlibs over, and recompiled Apache/PHP with easyupdate. Apache & MysQL both start/run fine without errors, however PHP files don't load. Just get black pages (HTML works fine obviously).
I went ahead and updated to Apache 2.2 & PHP 5.2.6 while I was at it, but that doesn't change things. I'm not sure why uninstalling MysQL & reinstalling would break any dependencies, but looks like thats the case. Perhaps I need to reinstall some libraries?
Or would it be easier just to reinstall Apache/PHP entirely? I have no data.
View 4 Replies
View Related
Jun 14, 2008
What will be best combo of those 3 which is main core for running almost any web server.Presently i have latest mysql,apache and php installed,but some people says how that is not good beacuse newest version arenot tested yet well enough.
View 6 Replies
View Related
Jan 27, 2007
I just switched to a new server - I went from a Dual Opteron 248 with 3GB of RAM to a Dual Clovertown with 4GB of RAM. Yet, despite having mild traffic right now, my load is rather high and my memory usage is like 80% (which is ridiculous, since that would mean I would be maxing out on the old box).
For some reason, my servers usually lose access when I get around 400 people on TEXT-BASED, non-MySQL pages? How is that possible? I have really solid servers, yet people running basic Pentiums with 1 or 2GB never run into this issue.
Is there any good, cheap site that would be able to properly optimize mySQL and Apache to lower the load and figure out why the memory usage is so high? Platinum Server Management never really got this done, so even though they're great for other support issues, please don't recommend them.
View 0 Replies
View Related
Feb 9, 2007
I'm wondering if there are special notes on compiling sever softwares under x86_64 (CentOS 4.4 64bit, Pentium D)? Are there any specific flags for extra optimizations? Or the regular "./configure" will compile things in x86_64 by default?
View 2 Replies
View Related
Jun 27, 2008
I'd like to have the ability to offer hosting in two geographical and network diverse locations for both Apache and MySQL. Two entirely different instances, with different everything. ie: high avail to the max. Obviously the MySQL part is harder due to the dynamic nature.
I can appreciate the technical aspects of the question - such as data needing to replicate to 2 locations, dealing with static versus dynamic data, etc. In short, there's a few ways this could be done.
I've not been able to find a guide in my Google searches, but I'm sure this is something that has been setup before.
If you're someone with experience in having had set this up, perhaps it would be easiest if we just speak directly and work something out, either via payment or giving you a dedicated server on my network. My AIM name is IGSOBEHELPER.
Please note that I am hoping to start a technical discussion about this, hence I am not posting the message in the employment section. I hope this is not off topic because of this.
View 0 Replies
View Related
Jun 21, 2008
if it was possible to load vhosts from a MySQL database and the only solutions i found didnt work for me. Im running Apache on Windows. Has anyone seen anything that would work with Windows? The only alternative i can think of is to read the database info using PHP and output it to a vhosts config file. I dont want to do that though because it means restarting the server to load the new config and i hear that a lot of vhosts slows the server down
View 4 Replies
View Related
Aug 5, 2008
i would like to update my CentOS Linux 5 but i don't want to update mysql and apache i need to use mysql 4. When i entered yum update i can see Total download size: 245 M i can see mysql i386 5.0.45-7.el5 base 4.1 M
how can update my server without updating mysql and apache
View 5 Replies
View Related
Jun 24, 2008
I have a fairly high end server in which I have installed SIM. SIM is restarting Apache up to 10 times a day, presumably due to high load causing un-availability.
On restart, Apache / MYSQL is stable until the load / mem usage begins to climb then it is restarted again. Here are my 'load' stats for today:
Load for today
High (2:18am): 4.63
Low (3:30am): 1.20
Mean: 1.84
Latest: 1.61
Mem usage for today
High (1:36am): 9,192.9 MB
Low (1:48am): 7,995.7 MB
Mean: 8,683.1 MB
Latest: 8,781.7 MB
I have seen it using 20GB RAM before.
I have tried to follow various optimisation guides but these seem tailored to less powerful servers.
The web application I run on this server is almost entirely MYSQL based, with thousands of DB calls a day. Across the entire system I probably get 200,000 bot hits per day or even more. At peak times search engine bots are literally hammering the server.
My server specs are:
# Processor: Quad-Core Xeon Processor * 8
# CPU Speed: 3Ghz
# RAM: 32 GB DDR2
# HDD: 36 GB 15k Raptor X2 + 1TB Sata
# OS: 32Bit CentOS
Changes / optimisation of the actual application is not possible.
My configuration files are:
My.cnf ....
View 11 Replies
View Related