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
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.
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/.
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!
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.
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?