Tagged Questions
2
votes
1answer
217 views
Running pg_dump on a hot standby server?
Disclaimer: I admittedly haven't tried this yet, but I'm not sure I would know if it wasn't working correctly, so I wanted to ask.
I would like to run a nightly backup job (via pg_dumpall) from a hot ...
0
votes
3answers
71 views
Where can I learn about MySQL master/slave, master/master, or clustering setups?
What are the best resources you've read or watched about setting up master/slave or clustering for database replication?
I don't know much about this. I have a database that is getting rather large ...
3
votes
1answer
83 views
Backup and off-site restore setup
I've been reading a lot of threads about different backup options for MySQL and was hoping for some more insight so I can settle on one.
Our current situation is ~100 GB of InnoDB and MySAM data in ...
1
vote
1answer
169 views
How to run a cold backup with Linux/tar without shutting down MySQL slave?
I run the following before tar-ing up the data directory:
STOP SLAVE;
FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
7
votes
1answer
123 views
SQL Server considerations when backing up / restoring a database that uses replication
In the event that I need to restore a database involved in replication, what considerations to I need to keep in mind?
Do I need to keep backups of both the publisher and the subscriber?
Can I ...
3
votes
2answers
179 views
Backup VLDB replicated database in SQL Server?
I have a problem with my backup strategy.
Currently I'm doing a Full Backup every night and transaction log backup every 2 hours to TAPE.
This used to work without problems, but the size of the DB ...
2
votes
3answers
166 views
Synchronise two databases (but not really)
I'm trying to design the following system.
An arbitrary number of of embedded systems will each record data constantly and indefinitely. It is required that these devices upload their data to a ...
2
votes
1answer
229 views
How often do you back up the distribution database for transactional replication when sync with backup is set to true for the distribution database?
I'm trying to figure out how often to back up the distribution database when "sync with backup" is set to true. If I understand this correctly, sync with backup ensures the distribution database can ...
1
vote
1answer
94 views
Backup / Restore Distributor
I have a database architecture with:
=> 1 distributor running on a dedicated instance of SQL Server 2005
=> 2 publishers running each on a dedicated instance of SQL Server 2000 and SQL Server 2005
=> ...
4
votes
1answer
356 views
Why are Stored Procedure schema changes not being replicated when using ”initialize with backup”?
In SQL Server I have set up transational replication using the "initialize with backup" option. Data is being replicated fine, as are schema changes to tables. However, schema changes to stored ...
3
votes
2answers
585 views
Removing Archive Logs after PostgreSQL PITR online-recovery
I'm using pgpool-II + PostgreSQL 8.4 on three servers: primary + standby1 + standby2.
Replication mode is "on"
Load balance mode is "on" (between primary and standby1)
I followed the official ...
