Has anyone any experience in hosting in AWS with Amazon Aurora?
We have the maximum RDS instance running MySQL on 4.4 cs-cart and are getting spikes with 600+ users online at once.
Am open to suggestion on how to tunes this?
Has anyone any experience in hosting in AWS with Amazon Aurora?
We have the maximum RDS instance running MySQL on 4.4 cs-cart and are getting spikes with 600+ users online at once.
Am open to suggestion on how to tunes this?
Hello!
Please contact us at sales@simtechdev.com. We can examine the issue and suggest you some solution.
Has anyone any experience in hosting in AWS with Amazon Aurora?
We have the maximum RDS instance running MySQL on 4.4 cs-cart and are getting spikes with 600+ users online at once.
Am open to suggestion on how to tunes this?
Hello,
Last time I checked you could just keep the MySQLi option enabled in CS-Cart as it connects to PHP by using a MySQLi driver. So just enter your database host, username and password and it should work, though some tweaks might be necessary as it doesn't support MyISAM.
As stated on their website:
Amazon Aurora is a relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora MySQL delivers up to five times the performance of MySQL without requiring any changes to most MySQL applications; similarly, Amazon Aurora PostgreSQL delivers up to three times the performance of PostgreSQL. Amazon RDS manages your Amazon Aurora databases, handling time-consuming tasks such as provisioning, patching, backup, recovery, failure detection and repair. You pay a simple monthly charge for each Amazon Aurora database instance you use. There are no upfront costs or long-term commitments required.
Read more here: https://aws.amazon.com/rds/aurora/faqs/#general
Best wishes,