Installing SQL Virtual Machine

[OwlHoot]

mySQL ? I've heard that this buggy , feature-less , miserable sql-wannabe is indeed capable of pushing you off the edge.

I've heard PostgreSQL is more sound than MySQL "under the hood", as it uses some abstract object layer, whereas with MySQL they simply pile in more and more functionality and then jump up and down on the lid to shut it prior to each new release!

I also know, from personal experience, that MySQL is more likely to throw a wobbler and become corrupted under high loads (or was three years ago) [see first paragraph]

[AtW]

I've heard PostgreSQL is more sound than MySQL "under the hood"

PostgreSQL is a crock - I used it for 2 years until finally I got tired of bulltulip gradual slowdowns for no good reason (vacuum DB my - was taking forever), thrown it out and moved to MS SQL - works like a dream, never need to freaking vacuum it

[juststarting]

My November bill was about £58 quid for one machine instance running for the whole month, a couple of gig of data stored on S3, a gig or so of data in and out of EC2, a fixed IP address, and a fifty gig block storage device (aka drive).

Currency rate fluctuations apply when converting from USD to GBP - I think my bill has gone up about ten quid over the last few months

Of course one of the major advantages of EC2 is being able to scale both up and down on demand - if you get Slashdotted, for example, you'll have about 20,000 visitors in the first hour, gradually tailing off with a total of around 120,000 visitors over the first twenty-four hours - at least, that was what we saw when I Slashdotted a friend's site the other year

An application doing a fair bit of work per request, as opposed to a static HTML page, would have trouble coping on just one server under that kind of load, but on EC2 you could just spin up a few more instances and load-balance across them, spinning them down as traffic tailed off - thus you only pay for what you need, even if you happen to need a hundred servers for just one hour.

Amazing indeed. I take it I can have my own Windows network? With the ability to set up Domain Controllers, etc. I am gonna be loading Sharepoint and that needs Windows infrastructure with several servers that talk to each other on windows intranet tcp ports.

[NickFitz]

Amazing indeed. I take it I can have my own Windows network? With the ability to set up Domain Controllers, etc. I am gonna be loading Sharepoint and that needs Windows infrastructure with several servers that talk to each other on windows intranet tcp ports.

I haven't used the Windows AMIs, but the tenth response in this thread on the EC2 forums suggests that you can build a network with a bit of messing around

One of the available Windows Amazon Public Images probably offers a good starting point.

[minestrone]

I've heard PostgreSQL is more sound than MySQL "under the hood", as it uses some abstract object layer, whereas with MySQL they simply pile in more and more functionality and then jump up and down on the lid to shut it prior to each new release!

I also know, from personal experience, that MySQL is more likely to throw a wobbler and become corrupted under high loads (or was three years ago) [see first paragraph]

I think it has improved vastly in the last couple of years. It did not even do nested queries until about 3 years ago. SUN buying it has been a big step up for them.

I was always told PostgreSQL was a quality product but I thought it was a bag of tulip when I used it.

[minestrone]

I am looking at using the EC2 for plan B, in fact I was just going to attempt to get my first AMI running in the next couple of days, I have installed g-eclipse, got my logon and picked my AMI. See how it goes.

We expect the usage will go from zero to about a million hits a day ( hopefully ) then we will move to a physical server but the ability to move up the hosting plans during the volume rise will be massive for us.

[AtW]

We expect the usage will go from zero to about a million hits a day

Only if your app shows up civilian targets in Israel within effective Kassam radius

[minestrone]

Only if your app shows up civilian targets in Israel within effective Kassam radius

Israel will have it's own partition of the application so one million a day is actually a conservative estimate.

Bring on the google ad revenue.

[TheVoice]

This sounds much like my week so far...a Microsoft (mainly!) nightmare. You'd think virtualising a small environment for a client would be a piece of cake - wrong!

Friday:
Spent installing Exchange 2007...even after the stated pre-req's were installed, the perpetual nagging from the "pre-setup tests" that "you need this update too" got me down & eventually left it installing & finished the job on the drive home via 3G & RDP!

Monday:
ISA Server! This installed fine until we put the clients webfilter on! It said it takes 60 meg of disk space, fine, got 5 gig free. Install it, server slows to a crawl & turns out the software is now downloading 4 gig of what it claims to be a filtering database. Cue lots of frantic service console action as I try to extend the disk....Another fine mess!

Today:
Coffee!

[KentPhilip]

You would think it be a quick one wouldn't you ? Well there I am , with all the experience and all , trying to install a VM with SQL 2005 .. taking 4 days now..

0. Installed a Widows 03 VM.

1. Tried installing SQL from my archive sources... all installs besides workstations components which throws an error.
...
Now that is why I hate IT and the way Microsoft uses the world for debugging purposes. GO GOOGLE !

1. Is the windows virtual machine on the network? Then just connect to it from client components on an external machine.

2. Try installing client tools before installing SQL Server

3. Try a copy of the binn folder - might work

4. Have you got another virtual machine with SQL already installed on it? If so copy an image across to the new server (dirty but might do it).

5. Get on your knees and apologise to the server for mentioning google. And accept that it is your role in life is to test for Microsoft. Thought crime is a crime you know, and can be detected by SQL Server 2005.