At the agency I am working at, they all use a software application that ties into a MySQL database. I am looking to build off of this application to add some new tables of data for some additional requirements that have nothing to do with the application itself.
So I am looking to create a new database that will mirror the one used for the application with the exception of my newly added tables.
What would be the easiest way to keep the second database in sync, but ignoring my new tables? Are there any real-time solutions or will I have to have something run hourly?
Thank you for any advice you might have.