SQL access in a reseller account

[Ghost hater]

I have several websites and plan to make more. As of now they are all add-on domains on a shared account. Things are going fine, but traffic is low and I want to start improving that; plus tying them all together can be risky as you know.

I was thinking of moving to a reseller account (just for myself, not to actually resell). However, there are a couple things I was wondering about (I read through all the linked threads from the sticky but didn't see these):

1. Can a php script from one site access some central SQL database? I have some info that is shared amongst all the sites (for example, I have a SQL database that is a list of robot user agents; no sense in creating a copy of this for each site, and keeping each up to date separately).

2. Is there a way to make a cron job that takes 30 seconds or so not hang the site up during those 30 seconds? (This question goes for the shared account I have now too!) I was thinking I could create an account that is just for running cron jobs, though again each cron job deals with SQL databases so I'd need cross-site access for this.

Basically, I want to know what kind of meta-access I can have to each site in a reseller account. I'm thinking none at all, but want to make sure (and if that's the case, ask what a better option would be).

If this makes no sense let me know and I'll try to explain it better. Thanks.

[Ghost hater]

Ah, another thing:

A reseller account comes with 5 IPs (or whatever it is), can I then add/buy more or is that a technical limit, no matter the number of cPanels? How different are these IPs?

[Pazeh]

1. yes you can do so. Just use the username/password/db name of the database you want to cross share.

2. that depends on what the cron job will do in the said 30 seconds, but I guess it shouldn't be a problem, as for centered cron job account... I'm not really sure about that

3. As far as I know, the 5 IP address are for dedicated server & not reseller account. and ye for 2$/month you can buy IPs. As for the limit, I think you should be able to get an IP for each Cpanel user without any problem.

[Ghost hater]

Originally Posted by Pazeh

1. yes you can do so. Just use the username/password/db name of the database you want to cross share.

Great, thanks. Could a php script also access the file system of another account? That seems less likely to me, but I'm not sure.

Originally Posted by Pazeh

2. that depends on what the cron job will do in the said 30 seconds, but I guess it shouldn't be a problem, as for centered cron job account... I'm not really sure about that

It would make an API call to a vendor (or two or more), get some products, and update the SQL as necessary. Most of the time is spent getting multiple responses from the vendor(s).

Originally Posted by Pazeh

3. As far as I know, the 5 IP address are for dedicated server & not reseller account. and ye for 2$/month you can buy IPs. As for the limit, I think you should be able to get an IP for each Cpanel user without any problem.

Ah, thanks. It does seem like separate IPs for separate cPanels would be a cinch.

[GatorSteveN]

You would want to have the crons run at intervals of 15 minutes or more for shared hosting plans.

User may not: ...

h) Run cron entries with intervals of less than 15 minutes.

http://www.hostgator.com/tos/tos.php

[tletourneau]

Just curious on the IP issue, are you doing SSL on each site or is there some technical reason you can't use the shared IP?

Just wondering.

[HalbrookTech]

Most hosts require a one of a short list of valid reasons for a dedicated IP address, since ARIN has strict requirements on them.

[Ghost hater]

Originally Posted by GatorSteveN

You would want to have the crons run at intervals of 15 minutes or more for shared hosting plans.

Right. It's just that when the cron does run, I found in the past that it could tie up the whole site until the script was done (I was calling a php script with the cron job that took about 30 seconds). Would this issue be solved in a reseller account somehow?

Originally Posted by tletourneau

Just curious on the IP issue, are you doing SSL on each site or is there some technical reason you can't use the shared IP?

Just wondering.

The vendor I call has a daily API-call limit, per IP address. Just one of my sites, if done correctly, will bump up against this limit. If they all have a separate IP address, no problem.


And the other question I have about reseller accounts, something that is no problem with my shared add-on domain system I have going now: can a script in one cPanel access a file system outside it, i.e. in another file system? (For example, could a php script in one cPanel import the code from a file in another cPanel?)

Thanks for the replies.