MySQL Asynchronous Replication LOad balancing using ProxySQL | Configurations | Testing

Поделиться
HTML-код
  • Опубликовано: 29 ноя 2024
  • In this video, I have explained about the ProxySQL configuration for MySQL Asynchronous Replication. Also, tested Query splitting used for Load balancing.
    If you like the video, please share this with your friends and subscribe my channel for more MySQL and related videos. Any feedback or concerns or comments are always welcome. Thanks!

Комментарии • 25

  • @rahulpardeshi4427
    @rahulpardeshi4427 9 месяцев назад +1

    One of the best video on ProxySQL thank for this social cost.
    If possible please share video on how to setup ProxySQL cluster.

  • @suneeraboobacker5825
    @suneeraboobacker5825 4 месяца назад

    Great explanations.... Thanks a lot Sri

  • @caderotoude3507
    @caderotoude3507 2 года назад

    good job . Everything is well explained

  • @spkdba2297
    @spkdba2297 2 года назад +1

    Awsome videos Sir
    Please provide Cluster setup and performance tuning Sir

  • @basavarajteli8752
    @basavarajteli8752 2 года назад

    This was really helpful... Thank you😊

  • @alemamangeldinov3880
    @alemamangeldinov3880 2 года назад

    Good job! Useful video! Thanks!

  • @Mat-fd1rb
    @Mat-fd1rb 2 года назад

    Such a complete crash course

  • @chandanu2916
    @chandanu2916 2 года назад +1

    Superb , well explained . Could you pls do video on replication setup of both master-master and master-slave.

  • @karthickk9636
    @karthickk9636 2 года назад

    Hi @sri vlogs can u make a video how to make server for practicing.

  • @krishnayadavrayappa9656
    @krishnayadavrayappa9656 2 года назад

    Hi Sir please make more video . We are waiting for ur next videos sir..🙏🙏

  • @krishnayadavrayappa9656
    @krishnayadavrayappa9656 2 года назад

    Sir where r u please do videos..... Really waiting for your video.
    Please sir....🙏

  • @sunil951
    @sunil951 Год назад

    Do we need to add same user again in mysql_users table for reader and writer group ? lilke If I am having 3 node ( 1 - Primary and 2 Secondary ) than ? How many user entry in table required ?

  • @krishnapirlabai9403
    @krishnapirlabai9403 2 года назад

    Superb sir... Really nice teaching... And good real time practice.
    Can you please do video on performance tuning?

  • @sunil951
    @sunil951 Год назад

    This was really helpful... Thank you!!

  • @bnsaisreenivas524
    @bnsaisreenivas524 2 года назад +1

    Please do same kinda video for GTid and group replication

    • @alemamangeldinov3880
      @alemamangeldinov3880 2 года назад +1

      I also wanna video about gtid, i can't understand different between simple replication

    • @hercules7sakthi
      @hercules7sakthi  2 года назад +1

      Will do that soon

  • @prateekmishrapmis7987
    @prateekmishrapmis7987 Год назад

    hey everything has been done but in last proxysql not able to connect to mysql on port 6033 its says access denied

  • @yogeshbansal9489
    @yogeshbansal9489 Год назад

    Hi sir. 1 error is coming in proxysql setup slave hostgroup status showing shunned

  • @fasalmuhammed8417
    @fasalmuhammed8417 2 года назад

    May I know which is better? Normal MySQL Master- Master replica or Galera synchronous Master- Master cluster? If galera is best, then can you do a video of it and how we could distribute queries to each nodes from an application. Thanks ✌️

    • @hercules7sakthi
      @hercules7sakthi  2 года назад

      Actually good point. Will do that. Thank you!

    • @fasalmuhammed8417
      @fasalmuhammed8417 2 года назад

      @@hercules7sakthi Looking forward to that video ✌️

  • @diegofernandopachecoesquiv7049

    on the client I have this: Slave_IO_Running: No
    how do I solve it? :c