MySQL - replicate some tables between transaction and report database I have two different database (on two different hosts). One database is transactional and another database is reporting. Let us say, it stores information about departments and their employees.

Transactional Database has one department table which stores employee data of all departments. This table has foreign and primary keys. This table has no partitions. Disk size is above 250 gb.

Reporting Database has one department table which is partitioned by department id. This table has no primary or foreign keys. Otherwise, structurally this table is same as transactional one.

Is there any way to replicate the department table between transactional and reporting.
You can replicate Transaction to Reporting without any issues are it's "independent" but Reporting to Transactional may cause issues depending on your foreign-key settings.

You can easily replicate single table with the help of replication filters (in your case replicate-do-table or replicate-wild-do-table).

There are plenty of blogs for replication setup instructions, say this one from Percona.