MySql is an excellent database by T.C.X. DataKonsultAB as free software. It is a true multi-user, multi-threaded SQL database server.
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.
- 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.
ReferencesPlease refer to MySql Web site.
- 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;