Is it possible to licence, install and run Windows dbsrv17.exe on Amazon AWS / EC2 / Lambda to provide full client server database (-x TCPIP) and web (-xs HTTP) access over the internet?

asked 10 Jul, 15:54

Breck%20Carter's gravatar image

Breck Carter
26.2k430599862
accept rate: 20%

edited 12 Jul, 11:21

Comment Text Removed

> 2. I think opening the DB (-x TCPIP) over the Internet is dangerous...

Yes, but... no more or less than HTTP, methinks, given the vast array of possible attacks (SQL injection, XSS, and so on)... not a lot of news items mentioning direct attacks against proprietary DBMS protocols.

Nevertheless, care must be taken, perhaps involving this Help topic: How to establish a client connection by using transport layer security.

(12 Jul, 15:38) Breck Carter

> 1b. 10 concurrent DB users will allow you to server > 100-1000 active web users.

For the sake of simplicity, assume a vanishingly small number of TCPIP client server connections for administration and development, and a larger number of HTTP connections for end user traffic. Also assume dbsrv17.exe is the only significant server-side executable; no separate application servers, no separate web servers, no load balancers, no relay servers, no unicorn farms...

...and let's leave connection pooling out of the discussion for the moment, lest my head explode :)

(12 Jul, 15:52) Breck Carter

If this was Walldorf, your comment might sound like a leak from inside SAP :)

(12 Jul, 16:08) Breck Carter
Comment Text Removed

Just to add: With v17.0.4 and above, you can use client certificates with TLS, making it probably more difficult for undesired client connections because they need to identify themselves, too...

(13 Jul, 01:32) Volker Barth

> A typical application has tens or even hundreds DB executions per single step.

A typical application?

That would be Number 37 in How To Make SQL Anywhere Slow: Send lots of small requests across a high latency network...

...possibly the result of Number 21 Do joins in the application.

...or Number 22 Move WHERE clause logic into the application.

By this logic, because drunk drivers crash and die, nobody should drive cars :)

(13 Jul, 09:32) Breck Carter

No offense is intended by this question or the resulting discussion, but here's a suggestion just in case :)...

(15 Jul, 09:47) Breck Carter
Replies hidden
1

In case anyone's wondering what happened here, apparently you can delete other people's replies by first converting your own comment to a reply, which you can then delete... that shows real ...discipline?

Well, it shows something :)... read this in reverse order:

Delete Vlad comment on Is it possible to licence and run SQL Anywhere on Amazon AWS? 1 hour ago

Vlad was awarded the Disciplined badge 1 hour ago

Delete Vlad comment on Is it possible to licence and run SQL Anywhere on Amazon AWS? 1 hour ago

Delete Vlad answer on Is it possible to licence and run SQL Anywhere on Amazon AWS? 1 hour ago

Delete Vlad answer on Is it possible to licence and run SQL Anywhere on Amazon AWS? 1 hour ago

Vlad converted comment on your question Is it possible to licence and run SQL Anywhere on Amazon AWS? into an answer 1 hour ago

Vlad converted comment on your question Is it possible to licence and run SQL Anywhere on Amazon AWS? into an answer 1 hour ago

(15 Jul, 10:16) Breck Carter
1

...not sure if the technique to "delete other people's replies" works perfectly, possibly due to bugs in the forum software, but hey, let's pile on anyway :)...

(15 Jul, 10:34) Breck Carter
showing 2 of 8 show all flat view

Perhaps Grace Hopper had the answer: "If it's a good idea, go ahead and do it. It is much easier to apologize than it is to get permission."

After all, that's where this forum came from... not SAP, not Sybase, but DIY :)

permanent link

answered 13 Jul, 09:08

Breck%20Carter's gravatar image

Breck Carter
26.2k430599862
accept rate: 20%

edited 13 Jul, 09:19

Yes, currently it feels like us customers, we're doing (fine?) all on our own...

(13 Jul, 09:55) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×6
×3

question asked: 10 Jul, 15:54

question was seen: 175 times

last updated: 15 Jul, 10:34