Use Local Server As Database Storage
I have a question if it is possible to use my local server as database storage and even some uploaded files. I am planning to host my website even in a shared hosting server provided that I could used my local server as data storage.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Scalable Raid Storage Storage On A Budget? Also Hdd Reliability Q's
I'm completely torn on going the absolute budget route vs spending more for something that'll allow easy upgradeability in the future. I basically need lots of space but file sending-- media like mp3s, video, etc. it'll be raid 5 and I'll need at least 2-3TB initially but the ability to expand would be nice. option 1: nice chassis with plenty of hotswap bays with sas expanders expensive sas raid card option 2: cheap chassis to serve "immediate" needs and go with more later. not sure what I'd use as a card? maybe even onboard? regarding reliability: I once saw a database of failure rates of different models. raptor was the most reliable of the "desktop" drives. anyone have the link? I'm wondering of the seagate ES drives are worth the extra money vs the non-ES drives. they're supposedely more reliable and the "server versions" of sata drives.
View Replies!
View Related
Mass Storage Server
building a mass storage server, but unsure whether it is better to go for most space per system, or most space per U. Looking at making 2 storage servers sometime in the future, one more for performance (15k 300gb SAS drives) and another for more storage (bunch of 1TB SATA drives). Both would act as iSCSI targets and likely have multiple gigabit ethernet connections bonded together. Some options I am looking at: 1) HP DL320s provides 12 drives in 2U, or 6 drives per U. Upgrade it to 512mb batter backed cache and it does RAID6. Probably the densest storage U. 2) Supermicro has a 3U chassis that does 16 drives, or 5 1/3 drives per U. Pair that with one of the newer Areca SAS controllers and up to 2gb onboard cache and it should scream. 3) Supermicro also has a 3U chassis with 15 drives... just 5 drives per U, though it is ~$200 cheaper than the 16 bay one. Probably a mute point, since either way, it is less storage per server and less storage per U. 4) Get a simple 1-2U case and use external JBOD enclosures. Could put in multiple RAID cards, hook it up to multiple 3U 16 bay enclosures, and really squeeze in a lot of storage per server. Anyone else been in a similar boat? Overall, not looking for a real dense configuration, with like 10-20 servers of this config, so don't *need* to squeeze in more TB per U, but it is one way that I've been looking at it. Perhaps, in a way torn between the pre-built DL320s and the white label Supermicro approach. DL320s is a nice packaged system, support, iLO, etc. Supermicro allows more space and likely more performance (Areca likely better than the HP SmartArray), but no iLO, no single source for support, etc.
View Replies!
View Related
Linux Storage Server Partitioning
Linux Storage Server Partitioning We are puting together a Linux Storage server which will have 4 x 1TB SATA Hard Drives connected to Hardware raid configured at level 10. We plan to use this box initially for NFS services but in the near future iSCSI targets so would like to make a setup optimal the first time. What is the best way to layout the drive partition’s for this setup? My thought is -100MB /boot ext3 -Rest in LVM --LVM Group ---LVM001 2048MB SWAP ---LVM002 10GB / ---LVM003 500GB /nfs ---LVM004 500GB /iscsi Is this an efficient setup and provide a great deal of flexibility down the road? We will end up having more than one iscsi target running on this box in the end. Also does LVM experience a performance hit ?
View Replies!
View Related
Building A Storage Server. Power Consumption
I'm building a storage server out of spare parts that are lying around here at the office. Purchasing a brandnew server kinda overshoots it's target, since all basic hardware is available lika a big Chieftec 4U casing with 2x 4drive SATA hotswap bays. The machine will just be dumb storage for saving our backups. The plan is to add a decent serverboard, proc and some ram as a baseline. On top of that a 3ware 8-port RAID-controller with 8 1TB harddrives (seagate has some nice ones). Now the only issue i'm having is powerconsumption. The case has an 460W PSU, but I'm not sure if that's enough.
View Replies!
View Related
Dedicated Server With Very Large Storage Capacity
I have found SL can offer you 12*1 TB drive based systems, after RAID-5 and Win 2003 install you get just over 10 TB of storage. The monthly price works out to $1000/Month. I know some time ago LeaseWeb offered these type of storages....any one else know of any others ? Amazon S3 works out to about $1500 for 10 TB
View Replies!
View Related
Building A Server With Lots Of Storage Space
We are going to offer web space to our students and we want to build a new server just for this purpose. We were looking at buying a storage array, a RAID card, and a server. I have no problems building a server; however, I have never built anything with an external enclosure. I am thinking about buying this storage array: www newegg com/Product/Product.aspx?Item=N82E16816702010 I plan on installing hard drives in every drive bay for a total of 12 drives. The problem I'm having is I don't know what type of RAID card to buy. I saw this one; but, I don't know if it will work with this storage array. www newegg com/Product/Product.aspx?Item=N82E16816116062 Thanks so much for any light you can shed on this! I apologize for the link but I do not have enough posts insert URLs.
View Replies!
View Related
Local To Live...sql Server
I have been working on an online shop locally from my machine, using Visual Web Developer and SQL server. This is working fine, but now its at the stage were i need to show a client. In order to do this i need to upload it to our servers. What i cant get my head round is the connection to the sql server, do i need to upload this too, or can i somehow point the connection string to the sql server sitting on my local machine... Is it easier just to upload an sql server? how would i go about this?
View Replies!
View Related
Local Mysql Server Name, IP Or Localhost
I am using localhost as mysql server name on my config file. then, when I enter [url], the address will automatically change to[url]that obviously getting error. when I change the mysql server name from localhost to the server public IP, everything seems ok. My sql is 4.1.x with php 4.4.7, is that any way I may use localhost instead of IP? or is there any potential danger using IP?
View Replies!
View Related
Different Local Remote Server Types
I cannot find a suitable forum for this query so here goes on this one! I am doing a charity site as a voluntary exercise. They currently host with Eclipse who have the Zeus server (site developed in Frontpage). This is not an open source server. Thing is, what are the issues of say developing on my loacal machine (apache or IIS5) and having the remote being Zeus. I use Dreamweaver 8 for developing. I would of thought this does not matter as the server technology is transparent and down to configuration files. The directory structure both ends can be the same. Am I right to go ahead and not worry about this?
View Replies!
View Related
Can't Access My Local Web Server By Its External IP
I have a local web server that I want to make available outside of my local network of two computers. I configured NAT at my router, configured the firewall. I Typed the external IP and got nothing, while I still was able to access my web server by typing "localhost", I tried both IIS and Apache, but what is interesting is that fact that the other people can access my web server via that external IP, I just cannot access it from my local network.
View Replies!
View Related
Unable To Connect To Local Httpd Server.
When i go to my website or any page under the domain it's just white. Blank nothing, nada. "Failed to receive status information from Apache. Unable to connect to local httpd server." This error message appears when i click on "apache status". Is this because of the network issue? Or is it because of something I did myself? I did a google search and came up on some solution, I did them and nothing.
View Replies!
View Related
Connecting To Local Server With Virtual Machines
How do you go about setting up virtual machines so that they can see sites hosted on the host machine? I've got Virtual PC 2007 and the disk image that MS supply for testing IE6 on Vista machines and I'm having trouble accessing my local Apache server (set up with XAMPP). Until recently I was able to set the XP VM's LAN settings to use a proxy server with the IP address of the host machine, but I got migrated to ADSL2+ yesterday by my ISP and now that's no longer working. To access my sites locally, I set up httpd.conf like this: PHP Code: <VirtualHost *:80> DocumentRoot "C:PathToFolder" ServerName siteName.local</VirtualHost><Directory "C:PathToFolder"> Options FollowSymLinks AllowOverride None Order allow,deny Allow from all</Directory> and then in Windows hosts file I add 127.0.0.1 siteName.local. So what's the best way of getting the host and VMs to talk to each other?
View Replies!
View Related
Updating Access Databases On Local Web Server
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases. The two errors I get are: Operation must use an updateable query. or Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database. (they are not read only!) Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?
View Replies!
View Related
How To Merge A Database Into A New Empty Database
How to merge a database into a new empty database? I used this method and its not working mysqldump --opt -uusername -p databasename > databasename.sql mysqldump --opt -uusername -p databasename < databasename.sql but get this error /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
View Replies!
View Related
Network Web Server And Database Server Together
I am going to setup our new database server (call it beta) in our data center. Previously we only had one server (call it alpha) which was web, email, ftp, dns, and database. Beta is taking over alphas database duties. We have a Sonicwall router/firewall as our main connection access point. I am trying to decicde if we should simply connect alpha and beta together locally via a gigabit crossover cable, or if I should connect beta into our sonicwall router/firewall. Beta does not need to be outside accessible at all. So if I connect beta to the sonicwall I simply would not open any ports. What do you guys think is best for performance and the overall right way to do it.
View Replies!
View Related
VPS For Database Server
I currently have a VPS cPanel/WHM and was wondering if I could use another VPS for a database server. Would this work ok? Do you know of any downsides to this? Would you keep the MySQL on the same server (localhost)?
View Replies!
View Related
Database Server - SCSI/Raptor
I'm about to purchase a 2nd server to use as a database server. I've been quoted for 2 x SATA II 320GB hdd's in RAID 1 (the same of which I currently use on my single server), but searching around it appears SCSI is the norm for db servers. The problem is, my host does not offer these as a standard/upgrade option and they would need to be specially ordered (along with RAID card), which is expensive. The fastest disks they offer are 150GB SATA 10K Raptors. My question is, would these be sufficient (compared to SCSI) and do they perform noticeably better than the standard SATA II disks? Quoted database server specs: Server = 1 x Dual Core Intel Woodcrest 5130 Memory = 4G RAM Hard Drive 1 = 320G SATA II Hard Drive Hard Drive 2 = 320G SATA II Hard Drive Raid Config = RAID 1 (3 Ware Hardware RAID) Bandwidth = 3000G Multi-Homed Bandwidth IP Address = 4 IPs OS = Centos 4.6 32 bit Service Monitoring = Ping Monitoring with Email Notification Server Management = Self-Managed Control Panel = None $239 Monthly
View Replies!
View Related
How To Backup Database (cpanel Server)
I have a crucial database (mysql). My server is running cpanel. It has daily backup but it is not enough as it is running a lot of transaction daily. I would like to run the backup to backup database only every 30 mins using cronjob. How do i do that in crontab. I have root access to the server.
View Replies!
View Related
How To Create Sql Server Database
I hosted with windows hosting plan. From my control panel, I can only able to create password for database. Database name is assigned as ftp user name. I don't know how to create tables inside that database. I can create tables using many tools in my desktop environment. But how can I create table in a database residing at server?
View Replies!
View Related
More RAM Or CPU Power For The Database Server
Given the choice which is more beneficial. Some of the things I've read say Database servers use up more RAM and others say they use up more CPU power. I'm just not sure. Also, what HDD should be used for the database server? I have a choice for SATA or SAS. Some benchmarks are showing SATA as faster I believe, but that SAS is more reliable? Can anyone comment intelligently regarding that as well?
View Replies!
View Related
Server Crash While Repairing Large Database
for months my server has been running fine, since about a week ago the server crashed and was up and down the fault was found to be faulty ram which has been replaced. now I have had every tom, dick & harry take a look at the server to get it stable again but im still having issues. The server seems to run fine but crashes when I try and repair or backup my database. the database is large like 30gig but the server used to do this fine before but it wont now, it get so far then hangs. Server: Dual Core Xeon 4GB Ram 2x 250GB HDD Raid 1
View Replies!
View Related
Is IBM X3250 A Right Choice As A Database Server
I have an IBM System x3250 Intel Xeon 3040 Dual Core 1.87GHz/1066MHz FSB, 2x1MB L2 cache 2x512MB 667MHz PC2-5300 ECC DDR2 SDRAMs/8GB Max (4 DIMM) 250GB Simple Swap SATA HDD This is mainly going to run MySQL database for my e-newsletter application. I do an email blast of about 100,000 email at a time about 3 times a week. Every clicks and every opens of newsletter will be recorded in the database. Is this server a right choice?
View Replies!
View Related
Innodb Database Server Setup (for Dummies)
I'm getting ready to setup a dedicated server for a site that is database intensive that mostly uses mysql innodb databases. What is the best setup for me that would allow regular database backups of my innodb databases the easiest way possible. I basically want to be able to backup my database at a regular interval (probably weekly) without having to think too much (and without having to shut down my server each time or stop my database). I'm not too tech savvy with database management so am after tips on: - Best server setup (second drive just for bakups?) - I Don't fully understand RAID 1 setups and how they would benefit me - Explain to me the backup process for any solution you suggest
View Replies!
View Related
Forum Database To New Server Introduces Increment Errors
I moved over a 400mb ish forum database for VBB to another server and ran into MySQL Error : Duplicate entry '0' for key 1 Which I imagine would have to do with auto incriment? What can I do about this? Is there a way I can bring it over and not hit this? Way to fix it? In the meantime all of the viewers cannot use the forum because I was forced to put it into maintenance mode so that no one can run into errors etc.
View Replies!
View Related
SLOW Connection: 2 Webservers Using A Single Database Server
I am developing an application on a load balanced network. It is configured as follows: Webserver1, Webserver 2 (Fedora 5 - Linux, Apache, Zend Opt, PHP) and a DataBase Server (MySQL) When the webserver attempt to use the Database server the connections and page output are REALLY slow! The database server is within the webservers local intranet - so I thought it would be a lot faster. ---------- Here is a quick test: : : Testing Database Connection on localhost Connecting to Database... 0.00054502487182617 seconds SELECT * FROM users... 0.00076389312744141 seconds Testing Database Connection on '192.168.1.200' Connecting to Database... 19.998768091202 seconds SELECT * FROM users... 0.0021719932556152 seconds 20 seconds to connect to the database server...
View Replies!
View Related
Web Space Storage Or Get Additional Space From Another Server
im running out of space on one of my sites but i have more then plenty of data transfer. Unfortunately my hosting packaged it weird where they provide not enough hd space. Im trying to figure out is there a way where i can use another server or hosting company that can provide space only and use their servers just for space? i think amazon.com offered this but wasnt sure how exactly this works.
View Replies!
View Related
Rapid Site Deployment (database Driven Domain Name Server (DNS) + Apache Config)
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)
View Replies!
View Related
"Can't Connect To Local MySQL Server" + "IPS Driver Error"
During peak times (especially weekends) many of my site's users have been reporting intermittent 'IPS Driver Errors' in the forums and the following error in the coppermine gallery: Quote: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) (The forums and the gallery are the main parts of the site). I'm assuming that the site is having problems handling the number of users trying to connect to SQL. I tried increasing the max_connections and max_user_connections settings in my.cnf but it doesn't seem to have made a significant difference. What do I need to do to fix this? Would I need to upgrade my server specs or is it something to do with the server settings? my server specs: AMD Dual/Dual Opteron 270 with 4GB RAM.
View Replies!
View Related
Storage, Why Do They Do This
I just clicked on the Lunarpages webhosting ad at the top of this forum. Not really hunting for hosting myself but regularly suggest places to clients. I noticed something strange. Their business account has unlimited storage: # Unlimited Storage # 3500 Gigs Data Transfer For 21.95 per month. That's more space than you get with their virtual private servers. Now we know that's not possible, machines have limits right? I've seen other hosting providers offer unlimited features as well - and since all servers have limited space and bandwidth abilities how can they offer these types of services with out the FTC cracking down for false advertising? Beyond that, I don't recommend any service that offers unrealistic plans. Am I just overreacting since it seems more and more common? ** note, this isn't an attack on Lunarpages. They were there and it made this thought pop in my head.
View Replies!
View Related
Copy An Account From Another Server Via WHM - Cannot Copy Mysql Database
In previous thread we made few manual transfer of our domains. We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature. All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
View Replies!
View Related
Aquarius Storage
I just like to thank Ryan from Aquarius Storage for helping me the other day set up my test account and test the server's loading time with my website. I now have fully transferred from my previous host, PeachyDandy, as my site loaded very slowly. I have now cancelled my account with PeachyDandy. With Aquarius Storage my website now loads twice as fast as before. Site loading time according to Pingdom: PeachyDandy - Average of 6 Seconds Aquarius Storage - Average of 3 Seconds Website - Mango Chico Great job with the support Aquarius Storage! Moreover, the staff are very approachable and welcoming! If you need speed, Aquarius Storage, is your hosting solution Thumbs up Aquarius!
View Replies!
View Related
How Much Storage And Bandwith Do I Need
My site is on forumotion right now. I want to move it and have it hosted somewhere. It is a local Mustang club. I have read all the problems with the oversold sites. I have also looked at others. The big issue is i dont rally know how much space I need. This is the site southshorestangs.com. What it will have is that forum and probably a few webpages. It is still only a month old so it will keep growing hopefully. i just dont want to get way more than I will need.
View Replies!
View Related
SAS Storage
Not sure if this is beyond anyones experience here or knowledge but I thought I would give it a try here and see if I can get any insight on this. Recently I had to work with a IBM xSeries 226 server which runs two SCSI Ultra320 drives in it at this time. I've actually purchased two extra drives for it but the distributor sent me the wrong drives for that server. Now they are saying its my fault of not proving them with more information but I think stating that I have two SCSI Ultra320 drives would be enough for them to send the right ones. Now they sent me the IBM SAS Serial ATA SCSI drives, so I was wondering if anyone in here has enough knowledge to possibly provide me on the insight on the solution I think might be right to still use these two drives and not being stuck with a $2000 bill and two drives that I don't use. My solution would be to buy one of the support or any Adaptec SAS Serial ATA SCSI controller cards and put it into one of the available PCIe slots and connect the drives. I've tried contacting IBM regarding this but they want $200 bucks just to say "yeah it will work or no it wont". Logically I think it would work, the only thing I'm afraid is that let say I spend $400 - $1000 bucks on a controller card and it doesn't work they way you would think, then I'm out $3000 bucks. (drives are $2000 + $1000 for a controller card).
View Replies!
View Related
Clustered Storage
Does anyone know of a good reliable and redundant method of organizing clustered storage? I know that IBM has GPFS - has anyone actually used it? Do they charge a crap load for it?
View Replies!
View Related
Cheapest Storage For 10-20 TB
I'd like to find the cheapest way to store about 10 to 20 TBytes of data. After looking at some tape drives it seems like it'd be cheaper to get two or three big towers and fill them with large SATA drives attached to 3-ware controller cards.
View Replies!
View Related
Blade And Storage
we want start with a new infrastructure for VPS service, we have think to use Dell Blade and a CX300 storage with Iscsi, i would your impression on this configuration, i am not sure on the velocity access btw blade nic and storage, do u think that is enough 1gbs port to connect each blade on the storage? how about NFS system? i dont would get trouble with access performance,
View Replies!
View Related
Aquarius Storage -Review
i want to write this small review for Aquarius Storage i been with them a few weeks now and they are great , great prices and the best of all great support , i ran into a few issues at first , issues i could resolve my self if ihave done further reading and they were nice and help me and even pointed me into some usefull information and tutorials thats great helping customers manage their own vps insted of charging ridiculos prices for simple task like i seen in the past with other providers , keep the good work guys my site is digitalxeon.net is still on development so there no relevant information on the site yet thanx Aquarius Storage keep it up! Support: 10 out of 10 Reliability: 10 out of 10 Value: 100 out of 10 Overall: a solid 10 out of 10
View Replies!
View Related
Parts Storage And Inventory
Wondering what kind of storage hardware server builders are using to keep organized? I am currently storing HDD, RAM, PSU, CPUs, and other various parts on shelves and it gets disorganized and messy very quick. I found this product for HDD and may order some to help organize HDDs: [url] Anyone know of similar products or good shevling / cabinets that are computer parts friendly?
View Replies!
View Related
Hosting Only To Storage Files
I need a hosting with 5-10 GB Hard-drive Space and about 500 GB of bandwidth (maybe a bit less). Without any features (apache, php, etc). I need only Ftp to upload and share video files.But not very expensive, not more than $10-$20.
View Replies!
View Related
|
TRACKER
