Pre-sales questions and considerations

[rcg_01es]

Hello .

I’m thinking of moving my site to Hostgator, but first of all I want to know if my website will fit in a “Baby plan”. Its “properties” are these:

1). My website has five Coppermine galleries. Four of them are only used to store pics, and they are not visited. However, one gallery has several visitors which download an average of 250 Mbytes each day. Maybe in the future there will be one or two more galleries with visitors.

2). These galleries use GD2.

3). These five Coppermine galleries use five MySQL databases (unknown version; the host I have now has breakdown and I can’t verify the version). I guess I will have a lot of problems to move these databases from my old host to Hostgator, especially if MySQL versions are different in each hosting company, won’t I?

(I used phpmyadmin to manage these databases, with my old host)

4). I have been told that Hostgator has a limitation of 25 mysql connections per user. Does it mean that my site could only have 25 visitors at the same time? ( this is the main question, I think… )

5). Will I have the opportunity of testing my website when I upload my files into Hostgator (without still having changed my DNS)?

That’s all. Thank you very much.

[gtgeorge]

The only real problems you will experience are with G2. Also if your current host isn't running phpsuexec you will need to make sure your 777 directories are chmod to 755.

The 25 connections refers to the actual connections to the db which should only be there as a user requests something. It usually allows for hundreds of users on the site at one time.

[charlesgan]

for item 5)... usually you can test the site existance by using this url:
http://www.yourmaindomain.com/addondomainnamehere

usually i use this to test the site is added in hostgator cpanel.
so that i can begin the nameserver changes.

[Serra]

Originally Posted by rcg_01es

5). Will I have the opportunity of testing my website when I upload my files into Hostgator (without still having changed my DNS)?

Not really. Not unless you have another domain name you can setup. You can always use the http://domainip/~username, but that is hit and miss at best.

[rcg_01es]

gtgeorge, charlesgan, Serra: Thank you for your comments .

Originally Posted by gtgeorge

The only real problems you will experience are with G2.

doesn't GD2 work with Hostgator?

Then I can't use my Coppermine galleries...

Originally Posted by gtgeorge

The 25 connections refers to the actual connections to the db which should only be there as a user requests something. It usually allows for hundreds of users on the site at one time.

Then, if there are 26 people watching my gallery (if they are watching pics, I suppose that they are requesting something to the db) will the site fail and be stopped?

Thanks for your patience

[riostyles]

Originally Posted by rcg_01es

gtgeorge, charlesgan, Serra: Thank you for your comments .


doesn't GD2 work with Hostgator?

Then I can't use my Coppermine galleries...


Then, if there are 26 people watching my gallery (if they are watching pics, I suppose that they are requesting something to the db) will the site fail and be stopped?

Thanks for your patience

No, the connection (If properly wrotten as non permanent) takes place only the time to "Call" the picture, not during "Watching"

Coppermine works on HG and GD is active. Can be GD2, don't know, maybe somebody will step in! Reading php-info I have GD = bundled (2.0.28 compatible)

[gtgeorge]

Yes GD will work and should be installed, I mistakenly saw it as G2 as in Gallery2 Coppermine will work fine. I have found that if you are missing a something required , like sometimes with some of the binaries or modules, HG will install them if you ask nicely in a support request.

[joemailey]

The move should be simple back up your data base, change few paths in configuration of coppermine.

All your require is

Database backups
File backups.

Upload your files to hostgator.
Import your database backups via phpmyadmin.

change few config paths in coppermine. you done.

i've moved different stuff around like coppermine, gallery2,joomla,mambo.

i find it easy

[Serra]

Originally Posted by rcg_01es

Then, if there are 26 people watching my gallery (if they are watching pics, I suppose that they are requesting something to the db) will the site fail and be stopped?

It is completely possible that 26 people would click on a link that required a db hit at the exact same second and if everything went perfect, one of them would see an error message.

However, that would require them to all access the db within a millisecond of each other. That is a lot harder than it sounds.

[rcg_01es]

Thank you to all of you for your comments. They are very useful and helpful to me .

I have another question: is there any way to test the speed of some websites hosted by Hostgator?. I would like to know how fast I see these sites. I suppose that this parameter is different in each geographic area, isn't it?

Thank you very much .


Edited: I answer myself ... I have found about two dozens of sites hosted by Hostgator. I suppose that now I should ping them to know their response times and compare. At first look, most of them are quite fast!

[TerryKing]

Can someone point to a couple Gallery2 sites hosted on HostGator? I'd like to try the response from Over Here...

Regards, Terry King ..On the South China Sea in Shekou
terry@terryking.us