Project

General

Profile

Actions

User story #2971

closed

Clean reports database v3 : Add a webconfigurable scheduler for automatic report database cleaning

Added by François ARMAND over 11 years ago. Updated about 2 years ago.

Status:
Rejected
Priority:
N/A
Assignee:
-
Category:
Web - Maintenance
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

Description

Rudder stores node's agent execution report in a database. But there might be a lot of such reports, and the database can growth enormously.
So, we want to be able to "archive" or "delete" old reports automatically.

For that, we want to add in the "DB Management" screen two section to configure job scheduling to archive and delete reports.

Archiving a report is juste compacting and moving it elsewhere in the database.
Deleting a report is well, removing it for ever.

The UI must allow to configure these parameters about the job scheduling:

- activate (or not) the job;
- "time to live" for report, i.e maximum age of a report before being cleaned;
- frequency and execution time of the job execution

For that last parameter, we want something providing almost the same functionality than google calendar recurrence picker:

Google Calendar UI to configure a job recurence

- allow to choose frequency by unit (hourly, daily, weekly, monthly, yearly)
- allow to choose how many time by that unit (minutes for hourly, hours/minutes for daily, etc)
- for weekly, allow to pick a specific day of the week;
- for monthly, allow to either choose a day number (each 5th of the month) or a specific day of month (each 3th Tuesday of the month) and a given time on that day.
- give a sentence summarizing the choice, ex: "every 3th Tuesday of the month at 03:00"

Each cleaning execution has to be logged in an event log.

If Rudder is not running at the configured execution time, nothing is done until the next event time (we don't execute a missed job as soon as we notice it).


Files

google_calendar_recurrence_ui.png (14.8 KB) google_calendar_recurrence_ui.png Google Calendar UI to configure a job recurence François ARMAND, 2012-10-30 15:11

Related issues 1 (0 open1 closed)

Blocked by Rudder - User story #2997: Clean report database v2 : Add an automatic reporting configured by properties ReleasedJonathan CLARKEActions
Actions #1

Updated by François ARMAND over 11 years ago

  • Description updated (diff)

From an implementation point of view, that will need a new table in the DB to store job information.

Todo: define what columns are needed so that we can handle all the frequency variation.

Actions #2

Updated by François ARMAND over 11 years ago

  • Description updated (diff)
Actions #3

Updated by Vincent MEMBRÉ over 11 years ago

  • Subject changed from Add a webconfigurable scheduler for automatic report database cleaning to Clean reports database v3 : Add a webconfigurable scheduler for automatic report database cleaning
Actions #4

Updated by Jonathan CLARKE over 11 years ago

  • Target version changed from 24 to 2.6.0~beta1
Actions #5

Updated by Nicolas PERRON about 11 years ago

  • Target version changed from 2.6.0~beta1 to 2.6.0~rc1
Actions #6

Updated by Matthieu CERDA almost 11 years ago

  • Target version changed from 2.6.0~rc1 to 2.6.0
Actions #7

Updated by Jonathan CLARKE almost 11 years ago

  • Target version changed from 2.6.0 to 2.6.1
Actions #8

Updated by Nicolas PERRON almost 11 years ago

  • Target version changed from 2.6.1 to 2.6.2
Actions #9

Updated by Nicolas PERRON almost 11 years ago

  • Target version changed from 2.6.2 to 2.7.0~beta1

I guess it will be done in 2.7 instead of 2.6

Actions #10

Updated by Nicolas PERRON almost 11 years ago

  • Target version changed from 2.7.0~beta1 to 2.7.0~rc1
Actions #11

Updated by Nicolas PERRON over 10 years ago

  • Target version changed from 2.7.0~rc1 to Ideas (not version specific)
Actions #12

Updated by Benoît PECCATTE about 9 years ago

  • Status changed from 8 to New
Actions #13

Updated by François ARMAND about 2 years ago

  • Status changed from New to Rejected

The current maintenance job and config is ok.

Actions

Also available in: Atom PDF