View Full Version : Flat file or Mysql ? (newbie)
mariorho 01-12-2005, 04:02 PM Hello guys,
I am planning to offer a small very cheap webhosting pagkage with limbo-cms installed and ready to run.
I think to rent the following dedicated.
Dual Xeon 2.8
2GB ram
2 x 73gb SCSI
Redhat 3.0 plesk 7.5 reloaded
How many accounts that server can handle?? I know it depends on visits but i am curious about the difference of text files or Mysql based.
Which one will give better performance to server so i can setup more accounts on server? text file or Mysql based cms??
limbo-cms com
ScottBannon 01-12-2005, 04:27 PM The number of accounts that server can handle will depend on factors such as how much activity each account gets.
As for the mySQL vs. flat-file question, I'm not overly familiar with Limbo but in general SQL is always going to provde an all around better performance with less pull on system resources.
HTH,
Scott
mariorho 01-12-2005, 04:54 PM Originally posted by ScottBannon
The number of accounts that server can handle will depend on factors such as how much activity each account gets.
As for the mySQL vs. flat-file question, I'm not overly familiar with Limbo but in general SQL is always going to provde an all around better performance with less pull on system resources.
HTH,
Scott
So it's better to use mySQL based cms than text files?
So if we have 1000 domains all of them using mysql based cms vs 1000 domains all of them using text files , both with same activity which configuration is better for server perfomance?
Actually i wanna figure out how many clients can have on server and how much money can earn.
dmike 01-12-2005, 04:56 PM It largely depends on the size of the databases.
mariorho 01-12-2005, 05:12 PM Ok i am planning to get this :
HE Server MAX² from hosteurope.de
It costs 389euro /monthly
So i think to host 1000 domains with 2euro/month which makes 2000euro profit/monthly. So i can earn 2000euro - 389euro = 1611 euro/monhly.
Do i think right???
All this sites will have 50 visits max. daily (each one) and all of them will be the same cms script.
I ask that because i have seen companies with 99cents hosting.So how do they earn money? Perhaps they run more than 1000 domains on server and earn $1000 momthly and server costs $200-$300 .
Is it like that?
..yeah..u gonna ask me .. "where u will find the 1000 client???"
..well that is another part of the story.. !!!
ScottBannon 01-12-2005, 05:44 PM All this sites will have 50 visits max. daily
How can you be sure of that? Maybe one of the sites will become very popular and get 50,000 hits daily? Will you still only charge them 2euro/month and be able to provide quality service to your other 999 clients on the server?
I'm not arguing with your plan here, only pointing out what seems like a flaw in it from what you've described.
As for the mySQL vs. text databasing, all I'll add to what I said earlier is that text parsing is resource heavy labor and without knowing more about Limbo I still believe you'll get better performance with mySQL over flat-file.
Good luck,
Scott
Vortex-Steve 01-12-2005, 05:55 PM 1000 clients on 1 server? You better pray nothing ever goes wrong or you will have a lot of angry people shouting at you!
mariorho 01-12-2005, 06:23 PM Originally posted by Vortex-Steve
1000 clients on 1 server? You better pray nothing ever goes wrong or you will have a lot of angry people shouting at you!
Ok, your company says :
These plans are for those of you looking to make an income in the web hosting business or for those of you with multiple sites. Affordability and flexibility matched with powerful features make these plans an excellent choice.
By giving you a large amount of space and data transfer you can create your own packages and charge your own prices. You can have as many accounts as your resources allow - we don't set any hard limits - so that's either lots of small accounts, or a few large accounts.
R1
Monthly Fee: £22
Disk Storage: 3GB
Monthly Data Transfer: 30GB
Number of Sites: Unlimited
-----------------------------------
So if u sell 10 R1 plans and u will get £220 monthly
and if each of your reseller have 50 will be 500domains if 100 then 1000domains.
even if 500 or 1000 what kind of server u need? how u handle it when make £220 monthly ???
If i had bought R1 plan then i could sell 60 plans of 50mb space & 500mb traffic. So if were 10 clients like that then is 600 domains on server, if 15 then 900... and £330 profit for you...
I cannot understand how this business works!!
jt2377 01-12-2005, 08:01 PM what's limbo? i google it and i still can't find the offical website. is limbo = lite mambo? why do you want to use limbo vs mambo?
thank
mariorho 01-12-2005, 08:34 PM Originally posted by jt2377
what's limbo? i google it and i still can't find the offical website. is limbo = lite mambo? why do you want to use limbo vs mambo?
thank
I just want to offer an easy management cms for anyone so to have the ability for internet presence.
limbo-cms.com yes is lite mambo
toenda.com is nice too
Walter 01-13-2005, 07:11 AM Originally posted by mariorho
So i think to host 1000 domains with 2euro/month which makes 2000euro profit/monthly. So i can earn 2000euro - 389euro = 1611 euro/monhly.
No. Please carefully read the "Running a Web Hosting Business" forum, there are many threads about this topic.
First, 1000 domains on a single server is not a good idea, not only performance wise - if the server has a problem you have 1000 customers crying for help.
Second, you forget about server administration, busines costs, taxes, advertising (somehow you will have to get 1000 customers?) and many more.
Im_Goodspeed 01-13-2005, 01:17 PM 1. definitely MySQL! forget flat-file, because it would give you a VERY bad performance compared to a database.
2. you have PHP websites, and a CMS is probably quite CPU intensive. my guess is you can put 150-200 accounts on that server. maybe 300, but probably not more.
jt2377 01-13-2005, 01:46 PM with flat file you lose the power of SQL but it's easy for you to unplug your website(CMS) and plug into another server without the headahce of SQL powered CMS. it really depend on how many user...etc.
Orc Webhosting 01-13-2005, 02:06 PM Not really, there are other things to consider when migrating from one server to another, like absolute paths, file permissions etc. adding a simple SQL base to the mix isn't going to make much of a difference, indeed if you can allow yourself the downtime to shut it down at one location, move it to the other place and update the DNS and wait until it propagates, then it's a fairly simple thing. I've migrated quite a couple of dynamic applications between servers over the years and the flat-file based Perl ones gave me much more trouble than the SQL-based PHP ones.
mariorho 01-15-2005, 05:54 AM Originally posted by Im_Goodspeed
1. definitely MySQL! forget flat-file, because it would give you a VERY bad performance compared to a database.
2. you have PHP websites, and a CMS is probably quite CPU intensive. my guess is you can put 150-200 accounts on that server. maybe 300, but probably not more.
Ok. 200 or maybe 300 max. acccounts.
But this gets the cost of server much higher. So i have to setup higher prices for packages too.
I wonder how many companies offers $2 - $6 packages. Do they get servers for free ? if its 200 accounts of $2 = $400 . The cost if server will be approx $250-$300.
Can somebody explain me?
Is it better to have multiple servers with 150 accounts each than 1 server with 750 ?
What i mean is : Check servers on hosteurope.de
HE Server L : 79euro
HE Server MAX2 : 389
Is it better to have 5 of HE Server L (150 accounts)?? or 1 of HE Server MAX2 (750 accounts)??
thomas.smith 01-15-2005, 06:47 AM Flat file databases use much less system resources than MySQL. However, if you are only expecting a few thousand hits a day its no problem... I used to have a service with half a million MySQL accesses per day and that got a lot faster when I switched to flat file databases.
If you have like 1000 MySQL accesses a day even a PII with 300 Mhz and 256 MB RAM should easily handle it unless it is a very complex site...
On a Dual 2.8 with 2 Ghz and an SCSI drive you can host like 1000 usual average hosting accounts I'd say... Although I am sure I will be bashed for saying this LOL. Try yourself. I'm having 500 accounts on a PIV 3 Ghz HT with 1 GB Ram and the load is on like 0.3 all the time.
Walter 01-15-2005, 11:46 AM Originally posted by thomas.smith
Flat file databases use much less system resources than MySQL.
Simply false.
It completely depends on the application and how it is written. For very, very small amounts of data a flat file usually is faster, but as soon as data grows a database will be faster in nearly all cases.
A database is able to find a certain record in a table with millions of entries in the fraction of a second using nearly no resources. Please tell me how you will do this with a flat file (even for much less data!).
Originally posted by thomas.smith I used to have a service with half a million MySQL accesses per day and that got a lot faster when I switched to flat file databases.
I see badly designed applications all day :)
|