Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with replication
Search options not deleted
user 3417
Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility
1
vote
Adding a new slave slowing down previous replicas?
Long running queries from master server - consider using row-based replication if you feel it helps your overall system performance. …
- 1,017
1
vote
Binlog - 'Race-like' Condition on Replication
RBR basically updates the slave with the entire row as it is after it has been inserted/updated and updates using the primary key of the table.
The advantages to this over statement is if the master …
- 1,017
21
votes
Accepted
Replicate tables to different database name
Yes, there is. Put this in your my.cnf file:
replicate-rewrite-db="dbname1->dbname1test"
See Replica Server Options and Variables: replicate-rewrite-db
- 1,017
6
votes
What is the safest way to switch the binlog format at runtime?
To switch binlog_format at runtime you can do:
set global binlog_format = 'MIXED';
This will set all NEW sessions to be mixed binlog format. All existing sessions will be whatever was set previousl …
- 1,017