do I need access to db server machine login ? [message #552986] |
Mon, 30 April 2012 12:33 |
miroconnect@yahoo.com
Messages: 202 Registered: April 2006
|
Senior Member |
|
|
I have a question with database adminstration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon dont provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql clinet but we cannot do ssh to server , please advice me in general can this limitation effct adminstration ?
|
|
|
|
|
|
|
|
Re: do I need access to db server machine login ? [message #553003 is a reply to message #552995] |
Mon, 30 April 2012 15:09 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
cookiemonster wrote on Mon, 30 April 2012 15:03The obvious question is what do amazon do for you.
Do they provide any form of DBA service or do you have to do everything yourself.
I do not know anything about amazon cloud database, and my statements might be ignorant, but what if there is a disk crash and the database needs to be restored? Who is responsible for fixing the disks, putting a backup in place so that you can apply logs? What if you wanted RAC? What if you needed to look at log files? What if you needed to do physical things on the server?
It all comes down to (ignoring that it is amazon cloud), how would you be able to administer a database if the database server was not at you location and you were not allowed access to it?
|
|
|
|
|
Re: do I need access to db server machine login ? [message #553079 is a reply to message #552986] |
Tue, 01 May 2012 11:56 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
@microconnect, I don't understand the problem: you can have ssh connections to an Amazon EC2 machine. You need to authenticate by passing a key, not a password. I do it with putty no problem.
@the_rest_of_you, Amazon cloud servers are pretty damn good. Cheap and reliable. One of our company websites has been running on them for a year now, one machine for the database another for the web access. You do all the admin yourself, we just use rman for backups. It's good technology, based on Xen. The way IP addresses work does take a bit of getting used to, though.
I'm actually not sure that there is really much point in buying your own mid-range hardware any more.
|
|
|