Skip to main content
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
Search options not deleted user 6417

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. …
Katafalkas's user avatar
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 …
Katafalkas's user avatar
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"
Katafalkas's user avatar
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 …
Katafalkas's user avatar
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 …
Katafalkas's user avatar
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. …
Katafalkas's user avatar