[sdc-support]

In order to migrate your SDC installation to use MySQL after been running with a Derby database, we are providing the following ant task:dbmigration.zip

1. Setup an account and empty schema in MySQL
1.1 User should have read/write permissions over this schema
2. Prepare the Ant task build.xml for migration
2.1 Edit the <property> elements of this file with the values that correspond for your SDC Data Files and MySQL install
3. Stop the SDC delivery hub
4. Run the migration to prepare the data in server
4.1 Install ant
4.2 ant migrate-sdc-derby-to-mysql
5. Edit the server’s config.ini values to now use MySQL
5.1 ${SDC_INSTALL_PATH}/Server/server//configuraiton/server-mysql.conf
5.1.1 Add the following lines

pulse.jdbc.url=jdbc:mysql://${MYSQL_HOST}:${MYSQL_PORT}/${SCHEMA_NAME}?autoReconnectForPools=true&blobSendChunkSize=2048000&jdbcCompliantTruncation=false&autoCommit=false&useUnicode=true&characterEncoding=UTF-8
pulse.jdbc.user=${MYSQL_USER}
pulse.jdbc.password=${MYSQL_PASSWORD}

5.2 ${SDC_INSTALL_PATH}/Server/configuraiton/config.ini
5.2.1 Modify the values to

com.genuitec.pulse.server.delivery.use.embedded.db=false
sdc.configfile=${SDC_INSTALL_PATH}/Server/server/configuraiton/server-mysql.conf

Attachments:

You must be logged in to view attached files.

[Author]

Posts