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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
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
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 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
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
Backup My Remote Dedicated Server With Centos Installed Over Ssh
i have a dedicated server with rapidswitch. Few days back all my websites stopped working, due to some reason which i was not able to solve. NOw, i want to backup all the files stored on my server. Each and every file including the database and every file there on my server. I tried to log in through ssh on filezilla but i was not able to find out all the folders. I have putty and could login over ssh , but i don't know the commands to backup. Could, you guys tell me how to get all those files on my local computer. i also have cpanel/whm installed and that is working.
View Replies!
View Related
Dedicated Server For Mysql Alone
telling me that mysql is hitting loads of 25, which he says is very high and i don't quite know what it means. He is strongly recommending that i shld get another dedicated server for mysql alone. So can i get some advice on how I can assess the validity of his recommendations? I see that my CPU is load is hitting 125-150% daily. So i suppose there is some truth? He is recommending that i get a raid-5 which is best. How can i know a suitable configuration of a new server to get? Of course, if i got all the money in the world i shld buy the best. But with constraints on budget, i want to get one (if i really need a new server) that is good for current loads with some projected margins for growth.
View Replies!
View Related
Dedicated Server For MYSQL
I've a huge site that runs on PHP and MYSQL, I'm going to get a dedicated server and make it for MYSQL so I need to know what server should I get for MYSQL ? does it need to have lots of ram or should I get high CPU ?
View Replies!
View Related
Dedicated MySQL Server
lets say my web server IP is A, and my dedicated MySQL server is B. Apache and PHP have been installed on A. MySQL server has been installed and configured on B. Im just wondering, do I still need to install MySQL client on the web server A?
View Replies!
View Related
Mysql C.dedicated Server
I was trying to upgraded MySql on my godaddy V.dedicated server.. And basicly ive screwed it up somehow. I need to get back up and running and could do with some help on the best way to do that.. Ive visited the MySql website.. ive been playing with the shell (a little too much thats why its screwed up) so i can access the server via that and the server is running Operating System: Red Hat Fedora Core 2 Can anyone point me first of all to the right download. and maybe point me to a tutorial or give me some advice on installing.. if ive messed up mysql does this also have any impact on the php or anything else?
View Replies!
View Related
Optimizing Dedicated Server With MYSQL And Busy Forum
Are there any services where an ADMIN can monitor DB usage on system and make some recommendations or even find SQL that is poorly written ... I have a DUAL harpertown, 10GB RAM, and RAID I have a typical, gallery, busy VB forum, and video script... THe site traffic has not increased much but my Memory keeps getting chewed up... i already did some tuning that VBULLLETIN suggested... but the memory still goes... i need a tool or someone to just monitor the server for a day and grab as much diagnostic info as possible.. I suspect that its a single query giving problems cuz i have some custom coded pages... I don't want to split the DB and HTTP request on diff servers cuz the traffic that i get shouldn't warrant it... for now...
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
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
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
Synchronizing MySQL Powered Site Across 2 Dedicated Servers
Here is what I am trying to do, to set up a WordPress powered site to be run across two servers for load balancing. The two servers are dedicated and I have the load balancing software installed and set up. I need to set up the site so that both of them are accessed, but to also have the same content. The main concern is for the same content. WordPress uses a MySQL database to place all of the content there, so the main thing I would need is to set up the databases so they are synched on both servers, so that the same content is showing up on both of the servers, and so I don't have to manually upload data to the database every few hours, that would suck. I have already found a script to connect to a remote mysql server, it is called HyperDB, but I was wondering if there are any better ways.
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
|
TRACKER
