mysql - Database cluster for storage -



mysql - Database cluster for storage -

i’m working in big project need massive database storage , web access.

about web server performances, quite easy deploy. utilize load balancing scheme proxy ha/varnish

my question database storage. need store huge quantity of simple info in real time , generate statistics. thinking nosql want maintain “simple” , don’t have knowledge nosql… think best selection me deploy mysql cluster of maybe mariadb cluster.

let me show info need store: receive 1 1,5 1000000 of records each day: ip address, username, site id, rating. based on data, i’ll produce statistics every 6 hours. first database i’ll have massive write access, , little read access (read access internal use) statistics, have 25 millions of read query per day.

because database huge after months, want have plenty disk space without having move new server, don’t know kind of technology best. think i’ll utilize ovh dedicated server 2 nic first public access , sec internal network every server can communicate private low latency high performance network. need utilize soft load balancer because it’s based on dedicated servers. have high availability , “unlimited” info storage need raid 15… maybe raid1 2 dedicated server real time replication

i don’t know best solution , software. - real time write access 1,5 1000000 of records each day - 25 millions of query per day based on statistics generated - storage simple text varchar 50 max.

i find nosql far more simple sql (relationships easier setup) sql can improve simple varchar storage, pacemaker can solution looking for, it's simple ha/failover cluster , can setup mysql cluster it, can setup loadbalancing , drbd (raid 1 on ip).

for info storage, think raid 15 not best solution, raid 5 offers less performance , info problems on disk failure, in company, using raid 10 , it's relly plenty our software (about 1 milion nosql requests per day).

if looking nosql cluster, neo4j has native cluster scheme (i never used it, know it's powerfull), maybe mongodb can too, don't know, never used it.

mysql nosql mariadb

-

Comments

Post a Comment

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

formatting - SAS SQL Datepart function returning odd values - i'm having massive problem project can't seem right. i'm trying modify info variable in datetime format. first info 30mar12:00:00:00. i've been advised utilize code below returns value 30mar60:5:30:00. want date component , have no thought how info got exported in format wasn't in microsoft access. i've tried several mods code 1 time again comes blank or sends error message. proc sql; update dataset set date = datepart(date); quit; any advice appreciated. i'm guessing variable date numeric , formatted datetime. 1 time you've carried out conversion, alter format date9. sas datetime value number of seconds since 01 jan 1960, whereas dates number of days since 01 jan 1960. both stored numbers, using right format display value key. illustration below. data _null_; a='30mar12:00:00:00'dt; b=datepart(a); c=b; format b datetime. c date9.; set b c; run; ...
Read more

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) - here error: duplicate symbol _objc_metaclass_$_bfapplinkreturntorefererview in: /users/user/documents/facebooksdk/facebooksdk.framework/facebooksdk(bfapplinkreturntorefererview.o) /users/user/desktop/project/project/project/assets/facebook/editor/ios/facebooksdk/facebooksdk.a(bfapplinkreturntorefererview.o) ld: 889 duplicate symbols architecture armv7 clang: error: linker command failed exit code 1 (use -v see invocation) i have searched find solution of error couldn't. there tons of similar error this, 1 hasn't been asked yet. problem shows when add together "-objc" "other linker flags". need add together utilize admob service. problem? how can solve this? i faced same issue while integrating facebook-ios-sdk. because using 3rd party library had bolts.framework linked against it. solution found incorporate facebook-ios-sdk source code hosted on github. ...
Read more

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' - extension's github project: https://github.com/mdmsoft/yii2-admin i'm using advanced template of yii2, i've backend , frontend , common folders advanced folder. the advanced folder on same level of vendor folder. i've others extensions , working then installed yii2-admin composer php composer.phar require mdmsoft/yii2-admin "*" installation worked well. into vendor folder i've mdmsoft folder yii2-admin subfolder it. this actual content of v endor/yiisoft/extensions.php (modified composer installation, haven't manually touched it) <?php $vendordir = dirname(__dir__); homecoming array ( 'yiisoft/yii2-jui' => array ( 'name' => 'yiisoft/yii2-jui', 'version' => '2.0.0.0', 'alias' => array ( '@yii/jui' => $vendordir . '/yiisoft/yii2-jui', ...
Read more