Skip to main content
10 votes

RDS snapshot: how long does I/O suspension occur?

The answer comes from understanding how snapshotting works. At the start of a snapshot, a message (command) is sent to all applications to come to a consistent state and flush necessary data to disk. ...
John Hanley's user avatar
  • 4,954
6 votes
Accepted

Is it possible to take a snapshot of a database in Azure?

Based on my knowledge, for now, Azure SQL database(Paas) does not support snapshot. There are many ways that you could choose to backup SQL database, please refer to this blog:Different ways to Backup ...
Shui shengbao's user avatar
5 votes

How to do offsite AWS RDS PostgreSQL backups?

One option you have is to copy your RDS snapshots to another AWS account. This is a commonly-used practice. This can be done by: Sharing your RDS snapshot with your second AWS account. Copy ("pull") ...
Matt Houser's user avatar
  • 10.3k
5 votes
Accepted

SQL 2012 Transaction Log backup does not truncate the logs

Your transaction log backup is truncating the logs in the sense that it's making room in the existing log file for more transactions. If you want to shrink the log file, you need to choose the "shrink ...
Katherine Villyard's user avatar
5 votes

Not able to backup of postgres DB from DBeaver

I did search and solution is like "which postgres-> and put result of it in it" Not on Ubuntu. which postgres will typically print nothing. The command that DBeaver wants are pg_dump to ...
Daniel Vérité's user avatar
4 votes

How to do offsite AWS RDS PostgreSQL backups?

I also wanted an offsite backup of my AWS RDS, and the code, logs, etc. I do this by: Doing a database export periodically (nightly at midnight, for me) into a given directory Having Attic Backup ...
Tim's user avatar
  • 32.9k
4 votes

Is it possible to take a snapshot of a database in Azure?

UPDATE: In April 2020, Microsoft updated their documentation regarding Azure SQL's Database Copy feature to clarify that a database copy in Azure SQL is not an instantaneous snapshot. While the ...
Dai's user avatar
  • 2,299
4 votes
Accepted

Where to store db backups in centos 7?

Put them wherever you'd like. As long as they're also copied elsewhere, preferably off-site. The only thing approaching a "best practice" here would be to put the backups on their own filesystem, so ...
EEAA's user avatar
  • 110k
4 votes
Accepted

downloading a big database (postgres) to a local copy

9GB compressed dump isn't really that large. You just need to make do it right: dump from EC2 instance in the same AWS account and region that RDS database is running — not over the internet; use ...
Tometzky's user avatar
  • 2,719
3 votes

best raid level for backup server

If you're going to use a hardware card, RAID 50 or 60 seems fine for this case. 10 is overkill. For storing a backup of living data (rather than something like tapes), I generally prefer the use of ...
Spooler's user avatar
  • 7,136
2 votes

AutoMySQLBackup: Create a single file for each database

You should be able to use the SEPDIR config parameter. It will create separate directories for each database, with an own file inside of it. From the Ubuntu manpage (but should work on CentOS just ...
Oldskool's user avatar
  • 2,025
2 votes
Accepted

Adding mysqldump parameters in automysql

I've added this option on /etc/default/automysqlbackup OPTIONS OPT="$OPT --lock-tables=false"
Miguel Costa's user avatar
2 votes
Accepted

Is there a (mostly) safe way to backup live MySQL databases using zfs snapshots

If all of your databases are in InnoDB format, then you don't need to do this. InnoDB will automatically make your data consistent at startup if you do a restore.
longneck's user avatar
  • 23.2k
2 votes

Backup strategy for dedicated LEMP stack server

You are addressing redundancy. That is good. You could fail over to the back up server in an emergency. This is NOT A BACKUP solution. You want your backups, especially for a web app to go back in ...
Daniel Widrick's user avatar
2 votes

Backup mysql without causing spike in disk I/O

There are two answers to your question. Direct answer. User XtraBackup's throttle feature - https://www.percona.com/doc/percona-xtrabackup/2.3/advanced/throttling_backups.html . Give to Xtrabackup ...
akuzminsky's user avatar
2 votes
Accepted

Can I use "Windows Server Backup function" or "wbadmin" to backup MariaDB?

You can, but I doubt it will make your life easier. wbadmin isn't a general backup tool applicable to everything, and in addition to that databases often have specially designed backup procedures. For ...
Nikita Kipriyanov's user avatar
2 votes

What is the best & safe & fastes way to backup a large mysql database?

(Approximately in order, least-invasive to most-invasive. Backup the Replica -- IF you already have such. Not fast, but has no impact on the Primary. LVM Snapshot -- This almost instantly makes a &...
Rick James's user avatar
  • 2,578
1 vote

cassandra backup - errors during compression

You shouldn't do the backup on the real data, but instead you need to create snapshot of the data on server using the nodetool snapshot, and do backup from it. After you finished the backup, you can ...
Alex Ott's user avatar
  • 316
1 vote

Correct way to have a mysql/mariadb incremental backup

Backup via binlog is the most obvious plan; however, restoring a very long chain of binlog would be quite tedious. For such short RPO/RTO I would suggest a block level backup, namely in the form of ...
shodanshok's user avatar
  • 50.7k
1 vote

Correct way to have a mysql/mariadb incremental backup

Don't do mysqldump, it's inefficient and slow. Use xtrabackup, it can run with almost no downtime whereas mysqldump will need to lock all tables for writes to get a consistent copy. And a good option ...
Stefan S's user avatar
1 vote

rsync: change_dir "/home/Sources//[email protected]/home/account" failed: No such file or directory (2)

You need the / before home rsync -h --progress --stats -r -tgo -p -l -D --update --delete-after --protect-args -e "ssh -i /location/to/file.pem" [email protected]:/home/account/file.any /local/...
Bob Dole's user avatar
1 vote
Accepted

Mysqldump to compressed file

--single-transaction tested, works as expected (thanks to Alexander Tolkachev) /usr/bin/mysqldump -v --single-transaction --skip-add-drop-table -u'user' -p'password' -h 'host' ${db} 2>/var/log/dump/${...
Damian's user avatar
  • 21
1 vote

Is it safe to restart a database as soon as VSS backup begins?

I would do a database dump to ensure a safe backup. As a VSS copy will not commit your log or anything like that. VSS can't know if your service was stopped correctly before the copy, and thus can ...
yagmoth555's user avatar
  • 17.1k
1 vote

MongoDB - Efficient backup

What should I do in order to have a backup system that's CPU or otherwise efficient? Maybe you can deploy Mongodb replica sets, then use another VM to run backup crontab. Also, you can run crontab ...
Jason Ye's user avatar
  • 2,409
1 vote
Accepted

What is a good way to backup SQL Server DB's from multiple AWS EC2 instances to a single AWS EBS Volume or S3 Bucket?

You're best off archiving to S3 IA class, as it's cheaper storage but reliable. An EBS snapshot already stores backups to S3, and can be scheduled. However, the disk images may not be perfect if a ...
Tim's user avatar
  • 32.9k
1 vote
Accepted

Backing up RavenDB - is it safe to backup data directory without VSS?

I contacted Hibernating Rhinos (RavenDB vendor) who responded: We require VSS for proper backup if you are using an external tool. To be frank, it is usually better to use the internal backup ...
eddiewould's user avatar
1 vote

Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?

You can also use Percona XtraBackup (already shipped and used by Percona XtraDB Cluster), that is a hot backup tool (if you are using InnoDB tables only, which you should since you are on PXC), ...
Guriandoro's user avatar
1 vote

SQL 2012 Transaction Log backup does not truncate the logs

OK, First thing to understand is why the Log file is the size it is. You say the Data is 500MB are you sure? thats a very small Data file in comparison to the Log file. If that is true the LOG is the ...
JayBay2279's user avatar
1 vote
Accepted

Backing up PostgreSQL - being prompted for password

You need to have literal values in ~/.pgpass, not shell variables like $DB_HOST. If you need environment variables then you can use these supported by libpq (PostgreSQL client library) like $...
Tometzky's user avatar
  • 2,719
1 vote
Accepted

bacula catalog backup error

I solved this problem by giving execute permission to user bacula on /etc/bacula/scripts/delete_catalog_backup
blade's user avatar
  • 113

Only top scored, non community-wiki answers of a minimum length are eligible