You can locate the sql clause code like /usr/bin/mysqlbinlog -v –start-position=142743807 –stop-position=147399325 /data/mysql/data/master-bin.000010 > temp.log Then compare slave and master database difference according to temp.log on specific pos. Then update slave database. Then skip that line with mysql -e “stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;”;
TL;DR STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; START SLAVE; Now the slightly longer version: if you have manually created the user on your slave first and on your master second, the CREATE USER command executed on the master has been replicated to the slave. Attempted subsequent execution of the statement failed, because the user … Read more
Due to a reasonably long delay with no answers, I have found out by trial and error. The answer is : Yes, I can run mysqld on top of glusterfs. I set this up on Ubuntu and briefly here are the steps: Install Ubuntu Install and configure glusterfs Install mysql-server Configure /etc/mysql/my.cnf to set datadir … Read more
What to try to fix your problem: You should remove master.info on slave first and restart mysql issue CHANGE MASTER TO MASTER_HOST=’XX.XX.XX.XX’, MASTER_USER=’repl’, MASTER_PASSWORD=’slavepass’; do mysqldump with ‘–flush-logs’ option on master ‘mysql -u user -p < dump.sql’ on slave ‘show slave status\G’ on slave to ensure that it is properly configured, MASTER_LOG_POS is 0 ‘start … Read more
I assume you use InnoDB as a storage engine. If so, you need to turn on bin-logging. If it’s not on now, you need to restart MySQL after modifying my.cnf. It is the only downtime, after which you can take dump of the database with binlog position without blocking the database: mysqldump –skip-lock-tables –single-transaction –flush-logs … Read more
Enable the read-only option in my.cnf. It can also be specified as a flag on the command line using –read-only with mysqld.
It is entirely possible to give yourself mysql permissions without knowing SQL GRANT commands. Example : Here is to create your own user with full privileges using SQL GRANT from anywhere called superdba with a password of ClarkKent: GRANT ALL PRIVILEGES ON *.* TO superdba@’%’ IDENTIFIED BY ‘ClarkKent’ WITH GRANT OPTION; Here is how you … Read more
This is how i did it for both masters log-bin = mysqld-bin binlog-ignore-db=test binlog-ignore-db=information_schema binlog-ignore-db=mysql log-slave-updates replicate-ignore-db=test replicate-ignore-db=information_schema replicate-ignore-db=mysql relay-log=mysqld-relay-bin
The binlog on DB2 wasn’t updating the slave updates. To daisy chain the replication, one must set log-slave-updates in my.conf. http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates
Do not mess with the mysql db. There is a lot more going on there than just the users table. Your best bet is the “SHOW GRANTS FOR” command. I have a lot of CLI maintenance aliases and functions in my .bashrc (actually my .bash_aliases that I source in my .bashrc). This function: mygrants() { … Read more