Support

Admin Tools for WordPress

#33763 – Admin tools on AWS cluster database

Posted in ‘Akeeba Admin Tools for WordPress’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Tuesday, 22 September 2020 11:24 CDT
wicko

I have managed to move my site onto a new AWS server running the Aurora cluster database.

However the site really does not run very well and was wondering if there are settings that I should change within Admin Tools to help this.

The site is GetGoFone.

regards

 

David

Web design and development in Reading and Oxfordshire UK.

Wicko Web design

Wednesday, 23 September 2020 03:55 CDT
tampe125

Hello,

which issues are you having?
Please remember that Aurora is just a MySQL-compatible database hosted on AWS infrastructure. Basically they will end up to manage it to keep performances acceptable, without you to worry about tweaking any database configuration.

As long as the writing and reading connections are the same, there is nothing do to. If they are different (ie you have an endpoint to write data and another one to read them) you can't use WordPress (or Joomla) out of the box; you'll need some third party plugin. If that's the case, Admin Tools won't be affected, however Akeeba Backup will be.

Finally, Admin Tools can do very little for you: we have utility tools to tweak your .htaccess file, but that will affect Apache, the webserver that is serving the requests, not the underlying database.



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Wednesday, 23 September 2020 04:21 CDT
wicko

Hi Tampe125

Thanks for the reply.

AWS have already managed to setup the database but was just wondering if Admin Tools had anything that might block or slow this down. We are just getting as 5s delat on new loads until the page is cached.

If the cluster database will effect Akeeba Backup is there a way I can fix that? AWS does have a backup service but I was hopeing I could use Akeeba to at least keep backups that I could take off site and push back to other servers if needed.

David

Web design and development in Reading and Oxfordshire UK.

Wicko Web design

Wednesday, 23 September 2020 05:15 CDT
tampe125

AWS have already managed to setup the database but was just wondering if Admin Tools had anything that might block or slow this down. We are just getting as 5s delat on new loads until the page is cached.

No, I'm sorry, in this case Admin Tools can't do anything for you

If the cluster database will effect Akeeba Backup is there a way I can fix that?

First of all double check if you really have such special setup (write in one place, read from another one). It's a very advanced setup, it's not very common unless you're dealing with a site that receives an huge amount of traffic. If you're 100% sure that you have such configuration, you'd need to override the MySQL connection settings inside Akeeba Backup configuration to point to the master (write) node because we need to both read and update tables using the same connection.



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Wednesday, 23 September 2020 06:29 CDT
wicko

Actually we only have one endpoint for this site as it is the staging site.
When we push to live I think there is will 2.

So for Akeeba Backup in this site I tihk all should be fine.

 

Many thanks


David

Web design and development in Reading and Oxfordshire UK.

Wicko Web design

Wednesday, 23 September 2020 07:14 CDT
tampe125

Ok, let me know how it goes



Davide Tampellini

Developer and Support Staff



Italian: native

English: good



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Saturday, 24 October 2020 01:17 CDT
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.