OpenStack Compute (nova)

lp:~jcannava/nova/lp741274

Created by Jason Cannavale and last modified

Bug: MySQL database tables are using the MyISAM engine
Created nova/db/sqlalchemy/migrate_repo/versions/017_set_engine_mysql_innodb.py
 - Checks for mysql
 - Executes "ALTER TABLE <table> Engine=InnoDB" for all current nova tables. Allows some flexibility in that the file can be modified to exclude certain non-transactional tables or new tables can be added as they are created.
 - Tested with manage.py and all current tables are updated:

auth_tokens InnoDB
certificates InnoDB
compute_nodes InnoDB
console_pools InnoDB
consoles InnoDB
export_devices InnoDB
fixed_ips InnoDB
floating_ips InnoDB
instance_actions InnoDB
instance_metadata InnoDB
instance_types InnoDB
instances InnoDB
iscsi_targets InnoDB
key_pairs InnoDB
migrate_version InnoDB
migrations InnoDB
networks InnoDB
projects InnoDB
quotas InnoDB
security_group_instance_association InnoDB
security_group_rules InnoDB
security_groups InnoDB
services InnoDB
user_project_association InnoDB
user_project_role_association InnoDB
user_role_association InnoDB
users InnoDB
volumes InnoDB
zones InnoDB

Get this branch:
bzr branch lp:~jcannava/nova/lp741274
Only Jason Cannavale can upload to this branch. If you are Jason Cannavale please log in for upload directions.

Branch merges

Related bugs

Related blueprints

Branch information

Owner:
Jason Cannavale
Project:
OpenStack Compute (nova)
Status:
Merged

Recent revisions

1094. By Jason Cannavale

Update migrate script version to 22.

1093. By Jason Cannavale

Incremented version of migration script to reflect changes in trunk.

1092. By Jason Cannavale

Incremented version of migration script to reflect changes in trunk.

1091. By Jason Cannavale

Incremented version of migration script to reflect changes in trunk.

1090. By Jason Cannavale

Added new snapshots table to InnoDB migrations.

1089. By Jason Cannavale

Cleaned up bug introduced after fixing pep8 errors.

1088. By Jason Cannavale

Cleaned up bug introduced after fixing ^Cp8 errors.

1087. By Jason Cannavale

Cleaned up text conflict.

1086. By Jason Cannavale

Cleaned up text conflict.

1085. By Jason Cannavale

Cleaned up text conflict.

Branch metadata

Branch format:
Branch format 7
Repository format:
Bazaar repository format 2a (needs bzr 1.16 or later)
Stacked on:
lp:~hudson-openstack/nova/trunk
This branch contains Public information 
Everyone can see this information.

Subscribers