Installing CiviCRM on Amazon RDS

[bpmccain]

I've been playing around with CiviCRM on Amazon EC2 to take advantage of some ability to scale quickly when demand increases on our site.

I looked into hosting the database on an Amazon RDS, but ran into trouble because of the lack of Super User privilege on RDS and I couldn't seem to find a way around it when importing my civicrm db. I had no problems with the drupal db.

Anyone have any experience with CiviCRM on Amazon RDS?

Brian

[alxgrlk]

Bump.  I'm also looking into a CiviCRM with Amazon RDS deployment and running into problems.  I get the error: MySQL support not included in PHP.

This is on a WordPress install.

[alangallery]

The CiviCRM database SQL dump creates a function and we were not importing the database with the user that created the function. We found that editing function in the SQL dump and then importing worked for us.

Near top of the dump around line 27 :
CREATE DEFINER=`<sqlusername>`@`localhost` FUNCTION `civicrm_strip_non_numeric`...

We changed to :
CREATE DEFINER=`root`@`%` FUNCTION `civicrm_strip_non_numeric`...

Since we were importing as root on RDS.

[alxgrlk]

It seems that at the core of the problem is the use of mysql_connect which is deprecated.  Because an additional complexity is that we are also using the official WordPress Docker, the container service did not support mysql_connect. RUN docker-php-ext-install mysql and this seemed to fix the issue.