The master-slave tag has no wiki summary.
1
vote
1answer
32 views
mySQL: Slave not able to connect to Master for replication
On my master, I did:
GRANT REPLICATION SLAVE ON *.* TO 'repluser'@'%' IDENTIFIED BY 'mypassword';
On my slave, I see:
mysql> show slave status \G;
*************************** 1. row ...
1
vote
1answer
39 views
Percona xtradb cluster with asynch slaves
I have a Percona xtradb cluster set up with 3 nodes. Node 1 is also set up as a master with an asynchronous slave. When I make an update to Node 1, it is replicated to the cluster as well as the ...
0
votes
1answer
29 views
Replicate from slaves to master and viceversa
I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this:
MySQL DB (master)
table1
table2
...
0
votes
1answer
70 views
Nagios and MySQL [closed]
We have a system that contains several machines running circle replication (Cross master). One extra machine is connected to one of them and operating as a slave.
Example
M1 -> M2
M2 -> M3
M3 -> ...
2
votes
1answer
155 views
Configure fallback redis server
I am using redis as a cache server. Can I somehow configure multiple redis servers, that the cache is fully functional (read/write) even if some of them go offline?
I looked into master->slave, but ...
1
vote
2answers
84 views
Overwrite SOA expiry in a bind9 slave name server.
I run a slave name server of a domain that I do not have full control over (i.e. changing the SOA is not possibly). The SOA specifies an expiry time of one week. For various reasons, I’d like to ...
0
votes
1answer
76 views
Moving Redis persistence to a slave
Redis' background AOF rewrites are killing performance of our service.
The general consensus is to move AOF persistence to a slave in a separate VM and disable it on master.
There is a problem with ...
2
votes
1answer
229 views
BIND no longer responds to AXFR Requests
Recently we moved our primary external DNS server. It has three caching DNS slaves in front of it provided by our ISP. They've told us they've started getting access denied requests when doing zone ...
3
votes
2answers
628 views
Magento hosting on a budget
I have to do a setup for Magento. My constraint is primarily ease of setup and fault tolerance/fail over. Furthermore costs are an issue. I have three identical physical servers to get the job done. ...
1
vote
2answers
365 views
Ulimit settings in Oracle 11g on Linux 5
Is there an issue with "Ulimit -Hn" being set too low (at 1024) when (Oracle recommend 65536)? This is for Oracle 64-bit 11g on Linux 5.
It is one of the settings that appears to be woefully short ...
2
votes
0answers
199 views
Using Amazon RDS (or similar) as a slave
Officially, RDS instances can't be directly set up to slave non-RDS databases.
My production master is MySQL running on Hetzner and I want an RDS instance to closely follow it for backup purposes, ...
0
votes
3answers
258 views
Design a DNS Master/Slave with SVN
I am looking for a good design of a master, slave DNS servers with SVN. Few doubts bothering me are:
Would it be good if I have a post-commit hook to replicate/rsync the DNS master data to the ...
3
votes
1answer
276 views
MongoDB -what's the safest and most efficient way to change from Master-Slave to ReplicaSet?
I now have two mongo servers with a Master-Slave configuration (all read-writes are done with the Master, the Slave is just a cold backup) serving a pretty demanding web app.
I want to switch to ...
1
vote
1answer
110 views
MongoDB ReplicaSet Elections when some nodes are down
I'm trying to get into ReplicaSet concept, and found something weird in mongoDB Documentation:
For a node to be elected primary, it must receive a majority of votes. This is a majority of all ...
5
votes
1answer
706 views
BIND, Master, Slaves and Notify
It might seem like a very basic question, but, how is a master DNS server aware of its slaves?
I mean, does it parse the zone file and determine where to send the NOTIFY message?
And if that is the ...
2
votes
2answers
900 views
--log-slave-updates is OFF but some updates are still logged to the slave binary log?
MySQL version 5.5.14
According to the document, by the default, slave does not log to its binary log any updates that are received from a master server.
Here are my config. on the slave:
# egrep ...
2
votes
1answer
810 views
pgpool2+streaming replication failover on only 2 servers?
I am trying to configure pgpool2 and postgresql 9.1 to handle failover.
I currently have streaming replication running, and are using pgpool2 for read-only load balancing.
I have 2 servers in my ...
1
vote
1answer
73 views
Backups from MySQL slave server — Good idea or bad?
I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an Xtrabakup (via the perl wrapper Innobackupex) backup and an atomic ...
3
votes
2answers
619 views
How to slave real-time data from two MySQL sources merging in to one MySQL destination?
I have two different MySQL instances that I would like to 'slave' to a third instance.
(so I can do easy joins on the third instance)
eg.
mysql1> show databases
db1
db2
mysql2> show databases
...
0
votes
1answer
130 views
Can I turn eNom in to a slave, or somehow work side by side?
I ran out of space at eNom, and can add no more sub domains.
Now I'am setting up bind9 on my server and was wondering, can I turn eNom in to a slave.
I would have preferred running my dns server as ...
1
vote
1answer
126 views
making slave server as master for another server
I have three servers, Server X, Y, and Z.
I have the main mysql DB on X (innodb DB).
now I have created Master-Slave from X to Y. everything is working fine here.
and now i set Y as a master for Z.
...
1
vote
3answers
407 views
Can DNS do failover switch for a domain?
I have heard about round robin solution. But that one is making different request to different ips to do load balancing. What I want is making one IP as master, only if it dies, the DNS server switch ...
0
votes
2answers
79 views
MySQL Master Slave Replication Not Working
I setup MySQL master slave replication, but none of the databases, tables, and data is being copied over to the slave from the master.
Here is the relevant configuration on the master:
server-id=1
...
1
vote
1answer
251 views
mysql replication - slave seems up to date but data not synchronized
I have a master-slave setup with 2 servers over a network. Due to an error, the slave IO thread stopped, though I could get it started and running, the slave is way behind the master. Also, SHOW SLAVE ...
0
votes
0answers
298 views
Error 'Unknown table engine 'InnoDB'' on query. after restarting mysql
I have mysql DB on server S1 (mysql version 5.1.41-3ubuntu12.7-log), i have created master-slave for this DB on server S2 (mysql version 5.1.54-1ubuntu4-log).
the DB on S1 was using one data file ...
3
votes
2answers
318 views
Online Schema Change Strategies for Large MySQL Tables
I'm curious to hear strategies and methods people use for performing alters on very large tables in MySQL. Large could be any number of rows or size that would be impacting to alter. For the sake of ...
8
votes
3answers
3k views
Bind zone transfer refused
UPDATE:
BIND Version:
[root@10.224.45.130] $ named -v
BIND 9.3.6-P1-RedHat-9.3.6-16.P1.el5
Operating System:
CentOS release 5.6 (Final)
After running [root@10.224.45.131] $ dig @10.224.45.130 ...
1
vote
3answers
401 views
MySQL slave reporting incorrect values for Seconds_Behind_Master
I have a MySQL slave that when it is 0 seconds behind the master, it correctly reports 0 Seconds_Behind_Master. However, if it gets even 1 seconds behind, it reports 14401 Seconds_Behind_Master (which ...
4
votes
2answers
2k views
MySQL slave replication reset with no Master Downtime (using MyISAM)
Root of the issue:
In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
0
votes
2answers
180 views
I can't enable binlog in MySQL
I am trying to enable binary log in order to create master slave for my DB.
MySQL version is 5.1.41-3ubuntu12.10-log
I have added this to my.cnf
log_bin = /var/log/mysql/mysql-bin.log
...
1
vote
1answer
161 views
Erratic Seconds_Behind_Master
One of my MySQL slaves will at one moment, report 57 seconds behind master, and the next will show 0. I am also monitoring with mk-heartbeat which shows an average of less than 1 second. MySQL and ...
0
votes
1answer
28 views
mysql - replicating to db with a different name
Can a mysql db named statsDb on server1.example.com be replicated to a db named newNameDb on server2.example.com ? server2.example.com already has a statsDb. Thanks for your help.
0
votes
1answer
88 views
High Availability MySQL question
So I'm currently testing a new DB topology before moving it into a production environment, and I've run into a rather odd problem. The current setup is as follows:
5 server instances. 2 are MySQL DBs ...
0
votes
1answer
28 views
add additional mysql master
I currently have 2 mysql servers running,
1 as master and 1 as slave as in the mysql manual
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
master->slave
What I want to do is add a new ...
3
votes
2answers
276 views
Why does MySQL replication break on missing row, then continue after “START SLAVE”?
The title is a bit confusing, but I can't think of a better one.
What I have is a simple vanilla MySQL replication, with the slave occasionally failing, with this error: Error 'Can't find record in ...
3
votes
2answers
892 views
mk-table-sync in a master-slave scenario: Changes not replicated to the slave
I have being employing mk-table-sync to synchronise tables from a
master to slave on mysql 5.1.
Unfortunately, while differences are correctly detected, modifications done on the master ...
4
votes
3answers
5k views
Automated failover strategy for master-slave Mysql replication - why would this not work?
I'd like some feedback about this failover strategy for a couple of MySQL servers I'm speccing up for a cluster, and I want to check if there's something obvious I'm not missing here.
One app server ...
0
votes
1answer
906 views
Master Server Bind i's OK but Slave NO
I install two dns server (BIND 9) was the first master, the second is slave.
In Master Server:
The file /etc/bind/named.conf.local
zone "globaltic.tk" {
type master;
file ...
3
votes
4answers
272 views
Old, stale DNS slave server considered harmful?
Its been a while since I was dabbling in DNS setups, so my knowledge might be a bit outdated.
We have a domain for which master server is administered by our team, and slave server is provided by the ...
3
votes
1answer
4k views
MySQL simple replication problem: 'show master status' produces 'Empty set'?
I've been setting up MySQL master replication (on Debian 6.0.1) following these instructions faithfully: http://www.neocodesoftware.com/replication/
I've got as far as:
mysql > show master ...
3
votes
1answer
434 views
M-M or M-S replication of EBS volume across multiple EC2 instances
I would like to share EBS backed file system of size up to 20GB in 200K files across multiple EC2 instances. Master-master would be ideal, but I'd be happy with master-slave solution too.
I know that ...
-2
votes
2answers
85 views
Given three dedicated servers how do I implement a development cycle?
I am a beginner to server administration and network design. Following is the requirement:
I have three dedicated servers. These three servers need to accomplish following:
There is a master DB
...
0
votes
2answers
312 views
MySQL Incremental backups with Master-Slave replication
we have a MySQL system in Master-slave replication mode. Currently we are doing full backups with mysqldumps to a remote disk server.
I think is best to do one full dump and many small incremental ...
0
votes
1answer
179 views
How to setup geographically different primary/secondary, master/slave DNS services at domain registrar?
This is a followup question to my previous post Multiple free dns services redundant as name servers of a website?
I would like to setup DNS services as primary/secondary, master/slave and would like ...
1
vote
2answers
102 views
Mysql leave slave 1 hour behind
Is it possible to leave the mysql slave 1 hour behind? I would like to create an script wich stops the slave when I markup some hacks such as big drop tables and stuff, to make this work I would like ...
0
votes
1answer
365 views
Promote MySQL master-slave to master-master replication
I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
0
votes
0answers
287 views
Promote MySQL master-slave to master-master replication
I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
0
votes
3answers
706 views
How to setup MySQL replication with minimal downtime
Basically we have a large MySQL database and we're looking to do replication to a slave (master slave setup). Do you guys have any step-by-step guide on how to do this with MINIMAL downtime on the ...
0
votes
1answer
247 views
Setting up MySQL Linux slave with a Windows master
I'm running a MySQL 5.0 database server on Windows Server 2008. The total size of the database is about 1Gb.
I make daily backups, but I'd like to step up to having a slave server for extra ...
1
vote
3answers
1k views
How to find slave's IP address and user name from Master server?
I am writing a code to extract the ip address and username of slave server in a MySQL replication environment. Does anyone know any function, variable, or something that I can run on the console and ...
