0

I have a master - server replication setup in Linux servers.

Master Configuration details :

 MySQL version is 5.1 and replication mode is MIXED type.

Slave Configuration details :

 MySQL version is 5.6

If i insert single record , then it is getting replicated to slave.

When i am running a script to insert thousand of records at master , it is not getting replicated.

When i see the size of binary log file , it is of 908 MB and when i see the size of relay log file , it is 560 KB.

Does , size of a binary log file matters ?
or what is the probable cause of this.

Below is master cnf details :

  [mysqld]

  datadir=/var/lib/mysql
  socket=/var/lib/mysql/mysql.sock
  user=mysql
  # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    bind-address = #master IP# ( not showing here )
    port=3306
    wait_timeout=90
    net_read_timeout=90
    connect_timeout=90
    max_connections=100
    lower_case_table_names=1
    log-bin=mysql-bin
    binlog_format=MIXED
    server-id=1

[mysqld_safe]
     log-error=/var/log/mysqld.log
     pid-file=/var/run/mysqld/mysqld.pid
4
  • 1
    post show slave status output of slave.
    – mysql_user
    Nov 26 '15 at 11:52
  • Do any records at all get replicated when you run the script? Can you please give more detail about how you are running the script? Nov 26 '15 at 12:08
  • when running the script at master end , not even a single record is replicating , yes but when i just insert one record manually , it get replicate. Script are designed to take data from Oracle and insert it into MySQL database. In this script every table of oracle is mapped with MySQL table and insertion takes place in the Master database. Nov 26 '15 at 12:38
  • An insert is an insert whether it happens from a script or the console manually. Please show in your question how you are running the script or what is in it. Nov 26 '15 at 14:46
-1

I have resolved the issue myself only using following process :

  1. Change the replication mode to ROW.
  2. Restrict the size of max_binlog_size=30M

In this way binary log file cant be of huge size and easy to replicate.

3
  • The size of the binlog has no impact on ease of replication. Reads are done from where it left off.
    – Rick James
    Dec 14 '15 at 0:45
  • 1
    Switching to ROW may be advisable, but won't solve the OP's problem, except by coincidence.
    – Rick James
    Dec 14 '15 at 0:46
  • its 2 year old question of mine and when i read it now , i wonder how foolish i was that i have posted an incomplete question . I should had given complete information .lol Feb 7 '18 at 13:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.