RSS LinkedIn Twitter

Posts Tagged ‘MySQL’

In my opinion, having dual-writable master MySQL databases (in a replication configuration) is not worth the hassle. There are a host of problems, enough that you should seriously consider what you’re trying to gain when attempting it. However, the master-master replication scheme still has some very good uses when used in an active-passive way. The […]

Tuesday, February 9th, 2010 at 10:34 0 comments

I’ve been doing a lot of research (not cutting edge type stuff) into MySQL scalability, and the first exercise I went through was configuring a simple master-slave replication setup. It was much simpler than I thought it would be. Here are the steps. Editing the my.cnf Files Because of the way replication works in MySQL, […]

Saturday, February 6th, 2010 at 15:33 0 comments

I created some barebones Fedora servers that I’m intending to create a load balanced cluster from using Apache’s mod_proxy_balancer. My topology will eventually look like this: load_balancer -> (ws1, ws2, ws3) -> mysql_server As you can see, it’s nothing fancy. To test the balancer, each web server has a PHP script that connects to the […]

Tuesday, February 2nd, 2010 at 11:34 18 comments

I’ve been using MySQL for almost 7 years now without realizing it had stored procedure capabilities.  So when I saw MySQL Stored Procedure Programming, by Guy Harrison with Steven Feurerstein, I decided to take the opportunity to advance my skills with MySQL.  It’s a pretty good sized book, and it took me a while to […]

Wednesday, January 27th, 2010 at 19:58 0 comments