You can configure a MySQL database on Amazon RDS for use with Content Services, with the following prerequisites:
- Setup Amazon RDS using the AWS Management Console
- Amazon EC2 instance
-
Use the ssh command to connect to the Amazon EC2 instance
using a provided .ppk key.
- For Amazon Linux, the user name is ec2-user.
- For RHEL5, the user name is either root or ec2-user.
- For Ubuntu, the user name is ubuntu. For SUSE Linux, the user name is root.
- Execute sudo su to change to root.
- Install Content Services.
-
Install the MySQL database connector.
The MySQL database connector is required when installing with MySQL, and allows the MySQL database to talk to the server. Check the Supported Platforms page for the correct driver.
- Download mysql-connector-java-8.x.x from the MySQL download site.
-
Copy the JAR file into the /lib directory.
For example, for Tomcat, copy the JAR file into the <TOMCAT_HOME>/lib directory.
- Install and use a database tool to connect to the Amazon RDS.
- Create a database named alfresco.
- Create a user named alfresco.
- Set the new user’s password to alfresco.
- Open the <classpathRoot>/alfresco-global.properties file.
-
Edit the following line with an absolute path to point to the directory in
which you want to store Content Services data.
For example: dir.root=C:/Alfresco/alf_data
-
Set and uncomment the database connection properties as shown
below:
db.name=alfresco db.username=alfresco db.password=alfresco db.host=alfqa-mysql5-6-19a.cw4mo3qj8qdu.us-east-1.rds.amazonaws.com db.port=3306 db.pool.max=275 # MySQL connection db.driver=com.mysql.jdbc.Driver db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?useUnicode=yes&characterEncoding=UTF-8Note: Ensure that these database connection properties aren’t commented out. - Save the file.
- Restart the Content Services server.