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 |
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
4
votes
2
answers
4k
views
MySQL replication: "Houston, We've Got a Problem"
I ran into a problem with our replication server. Essentially, we have 2 databases (database1 and database2). Master server has both. Slave has only database1. … error for replication server. …
2
votes
1
answer
170
views
mysql read slave to fetch entire database on start
I am building a standart infrastructure, where writes are going to master db, and reads are going to slave dbs. The idea is that when I need more read power - I just spawn more MySQL slave servers.
N …
3
votes
Accepted
mysql replication: replicate all but one table to different database on different server
So I had some lunch and figured it out !
replicate-do-table = database2.table
replicate-rewrite-db = "database1->database2"
2
votes
2
answers
3k
views
mysql replication: replicate all but one table to different database on different server
I got database1 on server1 and database2 on server2.
Now I need to replicate a single table from database1 to database2
Now I thought that this would work:
replicate-ignore-table = %
replicate …
1
vote
1
answer
184
views
MySQL: records, inserted via phpMyAdmin, do not replicate
As it says on the topic, for some reason records inserted/ modified via PMA do not get replicated to the slave, If I do exactly the same insert/modification on master via mysql command line, or applic …
1
vote
2
answers
949
views
Consistent mysqldump of mixed InnoDB and MyISAM tables from RDS instance
I can not get consistent copy to run replication. … I tried doing snapshot and building replication from the restored snapshot - but replication gets errors about duplicate entires and foreign constraints. …