Mega Database Disks
Jul 27, 2007
How do you handle your mega space requirements for your high-use databases? Do any of you work with storage in the terabytes? If so, what kind of hardware and setup do you use?
Do you just have many commodity servers with maybe 100GB or so in each, or do you have some kind of shared RAID array set up? Or some kind of SAN?
Keep in mind I'm not talking about network storage (i.e. slow, personal use, file server) but rather high-speed intensive high-read/high-write database requirements.
What are the options for implementing such a solution?
What types of products fit such requirements? Could you comment on what things to look for when purchasing such a set of products?
View 10 Replies
ADVERTISEMENT
Jun 12, 2007
the FTP was goosed on a personal server before and I was on my way out with the bitch, so I decided to get PSM to sort it out for me.
Came back about 5 - 6 hours later and it hadnt been fixed. No problem though as I would just do it myself. Anyway just as I logged into SSH to get it done, they did it, cheers.
I wanted something enabling on the FTP at the request of a friend but wanted to watch some TV and as I can't seem to use the laptop and watch TV at the same time nowadays, decided to get PSM to do it (its only to enable resume on the FTP, so its a simple request).
Anyway to cut the story short, the ticket was submitted 6 hours 33 minutes ago and still no response. I wont do it myself now as I want to see how long it takes them to respond, it will be interesting as they have already failed to meet their 6 hour response guarantee.
Other then tonight I can't fault PSM, whenever I use them (which to be honest is maybe once every 5 months or so) they are great and usually very speedy, but tonight its just sooooo slow, its really unusual. Anyone else noticedc this slowness tonight?
View 10 Replies
View Related
Apr 18, 2008
I have a vps that has used over 400GB of bandwidth (uaually uses about 80gb if that!) as monitored by hyper vm. The vps keeps maxing out with high mysql usage and http. The server has 756mb ram and 40% cpu of a dual core e6600.
I have apf installed and have done these [url]hacked and the securing the vps thread on this forum. The only way I can keep it server up and stop it maxing out with with a band aid fix of restarting mysql and https every hour via a cron! (nice!)
I have a script that runs when the server goes over a limit here is the output any suggestions would be appreciated.
Load average Crossed allowed limit.
Local Date & Time : Fri Apr 18 12:28:03 UTC 2008
| Uptime status: |
-------------------------------------------
12:28:03 up 1 day, 26 min, 0 users, load average: 8.84, 5.85, 3.15
-------------------------------------------
| Top 20 CPU consuming processes: |
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
nobody 15565 10.6 1.0 35192 10868 ? R 12:25 ............
View 1 Replies
View Related
Apr 27, 2008
I would like to hear which configuration you think will be better for a hosting server.
I have allready a raid controller in the server.
I am more concerned with security.
View 12 Replies
View Related
Apr 29, 2008
Does anyone know the secret behind the server configuration of the big boys in hosting who offer as much as 1.5TB webspace and $15TB bandwidth or even unlimited for less than $10/month? I want to offer such a high webspace at less than $10/month too.
I want to know the exact server configuration in terms of hard drives/accessories that can make this possible and very reliable data centers where I can co-locate the servers with unmetered bandwidth too.
The estimated cost of the hard drives/accessories and any other associated costs should be stated clearly.Linux/Unix platforms preferred.The DC should be ready to do the configuration and the cost would not leave a serious dent on my financial resources.
View 8 Replies
View Related
Nov 2, 2009
Currently we're using HP servers with 4 hot-swap bays that hold 3.5" Seagate Cheetah 15K RPM SAS disks, which we can get in 300, 450, and 600 GB flavors.
I'm looking at the HP DL380/385 models which use 2.5" SAS disks. About the only decent 15K RPM SAS disk I've found in 2.5" form is the Seagate Savvio, but it doesn't come any larger than 146 GB.
Anyone know of another enterprise-class SAS disk that has all of the following attributes: 2.5", 15K RPM, SAS, and at least 300 GB?
(Please, no 10K RPM or SATA recommendations like the WD Velociraptor. I won't consider anything that's not 15K RPM SAS.)
View 14 Replies
View Related
Jul 25, 2009
I do not have a restore disk for my Toshiba laptop and there is a virus on it. Can I use my restore disk from my HP computer? Both use windows XP?
View 4 Replies
View Related
Aug 31, 2009
Hardisk brands all had their ups and downs over time. So almost all brands made sometime bad drive models that failed (yes, even IBM)
I just finished reading an article that currently for servers it seems Seagate is the best (currently).
Some say Western, some say Maxtor, I heard everything. It seems nobody agrees or there isnt one that actually has the lowest failure rates.
It would be nice to hear from real experience on servers scenarios (not office, or desktop). The article also said Hitachi was one of the worst and my eyes just popped out. I found reviews of people here that said Hitachi where the bests. So to conclude it seems everybody has their own preference.
It would be nice to hear some Datacenters or people with tons of servers. I suppose recovery centers and datacenters probably have the best stats on which disks are failing the most.
View 14 Replies
View Related
Feb 12, 2008
I colo a 1U machine with 2-36gig drives. They're not in RAID, and I have it set to rsync backups to a remote machine on a regular schedule. I have another remote machine functioning as a secondary DNS. Neither of these 2 are on a large upstream pipe. I just bought 2-147gig drives that I'd like to replace the 36g's with. How does this sound for a scenario to accomplish this with little downtime (pre-pardon my noob'ish ways):
1. Do a complete rsync of the filesystem to my remote machine as well as sync the mysql db's (to 1 remote drive).
2. Pop that single rsync'd drive into an external enclosure.
3. Travel to datacenter, once there, plug external drive into laptop and start up a VM that boots off of that drive.
4. Sync again so external drive has the most up-to-date data.
5. Change over IP's from colo to VM on laptop.
6. Shutdown and swap out drives in colo'd box with the new ones.
7. Setup new drives as RAID 1, install OS, then rsync filesystem over from laptop to new drives in colo'd box.
8. Change back IP's.
What am I missing, or is there an easier way without a 2nd colo/dedicated server? Currently, the colo'd machine is using about 1.3Mbit/sec outbound and it's running a low load.
View 5 Replies
View Related
May 30, 2008
I have a server with SATA- Hot Swap disks. I can do this, and swap out a disk, and re-partition
the new one, however the running Linux kernel hangs on to the old partition table in memory.
So even though the disk is not in use, and has been re-partitioned, I still need to reboot to
get the kernel to see the new partitions, and use them. Is there any way around this?
How to force kernel to re-read disk partitions on non-system disks?
View 2 Replies
View Related
Mar 19, 2008
anyone know any managed dedicated server provider who we can mail our hard disks to? We have a small pipe to the Internet and this is the only avenue we've thought of.
Or perhaps another solution that we haven't thought of?
View 9 Replies
View Related
Dec 2, 2007
Up to now we've been using CentOS with SCSI/SATA disk shich weren't "hot swap", and now we're upgrading to a Dell PowerEdge 1950 revision III with SAS hot swap disks on a PERC RAID 6i (new model of raid controller from Dell).
OF COURSE, Dell ONLY supports Windows (and Red Hat at the very most on the Linux world) so we were told by a Microsoft Tech that to be able to extract a disk and replace with another it had to be done via software. (The software powers the disk down and then you replace it)
Does anyone use CentOS with hot swap SAS disks? Do you use any special software to monitor the disks and/or replace them?
View 6 Replies
View Related
Oct 2, 2007
For building a house for, ie, 30 VPS, what kind of disks are you using? normal SATA? Raptor? SCSI?
I am going to use Quad-core CPU with 4-8GB RAM, but still wondering about the disks
View 7 Replies
View Related
Aug 7, 2007
We're about to buy a Dell Poweredge 1950 with hot swap disks in a raid 1 configuration (might even think about other raid combinations).
We will be installing Centos 5 (never tried it - normally use Centos 4) + control panel
The question is: what happens when a disk fails? How do we find out?(Apart from looking at the server) Any software notices?
Once noticed, what is the standard procedure to replace the disk? (Remember they are "hot swap") Do you just pull one out and replace it? Surely you have to rebuild the array...
View 9 Replies
View Related
Mar 1, 2009
I have a server with 2 hard drives, say drive A and drive B. Right now all my files, database and data is on drive A, and drive B is empty. Since I have another drive available, I want to split the load between the two drives. I'm ok with having the web pages and the database on one drive. I mostly want to just have the data (I have about 500GB of data) split between the two drives. Note that I want to avoid duplicating the data. I want to have each file on either drive A XOR drive B.
Should I map a separate subdomain to drive B and then use that subdomain to serve the half of the data thats there? Is there something I can do with hard/soft links on the server so that even though the data is on 2 drives, users still use the same url to access data on either drive? Any other options?
View 6 Replies
View Related
Sep 14, 2008
if I order a RAID from a host, can I be confident that they're not going to put two of the same make, model and order in there?
Or at least run one of the disks for a significant time before using inserting into the RAID?
View 14 Replies
View Related
Jan 11, 2007
Since purchasing 16-disk arrray NAS server 4-5 months ago, 5 disks have crashed so far. They are all WD4000YS. They're all "Raid Edition" which supposed to last longer than typical drives. It has been puzzling me until now.
It turns out that "Data Lifeguard" feature was confusing the RAID controller to believe that the disk was dead, hence the "failed" disk. AFAIK, Western Digital released firmware update on 01/09/07 that's supposed to fix this.
[url]p_faqid=1493&p_created=1168299631&p_sid=vfEX7qri&p_accessibility=0&p_redirect=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3J vd19jbnQ9MiZwX3Byb2RzPTAmcF9jYXRzPTAmcF9wdj0mcF9jdj0mcF9zZWFyY2hfdHlwZT1hbnN3ZXJzLnNlYXJjaF9mbmwmcF9wYWdlPTEmcF9zZWFyY2hfdGV4dD1XRDQwMDBZUw**&p_li=&p_ topview=1
So, if you have WDxxxxYS on your pre-production server, pull them out for a firmware update first!
For me, I can only swap "hot-spare" out for a firmware update. For other disks, I'll just have to wait for them to "drop" out of the array first. I cannot take this server offline at all. Any suggestions?
View 14 Replies
View Related
Oct 27, 2009
If you want a quick run down as to WHY I want to do this, read here
Basically, my ISP could not get my server running stable on a simple raid 1 (or raid 5) so what it came down to was having them install my system on a single disk. I don't exactly like this, main reason being, if the system (or HDD) crashes, I'll end up with another several hours of down time... So here is my proposal:
Please Note: This will have to be accomplished on a live System (full backups!) over ssh as I don't trust my ISP to do things right as described in my post above.
Current Setup:
CentOS 5.3 x86_64
Dual Xeon 5410
16GB RAM
4x 750GB HDDs
/boot - /dev/sda1 - 512MB (real 471MB) ext3
/ - /dev/sda2 - 50GB (real 46GB) ext3
/home - /dev/sda3 - remaining space (real 642GB) ext3
swap - /dev/sdb1 - 32GB
/backup - /dev/sdb2 - remaining space (real 659GB) ext3
/dev/md0 - /dev/sdc + /dev/sdd - raid 1 (NOTE: uses entire disk, no partitions!)
Proposed Solution:
Code:
vgcreate -s 64M vg0 /dev/md0
lvcreate -L 512M -n lvboot vg0
lvcreate -L 50G -n lvroot vg0
lvcreate -L 5G -n lvtmp vg0
lvcreate --extent 100%FREE -n lvhome vg0
mkfs -t ext3 -m 1 /dev/vg0/lvboot
mkfs -t ext3 -m 1 /dev/vg0/lvroot
mkfs -t ext3 -m 1 /dev/vg0/lvtmp
mkfs -t ext3 -m 1 /dev/vg0/lvhome
Now, I'd like to 'init 1' at this stage but I can't, so I won't (possible solutions?? Possible to umount the / partition??)
Assuming I'd have to do this on a fully live system, I'd disable all services that I can
Code:
/etc/init.d/sendmail stop
/etc/init.d/postfix stop
/etc/init.d/saslauthd stop
/etc/init.d/httpd stop
/etc/init.d/mysql stop
/etc/init.d/courier-authlib stop
/etc/init.d/courier-imap stop
/etc/init.d/amavisd stop
/etc/init.d/clamd stop
/etc/init.d/pure-ftpd stop
/etc/init.d/fail2ban stop
/etc/init.d/syslogd stop
Then we copy all of our data from the single partitions to the raid disks
Code:
mkdir /mnt/newroot
mkdir /mnt/newroot/boot
mkdir /mnt/newroot/tmp
mkdir /mnt/newroot/home
Code:
mount /dev/vg0/lvboot /mnt/newroot/boot
mount /dev/vg0/lvroot /mnt/newroot/root
mount /dev/vg0/lvtmp /mnt/newroot/tmp
mount /dev/vg0/lvhome /mnt/newroot/home
(I think I covered everything)
Code:
umount -l /dev/sda1 (/boot)
umount -l /dev/sda3 (/home)
cp -dpRx /* /mnt/newroot/
mount /dev/sda1 /boot
cp -dpRx /boot/* /mnt/newroot/boot/
mount /dev/sda3 /home
cp -dpRx /home/* /mnt/newroot/home/
Once we have everything copied, update /etc/fstab and /etc/mtab to reflect the changes we made:
vi /etc/fstab
Code:
LABEL=/home /home ext3 defaults 0 3
LABEL=/ / ext3 defaults,usrquota,grpquota 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sdb1 swap swap defaults 0 0
To
Code:
/dev/vg0/lvhome /home ext3 defaults 0 3
/dev/vg0/lvroot / ext3 defaults,usrquota,grpquota 1 1
/dev/vg0/lvboot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
LABEL=SWAP-sdb1 swap swap defaults 0 0
Moving on, we make a fail safe in the event this doesn't work out:
vi /boot/grub/menu.lst
find
Code:
default=0
add after
Code:
fallback=1
Then we find (in the same file):
Code:
title CentOS (2.6.18-164.el5)
root (hd1,0)
kernel /vmlinuz-2.6.18-164.el5 ro root=/dev/vg0/vgroot
initrd /initrd-2.6.18-164.el5.img
Add before:
Code:
title CentOS (2.6.18-164.el5)
root (hd3,0)
kernel /vmlinuz-2.6.18-164.el5 ro root=/dev/sda2
initrd /initrd-2.6.18-164.el5.img
Where (hd3,0) is /dev/sdc. If the system fails to boot to the raid then it'll auto boot to the single disk (/dev/sda)
then update my ramdisk:
mv /boot/initrd-`uname -r`.img /boot/initrd-`uname -r`.img_bak
mkinitrd /boot/initrd-`uname -r`.img `uname -r`
And now to set up grub...
Code:
grub
> root (hd0,0)
> setup (hd0)
we should see something like this:
Checking if "/boot/grub/stage1" exists... no
Checking if "/grub/stage1" exists... yes
Checking if "/grub/stage2" exists... yes
Checking if "/grub/e2fs_stage1_5" exists... yes
Running "embed /grub/e2fs_stage1_5 (hd0)"... 15 sectors are embedded.
succeeded
Running "install /grub/stage1 (hd0) (hd0)1+15 p (hd0,0)/grub/stage2 /grub/grub.conf"... succeeded
Done.
Code:
> root (hd3,0)
> setup (hd3)
Again, we should see something like this:
Checking if "/boot/grub/stage1" exists... no
Checking if "/grub/stage1" exists... yes
Checking if "/grub/stage2" exists... yes
Checking if "/grub/e2fs_stage1_5" exists... yes
Running "embed /grub/e2fs_stage1_5 (hd1)"... 15 sectors are embedded.
succeeded
Running "install /grub/stage1 (hd1) (hd1)1+15 p (hd1,0)/grub/stage2 /grub/grub.conf"... succeeded
Done.
Code:
> quit
From here I think we're ready to reboot, can't see where I missed anything. If all goes well then I should see my volume groups listed in 'df- h'
View 0 Replies
View Related
Jun 10, 2015
Due to data center limitations, I am restricted to 100GB on my primary disk but can have up to 2TB on a second disk.Is it possible to have the backup node use the second disk instead of the primary disk?Also is it possible to have multiple to have multiple backup nodes?
View 3 Replies
View Related
Jun 18, 2008
about the NIC and switch,
there are giga port vs mega port,
in your experience,do they really be different?
View 14 Replies
View Related
Jan 3, 2009
just out of interest, does anyone know a ssh command(s) to bring up your servers hardware stats? Cpu type and clock speed, memory, disks etc.
I've looked everywhere for a shell command to show cpu type with no luck.
View 8 Replies
View Related
Nov 20, 2014
When 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.
View 5 Replies
View Related
