I did the upgrade from 1.8 to 2.x yesterday - with partitioned tables and MySQL... And everything is running fine. You don't need to migrate to Postgre and neither hack the DBUpgrade-script in any strange way.
The only trick is to remove table partitioning from the (small) monthly partitioned tables (acknowledges, alerts, auditlog, events, service_alarms). Only (some of?) these tables use foreign keys in v2.
The huge tables history and trends are remaining partitioned daily, of course.
I don't have a cleanup of those small monthly tables yet, but this is not a big problem (sum about 600MB, whereas trends and history are 36GB in size...) So if they are 2GB in two years, they should be, it doesn't bother me.
The only trick is to remove table partitioning from the (small) monthly partitioned tables (acknowledges, alerts, auditlog, events, service_alarms). Only (some of?) these tables use foreign keys in v2.
The huge tables history and trends are remaining partitioned daily, of course.
I don't have a cleanup of those small monthly tables yet, but this is not a big problem (sum about 600MB, whereas trends and history are 36GB in size...) So if they are 2GB in two years, they should be, it doesn't bother me.
Comment