Slave SQL thread. The slave creates an SQL thread to read the relay log that is written by the slave I/O thread and execute the events contained therein. In the preceding description, there are three threads per master/slave connection. A master that has multiple slaves creates one binlog dump th...
Slave Status Logs A replication slave server creates two logs. By default, these logs are files named master.info and relay-log.info and created in the data directory. The names and locations of these files can be changed by using the --master-info-file [2006] and --relay-log-info-file [2008] op...
Space Needed for Keys MyISAM tables use B-tree indexes. You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. This is for the worst case when all keys are inserted in sorted order and the table doesn'...
SQL nodes. On each machine to be used for hosting a cluster SQL node, install the server RPM by executing the following command as the system root user, replacing the name shown for the RPM as n...
SQL nodes. If you compile MySQL with clustering support, and perform the default installation (using make install as the system root user), mysqld is placed in /usr/local/mysql/bin. Follow the steps given in Section 2.9, “Installing MySQL from
SQL node. We assume that you have placed a copy of the no-install archive in the directory C:\Documents and Settings\username\My Documents\Downloads on the computer having the IP address 192.168.0.20, where username is the name of the current user. (You can obtain this name using ECHO %USERNAME% ...
SQL nodes. On each of the machines designated to host SQL nodes, perform the following steps as the system root user: 1. Check your /etc/passwd and /etc/group files (or use whatever tools are provided by your operating system for managing users and g...
Stage Event Consumers These consumers require both global_instrumentation and thread_instrumentation to be YES or they are not checked. • events_stages_current, if NO, disables collection of individual stage events in the events_stages_current table. If YES, it enables stage event collection and...
Standard MySQL clients. MySQL Cluster can be used with existing MySQL applications written in PHP, Perl, C, C++, Java, Python, Ruby, and so on. Such client applications send SQL statements to and receive responses from MySQL servers acting as MySQL Cluster SQL nodes in much the same way that they...
Starting the MySQL Cluster Auto-Installer The Auto-Installer is provided together with the MySQL Cluster software. (See Section 17.2, “MySQL Cluster Installation”.) The present section explains how to start the installer. You can do by invoking the ndb_setup.py executable. ndb_setup.py is found i...
