A master/slave protocol involves one dominant participant (the master) controlling communication with one or more other participants (slaves). Prefer to tag the specific protocol, such as "i2c". For master/slave database replication, prefer "replication".
Questions tagged [master-slave]
790 questions
10
votes
0 answers
Setting up master/slave replication databases within my Vagrant box
Currently, I am using Vagrant 1.4.3 in-conjunction with VirtualBox running Unix (Centos) for my development server (using MariaDB).
I didn't setup the box myself (so my knowledge of setting this up is limited) I would basically like to do the…

Zabs
- 13,852
- 45
- 173
- 297
10
votes
1 answer
Warning: Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT
Full error:
Warning: Unsafe statement written to the binary log using statement format
since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an
auto-increment column after selecting from another table are unsafe because
the order in…

DanH
- 5,498
- 4
- 49
- 72
10
votes
2 answers
On RDS can I create Tables in a Read Replica that are not present on the Master?
We have a separate RDS Instance to handle session state tables, however found that the session DB load is very low. if we can convert the instance handling session as a Read Replica of the main DB, then we can use it for read-only tasks that are…

Subramanyam
- 101
- 1
- 4
9
votes
2 answers
Master-slave vs peer-to-peer distributed computing
HBase has a master-slave model, while Cassandra has a peer-to-peer model. I am aware that in a master-slave model, the master is a SPOF (Single Point of Failure) and there is no such thing in a peer-to-peer model.
Are there any other pros and cons…

Praveen Sripati
- 32,799
- 16
- 80
- 117
9
votes
3 answers
Hudson -- Step by step guide to set up master and slave machines
As you can see, the link to that on the hudson website is dead.
So, I was hoping for a little step by step for setting up a windows slave with a linux master.
I managed to setup hudson on the windows machine, but how do i link the slave to report…

Mahdi Yusuf
- 19,931
- 26
- 72
- 101
9
votes
2 answers
Everytime I run cluster.fork(), I get a Error: bind EADDRINUSE
I'm using node.js, and using the cluster module. Everytime I run cluster.fork(), I always get a
throw er; // Unhandled 'error' event
Error: bind EADDRINUSE
at exports._errnoException (util.js:746:11)
at cb (net.js:1205:33)
at rr…

Gakho
- 603
- 1
- 9
- 18
9
votes
2 answers
Rails: How to split write/read query across master/slave database
My website has a very heavy read traffic. A lot heavier than write traffic.
To improve the performance of my website I have thought of going with master/slave database configuration.
The octupus gem seems to provide what I want, but since my app is…

Sanjay Salunkhe
- 2,665
- 5
- 28
- 52
8
votes
1 answer
What is the difference between binlog-do-db and replicate-do-db?
I'm a beginner for MySQL Master-Slave .
and I have read two tutorials .
How to Setup MariaDB (Master-Slave) Replication
Setup MariaDB Master-Slave Replication
In first tutorial. It make me that
[mysqld] Master…

gclove
- 93
- 1
- 1
- 5
7
votes
3 answers
SSH Key authentication failing when connecting Mac Hudson slave to Linux master
Ok, so I have Hudson (v1.393) running in an Ubuntu VM and everything's working fine.
However I'm trying to add a Mac slave to the Ubuntu master and I've run in to a few problems.
I have set up SSH keys so that from the command line, the Ubuntu VM…

mattbilson
- 558
- 2
- 5
- 15
7
votes
3 answers
Master / Slave switch in the Zend Framework application layer
I am writing an application which requires the Master/Slave switch to happen inside the application layer. As it is right now, I instantiate a Zend_Db_Table object on creation of the mapper, and then setDefaultAdapter to the slave.
Now inside of…

Pro777
- 1,684
- 1
- 18
- 30
7
votes
5 answers
How to write the Mysql binary log position of master when doing a mysqldump from slave?
I am currently running mysqldump on a Mysql slave to backup our database. This has worked fine for backing up our data itself, but what I would like to supplement it with is the binary log position of the master that corresponds with the data…

wbharding
- 4,213
- 2
- 30
- 25
7
votes
2 answers
How to separate Master Slave (DB read / writes) in Flask Sqlalchemy
I'm trying to separate the Read and write DB operations via Flask Sqlalchemy. I'm using binds to connect to the mysql databases. I would want to perform the write operation in Master and Reads from slaves. There does not seem to be an in built way…

Nands
- 1,541
- 2
- 20
- 33
7
votes
2 answers
ZooKeeper - adding peers dynamically?
I'm new to ZooKeeper. This is what I need.
I've a network of peers.
At t=t_1 -> [peer-1 (Leader), peer-2]
peer-1 is the master and all clients connect to this node.
At t=t_2 -> [peer-1 (Leader), peer-2, peer-3]
At some later time peer-3 joins the…

Soumya Simanta
- 11,523
- 24
- 106
- 161
6
votes
1 answer
Master Slave Configuration in Laravel 5.5
How to configure Laravel 5.5 with master slave MySQL replication ?
I want to make write operations and read operations in master and slave respectively .
Optional: Is there any way to do connection pooling and max / min no of open connections in…

Subhajit
- 876
- 3
- 17
- 37
6
votes
2 answers
apache spark master ui not working
Hey all I have a simple 2 node cluster 1 master and 1 slave(hadoop and spark). Everything was working fine but for some reason now when I launch the master spark I can't connect to the master web ui(port 8081 i set it explicitly in the spark-env.sh…

Neil
- 211
- 1
- 6
- 13