Page History

...

• We will rely on Mysql's Connector properties to achieve Master-Master DB HA
  • Look at the following link to know the parameters used to achieve HA using mysql connector
    http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
• We need to have at least 2 nodes which are connected through 2-way replication and should be consecutive in connector's url
  • look at the following urlss to setup Mysql replication
    http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
    https://wikis.oracle.com/display/CommSuite/MySQL+High+Availability+and+Replication+Information+For+Calendar+Server
    
• It is recommended to use semi-replicaiton over asynchronous replication to avoid data inconsistency issues during master server crash(Asynchronous replication will not guarantee the date sync between master and slave before master crashes where as semi-synchronous will guarantee 99% of data sync between master and slave).
• The following configuration need to be done in my.cnf of each mysql server to clean up bin log files automatically.
  

  expire_logs_days=10 (Number of days to keep the bin log files)

  max_binlog_size=100M (The max size of each bin log file)

• To change the bin log files location please use the following property in my.cnf of each mysql server
  log-bin=/var/lib/mysql/binlog/bin-log  (Remember here “bin-log” is the file prefix)

...