Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
This function replaces the usual primary election process; see Section 20.5.1.1, “Changing the Primary”, for more information. The following function enables you to set a member of a single-primary replication group to take over as the primary.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
Nonetheless, most advanced database management systems have evolved some means of determining the physical location to be used for storing specific pieces of data in terms of the file system, hardware or even both. However, there is nothing ... This ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
Channel specific replication filters are particularly useful in a multi-source replication topology when the same database or table is present on multiple sources, and the replica is only required to replicate it from one source. However, with ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-restore.html
The restore operations restores the data files from a backup to their original locations on the database server, or to other desired locations. Normally, the restoration process requires the database server to be already shut down (or, at least not ...The option datadir must be specified either in the file specified by the --defaults-file option or as a command-line ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. (Bug #44791, Bug #11753361) To simplify the codebase of Connector/J, the IterateBlock class has been removed, with its function replaced by traditional for loops. (Bug #38044940) A java.sql.Time instance created from a negative millisecond value, when inserted into a database via using a PreparedStatement, lost its fractional part of the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
2025-06-25: New Way to List Available GenAI Models MySQL HeatWave GenAI now supports automated discovery and listing of all available in-database and AWS Bedrock LLMs and embedding models starting with MySQL 9.3.2. 2025-05-29: Expanded Support for ... Release Notes 23 Release Notes Release notes for MySQL HeatWave on AWS 2025-08-26: Data Storage Size Can Now Be Increased For Highly Available DB Systems You can now increase the data storage size of a highly available DB System ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The following example shows a simple stored procedure that, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
On Windows, InnoDB always stores database and table names internally in lowercase. To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. MySQL Enterprise Backup The ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. However, it does need to access the MySQL server on which the database to ...Unlike the other utilities discussed in this section, it does not require access to an NDB Cluster (in fact, there is no reason for it to do ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules.html
On the source, you can control which databases to log changes for by using the --binlog-do-db and --binlog-ignore-db options to control binary logging. For a description of the rules that servers use in evaluating these options, see Section ... If a ...