Changes between Version 18 and Version 19 of InstallationGuidelines/MySQL
- Timestamp:
- 09/06/10 07:06:09 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/MySQL
v18 v19 61 61 }}} 62 62 63 Index columns (especially on tables with many records) which are sorted on (which we do a lot for dropdowns):63 Index columns which are sorted on (especially on tables with many records) [we sort by name in most dropdowns]: 64 64 * gis_location.name 65 {{{ 66 ALTER TABLE `gis_location` ADD INDEX ( `name` ) 67 }}} 65 68 === MySQL Replication === 66 69 In order to have a backup instance, configure replication from the Master node to a Backup node: