Top Things to Know if new to MySQL on Solaris
By George Trujillo on May 27, 2008
Here are ten things to know about MySQL if you are new to MySQL on Solaris:
- The default install is simple, easy, takes minimum resources but is not a configuration you should use for production environments. If new to MySQL use the default install.
- To connect to a MySQL database server you need to know the host and the port. The my.cnf (or my.ini) file is the startup configuration file.
- The mysqld background process is the database server that reads the startup configuration file. The mysqld database server is thread based, so threads start up to manage sessions.
- MySQL has unique features just like other relational databases. MySQL database servers need to be configured for performance like any database server if running in a production environment. You'd better understand these features if supporting MySQL.
- Before running MySQL in a production environment, you'd better understand storage engines, SQL Modes, MySQL security and the architecture of the MySQL database server.
- As of May 30, 2008 MySQL 5.0 is the GA release, 5.1 RC is about to go
GA. MySQL 6.0 is in alpha. The goals of MySQL 6.x is adding a lot of online features, new
important functionality with increased performance and throughout. MySQL 6.0 will add significant scalability and functionality to the database server.
- Through version MySQL 5.1, there is no hot backup utility. OS snapshots, replication, InnoDB Hot Backups are popular ways for backing up MySQL databases. MySQL 6.x will have hot backup capability.
- MyISAM tables totally rock when high speed reads are very important. Make sure you understand all characteristics or these tables before using them.
- InnoDB is the transactional storage engine to use through MySQL 5.1.
- New storage engines such as Maria, Falcon and enhancements to InnoDB are going to change the use of MySQL in the enterprise.
- Replication is one of the most popular features in MySQL. It is free, relatively simple to set up and performs basic functionality of replication. Does not contain advanced replication features but it also does not contain the complexity either. That is what users like about MySQL replication.
- MySQL Cluster is a HA (high availability) environment. MySQL Cluster works extremely well when applications leverage how MySQL Cluster works. Make sure you understand the characteristics of MySQL Cluster before considering it for an application.
- Go to http:/dev.mysql.com and then click on Documentation. Scroll down a little bit and find the Example Databases section. The World, Sakila and Menagerie gzip and zip files contain SQL code for creating database schemas, building tables and storing them with data. They provide sample data to play with.
- MySQL Enteprise Monitor is MySQL's management and monitoring software for managing MySQL database servers. It contains lots of GUI interfaces and advisors.
- Popular software seen in MySQL environments include memcache, SQLYog, Navicat, Pentaho and Nagios.