Synchronizing MySQL Powered Site Across 2 Dedicated Servers
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
ADVERTISEMENT
Jul 16, 2008
I 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.
View 6 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 16, 2008
I have a small dns cluster with 4 servers, the problem is that when i want to update a dns registry one of them doesnt sync, i have to try like 6 or 8 times to get that server to sync with all the others, and im concern because the one who gets trouble to sync is my secondary dns server
View 2 Replies
View Related
Apr 14, 2015
Starting point: a working site using a shared IPv4, dedicated IPv6, and SSL. HTTP and HTTPS work, the latter only using SNI of course.
The good news: If I simply allocate an IP resource of 1 to a subscription it is pulled from the pool, assigned to the service node, assigned to the web site, DNS is updated, and the site is automatically changed to using a Dedicated IPv4 and Dedicated IPv6.
The bad news: visitors land on the default web site of the service node, with the default SSL certificate.
Other info: I can't ping the new IP, even though it shows in "ip a l" and /etc/sysconfig/network-scripts/ifcfg-eth0:0. [edited]
After the IP assignment, it is still installed, and /etc/httpd/conf/plesk.conf.d/ip_default/domainname.conf shows the new certificate is being used.
However, a second set of VirtualHost entries is created in server.conf for this IP for ports 80 and 443, with NameVirtualHost enabled on the new IP. The port 443 entry uses the default certificate. Apache's setup this default VirtualHost entry will override the web site configuration because Apache is listening on port 443 with the wrong cert.
If I go to "Change webspace settings" and toggle to Shared IPv4, Dedicated IPv6 the site works again via HTTPS, and Dedicated IPv4 and Dedicated IPv6 breaks it again. Setting the SSL cert to None and back again does not work.
Setting the SSL cert to None, changing to a dedicated IP, and enabling SSL results in the server being inexplicably inaccessible...browsers no longer connect to either the default site or the correct site, and I don't see any entries in the vhosts's logs.
View 6 Replies
View Related
Jun 2, 2009
I'm questioning whether a host is really wind powered as they claim. They are a reseller and have a GoDaddy SSL seal at the bottom. I know that doesn't mean that they're reselling GoDaddy hosting - but isn't it a little curious?
How can I find out if this reseller is really wind powered?
View 17 Replies
View Related
Mar 26, 2009
Some information about my forum:
I run a VBulletin forum with - 575,614 post, 14,369 members and 2.9 million page views per month. On average there are 300 - 400 people on the site.
The server right now is a Linux CentOS VPS with 1.1 gigs of memory. The hosting provider keeps telling me that I need a dedicated server.
Question # 1 - In your opinion - do you think its time for a dedicated server?
The server I am looking at has these stats:
E8300
2 GB RAM
250GB HD
cPanel
Management
The price I was given is pretty good. So the offer is going to be hard to pass up.
Question # 2 - Has anyone here used Future Hosting for their dedicated server solution?
View 9 Replies
View Related
Dec 19, 2008
I've been with this guys for over 4 months, but for my surprise when I got home today from work just noticed that my server is being "unpluged" for hours.
I did get an e-mail about the outage and was aware about the datacenter move. I am with live chat now waiting for some response and will update soon.
I hope my server did get stolen or lost during the move... and hopefully i will be compesate for this huge downtime.
View 11 Replies
View Related
Oct 11, 2009
I am just colocating servers and managing them myself, and renting services off of them. In the future I would like to start offering dedicated servers as well. I am wondering if many companies do this, or if its more of a general practice to just setup as a reseller? The worst part that comes to mind is thinking of how to do billing for the bandwidth per month. With my setup I would only be offering flat bandwidth packages (like 2TB a month) but even so, I cant think of anyway to automate it so WHMCS knows if they went over, if so, how much, etc.
View 6 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
Sep 6, 2009
We have just signed up with Interactive in Melbourne. They claim that in November they will be the world's first 100% green powered Data Center.
View 14 Replies
View Related
Oct 24, 2009
I'm currently transferring my files from my VPS Servers.
The Source file is from this VPS;
Windows Server 2003
100MBPS Port
Hosted at ServerComplete's Atlanta, GA DC.
and I'm downloading the file from;
Centos 5.3 w/ Cpanel
100MBPS Port
Hosted at Futurehosting's Dallas, TX DC
So the question is, Is it slow to get only around 300-800k/s download speed on a 100MBPS port powered VPS? .....
View 8 Replies
View Related
Jul 13, 2009
How do I apply a MAC Address (of my choice, not random) to a VE (Virtuozzo powered)
I tried this:
[root@node root]# vzctl set VEID# --mac "actual mac address here" --save
Invalid usage. Option --ifname not specified
In order to license software for use for my client's company, the vendor needs the MAC Addresses setup for their vps' virtual enet interfaces.
View 3 Replies
View Related
Oct 4, 2007
I've just initiated myself to splitting the load between servers... in this case, one server delivers all the html/php/mysql/emails, another serves all the images... its an auction site so there are loads of images.
Just did some testing using Firebug, with 20 5-10kb thumbnails loaded from the image server, everything else from the original server... the results speak for themselves:
no browse cache:
current - 11.7 seconds
test - 5.6 seconds
refresh (checks modified date on some/all files I believe):
current - 8.6 seconds
test - 4.1 seconds
I'm not testing scientifically or anything but these times were fairly consistent over a few dozen trials. Obviously also there are other factors with network connections, server loads etc. From my primitive knowledge I figure that if you fork the requests down 2 or more paths, instead of just 1, then you are virtually doubling the amount of requests that are taking place, hence the page loads faster.
Is this consistent with what others have found? In this case I figure the images are the common denominator so having them on the 2nd server makes sense. I also understand that databases, emailing and other processes can be split onto a separate server...
On a final note, can I get a recommendation...
#server 1:
hosts html, css, javascript, PHP, MySQL databases, and sends emails... php 5 is required and security is very important
#server 2:
hosts images and will possibly stream videos... basically just a file system we can access from another site
What would be the advisable server specs and operating systems for each? They would not be under a heavy load for some time, but the idea is that they could be further expanded if necessary. I understand that lighthttpd is good for serving images?
and finally, I also require:
- a good host
- a backup solution
if anyone could recommend anything to me at this point that would be great!
P.S. don't worry, i'm not setting the servers up myself - but i'm kindof in the position where I have to make the decisions!
Off Topic:
woohoo! 1,000 posts!
View 14 Replies
View Related
Aug 8, 2008
I run a website that gets a huge spike in traffic approx. once a month for 24 hrs.
Can you mirror one site on two separate servers and add load balance via the DNS records on godaddy.
exmp.
ns1.siteone.com
ns2.siteone.com
ns1.sitetwo.com
ns2.sitetwo.com
Is this possible? If one server goes down will I loose 50% of visitors or will it all forward to the up server.
View 15 Replies
View Related
Nov 10, 2008
Would it be possible to split website components transparently across 2 servers and make it look like a single site? For example: run a forum on ServerA and a wiki on ServerB, but with the same base URL? Doing this will allow me to buy smaller servers instead of a single huge server.
View 9 Replies
View Related
Jan 22, 2008
Let's say I want to host DOMAIN.COM on one server, and FORUMS.DOMAIN.COM on another server.
View 3 Replies
View Related
May 14, 2007
Is it possible to resell servers belonging to some other site and yet not letting the customers come to know who exactly is the owner of the server?
Something like adding personal name servers to a reseller?
View 5 Replies
View Related
Apr 7, 2009
I use shared web hosting service to get my website online. I'm wondering how many people use dedicated servers or virtual private servers instead and pay from $20 to several hundreds of dollars? Will I face any big problem with shared web hosting package which makes me choose dedicated servers?
View 14 Replies
View Related
Sep 30, 2007
I would just like to no how you would load balance 2 sites. Would this be done via dns settings. EG
instead of seting the domain to something like
ns1.server1.com ns2.server1.com
would it be?
n1.server1.com ns2.server2.com
View 4 Replies
View Related
Apr 21, 2008
My forum is becoming more and more active and i would like to know how to setup a website on two servers. Ive seen many sites using www0.example.com and www1.example.com. Is this difficult to do?
View 5 Replies
View Related
Oct 11, 2008
We are developing a new web site that will be collecting private information (no credit cards - only names, phones, email addresses and potentialy addresses etc).
Our company will be based in the EU and the target audience will largely be located in the EU.
We were thinking of using some of the very respected US companies like theplanet or softlayer that have very good prices for a quality service instead of the more expensive and less flexible EU based solutions.
But I was wondering whether this would violate the EU privaxy regulations (not sure if softlayer or theplanet are part of the US Safe Harbor) or whether there would be a way to cover ourselves (e.g. special contractual binds with the provider (which i am hoping would be part of their standard SLA/T&C) or by mentioning in the Terms & conditions of our site that data will be stored in the US.
View 7 Replies
View Related
Jun 14, 2008
I own a site that is MySQL driven, shared hosting is no way to go now with over 100 guests on the site, and alot of MySQL usage...
My question is, do we need a dedicated server? or the site would function great with 99% uptime on a VPS?
Another issue is, the site gets DDoS / DoS attacks between now and then, haters out there... so would a VPS be able to stay up against the attacks? can I install CSF with no problems? or any other firewall?
Let me know what you think, and if VPS is the way to go, please suggest some VPS hosting providers...
View 6 Replies
View Related
Apr 3, 2008
What would be the site hosting capacity of a dedicated server in terms of numbers of small sites.
1000 visitors a day for example.
Perhaps 5 page views a vistor and each site having a VBulletin as a sub-domain.
Would it be best to run them all off one dedicated server or each site just off a small hosting plan?
For organizational purposes it seems the dedicated server would be the way to go?
View 2 Replies
View Related
Oct 6, 2007
How much dedicated (and burstable) RAM would one need for a community site that averages 60 signed users for its performance to be good?
View 5 Replies
View Related
Sep 29, 2009
Currently, I am using 1 VPS, and pay $30/mo.
Now, I want more resource. Should I buy another VPS ($30/mo)? Or buy a dedicated server(<=$60/mo)?
I understand that the 3rd choice is 1 upgraded VPS($60/mo). But I do NOT think it's better than 2 small VPS($30/mo).
which one is better? For now, I do NOT want to pay more than $60/mo.
View 6 Replies
View Related
Mar 31, 2008
My lease with LayeredTech is about to renew, so I am looking for better deals, and I found several $23 $24 $30 dedicated offers here. How are those servers/network/dc comparing to layeredtech?
I have not been looking for 2 years, because I was in other business. Badly needing a update on server industry now.
I thought utility bills are up, inflation is high, so it is a shock to see the price of dedicated servers are falling.
View 14 Replies
View Related
Feb 15, 2008
Does anyone know of a dedicated servers in USA/Canada that allow IRCd, and the price is UNDER $70/mo.
A server that has atleast 1GHz of processing power is good, such as a (Dual) P3 or a Celeron, or anything better.
It needs atleast 512MB of ram, and atleast 10GB IDE/SCSI (SCSI preferred, not needed) HDD.
And with atleast 1TB+ bandwidth.
Netdirekt has a $50 server which is what I need, though its in Germany, I prefer a USA/Canada server.
View 14 Replies
View Related
May 19, 2008
Currently I run my forum with a host that is having too much downtime for my liking. I run a new forum on vBulletin with 210 + members with 1-5 new members. My main requirements are PHP5, MySQL5 and OpenSSL. What would your suggestions be for a host / server specification? Unfortunately as I am not using any advertising so my monthly budget is rather low ($50). We currently have a dedicated server with a 2.4ghz processor and 512mb ram but I would be more than happy to move to a vps if it would be more reliable.
View 8 Replies
View Related
Apr 8, 2009
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?
View 14 Replies
View Related
