Skip to content
logo
Percona Distribution for MySQL
Architecture and components
Initializing search
    /percona/pdmysql-docs
    /percona/pdmysql-docs
    • Home
      • Components
      • Deployment variants
      • Install Percona Distribution for MySQL
      • Upgrade Percona Distribution for MySQL
      • Downgrade Percona Distribution for MySQL
      • Technical overview
      • Architecture and components
        • Architecture layout
          • Components
      • Measurement and monitoring
      • Deployment
      • Replication manager for Percona XtraDB Cluster
      • Replication manager troubleshooting
      • Single replica manager for Percona XtraDB Cluster
      • Uninstalling Percona Distribution for MySQL
      • Release notes index
      • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL Update (2023-03-28)
      • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster Update (2023-03-28)
      • Percona Distribution for MySQL 8.0.32 using Percona Server for MySQL (2023-03-20)
      • Percona Distribution for MySQL 8.0.31 using Percona XtraDB Cluster (2023-03-15)
      • Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL Update (2023-02-15)
      • Percona Distribution for MySQL 8.0.31 using Percona Server for MySQL (2023-02-09)
      • Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster Update (2023-01-23)
      • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL Second Update (2023-01-23)
      • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL Update (2023-01-06)
      • Percona Distribution for MySQL 8.0.30 using Percona XtraDB Cluster (2022-12-28)
      • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster Update (2022-12-01)
      • Percona Distribution for MySQL 8.0.30 using Percona Server for MySQL (2022-11-29)
      • Percona Distribution for MySQL 8.0.29 using Percona XtraDB Cluster (2022-09-12)
      • Percona Distribution for MySQL 8.0.29 using Percona Server for MySQL (2022-08-09)
      • Percona Distribution for MySQL 8.0.28 using Percona XtraDB Cluster (2022-07-19)
      • Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL Update (2022-06-20)
      • Percona Distribution for MySQL 8.0.28 using Percona Server for MySQL (2022-05-12)
      • Percona Distribution for MySQL 8.0.27 using Percona XtraDB Cluster (2022-04-11)
      • Percona Distribution for MySQL 8.0.27 using Percona Server for MySQL (2022-03-03)
      • Percona Distribution for MySQL 8.0.26 using Percona XtraDB Cluster (2022-01-17)
      • Percona Distribution for MySQL 8.0.26 using Percona Server for MySQL (2021-10-20)
      • Percona Distribution for MySQL 8.0.25 using Percona XtraDB Cluster (2021-11-22)
      • Percona Distribution for MySQL 8.0.25 using Percona Server for MySQL (2021-07-13)
      • Percona Distribution for MySQL 8.0.23 using *Percona XtraDB Cluster* Update (2021-09-15)
      • Percona Distribution for MySQL 8.0.23 using Percona XtraDB Cluster (2021-06-09)
      • Percona Distribution for MySQL 8.0.23 using Percona Server for MySQL (2021-05-12)
      • Percona Distribution for MySQL 8.0.22 using Percona XtraDB Cluster (2021-03-22)
      • Percona Distribution for MySQL 8.0.22 using Percona Server for MySQL (2020-12-14)
      • Percona Distribution for MySQL 8.0.21 using Percona XtraDB Cluster (2020-12-28)
      • Percona Distribution for MySQL 8.0.21 using Percona Server for MySQL (2020-10-13)
      • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster Second Update (2020-10-22)
      • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster Update (2020-10-09)
      • Percona Distribution for MySQL 8.0.20 using Percona XtraDB Cluster (2020-10-01)
      • Percona Distribution for MySQL 8.0.20 using Percona Server for MySQL (2020-07-21)
      • Percona Distribution for MySQL 8.0.19 (2020-06-22)
      • Copyright and Licensing Information
      • Trademark Policy
      • Glossary

    • Architecture layout
      • Components

    Architecture and components¶

    The following is the architecture layout for Percona Server for MySQL based deployment variant of Percona Distribution for MySQL with Group Replication.

    Architecture layout¶

    image

    Components¶

    The architecture is composed of two main layers:

    • Connection and distribution layer

    • Relational Database Management System (RDBMS) layer

    Connection and distribution layer¶

    The connection and distribution layer consists of the following:

    • Application to proxy redirection mechanism. This mechanism can be anything from a Virtual IP managed by Keepalived local service to a DNS resolution service like Amazon Route 53. The mechanism’s function is to redirect the traffic to the active Proxy node.

    • Proxy connection distribution. The distribution consists of two or more nodes and its role is to redirect the traffic to the active nodes of the Group Replication cluster. In cases like ProxySQL where the proxy is a level 7 proxy and can perform a read / write split, this layer is also in charge of redirecting writes to the Primary node and reads to the replicas, and of high availability to prevent a single point of failure.

    RDBMS layer¶

    The data layer consists of the following:

    • Primary (or source) node serving write requests. This is the node that accepts writes and DDL modifications. Data will be processed following the ACID (atomicity, consistency, isolation, durability) model and replicated to all other nodes.

    • Replica nodes serving read requests. Some replica nodes can be elected Primary in case of the Primary node’s failure. A replica node should be able to leave and join back to a healthy cluster without impacting the service.

    • Replication mechanism distributing changes across nodes. In this solution, it is done with Group Replication. Group Replication is a tightly coupled solution, which means that the database cluster is based on a Datacentric approach (single state of the data, distributed commit). In this case, the data is consistent in time across nodes though this type of replication requires a high performant link. Given that, the main Group Replication mechanism does not implicitly support Disaster Recovery (DR) and geographic distribution is not permitted.

    The node characteristics such as CPU/RAM/Storage are not relevant to the solution design. They must reflect the estimated workload that the solution will have to cover, and this is a case by case identification.

    However, it is important that all nodes that are part of the cluster must have the same characteristics. Otherwise, the cluster is imbalanced and services will be affected.

    As a generic indication we recommend using nodes with at least 8 cores and 16GB RAM when in production.

    Contact us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: 2023-03-28
    Percona LLC and/or its affiliates, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.