I have a server with 1 hd running Fedora core6 and my dabatase is getting a tad large. Its over 1.5gb now and backing up takes very long. Is setting up replication easy? I dont really know my way around my box since its my first time working with one. I've been learning stuff searching around but I cant find a clear guide on how to set up this thing. Or is there another alternative?
Setting up replication is very easy. Take a look at these http://dev.mysql.com/doc/refman/5.0/en/replication.html and http://www.databasejournal.com/features/mysql/article.php/3355201.