Usage Server - Cleanup database and start fresh new

[EduFrazao]

Hi!!
How can I cleanup my cluod_usage database?
I don't care to loose old records, I just want to start recording usage from now on.
I cannot cleanup my cloud database, its in production. I just want to clean the cloud_usage.

Thanks

[nickaccuweb]

@EduFrazao,

You can clear the old usage records without cleaning or rebuilding your production cloud database.

I don't recommend truncating the entire cloud_usage database because it also contains internal helper and usage-job information. Removing everything may cause CloudStack to process old usage events again.

If you simply want to remove the old usage history and start collecting new records, I recommend:

Step 1. Stop the Usage Server.
Step 2. Take a backup of cloud_usage.
Step 3. Clear only the main aggregated usage table:

TRUNCATE TABLE cloud_usage.cloud_usage;

Step 4. Start the Usage Server again.

This keeps the existing Usage Server state/helper tables while removing the old generated usage records.

I would also recommend taking the database backup first, especially if the usage data is currently being used by any billing or quota integration.

Nick R
Accuweb.Cloud

[EduFrazao]

Hi @nickaccuweb . Thank you by your advices.
I wanna do a cleanup because I got some strange quota values being calculated, accounts with incorrect IP address usage (Ips that does not belong to account anymore), and what appears to be some duplicated usage values, or incomplete information, like usage_vm_instance without end_date (but this vms does not exists on this accounts anymore).

The procedure that you indicate, can fix those problems?