hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Cloud Hosting : Hosting SQL in cloud
Reply

Forum Jump

Hosting SQL in cloud

Reply Post New Thread In Cloud Hosting Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 04-28-2010, 12:21 PM
awu25 awu25 is offline
New Member
 
Join Date: Apr 2010
Posts: 2

Hosting SQL in cloud


We are thinking to host our SQL server in a cloud. IS there any performance/security issue with hosting our database in cloud?



Sponsored Links
  #2  
Old 04-28-2010, 01:40 PM
devonblzx devonblzx is offline
Web Hosting Master
 
Join Date: Nov 2005
Location: Michigan, USA
Posts: 3,660
What type of cloud?

  #3  
Old 04-28-2010, 01:41 PM
awu25 awu25 is offline
New Member
 
Join Date: Apr 2010
Posts: 2
I am new with this so I don't even know what types of clouds are out there.

Sponsored Links
  #4  
Old 05-01-2010, 09:24 AM
holmesa holmesa is offline
WHT Addict
 
Join Date: Nov 2007
Posts: 137
You can do this with Amazon EC2. You will get performance options and security will be on a very high level. Let me know if this helps.

  #5  
Old 05-01-2010, 09:26 AM
cagoon cagoon is offline
Aspiring Evangelist
 
Join Date: Mar 2010
Posts: 354
you will probably notice higher load times since sql isn't on the same network. the load times will generally increase with the size of your queries.

won't hurt to test it though.

  #6  
Old 05-25-2010, 10:20 AM
pnorilsk pnorilsk is offline
Web Hosting Evangelist
 
Join Date: May 2004
Posts: 466
SQL Azure !

Good idea, Microsoft agrees with you. Check it out - "SQL Azure"

__________________
Open Solution, Inc
http://opensolution-us.com

  #7  
Old 05-25-2010, 12:05 PM
psmith98752 psmith98752 is offline
Web Hosting Guru
 
Join Date: May 2009
Posts: 281
Well do you just mean you want High Availability for SQL server? You'd implement this with mirroring or clustering - the servers themselves can be on the cloud.

  #8  
Old 05-25-2010, 09:24 PM
plumsauce plumsauce is offline
******* Unleaded
 
Join Date: Feb 2004
Posts: 3,806
Hosting SQL in a cloud just gets you ACID rain.

__________________
edgedirector.com
managed dns global failover and load balance (gslb)
exactstate.com
uptime report for webhostingtalk.com

  #9  
Old 06-05-2010, 08:28 AM
albatroz albatroz is offline
Web Hosting Master
 
Join Date: Jun 2002
Location: Lima
Posts: 1,123
There is a free option you can try here
http://www.microsoft.com/windowsazure/offers/

  #10  
Old 06-05-2010, 08:51 AM
enotchnet enotchnet is offline
Web Hosting Master
 
Join Date: Feb 2004
Location: United States
Posts: 563
I don't think it would good to just move the SQL portion of your application and/or environment to the cloud. As resource itensive and network aware that SQL Server is these days especially with SQL 2008 R2. I think you'll starting getting weird errors that will be a nightmare to troubleshoot.

We tried this as a POC with a medium SharePoint farm for a customer and it was a disaster.

  #11  
Old 06-06-2010, 05:42 PM
arisythila arisythila is offline
Aspiring Evangelist
 
Join Date: May 2007
Posts: 449
I would stay away from Amazon's EC2. I would keep your SQL database close to your main server. But it's all depending on the application your running. We have a few customers that do this, but there application that runs in windows that hits the database server. So there are no real issues. But if your having this for a website there will be latency issues (slowdowns).

Thanks,

__________________
Michael Wallace - michael@birdhosting.com
Bird Hosting Inc. - An Applogic Cloud Hosting Certified Provider
24/7 Support, Call us @ 1-877-740-BIRD (2473)
www.birdhosting.com - Ashburn - Dallas - Seattle

  #12  
Old 06-07-2010, 08:47 PM
sam9 sam9 is offline
WHT Addict
 
Join Date: Mar 2010
Posts: 140
A cloud environment - EC2 / Rackspace or any other - will allow you to dedicate instances to your database/SQL. This can mean better performance.

Amazon, incidentally, also has RDS or Amazon Relational Database Service, which can help you optimize your db performance. It is for MySQL 5.1, currently.

Cheers!

__________________
SECPANEL | Security made simple for servers | No technical knowledge required
http://secpanel.com

30 day Trial | Sign up NOW | https://install.secpanel.com/billing2/signup.php

  #13  
Old 06-16-2010, 05:20 PM
Stratogen Stratogen is offline
WHT Addict
 
Join Date: Jun 2010
Posts: 120
SQL server is the worst app to host in the cloud because it needs high iops, so you need to choose your provider carefully. Many of the enterprise providers recommend a hybrid solution that keeps your SQL server separate from your other virtual machines.

  #14  
Old 06-16-2010, 09:06 PM
01globalnet 01globalnet is offline
Web Hosting Master
 
Join Date: Mar 2005
Location: Athens, Greece
Posts: 1,497
For a website, this is a bad idea. There will be latency issues and also billable transfer...

Just signup with a cloud provider. Many providers can also combine dedicated, shared and cloud servers, all of them connected via internal network. One provider that comes to my mind would be Cartika. There are more of course!

__________________
Antonis Adamakos @ FuzzFree :: Fully Managed Web Hosting, Development, Online Marketing

Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows VPS - Automated cloud backups of MS SQL Server DB novice32 Hosting Security and Technology 7 07-14-2010 07:02 PM
1ST MONTH FREE ON MOSSO CLOUD SITES & FILES - $100 REBATE - ENTERPRISE CLOUD HOSTING ckeck VPS Hosting Offers 2 11-28-2009 11:46 PM
[UK] - Cloud Above Shared + Cloud cPanel Hosting - 60% off recurring discount! Anthony-HD Shared Hosting Offers 0 10-10-2009 05:06 PM
[UK] - Cloud Above Hosting, the Cloud has Arrived! 20% recurring discount! Free SSL! Anthony-HD Shared Hosting Offers 2 10-03-2009 02:38 PM
1/2 OFF FIRST MONTH ($50 REBATE) - ENTERPRISE CLOUD HOSTING w/ MOSSO CLOUD SITES ckeck Shared Hosting Offers 0 02-24-2009 11:18 AM

Related posts from TheWhir.com
Title Type Date Posted
Codero Hosting Listing 2014-04-24 03:29:58
Cloud Vendors Form Program to Help Web Hosts Launch Cloud Services Web Hosting News 2012-10-24 16:35:13
VPS.net Expands Cloud in Asia by Adding Tokyo as Cloud Hosting Option Web Hosting News 2012-10-02 15:12:05
Web Host MTL Servers Launches Shared Cloud Hosting, Cloud Servers Web Hosting News 2012-07-12 14:39:19
Cloud Slam 2012 Web Hosting Events 2012-05-07 15:26:31


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?