Backing Up Raw Data from a Slave To guarantee the integrity of the files that are copied, backing up the raw data files on your MySQL replication slave should take place while your slave server is shut down. If the MySQL server is still running, background tasks may still be updating the database...
BaseCommandInterceptor The BaseCommandInterceptor class has these methods that you can override: public virtual bool ExecuteScalar(string sql, ref object returnValue); public virtual bool ExecuteNonQuery(string sql, ref int returnValue); public virtual bool ExecuteReader(string sql, CommandBehav...
BaseExceptionInterceptor You develop an exception interceptor first by creating a subclass of the BaseExceptionInterceptor class. You must override the InterceptException() method. You can also override the Init() method to do some one-time initialization. Each exception interceptor has 2 method...
Basic memcached Operations The interface to memcached supports the following methods for storing and retrieving information in the cache, and these are consistent across all the different APIs, although the language specific mechanics might be...
Binary log execution errors and slave_exec_mode. If slave_exec_mode [2028] is IDEMPOTENT, a failure to apply changes from RBL because the original row cannot be found does not trigger an error or cause replication to fail. This means that it is possible that updates are not applied on the slave, ...
Binary logging. MySQL Cluster has the following limitations or restrictions with regard to binary logging: • sql_log_bin [557] has no effect on data operations; however, it is supported for schema operations. • MySQL Cluster cannot produce a binary log for tables having BLOB columns but no prima...
Building MySQL Cluster from Source on Linux This section provides information about compiling MySQL Cluster on Linux and other Unix-like platforms. Building MySQL Cluster from source is similar to building the standard MySQL Server, although it d...
Capturing a Connection with connect_server() When the proxy accepts a connection from a MySQL client, the connect_server() function is called. There are no arguments to the function, but you can use and if necessary manipulate the information in the proxy.connection table, which is unique to eac...
Checkpoint. Generally speaking, when data is saved to disk, it is said that a checkpoint has been reached. More specific to MySQL Cluster, a checkpoint is a point in time where all committed transactions are stored on disk. With regard to the NDB storage engine, there are two types of checkpoints...
Data nodes. A MySQL Cluster data node on a Windows host requires only a single executable, one of either ndbd.exe or ndbmtd.exe. For this example, we assume that you are using ndbd.exe, but the same instructions apply when using ndbmtd.exe. On each computer where you wish to run a data node (the ...
