code13 0 Report post Posted February 28, 2010 Hi kepada pembaca forum, Saya di sini ada masalah berkaitan task saya mengenai data replication...boleh tak sape2 di sini menerangkan perbezaan, pro/cons mengenai data replication..? saya perlu membuat perbandingan di antara volume level ngan database level. Harap2 ada forummners di sini yang sudi membantu. terima kasih rgds, Code-13 Quote Share this post Link to post Share on other sites
DevGuy 0 Report post Posted February 28, 2010 maksud volume level tu disk storage level kerr apa. kalau yer mmg ada pro n cons. database level kalaubuat replicate dia akan replicate database sahaja maksud nyer dia akan update master ngan slave database kalau storage level pulak dia akan replicate aa sejibik storage tu contoihnyer drive c atau d atau apa22 a. dia kaan sync ker main dia kalau aku aku suka buat database replication sebab kebanyakkan reqirement yg aku dapat semua nak replicate database huhuhu heheh Quote Share this post Link to post Share on other sites
code13 0 Report post Posted February 28, 2010 Thanks devguy atas pencerahan, aku pun sebenarnyer x mahir lagi tentang replication nie. tapi as aper penerangan ko aku raser mungkin same volume ngan storage, mungkin terms berbeza. lagi satu, kalo storage replicate tue dier sanpshot sebijik cam server asal ker? kenapa ko prefer database, bukan ker dier cuma backup data (i.e SQL) tapi apps lain dapat tak? camner ngan faktor bandwith, maner ko prefer kalo nak buat replication? Quote Share this post Link to post Share on other sites
DevGuy 0 Report post Posted February 28, 2010 oo sebab dalam kes aku kena refer ker architechture jugak. kami ada app server, database server, mirror lagi. sebab tu aa jus database jer. cuma ada satu projek ni aku guna windwos server 2008 with hyper V which aku leh buat virtualization di mana Zero down kalau nak buat replication ker kalau ada error apa22 ker kalau server down ker. baru nak deploy maybe next week. Quote Share this post Link to post Share on other sites
sworn 0 Report post Posted April 4, 2010 (edited) ahah... alang2 dah ternampak post nih,nak tanye nih.kalo nak buat replication db level tu,guna cara ape yg elok?utk client yg byk bilangannye.bkn la replicate yg mcm devguy ckp tu,lebih kpd db sync.db kecik je,cuma client dlm seribu lebih,network plak slow bebenor.ade kwn suggest guna db cache(dotnet),jadi,nak tau la ape cara yg slalu org guna utk handle prob camni.begitulah... Edited April 4, 2010 by sworn Quote Share this post Link to post Share on other sites
DevGuy 0 Report post Posted April 5, 2010 ok kita leh guna sync framework. sync framework niboleh support data besar tak kisah la cam ner. kalau nak tahu lebih lanjut carik microsoft sync framewok. aku buat benda ni utk projek ngan yapiem . sebab dia nak update data seluruh malaysia.o anyway ada satu lagi teknologi baru. cloud computing. tapi memandangkan malaysia tak der lagi benda ni. aku tgh bentangkan kertas kerja ngan yapiem utk benda ni. yapiem nampak macam setuju. kalau jadi company yg nak buat sistem tak yah beli database atau server atau apa. sebab semua provide by us. cuma kena ada internet aaa. tunggu unify support kawasan la pulak. Quote Share this post Link to post Share on other sites
sworn 0 Report post Posted April 5, 2010 ahah.... mekasih devguy utk info itu... lega ati den. Quote Share this post Link to post Share on other sites
rizal 1 Report post Posted April 5, 2010 hmmmmm....bagai mana ndak antar data dr database versi lama ke database versi baru?Ada sesapa ada idea?tq very much. Quote Share this post Link to post Share on other sites
DevGuy 0 Report post Posted April 5, 2010 what do u mean by hantar data dari versi lama ker versi baru explain sikit. tapi kalau guna ssis tak kisah versi berapa . takpun guna sql bulk pun ok fak. Quote Share this post Link to post Share on other sites
rizal 1 Report post Posted April 6, 2010 (edited) saya menggunakan postgresql versi purba 8.0.0 dan ndak hantar data dari versi purba ke versi yg lebih canggih iaitu versi postgresql 8.4 .Dan juga macammana database berlainan versi ni dapat berkongsi port yang sama dalam satu masa?buat masa ni versi purba aja yg dapat run,manakala versi canggih iaitu 8.4 x dapat connect .ada any idea?thanks. Edited April 6, 2010 by rizal Quote Share this post Link to post Share on other sites
DevGuy 0 Report post Posted April 6, 2010 oo senang jerrr. kena ada dua pc atau laptop which satu pc intall versi purba and satu lagi install versi baru then baru a aboleh buat integration. kalau intall satu pc tak sure aa tak pernah try tapi kalau dua pc noi problem Quote Share this post Link to post Share on other sites
sworn 0 Report post Posted April 7, 2010 btul2... xkisah pun versi ape postgres tu,buat je integration.kalo xbyk client dan xbyk data,guna webservice aje senang.xyah penin2.kalo critical punye data,guna queue pun boleh.devguy,zaman skang,org pakai ape ye yg elok utk integration? Quote Share this post Link to post Share on other sites
rizal 1 Report post Posted April 7, 2010 (edited) hmmmm....mintak DevGuy bagi ringkasan kaedah untuk buat integration.kalau pakai virtual pc utk integration boleh x?so, boleh buat dlm satu pc, who know.hehehee oh ya, saya dah cuba tukar registry bagi postgre ini, tapi belum work. Edited April 7, 2010 by rizal Quote Share this post Link to post Share on other sites
DevGuy 0 Report post Posted April 7, 2010 huhu hapasal la guna postgreee guna aaa sql server ker huhuh senang sikit kerja hahahahah leh jer nak tolong guide migrate Quote Share this post Link to post Share on other sites
rizal 1 Report post Posted April 7, 2010 [quote name='DevGuy' date='07 April 2010 - 02:46 PM' timestamp='1270622816' post='1024825'] huhu hapasal la guna postgreee guna aaa sql server ker huhuh senang sikit kerja hahahahah leh jer nak tolong guide migrate [/quote] sebab kene pakai dan melibatkan data yg besar gabak.Tapikan versi purba ni suka hang terutamanya bila data dah lebih 10k.sebab tu la ndak migrate ke versi baru.tapikan bos still ndak gak gunakan software xxx yg pakai versi purba ni.sob sob sob. Quote Share this post Link to post Share on other sites
DevGuy 0 Report post Posted April 7, 2010 ala 10K sikit jerrr. belom lagi ratus ker atau million data. ok jerrr.tu aapasal pakai postgreee. huhuhuhu Quote Share this post Link to post Share on other sites
rizal 1 Report post Posted April 7, 2010 tu la apsal jd hang? mintak sedara senaraikan segala kemungkinan.nanti saya check.tengkiu.huhu. Quote Share this post Link to post Share on other sites
rizal 1 Report post Posted April 16, 2010 ok.... saya dah check betul2.sebenarnya sistem yg jd "hang".ok tq. Quote Share this post Link to post Share on other sites