Does `Seconds_Behind_Master` show exact Slave Lag from Master?
Does Seconds_Behind_Master always show the correct number of seconds the slave is behind the master? I have also Implemented the mk-heartbeat replication monitoring. … Read more
mysql-5.1
Client to use the slave when the master is down in MySQL replication
Is it possible for the client to use the slave when the master is down in mysql replication? I have already setup a … Read more
mysqldbcompare – ERROR: The list of objects differs among database
I’m running: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.5 (Santiago) # rpm -q mysql-server mysql-server-5.1.73-3.el6_5.x86_64 # and mysql> SELECT VERSION(); … Read more
Speed up slave replication on large database / quickly spawn slave
We have a large MySQL database (about 100GB on disk) that we would like to spawn a slave for. Our typical process for … Read more
MySQL Event does not run
i am running mysql 5.1.41 that came bundled with xampp on windows. the problem is that the event doesnt run automatically even when … Read more
MySQL replication error 1594
Is there a way to restart replication without going over MySQL :: MySQL 5.1 Reference Manual :: 16 Replication. I’m NOT seeing ANY … Read more
Optimized my.cnf for high-end and busy server
Currently my main culprit of poor performance is MySQL and I’m not DB savvy. So far, I’ve had little luck in optimizing MySQL … Read more
Migrating MySQL to new server
We have a MySQL 5.1 instance running on Windows Server 2008 R2 x64 (Server A) replicated to another MySQL 5.1 instance on Windows … Read more
MySQL v5.1.73 – can the binlog_format betweem Master & slave be different?
We are in the process of testing MySQL replication before using it in production. The MySQL is being setup by Puppet in our … Read more
Can a trigger access the query string?
I’m thinking about using triggers as a logging mechanism in MySQL (v. 5.1) and therefore I’d like my trigger to get the query … Read more
