MySQL Installation

MySQL Installation

Communication buffer

In order to allow big sized transactions to be executed by SYNTHESE, raise the max_allowed_packet variable to a high value. To do this, execute this query on the MySQL server :

set global max_allowed_packet=9999999999999999;

You can also set it in my.cnf, for instance:

max_allowed_packet = 512M

SYNTHESE UDF notifier tgz package

First, follow Debian_Installation_TGZ.

sudo cp /opt/synthese/lib/mysql_udf_plugin/libsynthese_mysql_udf.so /usr/lib/mysql/plugin/synthese_mysql_udf.so
mysql -u root -proot_password -h localhost mysql < /opt/synthese/share/synthese/mysql_udf_plugin/trigger_udf.sql

SYNTHESE UDF notifier from sources

MySQL UDF module can be installed for telling Synthese when a modification is made directly on the database.

This only works on Linux at the moment, Windows support is tracked in issue #10478 (you can still use a client on Windows that connects to a Linux MySQL instance).

cd ~/path/to/build
make -C src/10_db/102_mysql/trigger
# On Debian/Ubuntu, MySQL will look for udf plugins in /usr/lib/mysql/plugin. You can copy the library there.
sudo cp src/10_db/102_mysql/trigger/libsynthese_mysql_udf.so  /usr/lib/mysql/plugin/synthese_mysql_udf.so
# On other systems (SLES 11 for instance), only the default library paths are searched:
#sudo cp src/10_db/102_mysql/trigger/libsynthese_mysql_udf.so /usr/lib64/synthese_mysql_udf.so

mysql -u root -proot_password -h localhost mysql < ~/path/to/synthese3/src/10_db/102_mysql/trigger/trigger_udf.sql

Testing of the notifier can then be performed by running this SQL code (change the hostname and port of the Synthese server):

SELECT notify_synthese_http('http://youserver:8080', 'some_variable=1&other_variable=foo');

Then, check that an entry is added to the Synthese log file in /var/log/rcs/s3-server.log

S3 Proxy

Crashes or freezes of Synthese can block MySQL when it is calling the UDF notifier and the Synthese HTTP server doesn’t respond immediately.

To avoid such issues, a proxy has been developped that will buffer the Synthese requests and return immediately to the UDF HTTP requests. See S3 Proxy for more informations.