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.
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.
Alternatively is there a way to do this
medianon MySQL without using extensions?