Mysql Master-slave Replication
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
ADVERTISEMENT
Dec 18, 2007
I'd like to run two servers, both will be using lxadmin and tinydns, what would be the best way to run a master/slave nameserver setup, and allow DNS updates to be transferred from the master to the slave?
View 2 Replies
View Related
Sep 18, 2006
I want to know more about dns servers (master2slave), is there any tutorials how can I do that? I have 10 servers now, do I need to buy 2 more only for DNS?
View 6 Replies
View Related
May 19, 2009
Wich port used by hypervm (master/slave)
I have csf installed on my server and i need to open needed ports.
View 7 Replies
View Related
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
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
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
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
Nov 4, 2014
I have setup Slave DNS using plesk 12. But it is not creating the zone in slave server. I could see log in /var/log/messages of slave server. But DNS zone is not creating. I have followed the KB "[URL] ...." for setup.
Nov 4 13:31:25 li456-187 named[16905]: received control channel command 'addzone testnith.com { type slave; file "testnith.com"; masters { 108.161.131.59; }; };'
Nov 4 13:31:25 li456-187 named[16905]: received control channel command 'refresh testnith.com'
Nov 4 13:31:25 li456-187 named[16905]: received control channel command 'addzone testnith.com { type slave; file "testnith.com"; masters { 108.161.131.59; }; };'
View 1 Replies
View Related
Mar 28, 2008
I have to regularly run the "RESET MASTER" command in MySQL to clear up space on a server's hard drive partition, is there a way to have this command execute automatically so as to avoid having to manually log in to the shell and enter it all the time ? Can this be done via Crontab?
View 2 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
May 20, 2009
Our master node unable to connect to slave node for create, rebuild, manage.
But we can give access to slave with hypervm -> Servers and run anything on it.
I checked firewall, also im stopped iptables.
But master cannot connect to slave.
Where is issue and how can resolve?
Note: i can give ping or ssh access with both server to slave/master!
Help me please.
I have this when i run /script/upcp on main node:
[root@server ~]# /script/upcp
Getting Version Info from the Server...
Connecting... Please wait....
hypervm is the latest version
Executing UpdateCleanup. This will take a long time. Please be patient
License Successfully updated
vps backupdir exists... returning
Updgrading Slave xx.xx.xx.xx...
no_socket_connect_to_server
View 9 Replies
View Related
Jun 19, 2009
How to configure bind using WEBMIN as slave zone with [url]as master?
View 1 Replies
View Related
Mar 26, 2008
This week I reached the pinnacle of all time greatest screw ups I've ever done with a web server in five years. During a routine upgrade, my server crashed and basically burned to the point that the technicians at Burst/Nocster felt it would be in my best interest to clear the server out and do a fresh restore.
Fortunately, I had the majorty of files and designs I've done on a safe backup. Unfortunately, the mysql database I had was not so fresh and recent. In there lies my big problem on an issue I really have not seen much information about.
We all know of the mysqldump command that can be used to backup databases and save a .sql file on the server. Its quick, easy, and relatively painless. The problem I have run into is
mysqldump --opt -u nqforum_braduser -p nqforum_nodqdb > /home/nqcom/backup.sql
This would be the command I'd use on my normal mysql dump. However, all of my files and past server information has been installed as a slave hard drive temporarily until I can gather everything I need. Therefore, the command above won't work because it is looking for this mysql database & user that does not exist on the new server. I currently have the slave hard drive path stored at
/mnt/olddrive/
So for example, to get to the website that would have that particular database
/mnt/olddrive/home/nqforum/
So my question for those who know anything about slave hard drives and mysql, how can I get a simple current backup of this database saved to a location, then of course once it is saved as a .sql file somewhere, I can simply run a mysql restore command in SSH to bring it back.
View 1 Replies
View Related
Dec 28, 2008
Is there any way to migrate a VPS from one HyperVM machine to another without the new machine being a slave or part of the same master as the other node? Maybe some kind of simple software that can copy it over? We have root access to the new node, and not the old one. We need to move 3 VPSs over. This is a personal favor for a friend, so I apologize for the lack of specific details. Long story short, he resells VPSs and needs to move hosts (again) as the one he is on turned crappy. He bought his own box @ LSN and wants to put these VPSs on there. It's currently set up as a HyperVM/OpenVZ box, same as the other box that's to be migrated *from*.
View 5 Replies
View Related
Oct 23, 2013
We have published an article about the 'Slave DNS' Plesk extension in our blog. Parallels does not provide technical support services for this Plesk extension. The extension is intended to serve as example of how certain technical tasks can be accomplished.
View 7 Replies
View Related
May 16, 2015
I am using the Slave DNS manager and I'm getting the following error in /var/log/messages on the slave server when the master/plesk tries to send change notifications.received notify for zone 'example.com': not authoritative
The domain is pointing to ns1.mydomain.com and ns2.mydomain.com, the domains zone on the master has both of these as NS records. And the SOA record lists ns1.mydomain.com as the primary authoritative nameserver.The zone has not been set on the slave server, what would be the cause here?
Slaves named.conf
bbb.bbb.bb.bbb = Slave IP
aaa.aa.aa.aaa = Master/Plesk
Code:
options {
listen-on port 53 { 127.0.0.1; bbb.bbb.bb.bbb; };
listen-on-v6 port 53 { ::1; };
directory "/var/named";
dump-file "/var/named/data/cache_dump.db";
zone-statistics yes;
[code]....
View 2 Replies
View Related
Apr 25, 2015
I've got a Plesk 12 server with the "Slave DNS Manager" extension installed.I've also got a CentOS 7 server that I would like to set up as a slave DNS server.I've installed BIND on the slave server and opened ports 53 and 953.I've followed the instructions on this page but I can't seem to get a link between the two servers: URL....
I've also tried the config that the Plesk panel provides like the case in this thread, I get the same results: URL....
View 2 Replies
View Related
Jul 8, 2013
How are the records on slave DNS servers updated ? Does it use the settings in the SOA section of the zone files to determine how often slaves are updated ?
Code:
18 ; serial
14400 ; refresh (4 hours)
7200 ; retry (2 hours)
2419200 ; expire (4 weeks)
3600 ; minimum (1 hour)
Is there any way for master to push out notifications to slaves OR get slaves to update their DNS sooner.
The main reason for this is it seems adding an entry on the master (via the GUI) is taking ages to appear on the slave.
View 2 Replies
View Related
May 19, 2015
I have a Windows/Plesk installation (Windows DNS), what is the best way to make a slave DNS server?I have two more servers without Plesk, windows and linux, one of then could be my slave server, how to accomplish that?
View 1 Replies
View Related
