abhilashthale.com
  • Home
  • BlogCategories
    • coding
    • other
    • n
  • Images to Pdf
  • My Files
  • Shares Average
  • About Me
  • Day
  • Night
  • Birds
  • Waves
  • Net
  • Dots
  • Halo
  • Rings
  • Fog
  • Clouds

    Create Replication Mysql

    by abhilash - Oct. 7, 2025

    mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql

    In 8.4 Community, the host cache is managed internally.
    FLUSH HOST DEPRICATED --> SELECT * FROM performance_schema.host_cache;


    CREATE USER 'repl'@'%' IDENTIFIED BY 'password';
    GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
    FLUSH PRIVILEGES;

    CHANGE REPLICATION SOURCE TO
      SOURCE_HOST='192.168.241.101',
      SOURCE_USER='repl',
      SOURCE_PASSWORD='password',
      SOURCE_PORT=3360,
      SOURCE_AUTO_POSITION=1,
      SOURCE_SSL=1,
      SOURCE_SSL_CA='/data/ca.pem';

     

     

    slave my.cnf

     


    [mysqld]
    datadir=/data/mysql_server
    socket=/var/lib/mysql/mysql.sock
    log-error=/data/mysql_server/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    server-id=2
    log_bin=mysql-bin
    binlog_format=ROW
    gtid_mode=ON
    enforce_gtid_consistency=ON
    get_source_public_key=1

    port=3360
    user=mysql
    symbolic-links=0

    # Connection limits (safe for low-memory VM)
    max_connections=50
    max_user_connections=50

    # Packet and temporary table sizes
    max_allowed_packet=16M
    tmp_table_size=32M
    max_heap_table_size=32M

    # Sorting and read buffers (per connection, smaller for low RAM)
    sort_buffer_size=2M
    read_buffer_size=2M
    read_rnd_buffer_size=4M
    join_buffer_size=2M

    # Storage engine
    default-storage-engine=InnoDB
    key_buffer_size=8M
    bulk_insert_buffer_size=8M

    # InnoDB settings for small memory
    innodb_log_file_size=32M
    innodb_print_all_deadlocks=1
    innodb_buffer_pool_instances=1
    innodb_buffer_pool_size=512M
    innodb_read_io_threads=4
    innodb_write_io_threads=4
    innodb_thread_concurrency=0
    innodb_io_capacity=100
    innodb_log_buffer_size=8M
    innodb_flush_log_at_trx_commit=2
    innodb_lock_wait_timeout=50

    # Transaction isolation
    transaction-isolation=READ-COMMITTED

    [root@node2 data]#
     

    ============================

     

    master my.cnf

     


    [mysqld]
    datadir=/data/mysql_server
    socket=/var/lib/mysql/mysql.sock
    log-error=/data/mysql_server/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    server-id=1
    log_bin=mysql-bin
    binlog_format=ROW
    gtid_mode=ON
    enforce_gtid_consistency=ON

    plugin-load-add=mysql_native_password.so

    port=3360
    user=mysql
    symbolic-links=0

    # Connection limits (safe for low-memory VM)
    max_connections=50
    max_user_connections=50

    # Packet and temporary table sizes
    max_allowed_packet=16M
    tmp_table_size=32M
    max_heap_table_size=32M

    # Sorting and read buffers (per connection, smaller for low RAM)
    sort_buffer_size=2M
    read_buffer_size=2M
    read_rnd_buffer_size=4M
    join_buffer_size=2M

    # Storage engine
    default-storage-engine=InnoDB
    key_buffer_size=8M
    bulk_insert_buffer_size=8M

    # InnoDB settings for small memory
    innodb_log_file_size=32M
    innodb_print_all_deadlocks=1
    innodb_buffer_pool_instances=1
    innodb_buffer_pool_size=512M
    innodb_read_io_threads=4
    innodb_write_io_threads=4
    innodb_thread_concurrency=0
    innodb_io_capacity=100
    innodb_log_buffer_size=8M
    innodb_flush_log_at_trx_commit=2
    innodb_lock_wait_timeout=50

    # Transaction isolation
    transaction-isolation=READ-COMMITTED
     

     

abhilashthale.com