Help for AWS Aurora MySQL Read and Write traffic Split

Discussion in 'Cloud Computing' started by _16256, Jan 8, 2018.

  1. _16256

    _16256 New Member
    Alumni

    Joined:
    Nov 22, 2017
    Messages:
    1
    Likes Received:
    0
    Hi All,

    How can i split the read and write traffic in Amazon Aurora MySQL Database. Like write will go for master and read will go for replica.


    Thanks
     
    #1
  2. Akansha Chaurasia

    Akansha Chaurasia Well-Known Member
    Simplilearn Support

    Joined:
    Jun 2, 2017
    Messages:
    604
    Likes Received:
    38
    Hello,

    You would need an intermediate proxy. The application would then always connect to the proxy, the proxy would then have to do packet inspection to examine each incoming query to determine if it's read-write, which then gets forwarded on to the master, or read-only (depends according to the requirement), which can then get forwarded to any of N replicas.

    Thank you
     
    #2

Share This Page