Anyone using a cloud SQL service with Fusion?

[smn]

I have looked at doing my own clustering but I am seriously considering a cloud platform instead. Should help simplify things and let me concentrate on Fusion and not database clustering and redundancy. Just wondering how well it works. I would assume latency is going to be more of an issue when you don't have a database on the same server, even if it's only a few ms away.

I think Google and Amazon both have PostgreSQL compatible services now so it will probably be one of those two.

 

[DigitalDaz]

I use Googles redundant postgres with my billing cluster but not FusionPBX. I see no reason not to just use BDR, I have been running multiple instances of BDR since 2015 and have NEVER had any problems.

 

[smn]

I use Googles redundant postgres with my billing cluster but not FusionPBX. I see no reason not to just use BDR, I have been running multiple instances of BDR since 2015 and have NEVER had any problems.

It's just more stuff to deal with. I have set up different types of sql clusters as experiments and they always end up getting really complicated really fast. I can do it and make it work well but it adds a lot of admin overhead. This is coming from a guy who always tries to do everything himself. So I don't make decisions about paying extra for a service to take care of it for me lightly.

 

[gflow]

If you're already using Amazon EC2 to host your Fusion servers then you can use their RDS and you will see no loss in performance, the underlying storage is still EBS, if you need additional performance you can purchase provisioned IOPS.

 

[puneet936]

If you're already using Amazon EC2 to host your Fusion servers then you can use their RDS and you will see no loss in performance, the underlying storage is still EBS, if you need additional performance you can purchase provisioned IOPS.

YES AWS RDS IS THE best option i am using it and working fine for me having 5K Extension and 50 tenants.. i am planing to use AWS Aurora which more reliable and very good performance.