BackupT2BCloud - Revision history

Stephane GERARD: /* Backup of the OpenNebula database */

2016-08-30T14:27:14Z

Backup of the OpenNebula database

← Older revision		Revision as of 14:27, 30 August 2016
Line 29:		Line 29:
	</pre>		</pre>
	Dumps older than 7 days are removed.		Dumps older than 7 days are removed.

			Here is the crontab command :
			<pre>
			* 5,17 * * * /root/one_db_backup.sh > /var/log/one_db_backup.log 2>&1
			</pre>

Stephane GERARD: /* Backup of the OpenNebula database */

2016-08-30T14:11:19Z

Backup of the OpenNebula database

← Older revision		Revision as of 14:11, 30 August 2016
Line 11:		Line 11:
	password=secret		password=secret
	</pre>		</pre>

			Here is the script that does a dump into a file :
			<pre>
			#!/bin/bash

			# Create the backup directory if it doesn't exist
			BACKUPDIR=/var/lib/one/one_mysql_db_backups
			mkdir -p $BACKUPDIR

			# Remove backups older than 7 days
			find $BACKUPDIR -name 'one_db_mysqldump*' -mtime +7 -exec rm -f {} \;

			# Make a dump of the db to a file in BACKUPDIR
			DATE=`date +'%d-%m-%y_%H:%M:%S'`
			FILENAME=$BACKUPDIR"/one_db_mysqldump_$DATE"
			mysqldump opennebula > $FILENAME
			</pre>
			Dumps older than 7 days are removed.

Stephane GERARD: /* Backup of the OpenNebula database */

2016-08-30T13:42:04Z

Backup of the OpenNebula database

← Older revision		Revision as of 13:42, 30 August 2016
Line 4:		Line 4:
	== Backup of the OpenNebula database ==		== Backup of the OpenNebula database ==
	The OpenNebula database being located in /var/lib/mysql, it is not backed up with the ZFS snapshots described in the previous section. That's why we have created a cron task to automatically do a regular dump of the mysql database into the /var/lib/one directory.		The OpenNebula database being located in /var/lib/mysql, it is not backed up with the ZFS snapshots described in the previous section. That's why we have created a cron task to automatically do a regular dump of the mysql database into the /var/lib/one directory.

			To avoid having to specify the user and password in the mysqldump command, we have created the file ~/.my.cnf with the following content :
			<pre>
			[mysqldump]
			user=mysqluser
			password=secret
			</pre>

Stephane GERARD at 13:35, 30 August 2016

2016-08-30T13:35:23Z

← Older revision		Revision as of 13:35, 30 August 2016
Line 1:		Line 1:
	= Backup of VMs =		== Backup of VMs ==
	The whole /var/lib/one directory is mounted from the volta fileserver, and regular scheduled snapshots are done automatically to tesla. You can access to these snapshots going through /var/lib/one/.zfs.		The whole /var/lib/one directory is mounted from the volta fileserver, and regular scheduled snapshots are done automatically to tesla. You can access to these snapshots going through /var/lib/one/.zfs.

	= Backup of the OpenNebula database =		== Backup of the OpenNebula database ==
	The OpenNebula database being located in /var/lib/mysql, it is not backed up with the ZFS snapshots described in the previous section. That's why we have created a cron task to automatically do a regular dump of the mysql database into the /var/lib/one directory.		The OpenNebula database being located in /var/lib/mysql, it is not backed up with the ZFS snapshots described in the previous section. That's why we have created a cron task to automatically do a regular dump of the mysql database into the /var/lib/one directory.

Stephane GERARD: Created page with "= Backup of VMs = The whole /var/lib/one directory is mounted from the volta fileserver, and regular scheduled snapshots are done automatically to tesla. You can access to the..."

2016-08-30T13:34:40Z

Created page with "= Backup of VMs = The whole /var/lib/one directory is mounted from the volta fileserver, and regular scheduled snapshots are done automatically to tesla. You can access to the..."

New page

= Backup of VMs =
The whole /var/lib/one directory is mounted from the volta fileserver, and regular scheduled snapshots are done automatically to tesla. You can access to these snapshots going through /var/lib/one/.zfs.

= Backup of the OpenNebula database =
The OpenNebula database being located in /var/lib/mysql, it is not backed up with the ZFS snapshots described in the previous section. That's why we have created a cron task to automatically do a regular dump of the mysql database into the /var/lib/one directory.