MySQL-Max

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 WindowsMySQL 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 LinuxMySQL 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 SolarisMac 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

 

Leave a Comment