Tagged Questions
0
votes
0answers
19 views
PostgresPlus advanced server replication testing issue
I made the replication on my Windows Server 2003 system as master DB and another XP system for slave DB. I just made the configuration, but I don't know how to check the replication of database.
I ...
0
votes
1answer
30 views
replication breaks after upgrading master
I have a set up of replication with master 5.1.30 and slave 5.5.16
and the replication is working good
Now i have upgraded mysql master to 5.1.47
As far as i know we have to turn off the log bin ...
0
votes
0answers
125 views
Oracle Data Guard Fast-Start Failover Questions
Here is the setup in question:
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dbabc
Observer: (none)
Lag Limit: 30 seconds (not in use)
Shutdown Primary: FALSE
...
2
votes
3answers
211 views
MySQL - Master/Slave Replication with different server specs
I have a Master/Slave replication (using MySql 5.1 / InnoDB).
Currently both my master & slave are running on the same type of server (32 GB RAM, 2 x Intel Xeon 5520 Quad Core 2.26 GHz (8 cores)) ...
0
votes
1answer
151 views
RAID vs Replication [closed]
I'm kind confuse about it, can some one give me a hand with this...
Differences.
Which one is better.
Which one do you use and why?
Personal Opinion and advise.
0
votes
1answer
50 views
Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication
I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.
...
2
votes
2answers
1k views
Difference between Row based and statement based replication in Mysql?
What is the Actual difference between Row based and Statement based replication I actually looking in terms of replication effect's on slave.
If I am using Row based replication then whats is the ...
3
votes
1answer
597 views
Master and Slave having same id's
I am working as a remote DBA for some of the production servers.
There was replication from Master to Slave.
There is something changed in the scenario they have made one of the Slaves as master ...
1
vote
1answer
352 views
Problem with MySQL Master/Slave reboot when in replication
There is a master and number of slaves connected to it.
Due to some patches, we have to Reboot the Master and Slave.
Afterwards, we have to make sure replication is running fine.
While doing this ...
3
votes
1answer
997 views
Does `Seconds_Behind_Master` show exact Slave Lag from Master?
Does Seconds_Behind_Master show the correct result?
I have also Implemented the mk-heartbeat replication monitoring.
It was showing the other result in comparison with Seconds_Behind_Master.
Which ...
5
votes
2answers
6k views
What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?
I am very new to Database Administration.
I face a lot of problems while setting up mysql master-slave replication.
I also face regular mysql replication troubleshooting issues.
Can anybody helps ...
2
votes
1answer
287 views
PostgreSQL archive_command on Windows
What is the best method for WAL log transfer on Windows?
I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit.
Servers do not have any shared SAN disk, they are on different hosts, ...
