Re: can Replication slow down the server?
Hi Rick,
The database is sitting on a RAID 5
sync_binlog was set to one.
SBR vs RBR - I left this as default which I believe is SBR. To be honest I wouldn't be sure which is the best but I can say that we do a lot of INSERTS and UPDATES, probably around 20,000 a hour or more.
InnoDB vs MyISAM - All tables are InnoDB due to the row locking vs table locking.
Well I can see my main problem, if the slave is supposed to be as beefy as the master then I'm in real trouble.
First the two machines are in two different countries so are connected over WAN. The slave is an old Dell desktop that hasn't been used in years so I installed Ubuntu. The plan was to just have an almost up to date database in our office to be used by the developers.
Maybe I can make a script to download the Friday's back up and restore to the Ubuntu MySQL or download manually each Friday morning and restore over the weekend....
I had hoped to use the slave to create the back ups using Perlico because right now I'm just using MySQL dump once a day without any increments.
Jim
Subject
Views
Written By
Posted
3002
October 07, 2013 06:07AM
1246
October 07, 2013 08:45AM
1241
October 08, 2013 10:31PM
Re: can Replication slow down the server?
1459
October 09, 2013 02:21AM
1301
October 10, 2013 09:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.