-
Notifications
You must be signed in to change notification settings - Fork 1
/
TODO.txt
94 lines (68 loc) · 2.62 KB
/
TODO.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
BUGS
------------------------------------------------------------------------------
- threads leak
- windows:
x:\sdk\bin\windows\..\..\lua\sock.lua:1361:
attempt to perform arithmetic on local 'n' (a string value)
FRICTION
------------------------------------------------------------------------------
- xrowset: must call update_client_fields() every time client_fields are needed.
- xrowset: manual_init_fields=true hack because we need to delay init_fields().
- xrowset: must call schema:resolve_types() on client-side because unserializable functions.
MILESTONES
------------------------------------------------------------------------------
- incremental file backups with rsync to complement xbkps
- restore:
- stop all deploys
- restore db
- restore files
- update deploy db
- start all deploys
- deploy backup & restore via mysqldump (with app stop for restore)
MONITORING
------------------------------------------------------------------------------
- disk per app
- app process list
- remote set logging.filter
- separate filters for file log vs server log
- set logging.debug automatically when directly monitoring
- global process list (requires root mm agent)
ADMIN
------------------------------------------------------------------------------
- app tenants
- app users
-
MYSQL
------------------------------------------------------------------------------
- start/stop/restart mysql server
-
TODO
------------------------------------------------------------------------------
- stop server without killing it
- let sqlpp tell xrowset when tables change, with control for when to
push changelists i.e. begin|end_rowset_changed().
- remove all rowset_changed().
- xrowset_table: derived from xrowset_sql.
- refactor all single-table editable rowsets.
- xrowset: gen col_map for self:insert_into() etc. from all non-r/o cols.
- remove all colmaps.
- save logs (excluding debug lines) in partitioned tables.
- auto-restart when lost contact (restart -f ?).
------------------------------------------------------------------------------
THINK
- kbytes() with variable magnitude or max decimals?
ALERTS
------------------------------------------------------------------------------
events:
- the app stopped sending procinfo
- max proc on machine is > X % for Y s in a row
- free ram on machine is < X MB
- app rss is > X MB
actions:
- log alert
- send email describing the situation
complications:
- prevent repeat email for the same alert type at intervals < X hours
LATER
------------------------------------------------------------------------------
- feature: generate/update list of putty sessions on mm windows client