Replication | Forum profile

7 vs 10: mine was 5.1; probably new features. missing sql_log_bin; frankly I was surprised to see it in SHOW VARIABLES, so I don't think that is the problem. This says to replicate only the one database: Binlog_Do_DB: bdgranada But if you do USE foo; INSERT INTO bdgranda.tbl ... The INSERT won't be replicated. This is because Binlog_Do_DB reacts to USE, not the actual database being used.

I was indeed able to back-up the users and user_info tables from the master's mysql schema and then restore them to the slave. After restarting the service it appears that my replication is working. I've created and entirely new schema on the master and it immediately appeared on the slave (well as fast as I could hit refresh anyway).

Hi Rick, I have installed MySQL 4.0.13. But I couldn't found the my.ini file anywhere. I am trying to make a setup for switchover /fail over. I cerated my.ini file on "C:\my.ini" with content as [mysqld] basedir="C:/mysql/" datadir="C:/mysql/Data/" binlog-do-db=mysql_repl server-id=1 log-bin="C:/MySQL_Binary_Log/" Is this the correct way to create my.ini file? After...

Thanks for your answers. I've checked that on master and 'log_bin' is on, but it returns only seven rows to me, not ten like you, don't know if it's my MySQL version (community server 5.0.45) or my OS, or what. Anyway, this is the complete output that i recieve binlog_cache_size: 32768 innodb_locks_usnafe_for_binlog: OFF log_bin: ON log_bin_trust_functions_creators: OFF max_binlog_cache_size: 4294967295...

I found it, so topic closed, with the following : SHOW VARIABLES LIKE 'binlog_format%'; I can see which binary log type is used, statement, row, or mixed based. greetings, Jo

Hi, I have a strange pb on one of my shard. The replication is broken and a slave status give me: Last_Error: Error in Append_block event: could not open file '/data/tmp/SQL_LOAD-15089-10065-34673.data' It is weird because in /data/tmp/ I have another file: [root@mysql5 mysql]# ll /data/tmp/ total 167472 -rw-rw-rw- 1 mysql mysql 171491328 Nov 26 11:37 SQL_LOAD-15089-10065-34674.data Any idea to skip this? I have already made some...

Dear Rick, I am really thankful to you for replying to my post. I have sorted out the issue and I could see the circular replication works well but suddenly got following error on one slave so its can't get new data from master but other does. Please find error below and do let me know if there is any configuration to avoid this or how to resolve this. =================================================================================...

Excellent advice. I agree strongly and will continue to master-master in only certain scenarios.

Hi, Is there a way to use push replication (master pushes updates to slaves) in mysql? Or is there a 3rd party software that you can suggest? My firewall configuration restricts me to use pull replication (ie slaves connects to master ) Regards.