Mysql Replication Stopped
Jul 23, 2008I had configured mysql replication for one of my client. Now the replication is stopped and slave server is not updating the data. How can I resolve this and start the replication again?
View 7 Replies
ADVERTISEMENT
MySQL Replication
Jul 13, 2009I am trying to achieve mysql replication between server1 and server2 with help from [url]
However, I have problem connecting server1 and server2 to perform the replication. The error that I receive during the first time replication on server2 is as below:-
mysql> LOAD DATA FROM MASTER;
ERROR 1218 (08S01): Error connecting to master: Access denied for user 'slave_user'@'server2' (using password: YES
However, I am able to connect from server2 to server 1 with:-
mysql -h server1 -u slave_user -p
I have followed the exact guides but still could not get it to work.
MySQL Replication
Dec 29, 2008I don't know much about MySQL replication at all but am trying to present a few different options to a client of mine.
They run a large eCommerce site with a very active database. For several reasons, they are considering having their site mirrored across two completely different dedicated hosting providers.
The question here is, is it also possible to replicate the MySQL database in real-time across external servers and if/how secure it is.
Essentially, if one DC becomes inactive they'd like to fall-back on the other. An even more ideal solution would be to split traffic across the two... but not sure if that's even possible, perhaps with DNS?
MySQL Replication/Failover
May 24, 2008I'm working for a client who has an e-commerce site currently hosted on a shared hosting solution.
He is now looking for 100% uptime (as near as), so I have suggested that we get 2 VPS and use DNS monitoring to switch servers as required (from DNSmadeEasy).
This is all fine, and the websites files/images do not change often, so I can use rsync every so often to sync these. Not a problem.
What does change frequently is the mySQL db for the site.
I've been looking at MySQL replication, but this seems to be no good. If one server goes down, then the other one takes over, they don't automatically sync themselves after they come back up. It seems MySQL cluster is best, but this needs 3 servers and they all need to be on the same LAN.
I've read you can set MySQL replication to MASTER-MASTER so that it acts like a cluster, and resyncs itself as required.
MySQL Replication Setup
Mar 31, 2008if you have MySQL replication setup, and DNS failover switches over to the MySQL Slave server in case of an outage...
Is that gonna work? Will the Slave suddenly just work as a regular non-slave DB?
Then when the primary server comes back up, how do I sync my changes back to the master db?
MySQL Replication.. Effective?
Dec 13, 2007Some of you may have read my previous posts about a dual server configuration I am currently working with. I run a high traffic forum which has up to 2-3k of people online at once. I was wondering if it could be effective to setup MySQL Replication of certain tables which are read very frequently and then modifying the script to grab data from the slave server rather than the master? For say viewing threads, forums etc. Information which isn't updated literally every second.
A few questions...
-Will this place a lot of load on the master having to write the data to the slave as well? As in would the load I save on SELECT queries be used on writing to the slave anyway?
-Could this actually be effective?
Mysql Master-slave Replication
Jul 22, 2008I'm not too experienced with this, so I'm hoping someone more enlightened here can help.
Scenario:
I'm trying to build a social network site geared towards old people. I'm using LAMP environment. I want to have 1 mysql master (writes) and 2 mysql slaves (reads). Two web servers will read from the 2 mysql slaves and write to the one mysql master.
Questions:
My concern is this: when a user posts a comment via the webserver, the comment is written to the mysql master. I would like for him/her to see the comment he posted right away so they don't think something failed or went wrong. I'm afraid that replication to the mysql slaves will take some time to sync all of the mysql databases together. How can I work around this? Or am I mistaken and this doesn't actually happen?
How fast is replication? How can I mitigate this delay in replication to show the user instant results of their submission.
The same thing can apply to uploading photos to a user's profile.
MySQL Replication For User On Shared Server
Nov 6, 2008I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this.
I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to:
1. execute:
GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa';
[url]
2. Stop mysql server and Add in my.cnf:
[mysqld]
log-bin=mysql-bin
server-id=1
slave-compressed=1
binlog-do-db=user_main
start server[url]
3. execute:
SHOW MASTER STATUS;
we need values of colomns File and Position from output of above command[url]
So my questions are:
Is there any security risk?
Is there significant extra resource usage?
Is this even done on shared environments?
MySQL Replication Setup With 150 Queries/sec -> Major Lag
Jun 8, 2008I have fairly a large web site that has a forum and a torrent tracker.
Currently MySQL server is handling about 150 queries an avarage per second.
Here is the server spec:
Core2Duo 2.66Ghz
4Gb RAM
320GB SATA 7200RPM (Server provider does not have 1.5K RPM nor 1.0k RPM)
100Mbit Connection (servers on the same switch and the switch does not have 1Gbit port)
MySQL Version: 5.0.51a
I had Master-Master Replication setup with forum running on one and the tracker running on the other.
Although this has been working for about few days, we started seeing lags in the replication process.
After a week, there is a major lag and the changes made on one of the servers takes about 5 hours to appear on the another.
So, this doesn't work.
What would be the other ways of splitting MySQL queries concerning the same database?
While I was researching, I read about MySQL Cluster with database storage engine being NDB.
But, let's say that there is a power failure on both the nodes at the same time, then I would lose the whole database as the database is stored on the memory correct?
I would not like to take that chance either, but if this is faster then replication method then maybe I will concider.
I thought about editing the forum coding to make all queries that concerns the tracker to go in to, say server B (with forum's primary MySQL server being Server A), and make the tracker use server B as MySQL backend, but it seemed like a heavy work so that will be the last choice.
MySQL Getting Started And Stopped All The Time (by Innodb )
Jan 6, 2007MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:
070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
070106 14:40:40 InnoDB: Starting shutdown...
070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
070106 14:40:42 mysqld ended
070106 14:40:42 mysqld started
070106 14:40:42 InnoDB: Started; log sequence number 5 959534492
Plesk 12.x / Linux :: Batch MySql Script Stopped
Oct 2, 2014I've this terrible problem: on my site I start a script that executes a batch process that imports into the Mysql database a lot of products (texts and images). I'm monitoring the query process from Phpmyadmin>Status and I notice that after some minutes the number of queries decreases from ~900 to ~30, that means that the script is stopped! Then I check the error_log and infact there's this error:
[Thu Oct 02 17:09:34 2014] [warn] [client xxx.xxx.xxx.xxx] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server
[Thu Oct 02 17:09:34 2014] [error] [client xxx.xxx.xxx.xxx] Premature end of script headers: insert_products.php
Some informations:
VPS server: 1 CPU; 40gb; RAM 1GB
OS: CentOS 6.5 (Final)
Plesk version: 12.0.18
What I tried via SSH console:
# /usr/local/psa/admin/bin/php_handlers_control --list
id: display name: version: type: cgi-bin: cli-bin: php.ini:
module 5.3.3 5.3.3 module /usr/bin/php-cgi /etc/php.ini
fastcgi 5.3.3 5.3.3 fastcgi /usr/bin/php-cgi /etc/php.ini
cgi 5.3.3 5.3.3 cgi /usr/bin/php-cgi /etc/php.ini
# /usr/bin/php-cgi -v
[code]....
DNS Replication
Aug 9, 2007We are currently configuring two machines to act as primary / secondary name servers.
Both machines are server 2003 Standard Editions, obviously based in seperate locations.
I would like to replicate all primary zones as secondary zones on the second server.
However If a machine dies I dont want to have to re-add every zone manually - I would rather point the machine at the other one and have it pull back information for all zones that machine is authorative for.
Is there a way to do this on server 2003 DNS or not?
Exchange Replication
Sep 16, 2007What would be the best way to replicate two exchange servers across a WAN? I would like to run exchange but in two different physical locations for redundancy and backup purposes, to ensure if one goes down, the other is right there. Is there any good commercial solutions?
View 0 Replies View RelatedWindows - Realtime File Share Replication
Sep 11, 2009I'm trying to find a low cost solution for realtime file share replication in a windows environment.
It doesn't look like there are any open source windows cluster filesystems around, so the only viable option I found would be running OpenFiler in a replication cluster on Hyper-V nodes. Has anyone worked with this, does it work reliably?
The required IO throughput on these shares would really be minimal and my biggest concern is 100% availability.
Make Site Load Faster Other Than Replication?
May 7, 2008what can make site load faster other than replication
(well lets assume that design wise it is ok and doesnt content heavy contents...)
i have heard that increasing networking speed at the server level can make site much faster...
is it true..?
is there any tweak bandwidth wise...
suppose we get 1tb bandwidth per month compared to 100gb ...
will that make site faster...
we want to host a photogalley site...which is fast or images are shown in faster way....
Load Balancing / File Mirroring & Replication - Microsoft IIS Servers
Jul 30, 2009Hello, we have a few web servers that run Windows 2003 Server and IIS for web page hosting. We develop custom applications and don't do "web hosting" per se.
What is the best way to do this in a load balanced environment? We have a Cisco load balancer out in front of these servers, but I'm curious about the following:
1) Is there a way to replicate IIS entries instead of having to configure the site on each server?
2) How does everyone handle file replication (hopefully in real time) across all servers?
IIS Just Stopped Serving..
Aug 2, 2008I have been hosting a site for the past number of weeks on IIS on Server 2003..I have a no-ip a/c which is working fine along with port forwarding on my router..
The other day I restarted my server for something but now I cant seem to access my site from across the internet and according down for everyone or just me (website) it is down. I can, however, access the site using domain name from within my lan.
I'm not too hot on server 2003 or IIS. What can I do to debug/diagnose the problem?
Nsplayer Must Be Stopped
Sep 24, 2007i have been around the internets trying to figure out how to stop this menacing problem and i really have come to just a lot of dead ends.
my issue is that i want to block people using something called nsplayer from ravaging my bandwidth. every day there are at least 300 or so entries from people using this piece of software which is causing me to blow through about 20 gigs a day instead of around 5-7 gigs. the fine support folks at imountain went out of their way and wrote a htaccess script but alas that isnt helping that much. so, what i have been doing is just banning each individual ip through htaccess and sometimes it works and sometimes it doesnt.
my site is in my profile.
is there anyway to block this completely?
here is an example of one of my log entries.
79-65-96-136.dynamic.dsl.as9105.com - - [23/Sep/2007:19:33:06 -0700] "GET /debaser/vol.%204/14%20Wish%20You%20Were%20Here.mp3 HTTP/1.1" 200 803868 "-" "NSPlayer/11.00.6000.6324 WMFSDK/11.00.6000.6324"
i dont know if it matters, but i am using h-sphere and indexing is turned off.
Tomcat @ Cpanel Stopped
Mar 18, 2007for some reason since 2 days ago tomcat stopped working by itself. i removed it and reinstalled it several times with no luck at all. it seems it has something todo with mysql connectivity, but the weird thing its working on php just fine even the test code its not working ....
View 0 Replies View RelatedMail Stopped Working
May 12, 2007I run a small website on a dedicated unmanged server with cpanel.
About a month ago,i stopped getting the daily mails from addresses that are located on the server...
Also,when I attempted to send mail to one of these addresses I never received it...
Its a RHEL 3 server with cpanel,is there anything I can do to see where the problem is?
SMTP Connection Has Stopped Working
Jul 9, 2008I have been having great trouble sending mails from my local Thunderbird/Windows client to my Debian/Exim-server via TLS/SMTP.
I am no expert on TLS and SMTP, but I managed to create a server certificate and set up a secure (TLS) connection more than a year ago, and it has been working fine until it suddenly stopped working a couple of weeks ago.
Sending to external addresses from web pages still works fine, the problem seems to be in the SMTP connection. If I try to "telnet xxx.xxx.xxx.xxx 25" I get no reply whatsoever (it seems to connect but it just gives me a blank screen with a blinking cursor) and I am wondering if there is a firewall issue or if I am simply not running the right daemon to listening for incoming SMTP connections...
POP continues to work fine with teapop/stunnel enabled.
I am running Exim 4.63-17 on Debian Etch. I configured Exim to be of the type "internet site; mail is sent and received directly using SMTP"
==============================
Firewall shouldn't be a problem (?):
debian:~# iptables -L
Chain INPUT (policy ACCEPT)
target prot opt source destination
Chain FORWARD (policy ACCEPT)
target prot opt source destination
Chain OUTPUT (policy ACCEPT)
target prot opt source destination
==============================
I really don't know what to do. I have tried running:
tail -f /var/log/daemon.log
Which responds when I access my mail using POP but not when I try to send using SMTP.
CPanel Stopped Working In Vista
Jan 4, 2008Yesterday I could reach all of my cPanels on a Vista laptop; today they all time out. I can reach them with other computers. It doesn't matter if I go to mysite.com/cpanel or mysite.com:2082. I even added a port 2082 under Windows Firewall; no change. I'm not using any 3rd party firewalls. I did install a bittorrent client last night, then uninstalled it when it didn't work.
View 3 Replies View RelatedPHP Mail() Function Stopped Working
May 10, 2008I have a dedicated that suddenly stop php mail() function to work.
Very strange because if I run php script with mail() function as root on command line all working fine.
But If I run php script with mail() function in my browser so not work. Seems that only ROOT can run mail() function.
Squirrelmail/Nutsmail Stopped Working
Sep 17, 2007Getting the following error in webmail when I try to acces nutsmail(squirrelmail):
Warning: strpos() [function.strpos]: Empty delimiter. in /usr/local/cpanel/base/3rdparty/squirrelmail/plugins/administrator/auth.php on line 34
Email Stopped Working On Server
Apr 14, 2007Recently I noticed that I was not getting any email on my server.
Server is running CentOS
When I send email to myself I am not getting anything and then it bounces back several days later saying the server is not responding.
When I check on Dnsstuff.com I get the following:
Trying to connect to all mailservers:
mail.webzila.com. - 216.32.77.68 [Could not connect: Could not receive data: Operation timed out.]
[Note that if your mailserver takes over 30 seconds to respond, our test will timeout, even though real mailservers will wait longer]
I tried turning mail services OFF and then ON again in Plesk but that didnt help.
Munin Stopped Reporting Eth0 After Reboot
Apr 30, 2008I rebooted my server and now munin is not showing any eth0 traffic. All other graphs are fine. I can see there is a ton of apache accesses so there is definitely eth0 traffic. Munin logs report no errors. I restarted munin and munin-node. I even did 'yum remove munin munin-node' and reinstalled again but it still doesn't work for eth0.
View 4 Replies View RelatedRemote Desktop Suddenly Stopped Working
Jan 28, 2008I have a server that I access through remote desktop. Suddenly I am getting the message "Remote Desktop Disconnected: The computer can't connect to the remote computer." when using Remote Desktop.
It was working a few minutes ago.
A while ago I suspected that someone knew the password for the box. I did change it at the time, and thought the issue was solved. Is it possible to turn off remote desktop remotely (whilst using remote desktop).
Power cycling the server isn't making any difference.
Any other options other than putting in a support request at the host?
Client Stopped Connection Before Send Mmap
Apr 5, 2007I've got a one month stable setup running a cpanel + apache 1.3.x and suddenly starting yesterday i get these errors from time to time in the log from various IPs:
(104) Connection reset by peer: client stopped connection before send mmap completed
(32) Broken pipe: client stopped connection before send mmap completed
send mmap timed out
Googling shows people guessing at everything from mysql errors to the visitor clicking a link on a partially showing page before it's completed.
Anyone with more clear insight? Mysql shows no apparent errors.
Site is a heavily loaded wordpress setup with mod_gzip the only major addition to apache. Also running a firewall for a week now. Errors did not show up until yesterday.