Add column on huge InnoDB table in MySQL 4.1 I need to add a column on a huge InnoDB table (200GB) which resides on MySQL 4.1.21 (SunOS).

CPU has 16GB RAM and 200GB of more disk space.

Is there any quick way of adding this rather than ALTER TABLE? Because, ALTER TABLE as far as I know would take some months to complete.

Any thoughts experts?
You can use statement-based replication and add the column to a slave first.  Any pending modifications will queue up on the slave, and apply once the alter has complete.  When the slave is fully up to date with the new schema, you can effectively 'promote' it.

I am sure you are aware, but MySQL 4.1 is quite old.  Triggers were not introduced until MySQL 5.0 (2005), so this limits your options to use tools like pt-online-schema-change.