Our WordPress maintenance support plans 7 installation has served us well using a single, optimised MySQL database server. However, a desire to deliver advanced reporting and dashboards driven by Power BI required us to implement a replicated slave so that Power BI could draw data from a datasource that would not impact the performance of the database serving the website.
Mostly the configuration was straightforward:
Replicate a MySQL 5.5 master into a single MySQL 5.7 slave
Stitchdata tunnels into MySQL slave to access binary logs – Stitchdata requires at least MySQL 5.6, which explains the version difference you…
Source: New feed