I enjoy a Bizspark account from Microsoft and they're supplying a fundamental Azure account. I've been told that it may run PHP, however I must make use of a more examined solution like WAMP. In addition, I wish to place a quite heavy WordPress / BuddyPress installation (which i hope brings lots of trafic :)

Has anybody done something such as this? If that's the case, what's your experience / issues etc.?

Thanks Stelios

Yes, this can be done. In the finish during the day you're simply using Home windows Server, so something that installs there'll install within the cloud too. I've carried this out myself for hosting WordPress in Home windows Azure.

However, you will find some issues here. Mostly the issues remain the M (MySQL). To create MySQL in Home windows Azure isn't very difficult, but there are several factors regarding how to make certain it is usually available. You are able to:

  1. Setup just one demonstration of MySQL in a job and keep db on local disk (this can be a bad idea).
  2. Setup just one demonstration of MySQL in a job and keep db on the drive (blob backed storage)
  3. Setup 2 cases of MySQL to every indicate a shared drive (hot-failover). Just one drives will have the ability to mount. Now, you've reliability and failover, but just one instance at any given time on your side.
  4. Setup 1 author of MySQL on the drive, and multiple visitors on the snapshot of the drive. Place in some logic via connection strings to make certain only creates goto just a single one and reads towards the others. Snapshot every X mins to update visitors.
  5. Setup multiple cases of MySQL and employ native replication features (each storing to local disk) and depend on when you lose an instance.

You will find most likely more permutations, however the gist of the issue is the way you scale out MySQL to be shown and reliable. In Home windows Azure, you do not get to depend on the truth that the neighborhood disk will be around or that you'll always have a similar instance. Actually, you are able to guarantee that the instances is going to be lower for many time period every month and finally, given sufficient time, you'll lose the neighborhood disk.

Overall, with multiple instances however, you are able to guarantee they will not be lower concurrently (towards the service SLA level a minimum of). So, you have to make certain MySQL works together with multiple instances (or accept single instance down time) which your computer data is backed by blob storage to ensure it's endured.

Or scrap everything garbage and merely use SQL Azure, which solves all individuals problems. So, it become WASP. SQL Azure may also be cheaper too for more compact DBs.

Or scrap everything garbage and merely use SQL Azure, which solves all individuals problems. So, it become WASP. SQL Azure may also be cheaper too for more compact DBs.

Ditto.

Setting up MySQL with an Azure role is not recommended for lots of reasons, most particularly (insufficient) scalability and reliability. (That's only for implementing on Azure, MYSQL is great)

To put it together remotely dependably you are have to a devoted instance that will cost you a minimum of $40 per month, choosing SQL Azure is $10/Gb, reely when you get an opening offer or Bizspark.

If you are just searching to adjust just one instance application, I'd suggest you rather use SQLite as well as other in memory db, it will be much less painful.