You can use the Database Manager GUI to change log settings. To do this, use the Configuration Wizard, which guides you through the entire process.
Check the log area and log writer information in the Database Manager GUI.
Start the Configuration Wizard. To do this, choose Start ® Programs ® MySQL MaxDB ® Database Manager Wizards ® Configuration Wizard, or, in the Database Manager GUI, choose Instance ® Configuration ® Configuration Wizard.
Choose Next to start each of the required steps.
Decide which log settings you want to change. You can change multiple log settings, one after the other. To do this, choose Back each time you complete your changes.
·
Log
Mode: Log Mode
The database instance can be in any operational state. You should ensure,
however, that you transfer the database instance into the operational state
OFFLINE after setting the log mode, and then into the operational state
ONLINE. If you want to mirror the log area by setting the log mode, then you
must use the Configuration Wizard to create only the required mirrors
of the log
volumes.
- Choose Properties.
- Specify the location of the mirror under Location.
- Start the process.
After this operation has been completed, the database instance is transferred
to the operational state OFFLINE and then to ONLINE.
·
Overwrite mode for the
log area
After a standard installation, normal log backup operations are activated,
which means that the overwrite mode is deactivated. The database instance must
be in the operational state ADMIN or ONLINE before you can change the
overwrite mode.
You can use the Configuration Wizard to activate the overwrite mode.
This setting remains active even after you restart the database instance.
You must activate normal log backup operations (and deactivate the overwrite
mode) explicitly with the Configuration Wizard. Afterwards, you are
prompted to make a complete data backup to
guarantee the integrity of your data.
·
Activating or
deactivating redo log management
Redo log
management is activated after a standard installation. The database
instance must be in the operational state ADMIN before you can change this
setting.
You can use the Configuration Wizard to deactivate redo log management.
This setting remains active even after you restart the database instance.
You must activate redo log management explicitly with the Configuration
Wizard. Afterwards, you are prompted to make a complete data backup to
guarantee the integrity of your data.