Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-2510

LP #1723509: Implement an option which will allow Percona Server to operate as binlog server


    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:


      **Reported in Launchpad by Sveta Smirnova last update 16-10-2017 10:47:36

      Currently if one wants to move read load from main master they should setup intermediary slave. If this is just a slave which receives and applies all updates it may use a lot of resources and require expensive disk, CPU and memory while it needs only good network in order to distribute binary logs further.

      Alternative workaround is to have all tables on this intermediary slave to have engine Blackhole, but this requires manual conversion and also affected by such bugs as lp:1722789

      What I propose here is to create an option: binlog-server, which will tell intermediary slave to connect to master, read its binary logs and store them without updating any table. Then all other slaves can just connect to this server as a master and get binary logs from it.

        Smart Checklist


            Issue Links



                • Assignee:
                  lpjirasync lpjirasync (Inactive)
                • Votes:
                  0 Vote for this issue
                  1 Start watching this issue


                  • Created: