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 5 RepliesI 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.
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.
What are the advantages of setting up a remote mySQL server?
If I do set one up, where do I go to look for one and what specs will be recommended?
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
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.
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?
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).
View 13 Replies View Relatedi 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.
if anyone have experience with remote MySQL server setup
I have 2 servers in the same datacenter, 1 serve as web server, and 1 serve as mysql server.
would my remote MySQL server slows down my site load if it's not connected through cross cable? it's on the same datacenter though
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.
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 ?
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?
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?
how can i change mysql variables in dedicated server?
WHM 10.8.0 cPanel 10.9.0-R57
CentOS 4.4 i686 - WHM X v3.1.0
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...
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?
but first, is it a good idea to have mysql on a remote server? let's say my app makes about 400 reqs per second.
View 2 Replies View RelatedI'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.
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?
Can anyone tell me which hosting allow remote access of mysql?
View 10 Replies View RelatedI have subscribed an account in Powweb but since the Powweb does not allow MySQL remote access I need to find another hosting that allow MySQL remote access.
Wich hosting with MySQL remote access do you know?
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.
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?
how to allow user to remote mysql connection from his localhost ( in linux server with WHM )
my user wants to connect to the mysql from his localhost