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)?
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.
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?
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?
Which do you recommend for mysql databases alone? around 200 - 300 connections anytime
I have heard that mySQL alone can be better on 64bit environment. How about the hardware?
I forgot the Password for the MySQL Database Server , How to recover it or change it without Known the old one ..
i have access to the SSH and webmin..
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 2 Replies View Relatedi transfer all customer in new server
and restore all backups
but all website VB appear Database error
although mysql work very good
Is it possible to move my mysql database to another server?
View 9 Replies View RelatedI'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