Marklogic questions -
hello sql server dba , new marklogic , have few questions.
would marklogic support .net framework. meant our developers using .net framework 4.5 , using linq generate scripts sql. able generate marklogic scripts performing crud operations against marklogic database?
would able run sql or sql scripts retrieve data marklogic database( selecting documents sql). know couchbase supports niql.
does horizontal scaling require entire cluster down? able add or remove node marklogic cluster while cluster still online?
does marklogic support point in time restore (database , document). sqlserver has concept of transaction log backups , let me point in time restore. there similar that?
i won't moving entire application marklogic rather part of sqlserver having contention. hybrid model. there issue 2 phase commits? (i meant commits sqlserver commits marklogic)
is there minimum number of nodes required purchasing license? , minimum number of nodes required cluster?
a document database not same relational database. comparing them , expecting existing tooling work unlikely scenerio.
1) marklogic can store xml 1 of document sources. linq has level of xml support (i not know linq - read tutorial). appears have may acceptable starting point.
2) marklogic have sql layer - more bi needs. suggest more robust rest api or xcc.net options , robust search features , embrace full features of marklogic.
3) clusters need not go down adding or removing nodes. there other configuration changes require host restarts, not items mention.
but keep in mind, there other ways scale depending on need - adding additional data forests, scaling need not = new node..
4) yes. can rollback forest (your data) particular point in time using journal. details can found here: http://docs.marklogic.com/guide/admin/backup_restore#id_21622
5) no transational database likes transactions stay open long time. long can adhere that, there news. in marklogic, can multi-statement transactions on rest api using multiple rest calls (https://docs.marklogic.com/guide/rest-dev/transactions). believe covered here.
but keep in mind there ways make marklogic talk sql server directly - may have other options when designing integreated solution. (https://developer.marklogic.com/code/mlsam)
6) minimum number of nodes can discussed sales marklogic - yes, there single-node installs.
for 'cluster', depends on mean. if considering ha, need 3 nodes data redundancy.
Comments
Post a Comment