5

We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS.

Unfortunately there is a functionality called Median that MySQL is missing. Our existing code base is utilising MySQL Infusion UDF to achieve calculating Medians.

  1. Now we are in a dilemma, is it possible to install these extensions on RDS? I believe RDS is not really like a EC2 where you can just SSH in and install something.

  2. Alternatively is there a way to do this median on MySQL without using extensions?

Houman
  • 1,545
  • 4
  • 22
  • 36

2 Answers2

7

No, this is not possible. If you require this extension, you will need to run your own MySQL instances.

EEAA
  • 109,363
  • 18
  • 175
  • 245
  • I was also looking to see if it is possible to use UDFs in an RDS instance. Unfortunately, it isn't so I ended up using MySQL on my EC2 instance, where I have full control and can upload binary shared objects to MySQL. – kimbaudi Sep 18 '16 at 16:26
-1

Please have a look at these links:

https://forums.aws.amazon.com/message.jspa?messageID=320196

https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-functions/

TuXaWy
  • 1