Using CWP with Amazon RDS

[pramod1221]

Hi,
I am planning to use EC2 for the web application and Amazon RDS for database. Has anyone tried to setup CWP to run on Amazon RDS instead of a standalone mysql installation?

Regards,
-Pramod

[fredo]

Hi Pramod,
No, I haven´t done that yet.. but I guess, that you shouldn´t have any sort trouble, as long as you open port 3306 to connect the EC2 to the RDS..
What I´ve done is very similar.. I had 4 EC2 instances, (1 web server with CWP installed, 2 web servers - only with apache  - and 1 ec2 With MySql).. It worked all fine!

cheers!

[limpingninja]

Hello Fredo,

Sorry to bump an old conversation here, but what you are describing is like what I have been working towards. I have been working my way through numerous web panels to find the one that is best suited for this architecture.

How easy did you find this with CWP? I ask because I've noticed that many panels are inextricably connected to the SQL and Web instances, where the only easy choice is using EFS or other NFS/CIFS/SMB methods to share a data disk for other web nodes. My current layout is basically as you described: Panel Server, AutoScaleGroup ( 2(minimum) Web Servers ),  Aurora Cluster, EFS x 2 mounted as NFS.

Beyond picking AWS and picking the panel feature set I needed, the next part was trying to find panels that are easy to segregate the duties for. Is this the case with CWP? I ask because it is now on my shortlist for trying and seeing how you've done something quite similar, your experience may be helpful!

Kind Regards,
LN

[Glenn]

I have a few servers on AWS with RDS backends CWP works really well have a look at this though

http://wiki.centos-webpanel.com/remote-mysql-with-socat-socket

[limpingninja]

Hello Glenn,

Thanks for the link - did not seem to work for me though, I've changed the backend configuration files for PhpMyAdmin, RoundCube, and PostFix by hand since they were not working. I have socat running pointed to my AWS cluster.

The annoying bit I run into is when I attempt to use the module MySQL_manager it just loads empty. Making database usage a bit of a pain for users.

http://<ip>:2030/user/index.php?module=mysql_manager

Did you do anything else to get yours to work?

LN

[limpingninja]

Ignore this, I will provide more information.

The socat connection appears to be working at least on the root_cwp database. Using 'mysql' from the command line with an appropriate user name (without host) appeared to work, but without did not.

Ah ha. Root users ~/.my.cnf needs to have a valid remote user name in it. Totally overlooked this.

LN