It’s been a busy week so far! On Monday I went and visited the Primus Data Center here in Edmonton and got a tour of the state-of-the-art facility. I am really excited to say that I plan to colocate many of my company’s servers into this secure facility over next month.

Today Apple announced the new iPhone 5 which will be available here in Canada next Friday Sept. 21! I’ve held onto the the iPhone 4 from its original launch date 2 years ago and I am really excited to update to this latest model next Friday, launch day as usual.

So Yesterday I setup MySQL replication for databases. I used these institutions found here.  But I ran into some issues when trying to run “show master status;” as I determined that binary logging wasn’t turned on. Which is needed in order to track and replicated databases changes. So to enable that I needed to add

log-bin = /var/log/mysql/mysql-bin.log

to /etc/mysql/my.cnf

But this line was already added to the file by following the institutions but didn’t work. My issue was that I added the line to the bottom of the file. It needs to be added higher up with  the following lines.

server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M

Other than that the instructions work great!

To add multiple databases to replicated.

On the slave in /etc/mysql/my.cnf just add another line replacing the “databases2″ with the name of the second database.

replicate-do-db=databases2

Well thats it hope that helps someone else out!

So I’ve been looking into server colocation in Edmonton to get faster internet and cheap IP blocks for my VPS solution that I will be launching soon! And I think I finally found a good datacenter to host in! It’s a Primus data center here in downtown Edmonton. I will be going for a tour later this week and will post some photos for those who are interested. I mostly chose Primus because they offer 1/8th (5U) server rack cabinets with 100Mbps network connection for 300/mo. As right now I don’t need a ton of rack space as I virtualize most everything these days and I will still continue to host from my home office here in Edmonton as well.