Archive through December 31, 2002
TV ClubHouse: Archives: 2003 January:
Computer Problem - I need advice/help (ARCHIVE):
Archive through December 31, 2002
Zachsmom | Sunday, December 22, 2002 - 11:06 pm     Let me see if we are on the same page here.. are you suggesting creating a separate database that is "Transactions" only and updating/inserting the transaction(s) that occured while server 1 is down? This could work..hmm |
Draheid | Sunday, December 22, 2002 - 11:11 pm     Right, and I would suggest this "Transactions" database be on a completely seperate server. I presume there is a reason #1 is the primary and this would make sure that the transactions that occur during the process are stored for 'insurance' of sorts. It's just a thought I had after reading your original inquiry. Hope it helps! |
Zachsmom | Sunday, December 22, 2002 - 11:15 pm     Thanks Draheid! I'll take this to my team tomorrow and see what we (or should I say "I") can do with it. |
Bob2112 | Monday, December 23, 2002 - 01:23 pm     Hi ZMommy, as always, when we talk databases, I would suggest moving it all over to Oracle on a Unix server. Then I can help you in great detail. I think you may want to look at running a fail-over configuration in an Active-Passive mode. This will move transaction logs from your active server to the standby server periodically (you tune this to balance performance/possible loss of transaction data) and allow your secondary database to come up when the primary database fails. After recovering the primary database, the transaction logs from the secondary database would be used to synch up the 2 databases. You could then fail back to the primary server if desired (maybe primary server is more powerful machine). Obviously there are many details missing here, but this is what we use in our Oracle environment and it works well. Even if the last logs were not automatically transferred to the backup server, they can often be copied manually to have all committed transactions rolled forward. We write our transaction logs to different raid sets, both local and on our SAN, so there would need to be multiple disk failures before any committed transactions were lost. The active-passive fail-over database functionality is typically based on one-way replication concepts, but usually provides more functionality. I would stay away from trying to accomplish this at the application level, since you want to capture all updates, table creations, granted permissions, etc.... It's all in the transaction logs already, so why run the risk of missing some Ad Hoc DDL or DML. I can not vouch for how well this works in SQL Server, but in Oracle it is the cheapest, most common solution to survive a failed server. Email if you want to discuss this in greater detail. Good to see you got MySQL running under Linux. You can download Oracle for free to run under Linux from the OTN. You mentioned in the past that you would like to do this, so maybe in all your "spare time" you can play with that too!  |
Zachsmom | Monday, December 23, 2002 - 01:53 pm     Quote:as always, when we talk databases, I would suggest moving it all over to Oracle on a Unix server. Then I can help you in great detail.
From you lips to my boss's ears..lol..if you knew how many times a week I told him that..it's a wonder I haven't been fired for pestering him.. The main function of this need is that the back-up database on server 2 HAS TO BE up and easily pointed to with exact database as server 1..SQL Server Replication can do this..my main concern is if I brought server 1 back up the easiest and least time consuming way to replicate server 1 from server 2. In other words..if server 1 goes down, he doesn't want anymore than 5 minutes down time to point to server 2 and when I get server 1 back up and running..no more than 5 minutes down time for the end user to get back to work. Have I mentioned how much I love my job? I bought some new hardware for my Linux box over the weekend..going to re-install Linux on the box and tweak it out a bit..then I'll be emailing you.. |
Grooch | Monday, December 23, 2002 - 01:56 pm     We are getting a new computer system at work. It is Movex by Intentia. I'm just wondering if anyone else has ever worked on it, and what they thought of it. It looks like a living nightmare to me. |
Zachsmom | Monday, December 23, 2002 - 01:59 pm     Hmmm..isn't that a mainframe? I don't know much about mainframes..except that it's my next goal after Unix/Linux to learn.. |
Grooch | Monday, December 23, 2002 - 02:00 pm     Ummmm..... what do you mean by mainframe? |
Weinermr | Monday, December 23, 2002 - 02:04 pm     <Weinermr is glad his job requires him to know the tax codes and probate/trust law, and not computerspeak.> |
Zachsmom | Monday, December 23, 2002 - 02:09 pm     LOL..Weinermr.. Grooch Mainframe= A large powerful computer that companies use..more often than not they have remote sites ..banks etc use them |
Zachsmom | Monday, December 23, 2002 - 02:12 pm     Here you go Grooch--in case I wasn't clear.. computer> A term originally referring to the cabinet containing the central processor unit or "main frame" of a room-filling Stone Age batch machine. After the emergence of smaller "minicomputer" designs in the early 1970s, the traditional big iron machines were described as "mainframe computers" and eventually just as mainframes. The term carries the connotation of a machine designed for batch rather than interactive use, though possibly with an interactive time-sharing operating system retrofitted onto it; it is especially used of machines built by IBM, Unisys and the other great dinosaurs surviving from computing's Stone Age. It has been common wisdom among hackers since the late 1980s that the mainframe architectural tradition is essentially dead (outside of the tiny market for number crunching supercomputers (see Cray)), having been swamped by the recent huge advances in integrated circuit technology and low-cost personal computing. As of 1993, corporate America is just beginning to figure this out - the wave of failures, takeovers, and mergers among traditional mainframe makers have certainly provided sufficient omens (see dinosaurs mating). Supporters claim that mainframes still house 90% of the data major businesses rely on for mission-critical applications, attributing this to their superior performance, reliability, scalability, and security compared to microprocessors. |
Juju2bigdog | Monday, December 23, 2002 - 02:20 pm     Hey, Bob, if Wink ever gets back around here, she might want to talk to you about her SQL's.
 |
Grooch | Monday, December 23, 2002 - 02:22 pm     ok. I think it is a mainframe. |
Twiggyish | Monday, December 23, 2002 - 02:35 pm     http://www.howstuffworks.com Click on computers on the menu at left. There is a lot of information there. =) |
Draheid | Monday, December 23, 2002 - 05:18 pm     Grooch: You can see some of their information at the www.intentia.com. It appears to me that they write custom applications using 'pure' Java for the various markets they serve. They work closely with IBM to provide the Movex system on what appears to be IBM hardware platforms. I would guess you'll see an IBM AS/400 system (I believe this is IBM's latest large-scale server system) which you can see at the IBM AS/400 Website. The Intentia website even has a demo of their 'workplace' product for you to view. Might be worth taking a look? Hope this helps. |
Crossfire | Saturday, December 28, 2002 - 12:56 am     Not sure if this is the right thread, but does anyone here have any experience with creating svcd's from divx files? |
Squaredsc | Saturday, December 28, 2002 - 07:28 am     i have a hopefully quick question, 2 actually. 1st-- my computer fan is broken, has been for months now and i know that im not supposed to use the computer with the fan broken cause it will overheat and i try not to stay on too long. anyway its a gateway and i was going to take it to their service desk but i am wondering if it will be very expensive. i consider over $50 expensive. 2nd and i think this is related to the fan thing, but my cd drive sometimes won't read any disks that i put in. some audio cd's and also i just got a digital camera and i went to load the software cd and it would read it, it kept saying no cd in the drive. i am wondering if this is connected to the fan thing or is the cd just broke and i need that fixed too and will this be expensive also?? thanks in advance.  |
Halfunit | Saturday, December 28, 2002 - 08:10 am     Square - how old is your computer? I had the fan on my video card go out and had it fixed under warranty at 1.5 years. Also, my CD drive went goofy and that was replaced for free after almost 3 years. I should note that I have a Dell, and I did the installation of the new parts myself, but I think Gateway stores would replace parts for free if covered under warranty. |
Squaredsc | Saturday, December 28, 2002 - 09:38 am     1/2 wouldn't you know the warranty ran out earlier this year, around spring time. and i didn't renew it. so of course things just fall apart. the computer is about 2 yrs old i think. i got it the spring before bb2, so maybe almost 2 yrs old. |
Car54 | Saturday, December 28, 2002 - 03:21 pm     Square, replacing the fan is simple. If you or dh are comfortable opening the case, it is pretty much plug and play. The same is pretty much true of the CD rom drive. I have done both things several times and it was a matter of looking carefully to see how the part was connected and mounted, put the new one in the same way...etc. With the CD drive, you may need to do some stuff to get it to recognize the new drive. Haven't bought a CD drive recently but an internal fan is cheap. Actually a lot of our servers are Gateway's business machines and I find them the easiest ones we have when I have to get inside the computer to fix something. |
Squaredsc | Saturday, December 28, 2002 - 07:23 pm     thanks car. we have opened the casing lots of times. so, where can i get a fan? i will try their website. or do a search. thanks again. |
Car54 | Saturday, December 28, 2002 - 07:28 pm     I bet you can order the parts from Gateway for pretty reasonable amount. I had to do a couple of fans and they were really cheap...like $10...I got them from a local place that repairs my printers and other things. If you have a local place, you could pop it out and take it in to show them. My guy didn't have the exact one, but he got one that was close enough and I was able to make it work. |
Northstar | Tuesday, December 31, 2002 - 01:43 am     I hope this is simple to do. I have a new photo of my husband as my background on the start up page, but half his face is covered with icons. I think that's what they're called, you know, the recycle bin, Explorer, Word, etc. Is it possible to move all the icons to the right rather than have them on the left? There's more space in the pic over on the right. I tried a drag n'click but they just popped back to the left. Or maybe I can just remove them and access them differently. If it's possible, please explain it slooooowwwlly, I'm way computer stupid. Thank you for your patience in advance. |
Crossfire | Tuesday, December 31, 2002 - 02:56 am     Sounds like a feature called 'Auto arrange' is enabled on your computer. What that does, is automatically place all icons on an invisible grid on the desktop starting in the upper left, working down and right as more icons are created. How to turn this off changes just a little bit depending on which version of windows you are using. To turn this off, click on a blank part of the desktop where there are no icons with your right mouse button and look for the menu option called 'arrange icons' hover the mouse over that option, and another menu will pop up, in that new menu, look for the menu item called 'auto arrange', and click on it with your left mouse button. That will turn off the feature and permit you to click 'n drag the icons around as you desire, and they wont pop back. Those were the instructions for windows 98. All the other versions of windows use the same basic method with only the 'auto arrange' option moving around a bit on the menus. It should be pretty easy to find, and you can always report back here if you need more help. |
Juju2bigdog | Tuesday, December 31, 2002 - 06:34 am     Last night we had a power outage, and my laptop stayed working on its battery. BUT in total blackness, the screen was blinding me, and I couldn't find a way to dim the viewing screen (probably because I was blinded, lol). Laptop is a bottom line Gateway Solo 1150 and op-sys is Windows ME. |
|