Remote Mysql Server In WHM
I see option to setup remote Mysql server in WHTM but wonder can i connect 2 servers through private network then fill in Remote server address something like 192.168.1.2.
If it is possible it would save me a lot of bandwidth for both servers.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Remote Dedicated Mysql Server
i am getting mysql down issues with my current dedicated server. I would like to move my database to a dedicated server where only mysql will be running. Just wondering if this will be faster than the localhost? I have planned to buy dedicated server from another hosting company so definitely there will be a good enough connectivity distance.
View Replies!
View Related
Move Mysql Db From Remote Server
how can i move mysql db from remote server ? (via SSH or most pratical way) suppose that... source server domain : google.com host : localhost user : zode pass : 123 db : source destination server domain : yahoo.com host : localhost user : hala pass : 456 db: target
View Replies!
View Related
DDos And Remote Mysql Server Two
i have two server one for running apache and second is sql server.Now come to problem. I have a very strange type of ddos attacks on my httpd server and due to these attacks my apche server failed many times (10 to 15 times)in a day. When i checked max http connection use by a single ip then i am surprised to see that my remote sql server ip is using maximum of http connections and behind this there is some other ips whose doing the same. I installed media layer it seems to work fine for me but suddenly he blocked my remote sql server ip due to using maximum http connection lolz its very strange any body please help me out of this problem.
View Replies!
View Related
Users Cannot Connect To Remote MySQL Server
I have a few users that have a hosting account with me and are trying to connect to their own MySQL servers elsewhere. Both said that they are able to connect to the MySQL server with other hosting accounts but not the ones hosted with me. I asked if they had setup permissions to allow remote connections from my server and they confirmed that they did. What am I missing? Do I need to configure my firewall somehow? I figured the connection is just using port 80 since it's from an PHP script right?
View Replies!
View Related
WHM Remote Backup
I noticed that when "WHM Remote Backup" backs up my websites via ftp, the tar.fz archives are incomplete, meaning the backup is pretty much useless. I have tried with both PASV on and off and it still persists. Any ideas why? Also, what is the command to force the whm remote backup to run?
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
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
Remote MySQL 5.0 Hosting
I'm running a VPS at TekTonic.net and so far I have only one problem. I love TekTonic's services in general, but for some crazy reason, I can't get my MySQL server to work. I've asked MySQL's support staff, and they haven't found an answer to date. I can do just about anything on my MySQL server EXCEPT add/remove a database, which creates a problem. A BIG problem. what I'm looking for now is a remote MySQL host that will accept connections from my TekTonic-hosted VPS.
View Replies!
View Related
CPanel Remote MySQL
just want to know if you use 2 servers ( A & B ) both with cPanel, suppose that you do use the remote MySQL on server B serving website on server A. How do we access phpmyadmin? Do you guys experience this?
View Replies!
View Related
Connecting To Remote MySQL Failing
I'm facing some odd issues with 2 servers located in the same datacenter. One server is the HTTP server, and every 5 minutes it works, then for 5 minutes Server One and Server Two (MySQL) hate each other and refuse to talk to each other. Not only can neither not connect to each others MySQL, but also neither can ping each other. The odd thing is, Server Three can however connect to the Server Two MySQL with no problems during this period. It seems to be just the communication between Server One and Server Two that keeps getting halted. I've tried "service iptables stop" to disable the firewall, and changing SELinux to disabled, but neither have fixed it.
View Replies!
View Related
Host For Remote MySQL Connection
I have developed a desktop system that uses MySQL data. I want to use a host to access the data but my current provider only allows access to MySQL data via a web server. Can anyone suggest a host that would provide direct connection to a MySQL database?
View Replies!
View Related
Cpanel Mysql Remote Connection USE EXIST DB
A have set up a cpanel with remote mysql server. My demo config: cpanel: centos VPS with cpanel WHM (demo) mysql: debian VPS the configuration is OK, it works. We have got 200 customers, and we will to change to cpanel. The MYSQL server is on a solaris zone. It is possible to make the remote connecting with it. I will import the 200 users MYSQL databases to cpanel, with privileges (user settings). The mail/web dir a will import manuali to cpanel server(copy-paste-setuser:group).
View Replies!
View Related
Remote MYSQL (cPanel) Small Error
I have create a remote mysql database in whm for another server on my network. Now my problem is that the remote mysql in fact works as the data is still being pulled from it with mysql disabled on the main server. I did however put in the root password during the remote mysql server setup. Now the only problem I seem to be having is the databases dont show up in any cpanel accounts and phpmyadmin doesnt work. but all sites using a database made before this change still work.
View Replies!
View Related
Connect To Mysql From Many Remote Virtual Hosts
I have a set up where server 1 holds a mysql DB and a virtual host. server 2 holds many virtual hosts in apache (16) connecting to this DB. The virtual hosts all hold the same script, but the single VH on server 1 receives about the same amount of visits as all the VHs of server 2. server 1 is very busy at times, like 100% CPU and a load around 10 for long period of times. server 2 is not very busy, around 30% CPU usage and 0.6 CPU load. Yet, users on server 2 experience *much slower* response times than the ones on server 1. The obvious reason could be the network between the two, but I'm not convinced (6 seconds for a query run from server 2 when it brings back 1 row and takes 0.01 second from server 1). I was wondering what other reasons it could be. The mysql processlist is weird: Code: mysql> show processlist; +-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+----------+---------------+----------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | 81817 | mysite | localhost | mysite | Sleep | 865 | | NULL | | 94992 | mysite | server2:47927 | mysite | Sleep | 188 | | NULL | | 96890 | mysite | server2:50881 | mysite | Sleep | 26 | | NULL | | 97213 | mysite | server2:51010 | mysite | Sleep | 22 | | NULL | | 97391 | mysite | server2:51085 | mysite | Sleep | 36 | | NULL | | 97919 | mysite | server2:51300 | mysite | Sleep | 49 | | NULL | | 97927 | mysite | server2:51306 | NULL | Sleep | 49 | | NULL | | 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL | 97933 | mysite | server2:51282 | mysite | Sleep | 48 | | NULL | | 97958 | mysite | server2:51321 | mysite | Sleep | 26 | | NULL | | 97961 | mysite | server2:51323 | mysite | Sleep | 46 | | NULL | | 98104 | mysite | server2:51344 | mysite | Sleep | 39 | | NULL | | 98169 | mysite | server2:51376 | NULL | Sleep | 36 | | NULL | | 98177 | mysite | server2:51388 | mysite | Sleep | 9 | | NULL | | 98365 | mysite | server2:51461 | mysite | Sleep | 26 | | NULL | | 98377 | mysite | server2:51427 | mysite | Sleep | 26 | | NULL | | 98380 | mysite | server2:51468 | mysite | Sleep | 6 | | NULL | | 98394 | mysite | server2:51474 | mysite | Sleep | 26 | | NULL | | 98404 | mysite | server2:51479 | mysite | Sleep | 26 | | NULL | | 98418 | mysite | server2:51486 | mysite | Sleep | 26 | | NULL | | 98419 | mysite | server2:51487 | mysite | Sleep | 26 | | NULL | | 98429 | mysite | server2:51496 | mysite | Sleep | 2 | | NULL | | 98503 | mysite | server2:51520 | mysite | Sleep | 22 | | NULL | | 98512 | mysite | server2:51524 | mysite | Sleep | 22 | | NULL | | 98514 | mysite | server2:51525 | mysite | Sleep | 20 | | NULL | | 98519 | mysite | server2:51526 | mysite | Sleep | 22 | | NULL | | 98557 | mysite | server2:51514 | mysite | Sleep | 21 | | NULL | | 98568 | mysite | server2:51548 | mysite | Sleep | 20 | | NULL | | 98581 | mysite | server2:51557 | mysite | Sleep | 5 | | NULL | | 98617 | mysite | server2:51572 | mysite | Sleep | 18 | | NULL | | 98620 | mysite | server2:51574 | NULL | Sleep | 18 | | NULL | | 98630 | mysite | server2:51577 | mysite | Sleep | 17 | | NULL | | 98644 | mysite | server2:51584 | mysite | Sleep | 17 | | NULL | | 98681 | mysite | server2:51601 | mysite | Sleep | 15 | | NULL | | 98698 | mysite | server2:51604 | mysite | Sleep | 14 | | NULL | | 98704 | mysite | server2:51606 | mysite | Sleep | 14 | | NULL | | 98714 | mysite | server2:51610 | NULL | Sleep | 14 | | NULL | | 98736 | mysite | server2:51619 | NULL | Sleep | 13 | | NULL | | 98748 | mysite | server2:51626 | NULL | Sleep | 12 | | NULL | | 98753 | mysite | server2:51628 | mysite | Sleep | 12 | | NULL | | 98785 | mysite | server2:51635 | mysite | Sleep | 11 | | NULL | | 98820 | mysite | server2:51654 | mysite | Sleep | 10 | | NULL | | 98821 | mysite | server2:51655 | mysite | Sleep | 10 | | NULL | | 98822 | mysite | server2:51656 | mysite | Sleep | 10 | | NULL | | 98823 | mysite | server2:51657 | mysite | Sleep | 10 | | NULL | | 98836 | mysite | server2:51660 | mysite | Sleep | 9 | | NULL | | 98840 | mysite | server2:51662 | NULL | Sleep | 9 | | NULL | | 98841 | mysite | localhost | NULL | Query | 0 | NULL | show processlist | | 98901 | mysite | server2:51680 | mysite | Sleep | 6 | | NULL | | 98903 | mysite | server2:51651 | mysite | Sleep | 7 | | NULL | | 98920 | mysite | server2:51684 | mysite | Sleep | 6 | | NULL | | 98947 | mysite | localhost | mysite | Sleep | 1 | | NULL | | 98954 | mysite | server2:51696 | mysite | Sleep | 5 | | NULL | | 99024 | mysite | server2:51710 | mysite | Sleep | 1 | | NULL | | 99031 | mysite | server2:51712 | mysite | Sleep | 2 | | NULL | | 99032 | mysite | server2:51686 | mysite | Sleep | 2 | | NULL | | 99041 | mysite | server2:51694 | mysite | Sleep | 2 | | NULL | | 99049 | mysite | server2:51717 | mysite | Sleep | 2 | | NULL | | 99058 | mysite | server2:51720 | mysite | Sleep | 1 | | NULL | | 99063 | mysite | server2:51685 | mysite | Sleep | 1 | | NULL | | 99064 | mysite | server2:51722 | mysite | Sleep | 2 | | NULL | | 99073 | mysite | localhost | mysite | Sleep | 1 | | NULL | | 99075 | mysite | server2:51724 | mysite | Sleep | 1 | | NULL | | 99086 | mysite | localhost | mysite | Query | 1 | Creating tmp table | SELECT DISTINCT * | | 99089 | mysite | localhost | mysite | Sleep | 1 | | NULL | +-------+----------+---------------+----------+---------+------+----------- Why so many sleeping processes from server 2, and none or almost none from server 1 ? Is it normal that every query from server 2 is open on a different port ? Should they be grouped by virtual host, or is there one different port for each script running concurrently? What could be a reason for server 2 having problems to open connections on server 1, and how to solve it? Right now I'm about to deport more users from server 1 to new virtual hosts on server 2, hoping it will lower the load on the first machine and overall accelerate the response times. I just thought I'd post here first because this all seems very weird to me and i thought someone with an external look might tell me what I'm doing wrong. And also if network would be the problem maybe that's not the clever thing to do to make more users remote.
View Replies!
View Related
MySQL Remote Connection Problem After A Heavy Usage
I have 2 identical Fedora8 boxes with Apache 2.2.8, MySQL 5.0.45 and PhP 5.2.4. I use one as the Web+DB server (say box A), and the other (box B) just as the Web server connecting to the DB server on box A. I use this 2 machine configuration to test a LAMP based-Web application. I have a client program on other machines that can emulate a massive web workload to these 2 servers; it can emulate hundreds to thousands of users using the application simultaneously. Before running the test, the connection to the DB server from both boxes seem fine. Using the mysql client program on either box A or B trying to connect to the DB, the connection goes through instantly. In the /etc/my.cnf file, I have max_connections=4096 and max_user_connections=4096. Note that the web app uses one single db user to connect to the db. To allow remote connection, I inserted one record into the user table of the mysql db whose the host field's value is '%' (allow connection from all remote hosts). After running the test (which I found out that many requests sent to box B failed), mysql client program on box A is still able to connect to the db instantly; but the one on box B has a problem: it takes extremely long (5 - 10 minutes or even more) to establish the connection, it doesn't time out, just takes that long. I believe that's the cause for the failure of requests to box B.
View Replies!
View Related
Backup In CPanel/WHM Without Mysql
The automatic backups you can setup in cpanel/whm bundle the entire user account. Is it possible for it to save everything except the mysql databases? I have an account that has databases over 5GB+ and would like to handle backing those up separately.
View Replies!
View Related
MySQL Disk Space In WHM Not Calculated
Today I check my server the WHM not calculated the MySQL dtabases size from the account quote. for example , let see this account Disk Space Usage 95.92 Megabytes MySQL Disk Space 69.77 Megabytes Disk space available 4.08 Megabytes While this account have max of 100MB so this account not have about 164MB a total mysql ana disk space , so how to fix this problem?
View Replies!
View Related
WHM Load Averages Display And MySQL Stats
I have one server where cPanel WHM displays the load averages at the top right, but another server where it doesn't. How do I enable this? And what do the three different numbers shown (e.g. "Load Averages: 0.99 1.17 1.43") stand for? way to get MySQL stats such as queries per day and things like that?
View Replies!
View Related
DB Server For Remote Client/server App
if there are any hosts you would recommend working with for hosting a DB app (MySQL or SQL Server is fine). The trick with many hosts is that the database is not made directly available to remote clients due to security reasons. What I'd like to do is provide the DB hosting for a client/server application we are developing. For many of these users, setting up and managing a database will be too complex, so I'd like to provide the hosting for them. Additionally, we'll be starting small and will need room to grow -- probably up to fully dedicated hosting. So -- any good experiences out there with this kind of hosting? It goes far beyond the usual specs of bandwidth, disk space, etc. into needing low server densities, high availability of the DB service, and most importantly, no plans to block remote access to DBs in the future...
View Replies!
View Related
Remote File Server And Web Server
I own a file hosting site. The site is powered by 2 servers - 1 front end web and database server, and 1 where all the files are stored. I'm facing a problem that uploading and downloading often failed. Connections to mysql would timeout. Has it to do with mysql settings or because the file server is located at a distance from the sql server? (my.cnf on the sql server) [mysqld] skip-locking skip-innodb max_user_connections=6000 max_connections=6000 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock
View Replies!
View Related
New Server Without OS (Remote FTP Backup Server)
I just purchased a new server with 4 hotswap HDD of 250GB each and reload with new CentOS 5 without any host control panel. The purpose is to backup all my other Cpanel servers data remotely. All my Cpanel servers are fully managed servers. This is the first time i'm going to do all things by myself, so I'm really a newbie. Please don't advise me to hire a server admin because I end up learning nothing I need to learn.. 1. My first step now is to secure & harden the server. - Can anyone mind to share with me valueable knowledge of basic server security & hardening? I was also thinking to use sudo root password which my serveradmin actually did but I don't know how. But su - access level would be OK too. - I also need to install firewall and close all kind of port and block all SSH connection from all kind of IP except my server & my own IP address only. Can anyone provide me a guide? 2. Secondly what I need is to install FTPd and create user for each hard drive with 2 directory inside. /sda/server1/ /sda/server2/ /sdb/server3/ /sdb/server4/ /sdc/server5/ (reserved for future server) /sdc/server6/ (reserved for future server) /sdd/server7/ (reserved for future server) /sdd/server8/ (reserved for future server) Does anyone knows where to find documentation how do install ftpd and how to setup user pointed to the specific directory.
View Replies!
View Related
Remote Clamav Server
I would like to know if its possible and if someone is using a remote clamav server to check the messages against viruses. We are running around 15 servers and all of them have the clamd installed, and we waste time upgrading the software, database and also monitoring many services that are exactly the same one. Our idea is to setup a central server that those 15 servers will send the message for checking first. We are running cPanel and Exim on those 15 servers. We have implemented remote spamassassin checking this week and its working like a charm.
View Replies!
View Related
Getting Remote Access To My Server
I would like to setup my server to allow remote access from home. It's on an office network which is separated from the WAN by a router. So long as I'm on this network, I can access the server from any computer connected to it. I enter the https URL of my server through IE and it brings me to the helm interface (the one that comes with Windows Server 2003). I can click on Maintenance and then on Remote Desktop, and it opens a new window with the server's desktop displayed. If I'm somewhere other than the office network, I can't access it. IE gives me a "can't find webpage" message (or something along those lines). How do I setup my server to access it from outside the office network. I'd prefer to have a similar graphical interface as Remote Desktop.
View Replies!
View Related
Email On A Remote Server Through Google
A client has told me that his brother wants to put the company email on a remote server through Google. Currently the email goes via the hosting company. He has asked me to send his brother the username and password for "updating domain information" so he can demonstrate what he is suggesting. I am not really sure what he wants (as I always set up email via the hosting company and am not familiar with any other way): domain details or hosting company details with the email passwords etc? If the latter, I am not too happy about giving him access to all the website files that I am responsible for. Does anyone know what he is talking about?
View Replies!
View Related
Remote Backup Solution For Server
backup service for my dedicated server that can do the following: Take backups of the server without my laptop being involved when the backup takes place. (So I can take a vacation for two weeks and have my laptop turned off - while backups still taking place). Strangely I have found it impossible to find such a service ... All services I have looked at require my laptop is turned on and running some software while backup of server is takeing place.
View Replies!
View Related
Dedicated Server With Remote Desktop
I am hoping to find a dedicated server with the following specs or similar... Processor: 3.00GHz or 1.8GHz Dual Core RAM: 1-3GB Hard Drive: 20-50GB (Yes, I realize most dedicated servers don't have drives this small.) Windows preferable Remote Desktop Access 30 GB Bandwidth I plan to use this for running autoclickers and that sort of thing so that I don't need to worry about them on my PC. If anyone has any suggestions, please let me know! I realize this is an odd request.
View Replies!
View Related
Remote Cpanel Server Backup
i run cpanel on centos, and i backup all websites and system setting to the 2nd hd by whm's backup feature everyday, i want to ask if any script or method i can backup all the files to another server in a period of time, it may be a week or 3 three days...etc,
View Replies!
View Related
Windows Server Remote Desktop
to install a server for data sharing. My user want a Windows server with remote desktop to write, edit and share document. The server will host 5 users. one admin and 4 users. each user will have there own account and folder. The user will update word files and save it directly on the server. The admin will have access to each directory (like a fileserver). I want your recommandation for the share, the OS and the upgradability
View Replies!
View Related
Setting Up Remote Sql Server
i am trying to setup a remote sql server , the web server which runs everything but sql is cpanel/WHM and the SQL server is Centos 5. I have installed mysql on the SQL server and it is running. When i put the information in cpanel for remote sql setup it comes up with an error of : usr/bin/mysqladmin: connect to server at 'IP Address' failed error: 'Host 'hostname' is not allowed to connect to this MySQL server' mysql has failed, please contact the sysadmin (result was "mysql has failed"). Is there something i have to enter in the remote sql server to allow the IP address of the cpanel server to be able to connect to the SQL server?.
View Replies!
View Related
Remote Logging, To See Which Server Is Using Most Bandwidth
Does anyone have an app they use to track the bandwidth/usage for each connected computer/server? we have multiple servers hooked up to one internet connection, all running miscrosoft windows software. Ideally i would like ONE of the servers running microsoft 2003 to log all others network usage. All the servers do different things, so it would be great to check which are under most demand etc. The other thing is, naturally i dont have screens for them all, only one. So this is the main reason for remote logging. Would be hassle to have to Remote desktop into each one to check how there doing every hour etc.
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
Remote Desktop On Windows 2003 Server
I am having a VPS and tried to use RDC from home and it i working. But from my office I couldn't since it looks like RDC is blocked when connecting to out of LAN. I have tried with the support to change the ports couple of times but still didn't work. I tried: GoToMyPC, IRemotePC etc. But I believe these 3rd part software doesn’t work in Windows 2003 Server. how to overcome RDC problem or web service or web service that can work on Windows 2003 Server for RDC?
View Replies!
View Related
Decompressing Files On Remote Server Using SSH
I uploaded a .tar.gz file to my host & want to decompress it on the server to avoid long & painful FTP uploading. I read so far that this is possible using SSH with command line, but I searched for the appropriate command to no avail so far. SSH (& SFTP) connection to server established successfully & I'm using WinSCP.
View Replies!
View Related
VPS: Unable To Access Remote Server
I have an outsourced project where someone from India is developing a program for me but we keep running into a problem that I can't find the solution too. Every time we try to use our program to access one of our private squid/proxy server we receive an error back. Type: System.Net.WebException Message: Unable to connect to the remote server Our VPS is a windows 2003 server and I'm pretty sure that one of the services is blocking the program or anything from accessing a remote server. By the way I disabled the firewall and I'm still having problems .
View Replies!
View Related
Cheap Server With 100Mbit For Remote Backups
cheap dedicated server for remote backups with at least 200GB hard drive and 100Mbps up/down connection and 1000GB transfer. It would be the best to be in US, but it can also be in Europe if speed from US can be at least 60Mbps. The best I found is Hetzner (49 eur), but they are in Europe and they have a 99 eur setup fee which is too much for me. It would be great that it's even cheaper than this, because this Hetzner server have a dual core AMD 5600+ CPU, 2x400GB HDD and 2GB of RAM, so because I don't need all that I was hoping to find even cheaper Celeron or Sempron with 200GB HDD and 512MB or 1GB of RAM in US.
View Replies!
View Related
Incremental Backup Of CPanel Accounts To A Remote Server
I want to back-up accounts managed by cPanel/WebHostManager to a remote server. I want to be able to restore to any of the last 7 days. I believe doing an incremental back-up each night can accomplish this best, saving both bandwidth and disk space on the remote server. Using the back-up functionality built into WHM is appealing because WHM knows what files need to be backed up to do a full restore. However, WHM can't do exactly what I'm looking for either. I've been looking into using rsync as described in this document: [url] It looks becaue of the "hard link" capabilities of linux, rsync can be used to create what functions like a full back-up every night but requires a full backup the first day and then each day after that only the incremental changes have to be transfered. However, because I don't know what directories need to be backed up, I'm not sure how to implement an rsyc solution either. (BTW, I want to back-up everything necessary to be able to restore each account except the log files. So, that means MySQL, mail, config info, and whatever the user has uploaded)
View Replies!
View Related
|
TRACKER
