| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> hrm ...
<1> this is IT related. you guys can provide answers. http://rafb.net/paste/results/F1Exrs11.html
<1> Do i really need database replication?
<2> That's more of a business requirements question than a database question.
<1> Halo_Four: we are missing the requirements
<2> Who is missing the requirements? The business?
<1> yes.
<3> exactly what is the question?
<1> LVK: the question is pasted. What options do i have so that i can use the database without corrupting the data or .. without affecting the performance?
<3> backup/restore
<3> as you've already surmised
<1> yeah but what goes between back up restore?
<3> your load test I'd ***ume?
<1> yes.
<1> but which database do i do it on?
<4> anyone copy paste from excel into mssql em?
<3> your production database
<1> i need the production data.
<4> am I missing something?
<3> 1. backup production database
<3> 2. load test
<3> 3. restore production database
<5> evening
<1> no need to replicate.
<3> correct
<1> are you serious???
<3> uhm, yes?
<3> when you say "in a production environment", do you mean "in the production database" or do you mean "on the production server" or do you mean "on an environment similar to the production environment" ?
<1> I mean, on the production database and environment.
<3> ok, so doesn't that mean you've already decided what you need to do?
<3> backup, test, restore?
<1> I see.
<3> pepp^: why wouldn't I be serious?
<1> you'd be
<1> is this a feasible solution?
<1> Let me see if I understand it correctly. 1. make a snapshot. 2. back up the snapshot. 3 drop the snapshot. 4 do the testing 5. Restore the snapshot. Is this correct?
<3> what kind of database engine is this?
<1> Oracle.
<3> well, I don't know what you mean by snapshot as I'm not used to oracle
<6> waint until the dba is around :P
<3> but make a backup copy of the database, test whatever you need to test, restore it
<6> easy solution
<1> hmm
<3> but this is what you've already concluded with
<3> you said "in the production database"
<1> yes. thats what I've had in my
<1> mind
<1> but my BOSS insists i do replicate for some reason. i can't understand why he'd want that.
<3> me neither
<3> does he know what replication is?
<3> do you?
<1> i think not
<1> i know what rpelication is
<1> its keeping db's synced
<3> right
<1> you don't need sync with fake test data.
<3> I wouldn't say "don't need"
<3> I would say "wouldn't dare"
<3> personally I would never touch the production database
<3> I'd set up a mirrored environment and do the testing there
<1> hmm.. how does that go?
<1> how would you set up a mirrored database?
<1> i think i can get that done.
<1> This DBA we have KNOWS NOTHING tho
<5> then it's not a dba
<1> I am not the DBA, I am a scripter for the tests.
<7> do you have 2 licenses for the environment?
<5> hire a real dba
<3> I'd set up a new server, backup the production database, then restore it on the other server
<3> then I could test to my hearts content and never disturb the production server/database at all
<3> and no, I would still not use replication
<8> Perform a backup, load the backup on another server. Simple
<7> pepp^, most times script monkeys and developers have no idea what the real requirements are, or what a DBA really does. Any stupid answer your dba gives, is because the person who is whining is too stupid to understand the real problem
<1> yes that makes sense.
<5> you want to replicate prd onto test? **** that...
<1> Jarett_: I am a scripter of the tests tht we run.
<7> Ok so that means you have no experience or technical clue
<7> Leave the database, and performance to the DBA
<1> But the dba tells me to tell him what he should do for this test i am running. I dont know what the method is for all this backup and recovery
<5> you shouldn't need to know
<7> A scripter shouldnt be worried abotu backup and recovery
<5> just ask for it to be done
<1> Jarett_: thats what I am saying the dba we have KNOWS NOTHING.
<3> then you do not have a DBA
<5> indeed
<1> but my boss also says, include replicate.
<1> i am just confused why he'd want that.
<3> he doesn't
<1> replicate is TOTALLY UNNECESSARY
<3> he doesn't know what he's doing
<5> did you *ask* why he wanted that?
<7> People at work think I know nothing because when ever they ask me questions I say "I dont know". But thats because they are idiots. If I told them that, and told them that I save their jobs every day.. it would be different
<5> maybe he wants to tets 'hot standby'
<1> what is hot standby?
<5> argh!
<7> sort, when you are more than a 'scripter' you can say what someone is or isnt
<5> in fact...
<7> Plus, is the DBA directly under your boss? or a different boss? Maybe your boss is an idiot too
<6> lol
<1> lol
<6> man, when the dba asks for precise statements, then hes clueless
<5> sounds like they're *all* idiots
<1> YuppieScm: I'd have to agree with you. :)
<5> pepp^ : *all* includes you...
<1> I like the idea tho, making a backup of the DB and loading it up on another server.
<5> pepp^ : that is standard practise
<9> wow
<9> are we still discussing this?
<9> lol
<5> the prd database should never ever directly connect to anything that is not prd
<5> anything that is not prd should never ever connect to anything that is prd
<5> bear those two rules in mind
<1> YuppieScm: yes that makes sense.
<5> good... no go away
<5> s/no/now
<1> Ok. One last question.
<7> pepp- is the DBA directly under your boss? or a different boss? Maybe your boss is an idiot too
<9> if the questionis not related or pertaining to
<9> "how do i exit irc" or "or will the alt+f4 button exit irc" please die
<1> Jarett_: the DBA is under a different boss.
<5> nah - the answer is 'yes, and please do...'
<7> Ok that makes sense. I bet you and your boss would be fired if you were under his boss :P
<7> You should kiss the DBAs butt, and ask him what would be the best thing to do
<1> Jarett_: dude, I am a scripter. I write scripts.
<7> You depend on him for your livelihood and paycheck
<7> In your company, you are nothing, and he is everything
<1> I dont write scripts on the database. I write scripts so that application can do things automatically.
<5> pepp^ : scripts for *what* engine?
<0> hrm, this is pissing me off ... using xmlhttp to send post data to a server ... and it's not working, yet all the examples I've found with google ... say I'm doing it right
<7> wow... I could replace you with a script.
<5> zoul : 'not working' - i'm not sure i've see nthat error before...
<1> YuppieScm: I write scripts in C, that talks with the application and makes it do things. like insert record etc. I record these scripts using a tool.
<7> do you compile the 'scripts'
<10> C doesnt do "scripts" in the real world
<5> 'write scripts in c' - last time i looked, people only ever wrote applications in c...
<7> pepp^, you are an intern arent you?
<5> 'intern'=='cretin'
<6> i record with msvs
<7> we will wait while you google another language to state
<5> in fact, let's just not bother
<0> set web = new xmlhttp: web.open "post", url, false: web.send "var=val&var2=val2": msgbox web.responsetext
<5> bye
<0> the url I'm using, is a php script, that just has ... foreach($_POST as $k->$v) echo "$k = $v\r\n"; ...
<9> lolz
<7> zoul, nothing like injectable code for breakfast :P
<6> it should be $k => $v
<0> upb, yeah I just realized that ...
<6> maybe thats why it 'doesnt work'
<0> the stupid *** server supresses error message,s forgot all about that ...
<0> Jarett_ and you figure that's injectable, how ?
Return to
#sql
or
Go to some related
logs:
#winxp
yaquake terminal
#narcotics
#politics
cache:0y7fh8HbPh8J:www.quotesdb.info/efnet/firebird/25Feb2006/1.html 1by-day.com
#slackware
#nhl
#beginner
#linux-noob
esd pua mystery
|
|