Which Host For Website With MySQL Database

Apr 19, 2008

have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!

View 14 Replies


ADVERTISEMENT

Plesk 11.x / Linux :: CentOS Backup Commands For Website Files And MySQL Database

May 27, 2014

I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.

View 1 Replies View Related

Hosting For 4GB Website + 2GB SQL Database

Aug 9, 2008

I have a friend who has a dedicated server right now that uses a good 4GB for all his website content. (not streaming media but just a whole bunch of scripts and etc. well thats what he tells me). And so anyways, his SQL database is about 1-2GB. And he is not too sure about his monthly traffic but its a social networking site with a good amount of users (so its actively used by many users). Would it be necessary for him to have a dedicated server or do you think he could cut costs with a shared hosting account at like host gator or some other shared hosting service like that? I guess my biggest concern is his current database. A lot of shared hosting companies (from what i saw) offer unlimited Mysql Tables do they have size limits? And does a bigger sql database drastically effect the performance of the overall server?

View 14 Replies View Related

Database And Website On Different Servers

Oct 26, 2007

We have 2 linux servers directly connected by Gigabyte Ethernet. On a First server (192.168.0.1) we have a website (PHP5, Apache2), on the Second server (192.168.0.2) (CentOS 5 64bit, kernel: 2.6.22.9xe5u) we have MySQL 5.0 Database. A website from a Fist server connects to the database on the Second. The problem is that this system is very slow. We triet to move our website from First server to the Second and it works 50-300 times faster.

This is very strange, because when we print SQL queries of a website we see that some similar queries which are not dependent on a data or where there are very small amount of data, are executing in very different time.

For example:

SELECT t.*, tl.title, tl.content FROM site_tree_public AS t INNER JOIN site_tree_public_localdata AS tl ON t.id=tl.site_tree_public_id WHERE t.hidden='0' AND tl.lang_keyword='eng' ORDER BY parent_id, orderid
0.61763
after refresh 0.00365
another refresh 0.86579
another refresh 0.00302
another refresh 1.22748

Another example:

Four similar queries to four different databases (shemas), on one page load:
SET NAMES utf8 0.00021
SET NAMES utf8 0.00012
SET NAMES utf8 0.00012
SET NAMES utf8 0.20491

When we moved website to the Second server these queries are executing in a good stable time.

Also some following problems were noticed:

1. While connecting to the FTP, server slowed down and sometimes connections were dropped

2. We tried to install Ubuntu unsuccesfully - the network didnt work at all, then we moved to CentOs 5

3. When we first installed CentOs 5 with standart kernel we had experienced problems with network (IP's aliases just didnt work) then we installed newer kernel and the problem was solved.

first server - SM-XE2, SuperMicro 6014H-82, Dual Xeon 3.4 Ghz, 4GB DDR RAM, 2x72GB U320 SCSI RAID1, Dual Intel PRO1000, 1U
second server - SM-XEW, SuperMicro 6015P-8, Dual Xeon 2.0 Ghz (Woodcrest 5130) , 8GB DDR RAM, 2x73GB U320 SCSI RAID1, Dual Intel PRO1000, 1U

So the question is - what do you think about the problem? Did you use such a system - when a website is on one server and the database on the second? And what was the experience? Could it be kernel problems?

we think that it might be problems with kernel that dont work properly with network, please comment this.

View 2 Replies View Related

All Website VB On Server Database Error

Nov 7, 2009

i transfer all customer in new server

and restore all backups

but all website VB appear Database error

although mysql work very good

View 3 Replies View Related

Plesk 11.x / Linux :: Website Files Copied To Another Domain But Database Remains On Old Site

May 18, 2014

When 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 Related

Trying To Host A Website From Home PC

May 15, 2009

I am trying to host a website from my home computer. Currently I have it setup and it works and everything. I have my virus database updated, router update, firewall up and running, and I am ready for people to try hacking. But there is one thing I can do. I can't seem to get my website online. I go to whatismyip.com and try that IP address on both the computer I am hosting the website from and a different computer downtown but I can access it. I am currently using webs.com to tell people to download COMODO EasyVPN to access my website. But they have to download it first to be able to access my website. At one time I had to load it using the IP address I go to whatismyip.com but it took it six minutes to load and with the EasyVPN it only takes seconds. I am just wandering if my internet connection is just timing out and not letting anyone on. Is there a software I can use that works like COMODO EasyVPN but lets you type in my External/Public IP address and it go to my website. I mean my connection is slow but with the COMODO EasyVPN software it makes people connecting to my computer fast. I need a software that tunnels my connection to a clients computer.

I am using the XAMPP software to host my website!

View 9 Replies View Related

ISO Host For Artist's Website

Apr 15, 2009

not anticipating a ton of traffic at once

250 mb storage should do it

the main mb-intensive feature will be a thumbnail gallery whose links open jpgs of about 800 kb

View 14 Replies View Related

Community Website - Which Host

Jul 9, 2008

I've had four different hosts in 1 year, and I'm noe experiencing problems again with my current host, Lunarpages. Therefore, I really want to make the right choice this time. It would be such a pleasure to see my website run without any problems for more than just 8-9 months at a time...

Anyway, let me try to describe it. It's based on the Content Management System phpFusion. It has news, downloads, forums and screenshots. The site itself is c. 2 GB large (because of forum attachments and screenshots), the download section is c. 15 GB, and the site use up about 700 GB og bandwidth each month. In the forum, there's 100.000 posts, growing day for day, of course. We have 12.000 registered members, but we only have c. 50 members online at the same time -- maximum. Throughout a week, 2.000 members log in, but as said, they are never online at the same time. The members are mostly from Europe, but we do also have members from USA and Australia.

I've had both Lunarpages and Servage as hosts, but I have experienced problems with both of them. Servage has a daily bandwidth limit which I had overlooked, and the website constantly exceeded this. Lunarpages is very, very slow when using a MySQL DB.

View 16 Replies View Related

Host For My First Proxy Website

Dec 7, 2008

i would like to put Glype proxy and some ads on it.

So which host should i choose.

I was considering TMZhosting for $5.99/month. 110gb/month.

How does that sound?

Any better hosts for around this price?

BTW i already registered a domaine at godaddy.com

View 6 Replies View Related

Host For Affliate Website

Sep 30, 2008

I'm not familiar with hosting issues at all, and I'm planning to set up an affiliate webisite for online gambling. Hostgator, which after reading the posts on this forum has been my choice doean't accept affliate webistes.

View 5 Replies View Related

CPanel/WHM To Host A Website

Oct 7, 2007

am trying to set it up to host my website. After giving it the ol' college try, I might have done it, I think. I wanted input about what I have done wright and/or wrong configuring the VPS and cPanel/WHM? Please let me know what else I need to post (MX record, A records, DNS zone files, etc...)?

So far I have done:
- Initial set up of WHM
- Created a new account
- Added additional IP address t o the server
- Edited the DNS zone file
- Set up nameservers with registrar, godaddy.com

*I think this is done correctly, if I go to (www).mysite.com, I see:
Index of /
Parent Directory
Private
etc...

**I used a guide posted at (www).hostlibrary.com (link at bottom)

linux OS and version: CentOS v4.5 (centos-4-x86_64)
Kernel Version: 2.6.9-023stab044.4-smp
control Panel: cPanel w/ WHM

#vmstat 5 5 output:

Code:
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
1 0 1273608 48916 45252 538996 0 0 0 0 0 266 2 1 93 4
0 0 1273608 49044 45272 538976 0 0 0 0 0 12332 0 0 100 0
0 0 1273608 52948 45276 538972 0 0 0 0 0 12695 0 0 100 0
0 0 1273608 53420 45296 538952 0 0 0 0 0 12265 0 0 100 0
0 0 1273608 63284 45320 539448 0 0 0 0 0 13090 0 0 100 0
#ps -auxf output:

Code:
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 4752 604 ? Ss Oct06 0:00 init [3]
root 1730 0.0 0.0 8712 856 ? Ss Oct06 0:00 xinetd -stayalive
root 13841 0.0 0.0 21928 1268 ? Ss Oct06 0:01 /usr/sbin/sshd
root 23637 0.0 0.1 36052 2792 ? Rs 08:34 0:00 \_ sshd: root@pt
root 23896 0.0 0.0 6548 1392 pts/0 Ss 08:34 0:00 \_ -bash
root 11677 0.0 0.0 5444 828 pts/0 R+ 08:40 0:00 \_ ps -a
root 15850 0.0 0.0 9700 912 ? Ss Oct06 0:00 crond
root 18134 0.0 0.0 20944 588 ? Ss Oct06 0:00 /usr/sbin/saslaut
root 5160 0.0 0.0 63980 1072 ? Ss Oct06 0:00 pure-ftpd (SERVER
root 5165 0.0 0.0 15296 944 ? S Oct06 0:00 /usr/sbin/pure-au
root 20331 0.0 0.1 36512 4056 ? Ss Oct06 0:00 /usr/local/apache
nobody 7930 0.0 0.1 36648 2868 ? S Oct06 0:00 \_ /usr/local/ap
nobody 7931 0.0 0.1 36648 2872 ? S Oct06 0:00 \_ /usr/local/ap
nobody 7932 0.0 0.1 36516 2780 ? S Oct06 0:00 \_ /usr/local/ap
nobody 7933 0.0 0.1 36648 2868 ? S Oct06 0:00 \_ /usr/local/ap
nobody 7934 0.0 0.1 36648 2864 ? S Oct06 0:00 \_ /usr/local/ap
nobody 3475 0.0 0.1 36656 2892 ? S Oct06 0:00 \_ /usr/local/ap
nobody 32247 0.0 0.1 36648 2876 ? S Oct06 0:00 \_ /usr/local/ap
nobody 32299 0.0 0.1 36648 2872 ? S Oct06 0:00 \_ /usr/local/ap
nobody 32358 0.0 0.1 36648 2848 ? S Oct06 0:00 \_ /usr/local/ap
root 23595 0.0 0.0 3632 548 ? Ss Oct06 0:00 syslogd -m 0
root 3137 0.0 0.0 2524 368 ? S Oct06 0:00 /usr/sbin/courier
root 3138 0.0 0.0 4684 536 ? S Oct06 0:00 \_ /usr/lib/cour
root 3231 0.0 0.0 2524 292 ? S Oct06 0:00 /usr/sbin/courier
root 3232 0.0 0.0 4684 524 ? S Oct06 0:00 \_ /usr/lib/cour
root 3282 0.0 0.0 2524 372 ? S Oct06 0:00 /usr/sbin/courier
root 3283 0.0 0.0 9028 632 ? S Oct06 0:00 \_ /usr/libexec/
root 3284 0.0 0.0 9028 216 ? S Oct06 0:00 \_ /usr/libe
root 3285 0.0 0.0 9028 216 ? S Oct06 0:00 \_ /usr/libe
root 3286 0.0 0.0 9028 216 ? S Oct06 0:00 \_ /usr/libe
root 3287 0.0 0.0 9028 216 ? S Oct06 0:00 \_ /usr/libe
root 3288 0.0 0.0 9028 216 ? S Oct06 0:00 \_ /usr/libe
root 13671 0.0 0.2 25920 6060 ? S Oct06 0:00 cpbandwd
root 15612 0.0 0.5 33336 10296 ? SN Oct06 0:00 cpanellogd - slee
mailman 15697 0.0 0.3 51308 7684 ? Ss Oct06 0:00 /usr/local/bin/py
mailman 15717 0.0 0.4 50204 9164 ? S Oct06 0:00 \_ /usr/local/bi
mailman 15719 0.0 0.3 50212 7652 ? S Oct06 0:00 \_ /usr/local/bi
mailman 15720 0.0 0.4 50244 9824 ? S Oct06 0:00 \_ /usr/local/bi
mailman 15723 0.0 0.4 50140 9204 ? S Oct06 0:00 \_ /usr/local/bi
mailman 15724 0.0 0.4 50260 10164 ? S Oct06 0:00 \_ /usr/local/bi
mailman 15725 0.0 0.3 51340 6828 ? S Oct06 0:00 \_ /usr/local/bi
mailman 15727 0.0 0.4 50256 10064 ? S Oct06 0:00 \_ /usr/local/bi
mailman 15728 0.0 0.4 49996 10096 ? S Oct06 0:00 \_ /usr/local/bi
nobody 15774 0.0 0.1 16316 2576 ? S Oct06 0:00 entropychat
root 15805 0.0 0.4 28228 8996 ? Ss Oct06 0:00 cPhulkd - process
root 15877 0.0 0.6 55204 12456 ? S Oct06 0:00 cpdavd - acceptin
root 24019 0.0 0.3 23208 7752 ? S Oct06 0:00 chkservd
named 29943 0.0 0.1 63772 3224 ? Ssl Oct06 0:00 /usr/sbin/named -
mailnull 20198 0.0 0.0 29084 1388 ? Ss 00:33 0:00 /usr/sbin/exim -b
mailnull 20206 0.0 0.0 29084 1312 ? Ss 00:33 0:00 /usr/sbin/exim -t
root 20249 0.0 1.9 67696 39956 ? Ss 00:33 0:00 /usr/bin/spamd -d
root 20283 0.0 1.9 68092 40288 ? S 00:33 0:00 \_ spamd child
root 20284 0.0 1.9 68088 40220 ? S 00:33 0:00 \_ spamd child
root 20281 0.0 0.0 12884 1980 ? S 00:33 0:00 antirelayd
root 23984 0.0 0.8 70368 16700 ? S 00:35 0:00 cpsrvd - waiting
the url for the guide I used:

HTML Code:
(www).hostlibrary.com/StepbyStepGuidetoSettingupaNewWHMcPanelServerforWebHostingAccounts

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved