This is really dangerous feature with really rarely usage.
Can you please describe the use-case where you REALLY requires this?
May be I omited some usefull scenarios, but from my point of view this
feature not very usefull and better to include another or RBR features
(and so spend time to it instead of this feature).
On Wed, Nov 2, 2011 at 9:25 AM, Adam Wróbel <email address hidden> wrote:
> when this will be available in the 5.5 series? This feature is critical
> for replication.
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https://bugs.launchpad.net/bugs/882988
>
> Title:
> Unknown system variable sql_slave_statement_skip_counter
>
> Status in Percona Server with XtraDB:
> New
>
> Bug description:
> mysql> SHOW VARIABLES LIKE "%version%";
> +-------------------------+-----------------------------------------------------+
> | Variable_name | Value |
> +-------------------------+-----------------------------------------------------+
> | innodb_version | 1.1.8-20.1 |
> | protocol_version | 10 |
> | slave_type_conversions | |
> | version | 5.5.16-55-log |
> | version_comment | Percona Server (GPL), Release rel22.0, Revision 189 |
> | version_compile_machine | x86_64 |
> | version_compile_os | Linux |
> +-------------------------+-----------------------------------------------------+
> 7 rows in set (0.00 sec)
>
>
> mysql> set global sql_slave_statement_skip_counter=1;
> ERROR 1193 (HY000): Unknown system variable 'sql_slave_statement_skip_counter'
>
> http://www.percona.com/doc/percona-
> server/5.5/flexibility/replication_skip_single_statement.html?id
> =percona-
> server:features:replication_skip_single_statement&redirect=1#sql_slave_statement_skip_counter
>
> This variable doesn't work?
>
> I have enable:
> server-id=2
> relay-log=mysqld-relay-bin
> plugin-load=rpl_semi_sync_master=semisync_master.so
> plugin-load=rpl_semi_sync_slave=semisync_slave.so
> rpl_semi_sync_master_enabled=1
> rpl_semi_sync_slave_enabled=1
> binlog_format=row
>
> log-bin = /var/mysql/mysql_binlog/bin.log
> log-slave-updates
> log-bin-index = /var/mysql/mysql_binlog/log-bin.index
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-server/+bug/882988/+subscriptions
>
This is really dangerous feature with really rarely usage.
Can you please describe the use-case where you REALLY requires this?
May be I omited some usefull scenarios, but from my point of view this
feature not very usefull and better to include another or RBR features
(and so spend time to it instead of this feature).
On Wed, Nov 2, 2011 at 9:25 AM, Adam Wróbel <email address hidden> wrote: /bugs.launchpad .net/bugs/ 882988 statement_ skip_counter ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ---+ ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ---+ conversions | | compile_ machine | x86_64 | ------- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ---+ statement_ skip_counter= 1; statement_ skip_counter' www.percona. com/doc/ percona- 5.5/flexibility /replication_ skip_single_ statement. html?id features: replication_ skip_single_ statement& redirect= 1#sql_slave_ statement_ skip_counter mysqld- relay-bin load=rpl_ semi_sync_ master= semisync_ master. so load=rpl_ semi_sync_ slave=semisync_ slave.so sync_master_ enabled= 1 sync_slave_ enabled= 1 mysql_binlog/ bin.log mysql_binlog/ log-bin. index /bugs.launchpad .net/percona- server/ +bug/882988/ +subscriptions
> when this will be available in the 5.5 series? This feature is critical
> for replication.
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https:/
>
> Title:
> Unknown system variable sql_slave_
>
> Status in Percona Server with XtraDB:
> New
>
> Bug description:
> mysql> SHOW VARIABLES LIKE "%version%";
> +------
> | Variable_name | Value |
> +------
> | innodb_version | 1.1.8-20.1 |
> | protocol_version | 10 |
> | slave_type_
> | version | 5.5.16-55-log |
> | version_comment | Percona Server (GPL), Release rel22.0, Revision 189 |
> | version_
> | version_compile_os | Linux |
> +------
> 7 rows in set (0.00 sec)
>
>
> mysql> set global sql_slave_
> ERROR 1193 (HY000): Unknown system variable 'sql_slave_
>
> http://
> server/
> =percona-
> server:
>
> This variable doesn't work?
>
> I have enable:
> server-id=2
> relay-log=
> plugin-
> plugin-
> rpl_semi_
> rpl_semi_
> binlog_format=row
>
> log-bin = /var/mysql/
> log-slave-updates
> log-bin-index = /var/mysql/
>
> To manage notifications about this bug go to:
> https:/
>
--
Oleg Tsarev, Software Engineer, Percona Inc.