mysql - Database type and engine for medium scale user content website -

-

using mysql basic storage of system/user data. need store/search messages (adding webmail functionality), , have analytic (on fly reports/graphs current , historical data, kind of data wearhouse) + means need store historical data.

so question is:
1) use mysql or use separate databases messages, analytics/historical data/user data? there live feeds on site heard mysql isn't with.

2) tables use mysql innodb enough or need more advanced engines tukodb?

for messaging friend mentioned use non relational database instead of mysql. if use separate datbase types adds int headache of keeping them in sync , given 24-7 user content site, cant have downtime.

-- website high traffic user content website, lots of reads/writes no money need depend less on servers/hardware , more on database/software keep me afloat, hence open free/open source databases , database engines.

before answering question directly should concerns premature. lot of assumptions wrong before have working project. instead of designing perfect architecture, make project (non-perfect) , be ready changes.

now, question.

for messaging friend mentioned use non relational database instead of mysql. if use separate datbase types adds int headache of keeping them in sync , given 24-7 user content site, cant have downtime.

that recommendation. don't need keep them in sync because persist different data in different databases.

  • sql database - transactional data.
  • document database - historical , non structured.

website high traffic user content website, lots of reads/writes no money need depend less on servers/hardware , more on database/software keep me afloat, hence open free/open source databases , database engines.

if @ cap theorem , requirements, can tell sql database not suitable because sacrifice partition tolerance or availability sake of consistency (which don't seem need).

from have described, you'll better off database supporting eventual consistency. mongodb 1 of popular document databases.

i heard things cassandra. allows tune between consistency, availability , partition tolerance.

redis can used extremely high loads providing consistency , availability.

so recommend to:

  • use sql database (innodb enough) critical data requires high consistency.
  • use document database higher traffic data (mongodb, coachdb).
  • use key/value (hash) database extremely hight traffic data (~redis).
  • use database comfortable rest.

Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have ...
Read more

html - Instapaper-like algorithm -

-
does of algorithm extracts contents webpage? instapaper ? there 2 steps instapaper does: find main content block on page (excluding headers, footers, menus etc) from content block extract , format text to find content block (typically html block element, div containing key page text content) instapaper uses algorithm 1 used readability . can @ source of readability.js see what's going on, @ core tries find area on page highest text/link ratio, although has other simple scoring metrics (e.g. off top of head, things ratio of text commas, para elements etc) go heuristics. once have identified root node element, relevant content, you'll need format it, if want can pull node element containing text out of source document , insert yours, in reality you'll want remove existing styles , apply own, standard , feel. if want output nice text-only can use jericho's renderer . update1 : should mention else instapaper - follow 'pagination' links (...
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj...
Read more