MySql

Description

MySql is an excellent database by T.C.X. DataKonsultAB as free software. It is a true multi-user, multi-threaded SQL database server.

Capability

MySQL since 1996 in an environment with more than 40 databases containing 10,000 tables, of which more than 500 tables have more than 7 million rows. This is about 100 gigabytes of mission-critical data.

Limitations

  • It is not free for re-distribution.
  • It requires a person with system administration knowledge for one time installation.
  • It provides (requires) a person with DBA knowledge to setup accounts for users.
  • Based on above limitations, MySql is not suitable in shrink wrapped version of LVG.

References

Please refer to MySql Web site.

Notes

  • The default character set and collation for table need to be set as utf8 and utf8_bin when table is created to integrate with utf-8, respectively.
    CREATE TABLE t ( ...) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;