AWS EC2 Question

[rvyne7]

Hi,

Anyone tried installing SQL Express inside EC2 (RDS)? I wanted to signed-up for a AWS account for personal usage but licensing for separate SQL is as expensive as EC2 itself. I'm planning to use it for personal usage - portfolio/demo apps (mobile and web).

I've compare it with Azure (Azure seems cheaper if includes features like VM and MSSQL) but I'm not familiar with environment.

 

[u0206397]

I suppose cloud pricing model is pretty transparent and thus consistent, unless you know Jeff Bezos and he's able to give you a discounted price. In AWS, on top of paying Amazon, you also have to pay Microsoft for the software.

Perhaps Micrsoft is able to give you a better deal if your technology stack is largely on Microsoft and Windows. You know, front end and back end on .NET, and SQL Server database. You might even be able to deploy directly to Azure from Visual Studio IDE!

 

[rvyne7]

Ya I'm actually been increasingly tempted getting Azure just lazy and used of AWS environment so I'm avoiding it. Beside AWS has free tier for 1 year too hehe (looking for long term not just a year)

 

[davidktw]

Hi,

Anyone tried installing SQL Express inside EC2 (RDS)? I wanted to signed-up for a AWS account for personal usage but licensing for separate SQL is as expensive as EC2 itself. I'm planning to use it for personal usage - portfolio/demo apps (mobile and web).

I've compare it with Azure (Azure seems cheaper if includes features like VM and MSSQL) but I'm not familiar with environment.

EC2 is not RDS.
SQLExpress in RDS db.t2.micro will cost you USD0.026/hr. You can always stop it so that you don't pay for it when you are not using it. There is no separate licensing for it, it is included in the price.

 

[u0206397]

EC2 is not RDS.
SQLExpress in RDS db.t2.micro will cost you USD0.026/hr. You can always stop it so that you don't pay for it when you are not using it. There is no separate licensing for it, it is included in the price.

davidktw is right.

There are 2 ways you can look at this. You can either do it the un-managed way from scratch: get a empty EC2 instance running Windows Server and install SQL Server in it yourself (provided you have a valid SQL Server product key anyway).

OR do it the managed way where AWS gives you a ready-to-go pre-configured running database instance.

The restrictions you will get is you cannot have shell access (no remote desktop or ssh to instance). It is after all a provisioned database that you need, and you shouldn't need to touch the operating system command shell anyway.

In order to deliver a managed service experience, Amazon RDS does not provide shell access to DB instances, and it restricts access to certain system procedures and tables that require advanced privileges.

But you can still connect to the database instance directly like SQL Server native client and maybe SQL Server Management Studio (SSMS) to browse the database structure and tables I believe.

TLDR: If you just need a database to store your data, just get the RDS and you need not bother with the rest. It's like going CPanel and getting a MySQL database.

 

[rvyne7]

My problem is EC2 alone base on configuration (I want) will cost me around 20 USD per month including Elastic IP.

RDS will cost me almost exactly same Price as EC2 but will be under utilized

So I thought I could just download a SQLExpress and install it on EC2 but anyways if its not possible might look for alternative way of doing it. Cant afford paying 40 USD+ monthly just for portfolio and personal projects.

I realized too that IOS Apps will now require SSL that adds my monthly cost + additional thingy like domains and etc.

 

[chenaz]

Why take up ec2 for such simple task? U can take up any web hosting companies with mssql supported which only cost u 100$ per year.

 

[rvyne7]

Why take up ec2 for such simple task? U can take up any web hosting companies with mssql supported which only cost u 100$ per year.

I like to manage on my owned stuff, you can host multiple website + scability too and some shared hosting also has issue with security and limitation with configuration that might not be allowed. If you're working with .Net Full stack shared hosting offer inconvenience.

 

[davidktw]

I like to manage on my owned stuff, you can host multiple website + scability too and some shared hosting also has issue with security and limitation with configuration that might not be allowed. If you're working with .Net Full stack shared hosting offer inconvenience.

https://calculator.s3.amazonaws.com...key=calc-357E5E76-9D76-4F19-8B1C-E27181BE1EF9

Even if you are using .NET, you can still work with MySQL. AWS have Aurora DB, which is MySQL compatible, which offers better performance

https://calculator.s3.amazonaws.com...key=calc-739A9C41-23F6-4E8D-BF8C-B6EFCFCAC93C

 

[chenaz]

Normal web hosting u can manage ur own database also. Ur personal portfolio and demos require a lot of security? Or u are from secret agency that cannot disclose your data? Then don't bother to host and have risk of leaking your data.

And simple stuff need what configuration? I don't understand this part.

I like to manage on my owned stuff, you can host multiple website + scability too and some shared hosting also has issue with security and limitation with configuration that might not be allowed. If you're working with .Net Full stack shared hosting offer inconvenience.

 

[Zehjie374]

Nor sure if you can do it the free approach way where you download WAMP/LAMP on your ec2 depending on Windows or Linux then you make a php script that echo out whatever data you want. Then you open your wamp/LAMP to public connection. Unless you're dealing with sensitive data or else this method will work

 

[Asphodeli]

Hi,

Anyone tried installing SQL Express inside EC2 (RDS)? I wanted to signed-up for a AWS account for personal usage but licensing for separate SQL is as expensive as EC2 itself. I'm planning to use it for personal usage - portfolio/demo apps (mobile and web).

I've compare it with Azure (Azure seems cheaper if includes features like VM and MSSQL) but I'm not familiar with environment.

if you want cheap and good, you need to put in more time...maybe you could port your MSSQL code to use another DB system like MariaDB, MySQL, etc. so that you can run your entire stack off free & open source software.

unless of course, your entire portfolio/demo is in .NET, then I'm afraid you're SOL.

 

[rvyne7]

if you want cheap and good, you need to put in more time...maybe you could port your MSSQL code to use another DB system like MariaDB, MySQL, etc. so that you can run your entire stack off free & open source software.

unless of course, your entire portfolio/demo is in .NET, then I'm afraid you're SOL.

bah you can't really maximized potential of asp.net web application if you're not going full-time and bit fixated with entity framework easier to connect to mssql from asp.net mvc application.

Anyways sort it out, I've get rid of RDS, Elastic IP Address go with just EC2 then installed MSSQL Express but to save space I have to uninstall SSMS but IP Restrict remote SSMS... apparently some open source sponsored by mozilla and etc offering free SSL (Let's Encrypt) so i got free SSL, to save more buck I've also use public ip for A records of my domain.. finally got promo coupon code for godaddy domain save like 60% and paid only 13 SGD for 2 years ..

Anyways my monthly is just as low as 14 USD (free 1 year hosting at AWS), 6gb space (left over from 30gb space after moving my web apps and mssql db) if I decided to install PHP/MYSQL later and other demo/project site. and remote desktop too

Note: If I needed additional diskspace I could easily get 1 USD per 10gb at AWS too hehe.

 

[Asphodeli]

bah you can't really maximized potential of asp.net web application if you're not going full-time and bit fixated with entity framework easier to connect to mssql from asp.net mvc application.

Anyways sort it out, I've get rid of RDS, Elastic IP Address go with just EC2 then installed MSSQL Express but to save space I have to uninstall SSMS but IP Restrict remote SSMS... apparently some open source sponsored by mozilla and etc offering free SSL (Let's Encrypt) so i got free SSL, to save more buck I've also use public ip for A records of my domain.. finally got promo coupon code for godaddy domain save like 60% and paid only 13 SGD for 2 years



Anyways my monthly is just as low as 14 USD (free 1 year hosting at AWS), 6gb space and remote desktop to add to that left if I decided to install PHP/MYSQL later and other demo/project site

expensive...I'm paying $8 SGD a month for all my hosting needs, excluding domain fees

Posted with E6533 via PCWX

 

[rvyne7]

expensive...I'm paying $8 SGD a month for all my hosting needs, excluding domain fees

Posted with E6533 via PCWX

those shared host for sure?

 

[Asphodeli]

those shared host for sure?

Yah shared hosting is all I need. I do have a project on Google App Engine, but it's at no charge.

Posted with E6533 via PCWX

 

[u0206397]

Yah shared hosting is all I need. I do have a project on Google App Engine, but it's at no charge.

Posted with E6533 via PCWX

Shared hosting would probably limit the server side language to PHP. Python and Java would be rare though.

Would AWS Lambda (Node.js/Python/Java/C#) or Google Cloud Functions (Node.js) offer better value than $10 shared hosting (PHP) or $10 VPS like DigitalOcean/Linode?

Too many choices to choose from.

 

[rvyne7]

Shared hosting would probably limit the server side language to PHP. Python and Java would be rare though.

Would AWS Lambda (Node.js/Python/Java/C#) or Google Cloud Functions (Node.js) offer better value than $10 shared hosting (PHP) or $10 VPS like DigitalOcean/Linode?

Too many choices to choose from.

I found some shared hosting with windows that offer to host php and mysql too.. but always problem is MSSQL either 100mb or no free at all. Then you also struck with different issue like having no control with settings and all.

 

[u0206397]

I found some shared hosting with windows that offer to host php and mysql too.. but always problem is MSSQL either 100mb or no free at all. Then you also struck with different issue like having no control with settings and all.

My personal opinion is that 100% free option is only good for 1 man development. These free things can get throttled, deleted, or taken offline anytime by the host. There is no obligation by them to keep anything running. Any files uploaded or data saved may also get deleted. Even without any resource abuse, the developer/user/hosting account may get closed for no reason.

If there is a real web application or mobile app that is published for use by real users (beyond the developer himself), it is best to at least spend a few dollars to buy a little commitment from the host like a $5/month shared host is still better than a free one with zero commitment.

 

[kuma-mon]

Yah shared hosting is all I need. I do have a project on Google App Engine, but it's at no charge.

Posted with E6533 via PCWX

Now google cloud is giving new users $300 credit and 12 months of free trial. its very worth. i think can use for 2 years or so, but depends on what type of ec2 u choose and the hardware support. im using one of their basic ec2 instances for my pcwx server and i left $290.