my vbulletin site has been growing significantly and the server has crashed many times due to the high loads. My server guys tell me that mysql is hitting loads of 30 (not sure what that means) and i need to get another server for mysql alone.
They recommend that I shld go for raid-5 for the mysql server due to performance and redundancy. Thus if i was to upgrade now, I shld just go straight for a raid-5. Is that true?
I have a server with lots of sites and about a hundred MySQl apps. All of them are configured to talk to localhost and work fine. But I'm trying to move the MySQL off to a separate box to increase performance.
So since everything was configured to localhost my idea was rather than change that what I would do is set up an SSH tunnel to the new server running MySQL. Seems like that should work, but it doesn't.
I set everything up on the new computer. I shut down mysql copied all the files over, started MySQL on the new server. Everything tested fine.
Then I established the ssh tunnel and everything looks good, but the applications just didn't see it. I did some experiments and if I set it to 127.0.0.2 it works, but not on 127.0.0.1.
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.
My video sharing site has high traffic, alexa rate:3,000
My site has 2 servers to split the load. 2 servers share a mysql server. Using rrdns to load the balance.
Server A running mysql 5.0,lighttpd
Server B running lighttpd.
Server B connect to A's mysql database.
During peak time. B can not connect to A's mysql server. It says server not responding. But A still running fine.
When I check mysql log file.
/usr/libexec/mysqld: Forcing close of thread .....
And when run top, the load average is 20.
The spec of Server A
Intel(R) Xeon(TM) CPU 3.06GHz dual core.
2G Ram.
Here is the my.cnf
Quote:
[mysqld]
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
max_connections = 1000
wait_timeout=60
connect_timeout=10
interactive_timeout=120
join_buffer_size=1M
query_cache_size=128M
query_cache_limit=2M
max_allowed_packet=16M
table_cache=1024
sort_buffer_size=2M
read_buffer_size=2M
My question, do I need another maching C to run lighttpd, and just keep mysql on A.
Or I can do some mysql optimization on A.
Also, if my site keeps going, can I have 1 mysql server and 5 http servers?
We have a VPS service with ServInt to host only our website (www.ourdomain.com for example) and not our email - the nameservers are also not on our VPS. This all works great but it means that any emails which are sent from our VPS to xxx@ourdomain.com are getting routed to the VPS and not the email server and so are being dropped.
Is there a way around this because ServInt support seem to be stumped because they have suggested the only way to fix it is to setup nameservers on the VPS instead of where they are now?
if it might be a good idea to have a separate forum just for the discussion of server hardware.
View 2 Replies View RelatedIf anyone can help me in doing this, I'd appreciate it. I searched to see if anyone had already done this, but I didn't find anything so my apologies if this has been answered before.
Here's what I have: 1 dedicated server with a static ip of course and currently, I run all my sites off of this machine as well as my few clients. The server is running CentOS and Apache.
What I want to do is build a new server at my house/office and create a secondary webserver that mirrors my current setup. I've heard about using Rsync to do this, but I want to know if it'll allow for the balancing effect I'm looking for.
Rather than use this 2nd server as a backup only, I want also use it for dns resolution. Right now, all my sites are using two nameservers (NS1.2D.NET and NS2.2D.NET), but they both point to the same IP address at the same location. I want NS2.2D.NET to point to this 2nd server for redundancy (in case the other location goes down) and also for balancing (to spread traffic over two servers instead of just one).
Eventually what I'm going to do is move all my clients and websites to one location again, but my own location so I can save the expenses of dedicated hosting off-site. However, I want to use this setup as a test to see if my own location will be able to handle the traffic and such.
I've been looking around on how to do a remote mail server for cPanel.
I am talking about two separate dedicated servers. I want this first server to serve as the mail server of my second dedicated server.
Is it possible to use a remote database server on two or more Plesk installations without issue?
Plesk A (192.168.1.1):
Local MySQL (default)
Remote A MySQL (192.168.1.5)
Plesk B (192.168.1.2):
Local MySQL (default)
Remote A MySQL (192.168.1.5)
... etc etc. Is that possible? It'll allow me to create databases on the remote server from both/all the Plesk servers without conflict?
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?
What is the average memory/cput usage for httpd connections.?One of the site is using 2.8% memory. Is it acceptable for 1 GB RAM servers?
View 6 Replies View Relatedi'm thinking about building a separate mail server away from my cpanel/whm machine. that mail server will be located on a different IP address with "clean" record so that business email won't get deleted my strict rules of hotmail.
can you please tell me, generally, about this "buidling separate mail server", i.e. what MTA, software, web-mail software, will it be worth? ,etc. Pointing me in the right direction will allow me to complete the project in the shortest time.
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.
I have been running 1 site on my VPS for some time, but there is still a lot of things I don't understand 100%. Now I want to add another site to the VPS, but keep the sites as separate as possible, and I have no idea how to accomplish this.
Lets say my first domain is football.com. This means I have these settings:
I got 3 IP's: x.x.x.1, x.x.x.2 and a new one x.x.x.9
My hostname is host.football.com (x.x.x.1)
My site is www(dot)football.com (x.x.x.1)
Nameserver NS1.football.com (x.x.x.1)
Nameserver NS2.football.com (x.x.x.2)
Reverse DNS on x.x.x.1 to host.football.com
Exim running on x.x.x.1
Lets say my second domain is water.com. It's no problem using WHM and run this site on x.x.x.9, but there is a lot of references to football.com (nameservers, hostname and probably emails).
Is there anyway to keep the sites separate? I'm thinking that I need to request 2 new IP's, run NS1.water.com and NS2.water.com on these. I don't know if I can get a host.water.com with reverse DNS, and I guess emails will still be from x.x.x.1.
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.
Does xen run better on a double processor server rather than an intel duo?
View 1 Replies View RelatedI have a domain : [url] pointed to server A with IP : 11.11.11.11
I want to make : [url] pointed to server B with IP : 22.22.22.22
I'm using CentOS on server A and I have cPanel/WHM on it and btw I found this tutorial about what I'm asking for but it didn't work after I did it
I am setting up an internal network for management only. So, assign an IP for the second NIC, and activate it, but it seems not working. I have tried this
#ifconfig eth1 192.168.2.14 netmask 255.255.255.0 broadcast 192.168.2.255
#ifconfig eth1 up
checking dmesg, it shows the NIC is up
# dmesg
ADDRCONF(NETDEV_UP): eth1: link is not ready
tg3: eth1: Link is up at 100 Mbps, full duplex.
tg3: eth1: Flow control is off for TX and off for RX.
checking routing table seeing the 192.168.2.x routed through eth1
# route -e
192.168.2.0 * 255.255.255.0 U 0 0 0 eth1
192.168.1.0 * 255.255.255.0 U 0 0 0 eth0
169.254.0.0 * 255.255.0.0 U 0 0 0 eth1
default reserve1.somename 0.0.0.0 UG 0 0 0 eth0
Repeat those steps for other boxes, but when pinging, all return errors
# ping 192.168.2.20
PING 192.168.2.20 (192.168.2.20) 56(84) bytes of data.
From 192.168.2.14 icmp_seq=1 Destination Host Unreachable
From 192.168.2.14 icmp_seq=2 Destination Host Unreachable
From 192.168.2.14 icmp_seq=3 Destination Host Unreachable
Before I went to register with GoDaddy, I looked back at some web hosts I was considering. Some real good ones include free domains. What are advantages to bundling a domain with the hosting package? Is setup usually quicker? What if, at the end of a yearly contract, I decide I want to host my site with a different company? I certainly hope domain names are transferrable around the expiration period.
View 17 Replies View RelatedI know this is not an awesome idea, but I'd like to try it. A friend and I want to share (home) servers. We both have fairly decent upload and we both have nice (dual core, 1GB RAM+) servers, so that's good. Another thing I'd like is failover for when one of our servers go down (I've got that part covered with my own DynDNS client). We're both running Windows servers.
Since I cant really use a load balancer in this situation, we'll be using round robin DNS. Now here's the questions:
How do we keep our MySQL servers synced?
Should I use rsync or something else for files?
How do we handle PHP sessions across servers?
If you don't think the load balancing thing will work out, I'd still like to do synchronization and failover. My friend is in another state by the way, we're not neighbors or anything so we can't just run some cables from one house to the other.
Anyone aware of a hosting company with all of their hardware in Canada who offers in their basic accounts the ability to host multiple domains without using sub-domains or sub-folders.
I want to host several domains with individual administration and security so that a bad script or hack of one wont affect the other domains.
Hoping to do it with a single account.
Is there anyone here using Softlayer for Windows dedicated servers but at the same time using a server management company to manage the same?
I use Platinum Server Management for my Linux server, but they don't do Windows. I'm looking for a Windows server management company who has experience with Windows 2008 Enterprise and MSSQL 2008 Standard.
I found the page listing all of the 3rd party server management companies, but what I want to hear are successful marriages between Softlayer and the management company based on experiences of real users here.
if it is better to host two related websites on single host or on separate servers?
currently we are hosting three related websites on 3 separate webhosts. one in US, another in UK & another in Nepal. can anyone please explain if is it better to use single webhost?
I'm starting to see this, or maybe it's always existed, but it seems like bigger sites are hosting their images on external servers. I've even seen some sites use Flickr as the host for all of their images. I guess for Flickr that means you have a guarenteed image CMS, but I really don't see that as why Flickr was created.
I'm sure there are bandwidth advantages, and maybe that's the main reason. Is there a point where the traffic gets so high that moving images off site would improve load times and sever loads? Is it a worthwhile endeavor for smaller sites? I'm curious to see what the thoughts are on this trend.
My family is getting into the blogging business and they want to be hosted together to share costs. What features should I look for in hosting 4 or 5 small but growing blogs?
Info that may help you give a recomendation:I plan to have a separate url for each blog's root directory.
I plan to use wordpress.
I want each site to have it's own email addresses.
In an effort to install an SSL cert for a subdomain (secure.domain.com), I recreated my accounts in WHM. Account 1 has userA and domain domain.com, and Account 2 has userB and domain secure.domain.com. I think I have everything back to normal, but I want to get everything stable before testing the cert install.
My question is, when visiting cpanel.domain.com, to enter the cpanel for that account, I am able to login with both userA and userB credentials, and the same when logging in to cpanel.secure.domain.com. As stated, I have separate WHM accounts for the main domain and the secure subdomain, I have dedicated an IP address for the secure subdomain, and the main domain uses the share IP address, and also, there are separate DNS zones setup for the secure subdomain and the main domain.
How do I set it up so that only userA can login to cpanel.domain.com and only userB can login to cpanel.secure.domain.com? Or is this not an ideal setup, and if not, what would be the ideal setup here?
I've setup two servers with Webmin on them. One is a master nameserver, and the other is a secondary nameserver.
I've setup a third server with DirectAdmin, and ofcourse, DA installs everything for you.
When I add a domain on DA.. it asks me to do all the DNS stuff there too.
Now, from what I understand, if I add a domain to a server, I host its DNS on that server too. Correct?
But then again, I've also seen many installations where the DNS servers are two completely different, even geographically, servers. And the main http/mail/db server(s) are different too.
I have a website and I have 15 e-mail accounts for my employees
for example - my website is Gazeboentertainment.com
and I created 15 E-mail accounts for 15 employees like -
abc@Gazeboentertainment.com
def@Gazeboentertainment.com
ghi@Gazeboentertainment.com
and so on...........................
But I want to create a seperate link where my employees can login directly.
For doing this it requires my ftp user ID and Pwd.
I want to create a seperate link for this,
How can it be determined that multiple domains are "affiliated" with each other? For example, at the link below, on the left side of the page it says that yahoo.com, yahoo.net, and yahooligans.com are owned together. Does this mechanism use WHOIS records, or does it use the IP addresses to which each address resolves (which would only get sites that use named-based virtual hosting to the same IP address, right?)
[url]
If people run multiple sites, say personal and business, and they don't want them to be affiliated, how can they make sure they can’t be linked with each other through such mechanisms?
I just started using plesk for my blogs and websites, so testing and finding my way around i notice every site i add instead of having its own folder just like in cpanel(shared hosting) the sites are been added under the primary domain.
example; maindomain.com/seconddomain.com
I want it to be
maindomain.com
seconddomain.com
thirddomain.com
etc ...