MySQL Overview

MySQL is an open source RDBMS (Relation Database Management System), and it can save the data to different table instead of putting all the data in a large warehouse. It speeds up accessing and improves flexibility. MySQL uses the standard SQL language. Support the large databases that can handle large databases with tens of millions of records. MySQL can also be used in multiple systems, and support multiple languages. In iServer, MySQL can be used to store the security information. In addition, iServer supports to publish the data of MySQL datasource. Now it supports the version higher than 5.6.16.

Please refer to http://www.mysql.com for more information.

It will introduce Install and Configure MySQL in Windows and Linux. It will help you study MySQL and use it in iServer.

Note:

1. MySQL uses following ports by default. Please make the following ports can be accessed:

• Default port: 3306

2. MySQL datasource map service only supports the single threading mode. After publishing MySQL datasource as the map services, it needs to close the multi-threaded mode of service providers. The detailed configuration is:

1. In iServer service manager, enter the service provider management interface http://localhost:8090/iserver/manager/spsAndspsets
2. Select the map service provider published based on MySQL data source
3. In Advanced, uncheck the "Whether to enable multi-thread mode". Click Save.