I wish to host a mysql database on my account here and use the forum on a vps which I often use to test stuff.
I am using vbulletin. So, is remote myql from other host allowed here? can I connect to my database at vlexo from another host?
If so, what are the setting i would have to put in?
// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
// for slave options just append _slave to your preferred database type. $config['Database']['dbtype'] = 'mysql';
// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost. $config['Database']['dbname'] = 'forum';
// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database. $config['Database']['tableprefix'] = '';
// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values. $config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;
// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost. $config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = '';
// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on) $config['MasterServer']['usepconnect'] = 0;
Some servers do not allow more than a set limit of database connections. Usually in the case of A LOT of users logging in on a forum etc face the problem of down time caused due the limited db connections. I have had a few friends hosted at hostmonster, hostgator etc, they all have only 50 simultaneous mysql connections (because they are hosted in shared enivronments and a re overselling to the max!). Now this can be a big problem with large forums! Especially if they want to invest in a Dedicated really soon.
So my question here is, How many DB connections does VLEXO allow?
Also any suggestion on where I can buy really cheap vps or dedicated servers.
My domain is fidhost.info and I am unable to access it. in FTP it says "unable to resolve domain" and in the browser it shows page load error. Firefox can't find the server at www.fidhost.info. However I can acess it via the IP address.
I guess its a DNS issue. Because I can access it through a proxy well and fine.