MySQL-Max: The MySQL-Max server is a version of the MySQL mysqld server compiled to add additional features.
Summary
[ hide ]
- 1 Distribution to use
- 2 MySQL AB
- 3 Advantages
- 4 Support for DBD and NBD Cluster
- 5 mysqld_safe script
- 6 Source
Distribution to use
The distribution to use depends on the platform:
- For Windows, MySQL binary distributions include both servers (mysqld.exe) and MySQL-Max server (mysqld-max.exe), so there is no need to purchase any special distributions.
- For Linux, MySQL is installed using an RPM distribution , the MySQL-server RPM can be used first to install a standard version of the server called mysqld . Next, the MySQL-Max RPM should be used to install the server called mysqld-max.
All other MySQL-Max distributions contain a single server called mysqld but which has the additional features included.
MySQL AB
MySQL AB compiles the MySQL-Max server using the following configure options: – with-server-suffix = -max : This option adds a suffix -max to the mysqld character string of the version.
– with-innodb: This option activates support for the InnoDB storage engine . MySQL-Max servers always include support for InnoDB . From MySQL 4.0 onwards, InnoDB is included by default in all binary distributions, so you don’t need a MySQL-Max server just to get support for InnoDB .
– with-bdb: This option enables support for the Berkeley DB Storage Engine ( BDB ).
USE_SYMDIR: This definition is turned on to enable support for symbolic links in Windows . In MySQL 5.0, support for symbolic links is available for all Windows servers , so a Max server is not necessary to take advantage of this feature.
– with-ndb-cluster: This option enables support for the NDB Cluster storage engine . The Cluster is currently supported on Linux , Solaris , and Mac OS X only.
Advantage
- MySQL-Max binary distributions are useful for those who want to install precompiled programs. If MySQLis compiled from a source distribution, you can build a Max-style server by activating the same configuration-time features that MySQL-Max binary distributions use when creating them.
- MySQL-Max servers include the BerkeleyDB ( BDB) storage engine when possible, but not all platforms support BDB .
- MySQL-Max servers for Solaris, Mac OS X , and Linux (on most platforms) include support for the NDB Cluster storage engine .
DBD and NBD Cluster support
The following table shows on which platforms the MySQL-Max binaries include support for BDB and / or NDB Cluster:
Mysqld_safe script
Mysqld_safe is the recommended way to start mysqld a server on Unix and NetWare . Mysqld_safe adds some security features like restarting the server when an error occurs and saving the information at runtime in an error log. By default, mysqld_safe tries to launch an executable called mysqld-max if it exists, or mysqld otherwise. The implications of this behavior must be considered:
- On Linux, the MySQL-Max RPMpackage is based on this behavior of mysqld_safe. The RPM installs an executable called mysqld-max, which causes mysqld_safe to automatically use that executable from then on.
If you install a MySQL-Max distribution that includes a server called mysqld-max, and then upgrade to a non-Max version of MySQL , mysqld_safe will still try to run the old mysqld-max server. If an update is performed, the old mysqld-max server must be manually removed to make sure that mysqld_safe is running the new mysqld serve