Fluid Hosting Forums  
HomeWeb HostingSupportContact UsAbout UsForums |

Go Back   Fluid Hosting Forums > General Forums > Pre-Sales Stage

Reply
 
Thread Tools Display Modes
Old 08-10-2004, 04:01 AM   #1
cord
Registered User
 
Join Date: May 2004
Posts: 418
VPS as dedicated mysql and other questions

Hello,
A while ago I asked a question about forum hosting here on shared accounts. It was mentiond in passing (by one of you FH guys) that you had somenoe using mysql as a dedicated mysql server for it.

I am not thinking about hosting a forum, but another project. I was wondering if you had any insight into how mysql performs on a vps. For example, does it perform comparably to the shared mysql server?

Also, I had a question about administration and such. For example, if I just want a vps with mysql (4.1 or 5.x) on there, with nothing else, how would the vps be handed to me? i.e. is firewall/basic security taken care of?

Thanks in advance.
cord is offline   Reply With Quote
Old 08-10-2004, 04:07 AM   #2
FH-John
Fluid Hosting Tech
 
FH-John's Avatar
 
Join Date: Feb 2003
Location: Washington
Posts: 4,177
Using a VPS to host a dedicated MySQL server will yield higher performance, in comparison to our shared hosting one. However, depending on the query, will depend on which one be faster.

The main reason for using the VPS is connection limits. We impose a reasonable limit on the number of connections to our shared server. However, with the VPS you could have a much higher limit.

Generally speaking the VPS would be provided with other basic software: Apache, Sendmail, etc. No firewalling, or security updates are performed unless requested. We can of course remove Apache, etc.
__________________
John T. Yocum
"An empty stomach is not a good political adviser." -- Albert Einstein
"There never was a good war or a bad peace." -- Benjamin Franklin
FH-John is offline   Reply With Quote
Old 08-10-2004, 04:50 AM   #3
cord
Registered User
 
Join Date: May 2004
Posts: 418
wow. quick response times

The thing is this: I have used linux before on a desktop. I have even setup basic firewalls with some guit tools (such as kmyfirewall etc...) I have never manually tampered with iptables rules.

Would I be able to recieve help (initially till I learn) or would I have to pay additionally for admin service?

Same goes for security updates etc...

thanks again.
cord is offline   Reply With Quote
Old 08-10-2004, 12:49 PM   #4
FH-John
Fluid Hosting Tech
 
FH-John's Avatar
 
Join Date: Feb 2003
Location: Washington
Posts: 4,177
You'll receive assistance in setting things up. For most basic/general tasks, if they don't require much time, approx 15mins, it's no charge. However, complicated tasks may incurr an additional fee.
__________________
John T. Yocum
"An empty stomach is not a good political adviser." -- Albert Einstein
"There never was a good war or a bad peace." -- Benjamin Franklin
FH-John is offline   Reply With Quote
Old 08-10-2004, 01:34 PM   #5
Skibum
Skibumus Lazium Extremum
 
Skibum's Avatar
 
Join Date: Apr 2003
Location: Canton, Ct. USA
Posts: 599
Say John

Any idea what it would cost to have you set up a VPS so that it is "ready to go" in a similar fashon to your shared hosting solution? Sort of a turnkey generic setup....
Skibum is offline   Reply With Quote
Old 08-10-2004, 01:53 PM   #6
FH-John
Fluid Hosting Tech
 
FH-John's Avatar
 
Join Date: Feb 2003
Location: Washington
Posts: 4,177
Actually, they are pretty much turnkey from the start. When signing up, the system asks if you want MySQL, etc. Then it installs the selections, and enables them within the control panel.

HSP Complete(VPS control panel) allows you to add/remove websites, databases, e-mail accounts, etc.
__________________
John T. Yocum
"An empty stomach is not a good political adviser." -- Albert Einstein
"There never was a good war or a bad peace." -- Benjamin Franklin
FH-John is offline   Reply With Quote
Old 08-10-2004, 02:00 PM   #7
Skibum
Skibumus Lazium Extremum
 
Skibum's Avatar
 
Join Date: Apr 2003
Location: Canton, Ct. USA
Posts: 599
Is this different from a year or so ago? When I first signed up, I selected the VPS, but hadn't a clue what to do...
Skibum is offline   Reply With Quote
Old 08-10-2004, 03:37 PM   #8
FH-John
Fluid Hosting Tech
 
FH-John's Avatar
 
Join Date: Feb 2003
Location: Washington
Posts: 4,177
Yes, we have upgraded our VPS system. The new HSP release is much more user friendly, and much more functional.
__________________
John T. Yocum
"An empty stomach is not a good political adviser." -- Albert Einstein
"There never was a good war or a bad peace." -- Benjamin Franklin
FH-John is offline   Reply With Quote
Old 08-10-2004, 05:31 PM   #9
Richard
Joy™
 
Join Date: Jun 2003
Location: Toronto
Posts: 1,053
Quote:
Originally Posted by cord
Hello,
A while ago I asked a question about forum hosting here on shared accounts. It was mentiond in passing (by one of you FH guys) that you had somenoe using mysql as a dedicated mysql server for it.

I am not thinking about hosting a forum, but another project. I was wondering if you had any insight into how mysql performs on a vps. For example, does it perform comparably to the shared mysql server?

Also, I had a question about administration and such. For example, if I just want a vps with mysql (4.1 or 5.x) on there, with nothing else, how would the vps be handed to me? i.e. is firewall/basic security taken care of?

Thanks in advance.
Cord, if you don't mind sharing, let me know how this works out for you. Are you planning on connecting to the VPS/MySQL from one of the windows shared hosting servers?
__________________

Richard is offline   Reply With Quote
Old 08-10-2004, 05:53 PM   #10
cord
Registered User
 
Join Date: May 2004
Posts: 418
yes. I am currently developing using asp.net/c# with the bytefx driver locally and it works quite well. There will be a new bytefx driver release in a few days and it is acquired by mysqlAB as the official Connector/NET

The new version will have unicode support and support for other 4.1/5.0 features. Once that is out, I will do a bit more testing a development. I will have a testing version up in a week or so I think (depending on release of the driver).

I will keep you updated how it goes.

on a side note, I will have a bit of fun trying to install mysql on a vps when the time comes. I will probably attempt to use the intel c++ compiler if I cannot find a suitable binary.

Firelogic, are you currently on vps?

Last edited by cord; 08-10-2004 at 07:58 PM.
cord is offline   Reply With Quote
Old 08-13-2004, 01:16 AM   #11
cord
Registered User
 
Join Date: May 2004
Posts: 418
Just wanted to make an update. So far, I am about 90 percent done with the project (minus any exception handling). I should be able to do some testing by the end of the coming week.

Meanwhile, since I am a poor student, I was wondering if fluidhosting does custom packages by any chance? Cant hurt to ask Its not fun being broke and having a hobby :*(
cord is offline   Reply With Quote
Old 08-13-2004, 01:23 AM   #12
FH-John
Fluid Hosting Tech
 
FH-John's Avatar
 
Join Date: Feb 2003
Location: Washington
Posts: 4,177
Generally speaking we don't offer custom packages. When we do, it's usually because someone needs more than we offer in a plan.
__________________
John T. Yocum
"An empty stomach is not a good political adviser." -- Albert Einstein
"There never was a good war or a bad peace." -- Benjamin Franklin
FH-John is offline   Reply With Quote
Old 08-13-2004, 01:31 AM   #13
cord
Registered User
 
Join Date: May 2004
Posts: 418
I see. Well when the time comes, I will start off with the smaller package. Depending on how many users I get, I may need to change plans. Its the processor and memory that are precious to me. I will not have much disk usage or out of network traffic at all.

btw, thanks for the quick reply. always appreciated.

Last edited by cord; 08-13-2004 at 01:42 AM.
cord is offline   Reply With Quote
Old 08-13-2004, 01:45 AM   #14
FH-John
Fluid Hosting Tech
 
FH-John's Avatar
 
Join Date: Feb 2003
Location: Washington
Posts: 4,177
BTW: Our VPS is full burst, so at times if you need more RAM or CPU you can burst quite high.

The CPU/RAM listed for the account package are the guaranteed minimum you'll receive.
__________________
John T. Yocum
"An empty stomach is not a good political adviser." -- Albert Einstein
"There never was a good war or a bad peace." -- Benjamin Franklin
FH-John is offline   Reply With Quote
Old 08-13-2004, 02:00 AM   #15
cord
Registered User
 
Join Date: May 2004
Posts: 418
Yeah, I know they are burstable. But, I am not compeltely familiar with mysql and how the performance is affected if the database is stored completely in memory vs. on disk. I will probably do some basic benchmarks to see what penalty I will take when I hit the disk.

Unfortunately, I didnt see any page that gives the price for extra resources. Some providers, for example, will list extra 64 megs of memory for 10 dollars (or whatever) so you can get that as an option to your account. Gives more customizability.

How long does it take before you get tired anwering my questions
cord is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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


All times are GMT -5. The time now is 01:34 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright© Fluid Hosting WebHosting Services