Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
Description
Hello,
It's many time I asked myself but I never found answer about that, why we cannot find the variable : replicate_rewrite_db in "show global variables" or "show all slaves stauts" <- (should be there)
MariaDB [(none)]> show global variables like '%replicate%'; |
+----------------------------------+-----------+
|
| Variable_name | Value |
|
+----------------------------------+-----------+
|
| replicate_annotate_row_events | ON |
|
| replicate_do_db | |
|
| replicate_do_table | |
|
| replicate_events_marked_for_skip | REPLICATE |
|
| replicate_ignore_db | |
|
| replicate_ignore_table | |
|
| replicate_wild_do_table | |
|
| replicate_wild_ignore_table | |
|
| wsrep_replicate_myisam | OFF |
|
+----------------------------------+-----------+
|
9 rows in set (0.005 sec) |
|
Attachments
Issue Links
- causes
-
-
- Closed
-
- is duplicated by
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- is part of
-
-
- Closed
-
- relates to
-
MDEV-29348 rpl.rpl_rewrt_db test fails with [gdb,manual-gdb] with wrong parsing
-
- Closed
-
- links to
Activity
| Field | Original Value | New Value |
|---|---|---|
| Issue Type | Task [ 3 ] | Bug [ 1 ] |
| Labels | need_feedback |
| Issue Type | Bug [ 1 ] | Task [ 3 ] |
| Priority | Major [ 3 ] | Minor [ 4 ] |
| Labels | need_feedback |
| Component/s | Variables [ 13903 ] | |
| Component/s | Configuration [ 13904 ] |
Hello Elena,
Yes, can you add this to be converted into a feature request for making it a variable.
without this you need reboot server each time, and it's not fair at all when you have many thread of replication.
| Labels | beginner-friendly |
At the moment it's not planned for any specific release (see above, FixVersion is empty). But eventually it will be added.
Hi, I was trying to search through the code base to get a starting point for this fix. I was looking through mysql.cc inside client directory, but don't know if this is a good place to start. Any inputs ?
I'm only getting started with Mariadb codebase so I'd appreciate any help.
sql/mysqld.cc contains the command line options. variables are in sql/sys_vars.cc. Ignore the client directory - its programs like the mysql client, mysqldump etc. Most things you'll need are in sql/.
| Summary | Variable who cannot be find in "show global variables" | Variable replicate_rewrite_db cannot be found in "show global variables" |
| Component/s | Replication [ 10100 ] |
I wonder if there is somebody working on this feature request? If not, I'd like to tackle it.
Nobody is working on it, as far as I can see. Feel free to do it.
Thanks!
| Labels | beginner-friendly |
| Workflow | MariaDB v3 [ 85951 ] | MariaDB v4 [ 130793 ] |
| Link |
This issue is duplicated by |
| Assignee | Anel Husakovic [ anel ] |
| Fix Version/s | 10.11 [ 27614 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Anel Husakovic [ anel ] | Brandon Nesterenko [ JIRAUSER48702 ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Remote Link | This issue links to "PR 2231 (Web Link)" [ 34244 ] |
| Priority | Minor [ 4 ] | Critical [ 2 ] |
| Link |
This issue relates to |
| Assignee | Brandon Nesterenko [ JIRAUSER48702 ] | Anel Husakovic [ anel ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Anel Husakovic [ anel ] | Brandon Nesterenko [ JIRAUSER48702 ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | In Testing [ 10301 ] |
| Assignee | Brandon Nesterenko [ JIRAUSER48702 ] | Angelique Sklavounos [ JIRAUSER50741 ] |
| Link |
This issue is part of |
SHOW SLAVE STATUS currently (10.11<=) doesn't output replicate_rewrite_db.
With this patch we should support also that replicate_rewrite_db can be shown in show slave status command output.
| Link |
This issue causes |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Assignee | Angelique Sklavounos [ JIRAUSER50741 ] | Brandon Nesterenko [ JIRAUSER48702 ] |
| Assignee | Brandon Nesterenko [ JIRAUSER48702 ] | Anel Husakovic [ anel ] |
| issue.field.resolutiondate | 2022-10-21 20:51:06.0 | 2022-10-21 20:51:06.468 |
| Fix Version/s | 10.11.1 [ 28454 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link |
This issue is duplicated by |
| Labels | Preview_10.11 |
That's because it's not a variable, it's a command-line option only.
https://mariadb.com/kb/en/library/replication-and-binary-log-server-system-variables/#replicate_rewrite_db
Do you want it to be converted into a feature request for making it a variable?