Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

for AWS Aurora users and when using a DB Reader: new INI setting to enable aurora read replica read committed for fixing purge lag performance issue #17718

Merged
merged 1 commit into from Jun 29, 2021

Conversation

justinvelluppillai
Copy link
Contributor

Description:

Allows enabling aurora read replica read committed

Review

  • Functional review done
  • Potential edge cases thought about (behavior of the code with strange input, with strange internal state or possible interactions with other Matomo subsystems)
  • Usability review done (is anything maybe unclear or think about anything that would cause people to reach out to support)
  • Security review done see checklist
  • Code review done
  • Tests were added if useful/possible
  • Reviewed for breaking changes
  • Developer changelog updated if needed
  • Documentation added if needed
  • Existing documentation updated if needed

@justinvelluppillai justinvelluppillai added the Needs Review PRs that need a code review label Jun 28, 2021
@justinvelluppillai justinvelluppillai added this to the 4.4.0 milestone Jun 28, 2021
@justinvelluppillai justinvelluppillai marked this pull request as ready for review June 28, 2021 23:57
@diosmosis diosmosis merged commit 163445b into 4.x-dev Jun 29, 2021
@diosmosis diosmosis deleted the dev-2193 branch June 29, 2021 05:20
@@ -184,6 +184,10 @@ public static function createReaderDatabaseObject($dbConfig = null)

$db = @Adapter::factory($dbConfig['adapter'], $dbConfig);

if (!empty($dbConfig['aurora_readonly_read_committed'])) {
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

fyi we might still want to update global.ini.php here maybe @justinvelluppillai @diosmosis ?

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Do we want to document the setting?

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I reckon it be good. Even if it's just useful mostly for us but then other devs will know what it's about.

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I'll document and create a new pull request to add the global.ini.php update

@mattab mattab changed the title Allow enabling aurora read replica read committed for AWS Aurora users and when using a DB Reader: new INI setting to enable aurora read replica read committed for fixing purge lag performance issue Jul 27, 2021
@mattab mattab added the c: Performance For when we could improve the performance / speed of Matomo. label Jul 27, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c: Performance For when we could improve the performance / speed of Matomo. Needs Review PRs that need a code review
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

4 participants