content_image/872306.jpg
## 17.5.1.15 Replication and Fractional Seconds Support 

MySQL 8.0 permits fractional seconds for TIME , DATETIME , and TIMESTAMP  values, with up to microseconds (6 digits) precision. See Section 11.2.6, “Fractional Seconds in Time Values” . 

## 17.5.1.16 Replication of Invoked Features 

Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: 

•The effects of the feature are always replicated. 

•The following statements are replicated using statement-based replication: 

• CREATE EVENT 

• ALTER EVENT 

• DROP EVENT 

• CREATE PROCEDURE 

• DROP PROCEDURE 

• CREATE FUNCTION 

• DROP FUNCTION 

• CREATE TRIGGER 

• DROP TRIGGER 

However, the effects  of features created, modified, or dropped using these statements are replicated using row-based replication. 

<img src='content_image/872306.jpg'>

• In the case of CREATE EVENT  and ALTER EVENT : 

## Note 

Attempting to replicate invoked features using statement-based replication produces the warning Statement is not safe to log in statement format . For example, trying to replicate a loadable function with statement- based replication generates this warning because it currently cannot be determined by the MySQL server whether the function is deterministic. If you are absolutely certain that the invoked feature’s effects are deterministic, you can safely disregard such warnings. 

•The status of the event is set to SLAVESIDE_DISABLED  on the replica regardless of the state specified (this does not apply to DROP EVENT ). 

•The source on which the event was created is identified on the replica by its server ID. The ORIGINATOR  column in INFORMATION_SCHEMA.EVENTS  stores this information. See Section 26.3.14, “The INFORMATION_SCHEMA EVENTS Table” , and Section 13.7.7.18, “SHOW EVENTS Statement” , for more information. 

•The feature implementation resides on the replica in a renewable state so that if the source fails, the replica can be used as the source without loss of event processing. 

