Tchater maintenant avec le support
Tchattez avec un ingénieur du support

NetVault Plug-in for MySQL 11.1 - User Guide

Introducing Dell™ NetVault™ Backup Plug-in for MySQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data Working with native MySQL replication Using the plug-in in a Failover Cluster environment Troubleshooting

Enabling the Binary Log on the MySQL Server (Standard/Community option only)

Before you configure support for PIT backups and restores with the MySQL Standard/Community option, you must enable the MySQL Binary Log.

Enabling the log on a Linux®- or UNIX®-based MySQL Server

IMPORTANT: If desired, the “log-bin” entry added to the my.cnf file can be set up using the following syntax to specify a different file to house the Binary Log:

log-bin=<NameOfDestinationFile>

When you specify the name of the destination file for the Binary Log, use only the name of the file itself; do not include full path information or the filename extension. For more information on enabling the Binary Log, see the MySQL Reference Guide before continuing with installation of the plug-in.

Enabling the log on a Windows®-based MySQL Server

1
Start the MySQL Administrator application; for more information, see the relevant MySQL documentation.
IMPORTANT: If you do not have the MySQL Administrator installed, update the configuration file on a Linux® or UNIX® system and then stop and restart the MySQL service to enable binary logging.
2
In the MySQL Administrator window, click Startup Variables in the left pane.
4
Select the Binary Logfile Name check box, and either enter a unique name for the file, or leave the field blank to use the default value of log-bin.
IMPORTANT: When you specify the name of the destination file for the Binary Log, use only the name of the file itself; do not include full path information or the filename extension. For more information on enabling the Binary Log, see the MySQL Reference Guide before continuing with installation of the plug-in.
5
Exit the MySQL Administrator application.

Reviewing the recommended configuration

While you can set up a single machine as both the NetVault Backup Server and the MySQL Server, that is, all software installation and configuration requirements are performed on a single machine, Dell recommends that these two entities exist on separate machines.

Software installed and configuration

Software installed and configuration

Binary Log enabled (MySQL Standard/Community option only)
mysqldump/mysqlbinlog utilities — compatible with the version of MySQL installed
mysqlbackup utility — MySQL Enterprise Backup option only
MySQL Server added as a NetVault Backup Client — for details on adding a Client machine to the NetVault Backup Server, see the Dell NetVault Backup Administrator’s Guide.
IMPORTANT: Sample images and procedures throughout this guide assume that you are using this two-machine environment and that configuration requirements have been met.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation