We are currently running Appian in the cloud using MySQL. Some concerns have bee

Dan over 9 years ago

We are currently running Appian in the cloud using MySQL. Some concerns have been raised regarding the scalability\\functionality of MySQL as our DB infrastructure. Does anyone have any experience running into issues with MySQL that they would like to share? What the issues were, at what point they were encountered, rough size of the application\\# of users, etc?...

Discussion posts and replies are publicly visible

0 Owen Parrish
Appian Employee
over 9 years ago

From the start you should plan your database design well, eg. proper indexes, table design, etc.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cichy
Appian Employee
over 9 years ago

From my experience, the Cloud team is constantly tweaking and adjusting their infrastructure to provide the best possible scalability and performance. I have not really ran into issues before until we started doing multiple triggers to insert and update data in tables with over 10m rows, which was, as Owen points out, a poor design choice rather than a DB problem. Otherwise, I have seen apps on Cloud operate normally with tables of a few million each.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel