| # |
May 29th 2016, 10:36 |
ionas |
but now I have a solution anyway I hope |
| # |
May 29th 2016, 10:35 |
ionas |
markstory well Iâ??d not pick sql server â??just because ofâ? binary file streams |
| # |
May 29th 2016, 10:16 |
marlinc |
Hey ChrisSME |
| # |
May 29th 2016, 10:14 |
 johan |
something I used in the past was GlusterFS, but that was also when I was managing the storage cluster and related servers myself, on bare metal. my understanding is that CEPH is an alternative to that. |
| # |
May 29th 2016, 10:13 |
markstory |
I've never used sqlserver filestream |
| # |
May 29th 2016, 10:13 |
dakota |
No, FileStream (https://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx) |
| # |
May 29th 2016, 10:12 |
ionas |
dakota you mean sql server binary stream? |
| # |
May 29th 2016, 10:12 |
dakota |
but you access it as if it was a db blob |
| # |
May 29th 2016, 10:12 |
dakota |
The actual binary is stored on disk (or s3, etc.) |
| # |
May 29th 2016, 10:11 |
ionas |
and thus should not be inâ?¦ say webroot/uploads |
| # |
May 29th 2016, 10:11 |
ionas |
however the basic idea that the talk exposed is: code=stateless, data=instance/stateful |
| # |
May 29th 2016, 10:11 |
ionas |
sure johan its not â??good ideaâ? unless there is binary streams like sql server has it |
| # |
May 29th 2016, 10:11 |
dakota |
thatâ??s what I like about FileStream. Itâ??s DB blobs but not |
| # |
May 29th 2016, 10:09 |
marlinc |
In that case you might be better of using something like Swift (OpenStack) or S3 I guess? |
| # |
May 29th 2016, 10:09 |
markstory |
backups get harder. |
| # |
May 29th 2016, 10:08 |
markstory |
Hard to but a CDN around blobs in the db. |
| # |
May 29th 2016, 10:08 |
markstory |
blobs in the database are a bad idea imo. |
| # |
May 29th 2016, 10:06 |
dakota |
I think SQL server did it right with File Stream |
| # |
May 29th 2016, 10:01 |
johan |
everything is a trade-off :slightly_smiling_face: |
| # |
May 29th 2016, 10:01 |
johan |
one obvious disadvantage to storing tons of binary data in SQL is backup and recovery becomes a little more interesting |
| # |
May 29th 2016, 09:59 |
ionas |
is that a good idea? |
| # |
May 29th 2016, 09:59 |
ionas |
I mean I always considered storing binary into sql, and he points out why but now I think about storing whatever â??user imagesâ? into redis or whatever |
| # |
May 29th 2016, 09:58 |
ionas |
this talk is great |
| # |
May 29th 2016, 09:57 |
marlinc |
https://twitter.com/dakotairene/status/736855039399079936 :P |
| # |
May 29th 2016, 09:53 |
birdy247 |
gossip etc.. ;) |
| # |
May 29th 2016, 09:53 |
birdy247 |
any cakefest updates ? |
| # |
May 29th 2016, 09:47 |
ionas |
at least that makes it possible that I hire Varoufakis |
| # |
May 29th 2016, 09:47 |
ionas |
ACTION cries. |
| # |
May 29th 2016, 09:47 |
ionas |
I am a gabe lookalike |
| # |
May 29th 2016, 09:46 |
marlinc |
http://orig08.deviantart.net/9f15/f/2013/009/f/a/gabe_newell__the_hero_of_us_all_by_radulfgreyhammer-d5r0ecr.jpg |
| # |
May 29th 2016, 09:46 |
ionas |
http://vignette4.wikia.nocookie.net/half-life/images/2/2b/Gordon_bust_rtb2.jpg/revision/latest?cb=20100622090108andpath-prefix=en *sigh* |
| # |
May 29th 2016, 09:46 |
ionas |
the one to the right https://www.google.nl/search?q=half+life+heroandclient=firefox-bandsource=lnmsandtbm=ischandsa=Xandved=0ahUKEwi-1PeR_f7MAhVJrRoKHU2RAwYQ_AUIBygB |
| # |
May 29th 2016, 09:46 |
ionas |
ACTION suicides |
| # |
May 29th 2016, 09:46 |
ionas |
omg |
| # |
May 29th 2016, 09:46 |
ionas |
k3+H4jzjQeuKEIDl7p9b1ZZFTiq1x/LtO/6sP1cEIU+T9Krx/vFhKeAQhebk9PF2xukKS3DTAm+/khCztUltwLTx6yufwTQCSTbW30QhSaPWwxGvCfHRRarYQhVKSO5cU/iHUfNCFpGbYdphOHrf/GT5SsXizDj1/VCF1/5f1ri8/cMO0lIQBPH69yELpYu3GyaqxoeSEICLjiAI7/sojWShCDdexOqXZSIQH//Z |
| # |
May 29th 2016, 09:46 |
ionas |
XD0yXTeNTHDekD7AA02uYNuHBO5dVLX9xH1+aKzwBbeBA3Bu4euKXKW7VVojVzW+JAPlKd4ha3dHsR/qHNeCWtAMOGrp4T+Xn4LtmUcBUP/Ef/AJV9VzB226IAkxFrArn8e/iV52fkyyu3pYYTGaVTMhJ/JV77fRSG9nnfyP73kf8A2U78W/ilbiHcfms/a/a5EVnZ0/yDvqf+S7fkG/Zpd5JT5qnimnuKW/6NGRkI4UR3f+KdOTAfmpDo39EbRTUlH/QcOWj/AHGeCadl/wD7s936rlxSUHEPaeDm/MKiS8XkD6FN1YvgiNpkXc3aAvexE236hVGKkkk3GnRbrtSP9PV/tHk4FYetEuHNdn+bK3Dlw+af+kZjBr4pXUpTmxAn16ulBBPNbsjPs4XLgpJaU253FBmnNULFn3Y5qa8CL9VAqu2tUBHldDokLV2AgOqgTbgkQgj+1br |
| # |
May 29th 2016, 09:46 |
ionas |
cifXms0HK2yKt8Q6H6H6JpV+L9172/yPMdCZHkQuKbz6/VS86EVjoNpgPeDHyIUBlTiuXKatej48vbGVZUjOuhTWLoSI3qP7W2vd+qR1a2p8SpbdxSYtpY/a3aOS1HtdcER1GverN4B3Dvgrn8Mw/lHcPstJnpz5+D2u4rKtVsASJEb1xTxI3H14q59k0flHgm6z4iALdLhP8iL/AJ/6q6+MEfafkohrbRAEybAH9VdtPTpIXRY0jTvGqPyF+CfaFQo7Ijz49FaZdlxq3dZnzTuT5eKu0To0wQeOum7ce9aCo5rG30GgG88k8cd8ln5PXiGmllMaQ0WEb+Q5qmx2JdUdLu4DQDgnK9YvdJ03cAFwWrRzo7Qug1OualaEGjgRKeYdJXRHrvSdUBxWfAtMlQrc05VfJkd11wUA7U5+E2TTilJ3pp5TI+83TmGeJJN4Fgd5KbfTIAtum |
| # |
May 29th 2016, 09:46 |
ionas |
v07loMC/8Ag0+bG/JYp9RazKHzSZ/bHzCpLLU3e63pxUoPaW2k9Bbx0UChRAazpeRPzUynVJ1J8guR60vCPiqR2bAj5n6eaoMRTg6X0WorYY+XH6KmxtH/AB9lUrLPFDwxMbuH1HzTVJw2uIJ+m+6dwbpLhzFt64A2Xz46bwto4r25xNO87uM2niPsnKOlzbd+n3Riwe4acTbeOKMMbct3HTyTI7s9U250Xt5lOxxUXEnw0QDTn3Ud9TcNUolxspdLCgffipt0vDD2MUqUXNzxVllGANV204e4D/2PDou8JlxrECNlg1jVaf2TKNO4gCwG8ngpxm+V5ZSTUQcS7YG0Y5D1uVTJJk3nWfmpNeqXmT/jkE02mtGBaYjRS6bvX+EzTCdA5INLp1YUgYgev8Kv2o5pqriSDAhAR6lYlLSdCQs6rmenrmnSWrsSmH1ZTDqq4afFAPsI3rQ |
| # |
May 29th 2016, 09:46 |
ionas |
dQVMwuZvazYBcOIsd3AqrhvljM9cIuIwYY4zG0QQ2OkX52PgmMIwkAB2wBBvoePQfqrH96kxtsY+DvBmNYiUmHxbRJLG20AgDdM7kvWn7wr3hoaQDpffIAgc9Z56KzyysGbLqtrA7LYmxBI5TGz3qufi5GgE6ka/P1PNNvqa8xvR6C5/QzLMHVqhcTr3C1oAXFN1rj5R6+6jE7gj2m7erZ7SmPPXuSYnEWgC/rcVDfidNZ3XXBkCSbqbdLxx2T2ZkAXJNupK1uW4VtJmyI2jcnn+irMmwWy32h+I/DyH6qZj6+yNjefiPLgnjPkZ5fBMTiJIA+Ec9TxUrC1+9VTCp1KDy6KmS+wmKEwbc1b0sWI3HvWZpN5qQ1xQHumOz+lT0948tPFZ7Fdr3EwC1o5a+JXnuY56TvKp2ZoS7XzRobevHtJ/D1JJ3rJ5tm+1JlUox5i5VZjsZKBsm |
| # |
May 29th 2016, 09:46 |
ionas |
E8fsptVGhyXDuLmmNTHkSPMJvtRmu08MbdrLAXubAzHSFMzLENw9Fw/M6zfmT5DyWSc6bzcnjzVYT5RnfhMfJEnwTTzIiPXqEtAiLkXNgle7Z9fZWzUFSnsvMKU58CO5Rqj5qTwUzB4U13hu7Vx4D7qL26MbqctN2Jw2y11Y6u91v9ouSO/wCS0tXMdGg8z9NO9VdFzWN2QIa0RHyHUpmk7aMk3K0k1HLlfa7afCVSSCCtJhceNm5I5SsbgakQrunUBGsd0oS9ZlIlhEJNCErlzoXRKo85zMNBQDGe5lstKzAxksB9fEVVZ5m20deSMC+aTT/Tb5qtItYTEDak8Xvd4uJ+qa9jAm8aBdtMgd5Tpbax3Lm3y9KY8KfFNEHcfLw+yq9obUxrw5K7x1NUdQe9C0jDNqMpzRr6Xs6pkBw2TMObB2hH9NoPemcxwLSfeEEjfoXbMSD5x1V |
| # |
May 29th 2016, 09:46 |
ionas |
l3D/AGdzE4fEU6gmA4Bw/pJh3kfJe/4evBY5pMm3ivAezuDFXE02xadp3QXP0HevZqOLLIuLDfx0HmfJaYuXzdt5hMwDrGxU8OWDw2L96x7pFv0Wkw2OGyLn11CGcyXSEIQoIQkQCpjF4jYbO/QLupUAEqgx2NDiSTyCchMJ+0TMtKIPxDbeeU2B6kE9y8qxbNo2t9lpu1eML69Z022ywcYaNm3mqGkd5t19Qss7y6vFjJihUqBaQdD63rVZBXBpVKZ/vA7oPy3c1Q1nbraTw/QpjAY51Kq12rQb28W9UtHdRoKWOc12we76rrNKbi0ua4tPI70vaHBQdtgnadLe8TAI4fVVH71MFh3cY4SiIQW53Vk3MDUnoJUejmT6jtnaIn7qsxFeS6N8945+alYamAZEdRuvax1EkKk8tjgsN7MTMk6nX0FEzDMd2vJQqGLeWQ508uA+qbw4c |
