I was curious to know a basic thing about hosting, i've always wondered is it possible to host a database driven website on one server and get the database picked form other server?
I mean place the database on different server, and connect to it on the other one, which is hosting the site, Are there any options available in the control panel?
I have built a database driven site with PHP & MySQL. Pages download quicker on some connections than other (obviously), however this is not due to connection speed. The web host server seems to respond very slowly to my boss's network (which is on a proxy server). Could it be that this problem is related to the web host? i.e. could it be that the web host is unequipped to deal quickly with this type of network?
On my home connection (2Mbps), pages often download instantly, however occaisionally I have to wait 10-20 seconds to receive the page from the host.
Finally, could you recommend an excellent web host to use with our site? My boss wants to offer a professional service where server response is quick. We are based in the UK.
I am trying to do something that I believe is fairly non-standard. What I am looking to do is create a system where I can rapidly deploy web sites without having to restart named and Apache. For example, if a customer completes a process, I want to be able to turn that site on immediately using a temporary domain (somecompany.example.com or othercompany.example.com).
With some programming language (hopefully PHP) I would like to get the customer up and running with their site immediately without having to restart the server. While doing some research I found I could use MyDNS which uses MySQL to manage DNS data instead of configuration files. MyDNS can be updated on the fly.
For Apache I have seen wildcard configurations, but everyone seems to be suggesting the use of mod rewrite. I would prefer that the domain maps directly to a specific folder:
somecompany.example.com -> /sites/somecompany/htdocs
(*.example.com -> /sites/*/htdocs)
Does anyone know how I might do this with Apache. It seems similar to user directories (example.com/~username -> /home/*/htdocs)
I am developer and I ahve done web-site development and database development but it was for other companies where everything was already available.
I was not sure if this was the right place for the post, but I thought I would atleast start here, if I should post this in some other category please let me know.
I am satrting work on a Database driven web-site. I say database driven, becuase the web-site copares prices for multiple products. By some worst case scenarios(explained later) I need a database to easily acoomadate more than 1000 GB of data. I can definitely try cutting this down, but my question is what type of hosting should I choose and how when the web-site is completely relying on data that is updated on a weekly basis.
The reason to keep old data is to use that to show a Price history and forecasting on future Prices. The thought of storing this data locally and just creating a summary has crossed my mind.
The Data Scenario:
Price of Products per store: 50,000
Approximate size for the table per store: 3 MB
Number of stores: 500
Avg Size: 1500 MB
This is the bare minimum 1500 MB + other tables + overhead
Other tables: Forum data, Reviewes, User Favorite Products, etc.
Number of weeks: 52
Avg Size: 78 GB
Howevere the table with the most data and the table that would be changing the most is the Price table. So I am approximating the minimum requirement for the Databse to be atleast 2GB.
My question now is:
To be cost effective I can store the history on my personal desktop. But I still need something that allows me to have 2 GB of Database space. What is my best solution?
I have no strict rules about platform or langauge, to get started I am just trying to be cheap but still find a decent web-hosting solution so that by getting started small I have hopes of going big.
I'm on a short assignment to inventory and manage the fixed assets of a small company, and we've just bought a web-based database for this purpose. While I'm pretty good at administering/running local databases, the web part has me stymied. Our company is between IT people, and there's no one on site with any more idea than I have about what's going on!!
Here's what I have so far:
--The company has a website which I'll call "ourwebsite.org" -- which I think, from searching the IP address the website points to, is hosted by HostMySite.com.
--There's also a record in DNS Management with the same name (ourwebsite.org), but pointing to our little server's local IP address.
--I need to find a way to get my database -- which I can access on the network at (server's IP address)/database (ie 0.0.00.0/database) -- online. I tried creating records in DNS Management (for ex., assets.ourwebsite.org) that point to our server's IP (the one that, if I type it in on the network, I can get to the site I'm looking for), but get generic "can't find the page" or "can't connect to the server" errors, even after 72 hours, when trying to access it from off the network.
--If I browse to assets.ourwebsite.org/database on the server itself, I get to the website! But if I go to that page from any other computer, on or off the network, it doesn't work.
--The Server is running Windows Server 2003
So, what are my options? Do I have to talk to the HostMySite.com people to add this page? Shouldn't I just be able to use my server's name (ourcompanyadc.ourcompany.org) and have that route to the server? What's going on here! Is there a simple way to get a tiny local-server-hosted website online outside of the network?
My company is just getting into web hosting. We currently have 10-15 sites that we are hosting. What do you guys use to keep track of all the details for the site (location, company info, etc). We're using a homegrown filemaker database atm, but we don't want to continue using this when we get 50+ sites. It doesn't matter if its web-based or a standalone program.
View 6 Replies View RelatedWhen I use website copy function the website files are copied to another domain but the database remains on old site. I use this function to move the website from devel state to the production state. All sites work fine but when i schedule the backups all databases are saved on old domain. How to move the database on production domain?
View 1 Replies View RelatedWhen I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
Attached is a (badly) drawn diagram of two sites, connected by a vpn.
The site to the left, is network 10.0.0.0/24 which runs a linux server as the router for the network.
The site to the right, is network 10.1.0.0/24 which runs a windows 2003 server as the router for the network.
Now, my problem is, the clients behind the windows 2003 server can ping any machine on the first network because i setup a static route to route all traffic to 10.0.0.0/24 over the vpn interface.
now, my problem is, only the linux server can ping any machine on the windows 2003 network, any client behind the linux server cant seem to route over the interface.
I have the following route on the linux server: .....
Starting point: a working site using a shared IPv4, dedicated IPv6, and SSL. HTTP and HTTPS work, the latter only using SNI of course.
The good news: If I simply allocate an IP resource of 1 to a subscription it is pulled from the pool, assigned to the service node, assigned to the web site, DNS is updated, and the site is automatically changed to using a Dedicated IPv4 and Dedicated IPv6.
The bad news: visitors land on the default web site of the service node, with the default SSL certificate.
Other info: I can't ping the new IP, even though it shows in "ip a l" and /etc/sysconfig/network-scripts/ifcfg-eth0:0. [edited]
After the IP assignment, it is still installed, and /etc/httpd/conf/plesk.conf.d/ip_default/domainname.conf shows the new certificate is being used.
However, a second set of VirtualHost entries is created in server.conf for this IP for ports 80 and 443, with NameVirtualHost enabled on the new IP. The port 443 entry uses the default certificate. Apache's setup this default VirtualHost entry will override the web site configuration because Apache is listening on port 443 with the wrong cert.
If I go to "Change webspace settings" and toggle to Shared IPv4, Dedicated IPv6 the site works again via HTTPS, and Dedicated IPv4 and Dedicated IPv6 breaks it again. Setting the SSL cert to None and back again does not work.
Setting the SSL cert to None, changing to a dedicated IP, and enabling SSL results in the server being inexplicably inaccessible...browsers no longer connect to either the default site or the correct site, and I don't see any entries in the vhosts's logs.
is there anyone knows for a good hosting located in uk,which is allowed : adult site and casino betting online site ?
im looking for vps and dedicated server.
please help me i really need as soon as possible.thx