Search Results
https://dev.mysql.com/doc/refman/9.7/en/group-replication-responses-failure-exit.html
In these situations, the super_read_only system variable is left with its original value, and the server does not shut down MySQL. The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves ...With this setting, you therefore need to pro-actively monitor the servers for ...Note that in the case of an expelled member, the member does not know that it was expelled until it reconnects to the group, so the specified action is only taken if the member ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-datetime-types-processing.html
If set to "SERVER" then the driver attempts to detect the session time zone from the values configured on the MySQL server session variables 'time_zone' or 'system_time_zone'. This option itself does not set MySQL server session variable 'time_zone' ...Accepts a geographic time zone name or a time zone offset from Greenwich/UTC, using a syntax 'java.time.ZoneId' is able to parse, or one of the two logical values "LOCAL" and ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-datetime-types-processing.html
If set to "SERVER" then the driver attempts to detect the session time zone from the values configured on the MySQL server session variables 'time_zone' or 'system_time_zone'. This option itself does not set MySQL server session variable 'time_zone' ...Accepts a geographic time zone name or a time zone offset from Greenwich/UTC, using a syntax 'java.time.ZoneId' is able to parse, or one of the two logical values "LOCAL" and ...
https://dev.mysql.com/doc/refman/9.7/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user name and the client host or hosts from which the user can connect to the server. There are several distinctions between the way user ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-faq.html
This file represents the InnoDB system tablespace, which grows but never shrinks as a database server operates, and is included in every full and incremental backup. The ibdata1 file in the incremental backups is typically much smaller, containing ... This section lists some common questions about MySQL Enterprise Backup, with answers and pointers to further ...
https://dev.mysql.com/doc/refman/9.7/en/install-component.html
[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...A ...Component names do not include any platform-dependent file name suffix such as .so or ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-use-cases.html
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog-row-events.html
# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== '/*!*/; ... # at 302 ...
https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html
MySQL stores the sql_mode system variable setting in effect when a routine is created or altered, and always executes the routine with this setting in force, regardless of the current server SQL mode when the routine begins executing. The exception ...This behavior can be changed by disabling the automatic_sp_privileges system ...See Section 11.2.5, “Function Name Parsing and Resolution”, for the ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-standard.html
Note The skip_networking MySQL system variable affects the TCP/IP connection method. This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP. Parameters Tab The parameters for standard TCP/IP connections are: ...In ...