vb.net - Best way to report events / read events (also MySQL) -


so i'm going attempt create basic monitoring tool in vb.net. i'd advice on how tackle logging , reporting side of things i'd appreciate responses users i'm sure have better idea me , can tell me far more efficient ways of doing things.

so plan have client tool, read mysql database values , change every x interval, i'm thinking 10/15 minutes @ moment. side of application quite easy, mean can read database every x amount of time , change labels , display alerts based on them. - documented , okay that.

the second part have client sits in system tray of server gathering required information. system tray part think trickiest bit of this, that's not part of question.

so assume can use normal information gathering commands , store them perhaps strings , can connect same database , add them relevant fields. example if had mysql table called "server" , column titled "connection" check if server has internet connection example , store result value 1 yes , 0 no , send mysql command table update "connection" value either 0/1.

then assume monitoring tool can run mysql query check "connection" column , if value = 0 change label or flag error , if 1 report connectivity okay?

my main questions above listed below.

  1. is using mysql database efficient way of doing this?
  2. obviously if database goes down there's no more reporting, still think that's con i'll have live though.
  3. storing values within code best way store data?
  4. is there particular type of format should use in mysql colum, thinking maybe tinyint(9)?
  5. is above method redundant , pointless?
  6. i assume these database connections cause unwanted server load, 15 minute refresh time should combat that.
  7. is there way combat delays perhaps client updating not in time reporter picks false data, perhaps fail safe column containing last updated time?

you don't need tool gathers information per se. web app (real time monitor) can that, since clients storing information in same database. web app can access database every 15 minutes , display data, without intermediate step of saving again. provide web app latest information instead of potential 29-minute delay.

in other words, clients saving connection information once. don't duplicate in database.

mysql should work anything.

it's bad idea hard code "everything". can use application settings or mysql table if need store ips, etc.

in application this, conversion more offset data savings of tinyint. use convenient data type.


Comments

Post a Comment

Popular posts from this blog

c++ - CryptStringToBinary API behavior -

i seeing strange behavior cryptstringtobinary cryptography api. please see below code (config: x64 debug): #include "stdafx.h" #include <windows.h> #include <strsafe.h> #include <iostream> #include <exception> void main() { dword dwskip; dword dwflags; dword dwdatalen; //lpcwstr pszinput = l"jaaaaaecaaadzgaaakqaagdnnl1l56bwgfjdgr3rpxtqqqn6daw3usv2emkjym4t"; //this works fine lpcwstr pszinput = l"mytest"; //doesnt work, api returns false,error code 0x0000000d // determine size of byte array , allocate memory. if(! cryptstringtobinary( pszinput, _tcslen( pszinput ) + 1, crypt_string_base64, null, &dwdatalen, &dwskip, &dwflags ) ) { dword dw = getlasterror(); //0x0000000d: data invalid throw std::exception( "error computing byte length." ); } byte *pbytebyte = null; try { ...
Read more

c++ - Correct method for redrawing a layered window -

i have window created ws_ex_layered window style. drawing onto memory bitmap using gdi+, , using updatelayeredwindow update graphical content of layered window. intend use window main window of application, require redraw frequently. seeing layered windows not receive wm_paint windows message [?] , need come appropriate method re-drawing window. optimisation not essential , it's nice have cake , eat too. therefore, in search of "correct" method use. here thoughts far: i guess it's idea render onto off-screen bitmap before bitblt ing or similar. 60 frames rendered per second should (more than?) enough (but how compare other applications' frame rates?). possible solutions: use settimer send wm_timer message on regular basis. useful because through specifying time-out value, can achieve desired frames per second, without requirement measure duration "frame" takes rendered. would cause input or other lags due frequency , speed of m...
Read more

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more