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

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

    XMLWordPrintable

    Details

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

      Description

      **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

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated: