PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
For each group member in turn, in any order: Connect a client to the group member. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
This ensures that in a situation as described previously, when client C1 is reconnected to the new primary it reads A=2. This means that a client C2 can write B=2 WHERE B=1 on the primary, immediately connect to a secondary and read B=1. Any ... In ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-use-cases.html
It is important to understand that although the database service is available, in the event of an unexpected server exit, those clients connected to it must be redirected, or failed over, to a different server. A connector, load balancer, router, or ... Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
For state transfer from a donor's binary log, a connection is established between the joining member and the donor and state transfer begins. Figure 20.11 Queued Transactions Finish: Caught Up When the server joining the group recognizes a view ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication.html
However, it is important to understand that if one of the group members becomes unavailable, the clients connected to that group member must be redirected, or failed over, to a different server in the group, using a connector, load balancer, router, ... This chapter explains MySQL Group Replication and how to install, configure and monitor ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. Grouping DML Operations with Transactions By default, connection to the ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range queries. Multiple get Operations The ability to fetch multiple key-value pairs in a single memcached query ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
$> python multicol.py If successful, the sample application returns this output: Connected to memcached. The data is available for MySQL queries, which demonstrates how the same data can be accessed using SQL or through applications (using the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
FOR EXPORT must remain open while the operation is running; otherwise, the .cfg file is removed as locks are released upon connection closure. This section describes how to import tables using the Transportable Tablespaces feature, which permits ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
A user can change the isolation level for a single session or for all subsequent connections with the SET TRANSACTION statement. To set the server's default isolation level for all connections, use the --transaction-isolation option on the command ... Transaction isolation is one of the foundations of database ...