You can translate the question and the replies:

Cache Database with mysql(AWS Aurora)

1. The customer wants to use the mysql(AWS Aurora) for Dev and QA environment. Is preferable to mysql as cache database in respective to performance? 2. Customer Source system is oracle and MS SQL Server. Based on the caching requirement, they are planning to configure the external database(preferably AWS Aurora) in production environment later. Is it okay to configure the cache external database when they required?
cache
user
30-08-2019 15:29:52 -0400
code

1 Answer

Hi, I was able to configure AWS Aurora as cache database using MySQL5 adapter. Please be advised that MySQL has to be configured for Unicode support. You can refer the knowledge base article about '[Configuring MySQL for full Unicode support](https://community.denodo.com/kb/view/document/Configuring%20MySQL%20for%20full%20Unicode%20support?category=Data+Sources)' for more information.The Performance factor is based upon your requirements and advantages of the Database and mostly depends on your scenario. It is recommended to use the external database for cache especially in the production environment as you can use AWS Aurora as discussed above. For detailed information, you can refer to [How to connect to Amazon Aurora from Denodo](https://community.denodo.com/kb/view/document/How%20to%20connect%20to%20Amazon%20Aurora%20from%20Denodo?category=Data+Sources) and [Best Practices to Maximize Performance III: Caching](https://community.denodo.com/kb/view/document/Best%20Practices%20to%20Maximize%20Performance%20III:%20Caching?category=Best+Practices) Knowledge Base articles. Hope this helps!
Denodo Team
03-09-2019 08:07:21 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here