Originally published at: https://pressbooks.org/blog/2017/10/19/moving-half-a-million-database-tables-to-aws-aurora-part-1/
This post is about migrating Pressbooks.com to AWS. Does It Scale? At Pressbooks we use WordPress Multisite as a development platform. Pressbooks changes WordPress and makes every blog a book. The prevailing wisdom of the day is that a relational database should have a manageable set of tables with lots of rows of data in them. WP…
Wow. Most of this went well over my head, but the parts I did understand were very impressive, Dac. I don’t know if this is relevant, but I just met this guy at U Iowa this morning: http://homepage.cs.uiowa.edu/~bdmyers/cv.html. His doctoral research was on “high performance parallel systems for data-intensive computing.” Very nice guy, very interested in OER and computer science/engineering education. Want an introduction?
1 Like
I just want to clarify that I’m just the messenger. Ned is very involved in this process and it’s a team effort. 
Our problem is mostly about moving tons and tons of tables. WordPress scales well with this (unconventional) model. There isn’t so much a lot of intensive parallel computing going on. Rather, our hosted instances are already on AWS and we’re just dealing with bit of procrastination with our dot.com offering.
Good times.
this seems amazing, do you also help me in the similar type partitioning in ludicrousdb on my new multisite network? ive tried asking ludicrous and no support form them. i did everything like you did, but got errors. please help me in this or suggest me a dev who can do this . thank you