HEAP tables are new in-memory table types. They can be used for extremely fast look-up tables. This gives Database Administrators the option to have the most optimized database setup to suit their specific needs. Replication One way replication can be used is to increase both robustness and speed. The extra speed is achieved by sending part of the non-updating queries to the replica server.
Replication can also benefit database backup operations.
Live backups of the system can be done on a slave instead of a master, eliminating potential problems and possible downtime. The use of these newly incorporated features can help to eliminate system downtime, by allowing the Database Administrator to repair damaged tables without shutting-down the MySQL server. Copyright 2001 NuSphere Corporation. All Rights Reserved.