MySQL Replication/Failover
May 24, 2008
I'm working for a client who has an e-commerce site currently hosted on a shared hosting solution.
He is now looking for 100% uptime (as near as), so I have suggested that we get 2 VPS and use DNS monitoring to switch servers as required (from DNSmadeEasy).
This is all fine, and the websites files/images do not change often, so I can use rsync every so often to sync these. Not a problem.
What does change frequently is the mySQL db for the site.
I've been looking at MySQL replication, but this seems to be no good. If one server goes down, then the other one takes over, they don't automatically sync themselves after they come back up. It seems MySQL cluster is best, but this needs 3 servers and they all need to be on the same LAN.
I've read you can set MySQL replication to MASTER-MASTER so that it acts like a cluster, and resyncs itself as required.
View 4 Replies
ADVERTISEMENT
Jul 13, 2009
I am trying to achieve mysql replication between server1 and server2 with help from [url]
However, I have problem connecting server1 and server2 to perform the replication. The error that I receive during the first time replication on server2 is as below:-
mysql> LOAD DATA FROM MASTER;
ERROR 1218 (08S01): Error connecting to master: Access denied for user 'slave_user'@'server2' (using password: YES
However, I am able to connect from server2 to server 1 with:-
mysql -h server1 -u slave_user -p
I have followed the exact guides but still could not get it to work.
View 6 Replies
View Related
Dec 29, 2008
I don't know much about MySQL replication at all but am trying to present a few different options to a client of mine.
They run a large eCommerce site with a very active database. For several reasons, they are considering having their site mirrored across two completely different dedicated hosting providers.
The question here is, is it also possible to replicate the MySQL database in real-time across external servers and if/how secure it is.
Essentially, if one DC becomes inactive they'd like to fall-back on the other. An even more ideal solution would be to split traffic across the two... but not sure if that's even possible, perhaps with DNS?
View 14 Replies
View Related
Jul 23, 2008
I had configured mysql replication for one of my client. Now the replication is stopped and slave server is not updating the data. How can I resolve this and start the replication again?
View 7 Replies
View Related
Mar 31, 2008
if you have MySQL replication setup, and DNS failover switches over to the MySQL Slave server in case of an outage...
Is that gonna work? Will the Slave suddenly just work as a regular non-slave DB?
Then when the primary server comes back up, how do I sync my changes back to the master db?
View 14 Replies
View Related
Dec 13, 2007
Some of you may have read my previous posts about a dual server configuration I am currently working with. I run a high traffic forum which has up to 2-3k of people online at once. I was wondering if it could be effective to setup MySQL Replication of certain tables which are read very frequently and then modifying the script to grab data from the slave server rather than the master? For say viewing threads, forums etc. Information which isn't updated literally every second.
A few questions...
-Will this place a lot of load on the master having to write the data to the slave as well? As in would the load I save on SELECT queries be used on writing to the slave anyway?
-Could this actually be effective?
View 13 Replies
View Related
Jul 22, 2008
I'm not too experienced with this, so I'm hoping someone more enlightened here can help.
Scenario:
I'm trying to build a social network site geared towards old people. I'm using LAMP environment. I want to have 1 mysql master (writes) and 2 mysql slaves (reads). Two web servers will read from the 2 mysql slaves and write to the one mysql master.
Questions:
My concern is this: when a user posts a comment via the webserver, the comment is written to the mysql master. I would like for him/her to see the comment he posted right away so they don't think something failed or went wrong. I'm afraid that replication to the mysql slaves will take some time to sync all of the mysql databases together. How can I work around this? Or am I mistaken and this doesn't actually happen?
How fast is replication? How can I mitigate this delay in replication to show the user instant results of their submission.
The same thing can apply to uploading photos to a user's profile.
View 3 Replies
View Related
Nov 6, 2008
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this.
I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to:
1. execute:
GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa';
[url]
2. Stop mysql server and Add in my.cnf:
[mysqld]
log-bin=mysql-bin
server-id=1
slave-compressed=1
binlog-do-db=user_main
start server[url]
3. execute:
SHOW MASTER STATUS;
we need values of colomns File and Position from output of above command[url]
So my questions are:
Is there any security risk?
Is there significant extra resource usage?
Is this even done on shared environments?
View 5 Replies
View Related
Jun 8, 2008
I have fairly a large web site that has a forum and a torrent tracker.
Currently MySQL server is handling about 150 queries an avarage per second.
Here is the server spec:
Core2Duo 2.66Ghz
4Gb RAM
320GB SATA 7200RPM (Server provider does not have 1.5K RPM nor 1.0k RPM)
100Mbit Connection (servers on the same switch and the switch does not have 1Gbit port)
MySQL Version: 5.0.51a
I had Master-Master Replication setup with forum running on one and the tracker running on the other.
Although this has been working for about few days, we started seeing lags in the replication process.
After a week, there is a major lag and the changes made on one of the servers takes about 5 hours to appear on the another.
So, this doesn't work.
What would be the other ways of splitting MySQL queries concerning the same database?
While I was researching, I read about MySQL Cluster with database storage engine being NDB.
But, let's say that there is a power failure on both the nodes at the same time, then I would lose the whole database as the database is stored on the memory correct?
I would not like to take that chance either, but if this is faster then replication method then maybe I will concider.
I thought about editing the forum coding to make all queries that concerns the tracker to go in to, say server B (with forum's primary MySQL server being Server A), and make the tracker use server B as MySQL backend, but it seemed like a heavy work so that will be the last choice.
View 6 Replies
View Related
Jul 4, 2007
I have this problem with MySQL
Quote:
Error while connecting to MySQL. Failover enacted.
MySQL is Running and Working, how i can fix this problem?
View 9 Replies
View Related
Aug 9, 2007
We are currently configuring two machines to act as primary / secondary name servers.
Both machines are server 2003 Standard Editions, obviously based in seperate locations.
I would like to replicate all primary zones as secondary zones on the second server.
However If a machine dies I dont want to have to re-add every zone manually - I would rather point the machine at the other one and have it pull back information for all zones that machine is authorative for.
Is there a way to do this on server 2003 DNS or not?
View 2 Replies
View Related
Sep 16, 2007
What would be the best way to replicate two exchange servers across a WAN? I would like to run exchange but in two different physical locations for redundancy and backup purposes, to ensure if one goes down, the other is right there. Is there any good commercial solutions?
View 0 Replies
View Related
Sep 11, 2009
I'm trying to find a low cost solution for realtime file share replication in a windows environment.
It doesn't look like there are any open source windows cluster filesystems around, so the only viable option I found would be running OpenFiler in a replication cluster on Hyper-V nodes. Has anyone worked with this, does it work reliably?
The required IO throughput on these shares would really be minimal and my biggest concern is 100% availability.
View 1 Replies
View Related
May 7, 2008
what can make site load faster other than replication
(well lets assume that design wise it is ok and doesnt content heavy contents...)
i have heard that increasing networking speed at the server level can make site much faster...
is it true..?
is there any tweak bandwidth wise...
suppose we get 1tb bandwidth per month compared to 100gb ...
will that make site faster...
we want to host a photogalley site...which is fast or images are shown in faster way....
View 8 Replies
View Related
Jul 30, 2009
Hello, we have a few web servers that run Windows 2003 Server and IIS for web page hosting. We develop custom applications and don't do "web hosting" per se.
What is the best way to do this in a load balanced environment? We have a Cisco load balancer out in front of these servers, but I'm curious about the following:
1) Is there a way to replicate IIS entries instead of having to configure the site on each server?
2) How does everyone handle file replication (hopefully in real time) across all servers?
View 2 Replies
View Related
Mar 26, 2009
I want to add a DNS Failover automated service at my server, in order that when it goes down, the DNS Failover enters in action and it will redirect all the traffic to a second backup/failover server (hosted at a different location).
So in order to do this i have been looking around and i have found dnsmadeeasy, and i found their offer interesting.
But i still have some question and doubts on how a dns failover service works. So maybe someone can expalin it to me.
My question and doubts:
1 - If i use for example the DNS failover from dnsmadeeasy, i would have to buy 2 servers where one is the principal server and the other is a backup/failover server, so when my main server goes down, the dnsmadeeasy will detect in a automatic way, and redirect all the traffic to my backp/failover server. After my principal server goes back online, dnsmadeeasy will automatic redirect all the traffic to the principal server.
Im i correct? Or i understound wrong how this works?
2 - I use my own Nameservers and i want to continue to use my own nameservers. So if i use dnsmadeeasy services, i will be able to continue to use my nameservers as ns1/ns2 and then i will add the dnsmadeeasy ns3/ns4...as the following example:
ns1.mynameservers.com
ns2.mynameservers.com
ns3.dnsmadeeasy.com
ns4.dnsmadeeasy.com
ns5.dnsmadeeasy.com
ns6.dnsmadeeasy.com
Correct?
View 11 Replies
View Related
Apr 4, 2009
I am planning to rent 2 managed dedicate servers with windows server 2008 and ms.sql 2008.
which I will use one for web application and 1 for database server.
why people usually divide them into web and database server? is it for security or performance reason?
Which one you prefer to choose?
- 1 server for web and 1 server for database.
or
- 1 server(web and database) and 1 server for failover
View 7 Replies
View Related
Aug 4, 2007
In making my plans for my web hosting business I plan to start, I've thought about a failover but wanted to know the best way to set it up.
I would ideally like to start with something like getting a small shared hosting solution (not reseller, just shared) at a reliable hosting company. On this hosting plan, I will host a simple 1 page site that says my company is having technical difficulties, reminds people that data is safe, and provides any contact information accessable (like e-mail/phone/etc...).
I already have DNS setup offsite.
I would like that if my server(s) go down for any reason, whatsoever, that DNS automatically starts serving the temp site.
so if my server suddenly goes down, [url]or [url]suddenly goes to the offsite shared hosting plan.
This would not provide customer site redundancy. This would only ensure that if anything happens to my service, customers have a page available that explains what is happening and has information to contact us to get more details.
View 4 Replies
View Related
Jul 11, 2008
We have 2 Cisco PIX 515's in a failover configuration (7.1 series IOS). We have available both a serial failover cable and adequate switch capacity to allow using either the serial or LAN-based approach. We have no current plans to locate the firewalls physically apart.
We have plenty of info on how to configure either, but no recommendation on which is the better choice.
View 1 Replies
View Related
Feb 21, 2009
I have a reseller account with a company that often has spontaneous DNS errors, and this, as you know looses us money. I also have a dedicated server running a panel exclusively via IIS. Is there a way I can set up my dedicated (Windows) box and my reseller account in a mirror way, so if one of them fails, the other will take over.
There are no file changes often, more database then anything. Is this possible?
Main necessities are:
-Mail Servers
-MySQL Servers
-PHP5
-Cron jobs
(Or, if a shared hosting company can accommodate this somehow and is relatively inexpensive.
View 14 Replies
View Related
Jul 17, 2008
I host my own server but need to get a failover server in the case it goes down. Does anyone know of any companies that host failover servers that will run off my own server?
View 7 Replies
View Related
May 1, 2008
Basically have 2 hosting accounts at different providers...each set-up for the same domain name...and then somehow wtih DNS make it so if host #1 goes down traffic goes to host #2 (which would basically be a splash screen explaining that host #1 is down and will be back soon).
DNS isn't my strong point, but I do know you can do this with MX records...so if the first server fails it tries the next until it gets a working one or reaches the end of the list. I'd just like to do it is A records.
It wouldn't be as simple as setting the nameservers like this would it?
ns1.host1.com
ns2.host1.com
ns1.host2.com
ns2.host2.com
Would it use the host1 nameservers as long as they're online, and if not failover to the host2 nameservers? If so, great, but what if the host1 nameservers are online but the server itself is not.
View 4 Replies
View Related
Dec 10, 2007
Assume, a DNS failover service would change the DNS from server 1 to server 2 when the first one is offline. This will be changed quite fast, however isn't it true that some visitors still experience a downtime of a couple of hours (saying that the main server will be offline for 6 hours) as their ISP might not update DNS that frequently?
So basically, what is the added value of a failover service?
View 8 Replies
View Related
Jul 22, 2008
What happens if your primary nameserver goes down? Meaning that it goes completely off the net, not even denying dns requests but completely ignoring them.
I'd guess that resolvers would query the secondary NS after a specified timeout, but what is that timeout set to? Does it differ from ISP to ISP? How much of a slowdown are we looking at for end users?
View 0 Replies
View Related
Oct 26, 2007
I'd like to create a failover server, a complete and identical copy (as much as possible) of my primary server, which becomes "primary" when the first server dies.
I've been reading a lot about this subject and i've seen an already working method which uses rsync and MySQL replication.
Has anyone managed to create such a system? is there someone with experience or can point me to a relevant web site?
View 3 Replies
View Related
Jul 8, 2007
I was wondering what sort of systems have you guys implemented for ensuring your website remains online.
Iv attached a pic of what I think are the best options.
What do you think?
Also, am I correct in my assumptions about DNS?
View 14 Replies
View Related
Jul 8, 2008
I'm building the infrastructure for a live event site.
I have specced 8 app servers but I'm still unsure with regards to MSSQL.
The site functionality makes a single write to the DB with no reads. A simple option would be to have a MSSQL DB instance on each of the APP servers and simply collate the information after the event.
I've also been looking at the mirroring function of 2005 as it would mean we could get away with two MSSQL servers instead of 8.
Has anyone used MSSQL 2005 Mirroring? Is it easy to setup and maintain? Any caveats?
View 1 Replies
View Related
Apr 21, 2009
We want to provide failover service at our server using dnsmadeeasy service.
So we have already buy the "failover server" (running linux/plesk), and now we are looking to find the most adequate / best way in order to keep the 2 servers sincronized, in order that if "main server" goes down, all the traffic can be redirect to the "backup server" using dnsmadeeasy.
on scripts/software to keep 2 linux servers sincronized in a failover setup?
View 14 Replies
View Related
Jul 7, 2008
I was wondering if this is the right section.
Well my problem is, we have 2(ABC and XYZ company) internet connection and sometimes,
the ABC connection is not active and we're disconnected for about 2-4 minutes interval to get the XYZ internet connection online.
My question is - Is there a software that will automatically set the XTZ internet connection to active? Something like if the ABC connection is down, the XYZ will supply internet connection right away.
View 5 Replies
View Related
Jun 12, 2007
CentOS, LAMP, webmin.
I have ibeat.org running on one server.
Now I want to make a status subdomain on another server.
ibeat.org on one - status.ibeat.org on another.
I've edited the master zone on server one and added status.ibeat.org. and www.status.ibeat.org. ... and pointed it with A and CNAME to the other server and related IP...
I have also created the subdomain on the second server.
So my question is what should I do to get this working? This isn't!
I want to have a status link on the ibeat site ... and also:
... if server one with ibeat.org fails make it open status.ibeat.org?
Should be pretty simple - but can't get my head wrapped around it.
View 4 Replies
View Related
