MySQL consolidated database

Before running the setup script, you should be aware of the following requirements:

The database user who runs the setup script is expected to be the same one used to update the MobiLink system tables during synchronization. This user must be used to start the MobiLink server and to configure MobiLink applications. See Required privileges.
The RDBMS user that the MobiLink server uses to connect to the consolidated database must be able to use the MobiLink system tables, procedures, and so on, without any qualifiers (for example, SELECT * from ml_user). See MobiLink server system tables.

The MobiLink server requires the default storage engine to be ACID compliant. If the default storage engine is not ACID compliant, make sure that all MobiLink server tables are created using an ACID compliant storage engine, such as InnoDB and Falcon. Failure to do so may cause data inconsistencies.

If necessary, before applying the file against your MySQL database, edit the syncmys.sql script file to add the following two lines after the line delimiter //, where engine_name is an ACID compliant storage engine.

set storage_engine = [engine_name]
	//

To set up MySQL to work as a MobiLink consolidated database, you must run a setup procedure that adds MobiLink system tables, stored procedures, triggers, and views that are required for MobiLink synchronization.

Prérequis

Your MySQL user ID must have privileges to create tables, procedures, functions, views, and triggers.

Contexte et remarques

You can also use the MobiLink 16 plug-in for Sybase Central to set up MySQL as a consolidated database.

Task

Using the MySQL command line tool or the MySQL Query Browser, run the syncmys.sql setup script, located in %SQLANY16%\MobiLink\Setup.

Résultat

The MySQL database is ready to be used as a MobiLink consolidated database.

To set up MySQL to work as a MobiLink consolidated database, you must run a setup procedure that adds MobiLink system tables, stored procedures, triggers, and views that are required for MobiLink synchronization.

Prérequis

Your MySQL user ID must have privileges to create tables, procedures, functions, views, and triggers.

Contexte et remarques

You can also use the syncmys.sql setup script to set up MySQL as a consolidated database.

Task

In the MobiLink 16 plug-in for Sybase Central, choose Folders from the View menu.
Open your MobiLink project and expand Consolidated Databases.
Right-click the database name and click Check MobiLink System Setup. If your database requires setup, you are prompted to continue.

To use an existing MobiLink system setup, your default_schema should be the schema of the MobiLink system setup.

Résultat

The MySQL database is ready to be used as a MobiLink consolidated database.

You must set up an ODBC DSN for your MySQL consolidated database using the ODBC driver that is provided on the MySQL web site. The MobiLink server supports MySQL ODBC driver 5.1.3 or later. See:

http://www.sybase.com/detail?id=1011880

To specify your ODBC configuration file in Unix, do one of the following,

Place the ODBC.INI file into the home directory of the current user.
Create an ODBCINI environment variable and set it to the directory location of the ODBC.INI file.

Data type mappings The types of columns must map correctly between your consolidated and remote databases. For details, see MySQL data mapping.
Stored Procedures You cannot use INOUT or OUT parameters in stored procedure calls. Procedures that require these parameters must be implemented as functions that return an OUT value.
Server events that require INOUT parameters, such as authenticate_user and modify_user, must be implemented as functions and run using a SELECT statement instead of a CALL statement.
Named parameters User-defined named parameters are not supported.

Cursor Scripts The events upload_fetch, download_cursor, and download_delete_cursor must be called using a SELECT statement, which the MobiLink server runs using a read-committed isolation level. A bug in the MySQL ODBC driver causes the server to read uncommitted operations, such as INSERT, UPDATE, and DELETE statements, which results in inconsistent data between the consolidated database and the remote database.

To work around this problem, affix a LOCK IN SHARE MODE clause to your SELECT statements. For example:

SELECT column1 FROM table1 WHERE id > 0 LOCK IN SHARE MODE

This clause protects the SELECT statement from uncommitted operations.

Bulk upload The MySQL ODBC driver does not currently support bulk upload correctly.
MLSD The MySQL ODBC driver does not currently support MSDTC, so a separate MLSD is not supported.
MySQL Server Configuration The MobiLink synchronization scripts are stored in the ml_script table as TEXT and are retrieved when needed. You may need to set max_allowed_packet equal to 16m or greater in the my.ini file.
Conflict detection The scripts generated for conflict resolution with a MySQL consolidated database have multiple statements. If you are using conflict detection, you must enable the Allow Multiple Statements checkbox on the Flags 3 page of the MySQL Connector/ODBC Data Source Configuration window when you configure a DSN for the MobiLink server to make connections to your MySQL database.
Multiple statements If any of your synchronization scripts contain batched SQL commands separated by semicolons, you may need to select the Allow Multiple Statements checkbox on the Flags 3 page of the MySQL Connector/ODBC Data Source Configuration window when you configure a DSN for the MobiLink server to make connections to your MySQL database.

See MobiLink isolation levels.