The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
2answers
6k 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 ...
2
votes
1answer
1k 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
82 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
101 views

DNS Slave doesnot serve new record while master is down until restart

could anyone explain the behaviour of DNS slave. i am testing dns server, for internal purpose, and after configuring master slave everything works fine, but i am willing to understand the mechanism ...
0
votes
1answer
79 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
140 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 ...
0
votes
1answer
205 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 ...
0
votes
1answer
395 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
1answer
128 views

MySQL master-slave replication with more than 1 server

Is it possible to setup replication for database_A from master_A and database_B from master_B server? It looks like I can only set one master-host in MySQL configuration file. Thanks in advance.
3
votes
0answers
19 views

Pacemaker DRBD resource not getting promoted to master on any node

First off, I'm no linux specialist, I've been following tutorials and been working with the help of google, this worked out fine until now, but currently I'm stuck with a problem. I'm using CentOS 6.5 ...
0
votes
0answers
16 views

RockMongo Connection Issue with MongoDB Slave

I have a MongoDB Replication with Master-Slave (not RepliSet) I have configured RockMongo on two servers. But I able to login to master server through rockmongo but when I login to slave with rock ...
0
votes
0answers
37 views

ISPConfig multi-server DNS setup

I have 2 servers with ISPConfig 3 installed. Both servers are used to all services (hosting, db, mail, dns etc). One of the servers is also configured to be ns1.mydomain.com and the secondary is ...
0
votes
0answers
359 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 ...