Support

Admin Tools for WordPress

#33763 Admin tools on AWS cluster database

Posted in ‘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.

Environment Information

WordPress version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by on Saturday, 24 October 2020 01:17 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

tampe125
Akeeba Staff

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 • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

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

tampe125
Akeeba Staff

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 • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

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

tampe125
Akeeba Staff

Ok, let me know how it goes

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
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.