7

Mysql synchronization databases on one machine

view full story
linux-howto

http://stackoverflow.com – I have MySQL databases. Database A and Database B. Running on Mysql 5.5 and Ubuntu 12.04. Into Database A i am doing INSERTs, UPDATEs every minute (cron) (The whole database has over 15 millions rows and growing). I want to synchronize Database B with Database A use it for SELECT queries (for performance). So I want to know: How can I synchronize new rows with Database B every 4 hours. I looked into MySQL replication. Is it good for this? I am thinking think about SQLite3 DB. All tables are InnoDB I'm looking for a headless command, not a GUI tool. Everything is on one machine. I ne (HowTos)