Multi Server Setup For DB Backup Performance
Jan 8, 2009
I am working on a busy and popular website which has a large amount of database activity - and requires hourly backups of all database data.
At the moment the site is hosted on two servers - one for the front end web server, one for the database.
Both servers are running a RAID HDD system which allows quick swaps of faulty HDDs without data loss.
An hourly full backup of database tables is running which is killing the server when it runs.
ISP has suggested installing a third server to run as a slave to the existing DB server, and hence always hold a duplicated of the live database.
I have a feeling however that this is basically just like having RAID mirroring, but on a different machine - so to solve the problem of a potential dodgy SQL statement wiping out ALL copies of the live database, we'd STILL need hourly backups to run, and hence would still see the major system speed drop each hour at the time of backup.
View 4 Replies
ADVERTISEMENT
May 6, 2009
My host and I discussed over a month ago the possibility of adding on another server so that I can use one for MySQL and the other for web, and eventually as my sites expand add a third one so that two balance the loads and the one will be dedicated just for MySQL.
Well, it's been a month now and I have had a server dedicated for MySQL and the other one dedicated for web set up. A month has gone by and my host and I are having problems setting it up - I have not been able to use the new server and have already had to pay the bill when I have not been able to use it for its purpose!
The old server was supposed to act as the MySQL while the new server was supposed to be for web. We are having so many problems trying to set this up, well at least my host is, and I am becoming more and more frustrated as the days go on because I am paying for the new server that I can't even use because it's not set up properly.
I am using DirectAdmin control panel and linking them is a pain in the butt. I linked my host to this article, but I don't think he's implementing what is being instructed to do:
[url]
The new server is still not working properly with the MySQL server and I have no idea what to do here. I have already paid for a month's service for no reason and now I am starting to feel robbed because this process is taking so long.
I am willing to switch control panels if it will speed up the process. Does anybody know of any control panels that will be better suited for my need? I'd ideally like to simply manage both servers in one control panel - under one license - and manage each server's services and most importantly the MySQL and it's databases on the dedicated server for MySQL.
View 14 Replies
View Related
Oct 21, 2014
Not sure if I labeled that correctly, but I am looking to setup a multi-server where I offer a cloud ssd hosting plan, and sata hosting plan. The current setup has ssd hosting, but id like to add another ip address, as well as its hard drive to host other websites on that specific server, which is sata based.
For example, I add a domain to my plesk 12 admin account and choose the added Ip address (the sata based one), where it points to that server to access the files for that specific website.
At the moment, cloudflare handles all of my dns settings.. but I am totally lost on how this needs to be setup and if I am required to purchase another plesk license. I am trying to avoid purchasing another plesk license and having to setup a whole new plesk installation just to do this.. This is a vps by the way, not a dedicated server...
View 4 Replies
View Related
Apr 19, 2007
I am trying to get my own set of ips from ARIN, and I need to qualify under the multi-home. My understanding of this setup is that I have 512 or more ips that I am using and that I have multiple routes in from the internet from at least 2 providers. Right now where I am coloing at I just have servers and no routers (only the ones that are provided by the co-location). In order to setup a true multi-home for my org will I need to have my own routers/switches and such to accomplish this?
View 12 Replies
View Related
May 14, 2007
What i'm trying to setup:
Internet comes in from modem into dual nic 1u server(DNS/DHCP/Firewall). It's getting an internet ip from first nic, then a private internal ip for 2nd nic. That 1u issues ip's through gig ethernet switch to 3 other servers from 2nd nic. Those other servers are dedicated for website, one for database, and one for email.
If each run win 2003 server ent, how can people access the email server if the only comp getting an internet ip is the 1u server, and same idea with website.
Also if people can access the website, how can the website server pull information from the dedicated database server if it's only getting an internal ip?
I'm thinking Microsoft Routing and Remote Access?
View 1 Replies
View Related
Nov 6, 2009
I need some advice on my situaton at my host, and possibly some frame of reference as to what can/should be expected from a VPS setup like mine and what I can expect it to manage.
I have a site that sees some traffic of about 150k pageviews per day. On any given day, it peaks for roughly a timespan of 4 hours per day where there may be about 5 req/s.
I use a standard setup (LAMP) running mod_php in Apache, not fast cgi. I have a VPS on Virtuozzos Power Panel that has 1,5 GB RAM and really an unkonwn amount of CPU. I haven't been able to ascertain that information but probably could if I asked my host.
The problem is that during these hours it gets a bit slow from time to time. Running TOP shows sometimes a staggering amount of waiting processes i.e. the load is quite high (15 - 25).
So, I'm now really at a fork in the road where I either start looking into going with a different setup, say Nginx + PHP-FPM (FCGI) and try to see if that makes a difference. I'm not really an admin so I would be kind of lost on that. I could also start looking into my code to see if I can cache more or do smarter stuff etc.
However, before doing any of the above, I'd like to ask this crowd here if you think that I've sort of hit the roof on what can be expected from a VPS of the size I just told you about. That my situation is quite normal and that the real solution is actually just to upgrade my VPS. Is it?
View 8 Replies
View Related
Sep 29, 2009
How do go about discovering where your bottleneck is with an openvpn setup?
Ive setup openvpn on my remote server and have setup everything so that my desktop clients (vista and ubuntu) at home can connect and have all internet traffic directed successfully through the tunnel.
Im using it to stream video that would normally be inaccessible outside of the UK whilst im in Japan i.e. iplayer.
The problem is its oftenvery choppy and unplayable. Though its good when england is sleeping.
Im new to servers (not to stuff like programming though) so dont know where the problem lies, how to find it out or even where to start looking. For example things ging through my head
Is it the limitations of the vps? How do i find that out? my plan:- vps1
Is it the location of the actual server in the uk? How do i know if there are any better coming from japan?
Is it my configurations? How do i pinpoint that?
Or is it working as good as it can be? How do i know that for sure?
etc etc
What would be your process of elimantion? Quick checks that would tell you which direction to move forward in?
View 2 Replies
View Related
Apr 8, 2015
My Centos server running Plesk12 is running scheduled backups every sunday 3AM.
The backup is configured so that it's created as a multivolume backup with a volume size of 2047MB.
The backup is placed on my Personal FTP repo (another plesk12 server mounted with big storage).
The backup content is configured to backup server config and content (all).
The problem I have is when the backup is running I can see that it creates the volumes and stores it locally. After it send all the volumes the the external FTP repo it will delete the local (tmp) data. See my attached screenshot for storage health during backup.
Is this behaviour normal? This way we can never run a backup to an external FTP repo when our server passed 50% storage. Is it not normal to:
- Create a volume
- Send it to FTP repo
- Delete volume locally
- Repeat until done
View 5 Replies
View Related
Jul 19, 2009
i have 100 web hosting clients that i want to move 50 clients to another server but i only now have one domain for the dns
server 1#
hostname : host01.dnsdomain.com
nameserver1 : host01.dnsdomain.com
nameserver2 : host02.dnsdomain.com
server 2#
hostname : host01.dnsdomain.com
nameserver1 : host03.dnsdomain.com
nameserver2 : host04.dnsdomain.com
and in the domain control panel i set the nameservers for the dnsdomain.com
nameserver1 : host01.dnsdomain.com
nameserver2 : host02.dnsdomain.com
and i didn't create account for it just dns only
is this a right way to create multi dns for multi webhosting servers?
and when i want to make subdomain hosting account site someting like
test02.dnsdomain.com
it didn't work
View 0 Replies
View Related
Jan 13, 2009
We have two in-house servers, one is hosting our public web server. The other one was just purchased to host a mirror of the production server (as a backup). The site is protected by an SSL cert... my question is how do i set up the server(s) so if/when the backup server needs to be switched into produciton, the SSL cert will transition flawlessly?
They are both apache 2 servers.
View 2 Replies
View Related
Jun 25, 2009
The data centre which I use, is moving all collacated servers to a brand new data centre next week, which will mean a two hour downtime for each of my servers and customer websites.
At the moment my servers utilise two nameservers on seperate servers and when the move happens all websites will be offline with an ugly error message to any visitors.
Does anyone know a good way to setup a page which would be displayed if the web server was down? I am using MS DNS.
My thoughts so far is
1. Setup a 3rd nameserver which is off site from the data centre.
2. Purcahse web hosting / vps for a month on a seperate hosting company
3. Set it up so that it accepts * to a specific IP address in IIS or apache
4. I create an index.php script which gets the host header value sent i.e. [url]and the page then displays a nice maintenace i.e
"We are sorry joeblogs.com is currently down for maintenace, we will be back online shortly".
I think my main question is do I need to setup a 2nd www record in DNS for each site and how do I ensure the 2nd dns (backup record) only gets used when the first website / server is down.
View 0 Replies
View Related
Apr 10, 2008
I'm starting to do my homework on a dedicated server and am really not that savvy on what's best for my needs.
Firstly, I'm just trying to determine how much grunt I need and am not really sure of the benefits of multi-core vs single core vs single processor vs multi processor.
I've been running on a low density VPS with 1 Gig ram for a while and it's doing fine but won't handle this setup too much longer. My site does a very high amount of disk read/writing and for the size of my site there are a lot of database calls.
I'm thinking a multi-processor will do wonders for a database intensive site, but will a single multi-core process do fairly well also? My budget is at the low end and obviously I can afford more for a multi-core single processor.
View 9 Replies
View Related
Jul 31, 2007
say you run a script like DIGG and then it just became huge and huge and one day u find out that a server cannot run it alone, that is u need to get multi servers to cope with the traffic and database requests. How would people go about doing that? Is it the script implementation side of change or just server side of change?
View 3 Replies
View Related
Apr 24, 2007
I have a local server who has only 1 IP. I would like to ask how to setup multiple site by using different ports. eg: site1:8080 ; site2:8081 ; site3:8083 , etc.
View 3 Replies
View Related
Apr 2, 2009
for a SMTP server / hints at how it might be done to accomodate the following :
One single email will be sent. If it doesn't get sent on the first try by one server, another server at another location will attempt the connection and will send out the email then.
Is there a prebuilt solution that anyone knows that will help with these things ? If not, do you know of any ways that this might be possible to be done - even if you don't know the exact details of how it should be done - any help in finding out something like this would help .
Note :
Linux / Windows / FreeBSD / Solaris is fine. So whatever OS it is, it's fine by me.
View 2 Replies
View Related
Nov 28, 2007
Its been a while since I have posted on here, anyway heres my problem.
I have a cPanel server in my office which handles the email for 2 domains.
I've also got a reseller account on a helm server.
What I want to do is: if I have a problem with the office server (outage) all emails will be routed to the helm server then delivered back to the office server once available. So any incoming email wont be bounced/lost.
View 1 Replies
View Related
Oct 23, 2009
I got two identical hard disks, one uses to run everything other is for backup, how to setup automatic backup of website content and MySQL database?
View 3 Replies
View Related
Aug 2, 2009
I just got a VPS plan for the first time where I want to host several new websites. In the past I've used individual accounts to host a couple of other websites and haven't paid much attention to nameserver setup, just configured at my registrar whatever I was given from the hosting service.
So, I got a brand new domain to act as the host of the rest of the domains I'm setting up: www.example.com.
In the VPS I have setup this one as the default domain for nameservers: ns1.example.com
ns2.example.com
Question 1:
- Can I setup ns1.example.com and ns2.example.com as the nameserververs for www.example.com ? i.e. nameserver is used for the same domain in which it is named. Even if this is possible, is it a good idea or would it be better to host it somewhere else? When I try to define those as the nameservers in Godaddy I get the error message Nameserver not registered. What am I missing?
Other DNS questions
Question 2:
- If I host my nameservers in my VPS, I will need a separate IP for each one (ns1, ns2...and so on). Can I still use those IP's to actually host websites, or do I need additional IP's to host the actual sites? Any value in keeping each IP dedicated to a nameserver?
For example:
IP#1 = used for ns1
IP#2 = used for ns2
IP#1 = used for website 1
IP#2 = used for website 2
Question 3:
- Are DNS backup services valuable if I host my own nameservers? Any suggestions on good quality providers? Price not an issue.
Question 4:
- If I used DNS backup services for example.com will that apply to ns1.example.com and ns2.example.com which I used for my VPS? and therefore will be applicable to other domains I host? Does this make sense? Or would I need a separate backup for each domain I host? Can I use one backup for multiple domains?
Question 5:
- What are the drawbacks of hosting multiple sites under the same IP? I control all sites under these IPs
Question 6:
- Can somebody recommend a good resource to learn how IP, DNS, nameservers, etc work? Any book, paid website, video... anything ? While there's a ton of info on the web, all is scattered and none seems to be too detailed enough for somebody starting to learn about this.
View 5 Replies
View Related
Jul 2, 2008
to make a backup of my Cast-Control setup
and accounts, so I can install on a new server.
According to the Support website:
[url]
Its should be easy , using a SSH connection to backup,
but when I try the command:
tar -cvvf castcontrol.files.tar /home/MyDomain/public_html/myCast/
I get invalid directory!
I have notice that there´s no myCast folder inside my server,
on that directory there´s only the "castcontrol" folder.
I have tried with that, but same error!
Even not using any domain, just
/home/public_html/castcontrol/
View 2 Replies
View Related
Sep 29, 2014
I've been running a Plesk server with around 100 domains for years and years now. I've always used a backup service provided by the server vendor, but with a new server, I wanted to consider some of the backup options built into Plesk.
1. It looks like Plesk/Acronis is dead or only for Windows. Is that right?
2. If I add a backup drive to the server, can I setup Plesk Backup Manager to store the backups there (instead of on the main RAID array)?
3. Are there any other 3rd party extensions that I should consider?
View 8 Replies
View Related
Jul 13, 2007
I am using dreamhost host 3 of my web sites and 1 blog. Dreamhost is great, offers alot space and bandwidth.
but I think they are oversellling their space, sometimes it gets really slow. (overselling ? ok, I dont really know, but sometimes its really slow, and most my asian readers said need to refresh to load the page. I am wondering if theres a way to check if they are overselling or not.)
I am thinking about buying vps, even tho, I still got 5 month left with dreamhost.
I found 2 vps companies are highly recommanded on this forum, JaguarPC and LiquidWeb.
theres already a post compared both companies in terms of price and service. I say I will pick JagarPc, cuz, its basic plan just 20 USD, and htey got promotion now, its even cheaper. and basic Liquidweb vps plan is 60 bucks.
I am wondering why Jagarpc is so cheap , are they overselling? how can we check if they are overselling.
I found a few posts saying how good jaguarPc is. and they are not overselling, but those members just signed up this month, and only have 1-3 posts. I cannot really trust those new members.
Can someone share their experience with JaguarPC? compare JaguarPc performance and liquidweb performance. antoher question is switch from dreamhost to JaguarPC basic vPS plan, will performance gets better?
last question: VPS account allows 3 IP, 3ip = 3 domains? if not, how many domains can I have?
View 14 Replies
View Related
Apr 12, 2009
We are getting into VPS hosting and wanted to get some opinions and feedback as we're quite unsure on what to expect as for performance and how many clients we can generally keep on a box.
For now we've bought 3 dell R710 with dual Xeon L5520, 72GB ram and 8 x 2.5" SAS drives.
We are thinking of a base offering of 512 megabytes of ram and
was hoping to get about 40-50 onto a server.
With 40 there should be -plenty- free ram and plenty drivecache.
Then a next offering of 1 gig ram and next one of 2 gigs.
Even if we do the biggest 2 gig offering with 25 on a server we should have free ram to spare.
The software would be virtuozzo.
Any thoughts on this, am I expecting too much, or am I being fairly realistic?
View 6 Replies
View Related
May 7, 2009
Hi"Optimization of computing resources has long been an important management issue. One of its aspects concerns server scalability and the question of whether an organization should scale-up or scale out.Assume that the computing performance of the servers can be measured by variable 0 <=p, that their total cost is given by "c" and the relationship between server performance and cost is defined by c=αp^β"
a. What is the cost-performance elasticity(ђ), precisely?
b. What would be the range of values for ђ that would be expected by moore's law and what are its implications?
c. What would be the range of values for ђ that would lead managers to scale-out? Draw a graph and throughly explain the implications.
View 8 Replies
View Related
May 2, 2009
We are a web-based Yacht Charter company, with offices scattered around the world:
www.boatbookings.com
Currently, both our web site and our back-office business management system are hosted on a single server in the UK, with an automatic fail-over to a server in Dallas, TX, USA.
The problem we are having is that our sales office in Singapore is having really slow response times and this is very frustrating for them.
Using an application called "JustPing" we see that response times From Singapore are much slower than other parts of the world. (the cities closer to London are fastest, the ones further away are slowest)
JustPing Results
Is there anyway to improve this or is hosting our applications on multiple servers the only way to improve performance. What's the best cost-effective method of multiple server hosting?
(Incidentally, if I JutPing Google, response times are fantastic worldwide, but we know they're hosted on many, very large servers)
View 3 Replies
View Related
Sep 29, 2009
I was just playing around with litespeed and I thought I would switch back to apache for a few min to see how the server reacts. The load with litespeed was 1.00 - 3.00. I switched to apache the load jumped to 28.00 - 35.00. Its amazing how litespeed is handling connections.
View 14 Replies
View Related
Jun 15, 2008
Is there a site which will enable me to enter url of my website and it will simulate visitors from multiple locations. It needs to open the page completely, and run for example 10 minutes. Two things I found are host-tracker, but it just gets headers from multiple locations, and does it only once. Another thing is Paessler software which can test exactly what I want (number of visitors for some period of time with full page download) but it must be run from one (my) PC, so I can not test bandwidth from multiple locations. I need combination of these two, anyone knows for something like that on the net?
View 5 Replies
View Related
Aug 17, 2008
My dedicated server is sometimes sluggishly slow. I would like to get a grasp of its performance during a day, to get a better understanding of what's going on.
Therefore I am looking for a server performance monitoring service. All service I found so far were simply monitoring uptime (server is down / server is up). I need something more - a service that checks every 30 seconds or so the loading time of the main page.
Then it would allow me to download the data in CSV or draw a response time graph.
View 2 Replies
View Related
Jan 8, 2007
I've recently found (last 6 weeks) that the performance of my client's websites on my trusted host's servers isn't how it used to be and/or how it should be. The download seems to take way much longer than before. So far it hasn't resulted in a significant drop in average pageviews per unique visitor but it might do if things continue. The host claims a number of attacks on the mailserver and an unusually high load at one point in time. Above all it's just annoying - isn't reliable server performance what can be expected from a reputable host?
Here's the question: what's the best way of monitoring online how the web and mail servers are performing so that I can take this report to my host and urge them to take (more) action? Ideally I'd like to compare this with a seperate web server that I use for another client. I don't mind spending a little bit of money but high subscription fees are not in my budget.
View 4 Replies
View Related
