ALTER PUBLICATION

Syntax description

ALTER PUBLICATION modifies the publication content.

Grammar structure

ALTER PUBLICATION pubname 
    [ACCOUNT 
            { ALL
            | account_name, [, ... ]
            | ADD account_name, [, ... ]
            | DROP account_name, [, ... ]]
    [COMMENT 'string']
    [DATABASE database_name]
    [TAble table_name]

Grammar explanation

-pubname: Existing publication name. -account_name: The tenant name of the publication can be obtained. -database_name: The name of the publishing library to be modified.

示例

create account acc0 admin_name 'root' identified by '111';
create account acc1 admin_name 'root' identified by '111';
create account acc2 admin_name 'root' identified by '111';
create database t;
create publication pub3 database t account acc0,acc1;

alter publication pub3 account add acc2;--Modify release scope
mysql> show create publication pub3;
+-------------+-----------------------------------------------------------+
| Publication | Create Publication                                        |
+-------------+-----------------------------------------------------------+
| pub3        | CREATE PUBLICATION pub3 DATABASE t ACCOUNT acc0,acc1,acc2 |
+-------------+-----------------------------------------------------------+
1 row in set (0.01 sec)

mysql> show publications;
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+----------+
| publication | database | tables | sub_account    | subscribed_accounts | create_time         | update_time         | comments |
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+----------+
| pub3        | t        | *      | acc0,acc1,acc2 |                     | 2024-10-28 11:20:20 | 2024-10-28 11:20:43 |          |
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+----------+
1 row in set (0.00 sec)

alter publication pub3  comment "this is pubs";--Modify release notes
mysql> show publications;
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+--------------+
| publication | database | tables | sub_account    | subscribed_accounts | create_time         | update_time         | comments     |
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+--------------+
| pub3        | t        | *      | acc0,acc1,acc2 |                     | 2024-10-28 11:20:20 | 2024-10-28 11:21:28 | this is pubs |
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+--------------+
1 row in set (0.00 sec)

create database new_pub3;
alter publication pub3 database new_pub3;--Modify publishing database
mysql> show publications;
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+--------------+
| publication | database | tables | sub_account    | subscribed_accounts | create_time         | update_time         | comments     |
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+--------------+
| pub3        | new_pub3 | *      | acc0,acc1,acc2 |                     | 2024-10-28 11:20:20 | 2024-10-28 11:21:44 | this is pubs |
+-------------+----------+--------+----------------+---------------------+---------------------+---------------------+--------------+
1 row in set (0.00 sec)