Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [master-slave]

125 questions
0
votes
1 answer

Mysql master-slave replication very slow

We're running a MySQL master-slave replication set-up and the slave is very slow at catching up. There seems to be no high network or cpu usage while the slave is going through the masters' logs. Connection between master and slave is stable and…
Qlii256
  • 151
  • 2
  • 8
0
votes
3 answers

Web Server failover solution

Sorry for a dumb question but I`m a green hand yet. I have two Linux server: one of it is running Apache with MySQL to serve my web-platform (master server) another one is supposed to be a sort of replication to provide a fail over (slave server).…
Ver
  • 33
  • 1
  • 7
0
votes
1 answer

XtraBackup restore gives duplicates on slaving?

We've recently upgraded a MySQL 5.0 master-master setup to Percona 5.6. Slaving went b0rken due to some failures on our side, but we thought we could simply fix it by using xtrabackup to create a backup from the running server and importing it to…
Tim Stoop
  • 588
  • 5
  • 20
0
votes
1 answer

CRUD with MySQL Master-Slave Architecture

I have setup mysql master-slave replication with 1 master and 3 slaves. Now that I have finished setting up the architecture I am curious as to the best way to make my reads. I realize all writes, updates, and deletes will be directed to the…
John Foley
  • 171
  • 7
0
votes
2 answers

ERROR 1130 (HY000): Host 'host' is not allowed to connect to this MySQL server, only on slave

So I have a master and a slave in a mysql cluster, the syntonization works as it should however I am not able to connect to the slave from any host except from the server it self. I have no problems connection to the master, but now I need to spread…
gonace
  • 1
  • 1
  • 1
  • 4
0
votes
1 answer

Configuring different read and write targets for OpenLDAP

I have a new piece of infrastructure (a simple LDAP web service) that will be a drop-in replacement for something that currently exists in production. The backend OpenLDAP server will not be upgraded at the same time. In order to test the new…
javanix
  • 247
  • 4
  • 15
0
votes
2 answers

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

Could anyone explain the behavior 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 behind, Lets say, dnsmaster.net and dnsslave.net…
tike
  • 643
  • 1
  • 5
  • 18
0
votes
1 answer

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 table3 MySQL DB (slave1) table1 table2 …
ReynierPM
  • 710
  • 5
  • 14
  • 30
0
votes
1 answer

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 the slave but there is no option of setting NS…
RoboTamer
  • 502
  • 1
  • 4
  • 17
0
votes
2 answers

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…
Justin
  • 5,328
  • 19
  • 64
  • 84
0
votes
2 answers

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 expire_logs_days = 1 max_binlog_size = 100M and…
Alaa Alomari
  • 638
  • 6
  • 19
  • 37
0
votes
1 answer

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.
ong
  • 1
0
votes
1 answer

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 in Master/Master . 2 are slaves that point to a…
Sam
  • 1
  • 1
0
votes
1 answer

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 mysql master to the current setup, so it does…
Gabriel Baker
  • 131
  • 6
0
votes
2 answers

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 backups. According to the MySQL manual, MySQL uses…
Juanma
  • 132
  • 8
1 2 3
…
8 9