Finally replicated...

Since we got our new database servers up and running, it had been about a month. I had both of the servers in sync, but because it was an emergency type of a changeover I skipped setting up replication at that time. Earlier this past week, I went ahead and started setting that up again. It didn't seem like a big of a deal at the time, but it ended up taking 2 and a half days to get the second server caught up. I guess that means we run a few queries each day, although only one slave SQL thread can run at a time which limits the amount of CPU that can be used by either of these severs for replication to about 25%. Since we have dual dual-core machines, it only uses one of the 4 available threads, making 25% the maximum. That was sort of disappointing from a performance point of view, but understandable to keep things perfectly aligned between the machines.

Once it was caught up, I went ahead and set up replication the other direction as well. We now have 2 servers which can handle any queries and the other will get the same data as well. All I can say is that it's about time. We've needed this for a while now.

This coming week, I'll be moving another switch over and putting the db servers behind the load balancers finally. That'll allow for a fail-safe, not to mention allowing me to reboot the database servers individually without shutting things down or having a short outage. This should also help me get some peaceful sleep since I finally won't have to worry about what happens if a server goes down.

Overall, I think our infrastructure is heading in the right direction to handle a lot more traffic, and it seems that each improvement on the server side seems to increase the output on the sales side. It also gives me options if I want to set up something unconventional, such as the W3C HTML validator that I have running on one machine now. But the biggest thing is that there is very little that happens on a typical day now that affects the performance for our users. That's what our investment has been about.

Comments

Post a Comment

Popular posts from this blog

Yii multiple select dropdownlist with default values

So I was coding a form in Yii, and came across a situation where I had a value of 0111110 (no, yes, yes, yes, yes, yes, no) that I needed to pre-populate values in a multiple select drop down. This didn't seem like it should be that hard, but the Yii documentation lacked a bit there. The first step was to split out the string. $optionValues = str_split($model->variable); Now, we create a blank array to hold our options. $options = array(); Then, we go through those options and set selected on the ones that need selected. foreach ($optionValues as $optionKey=>$optionVal) {      if ($optionVal) {         $options[$optionKey] = array('selected' => 'selected');     } } Now, we render the drop down list. echo $form->dropDownList($model, 'variable', array('0' => 'Zero', '1' => 'One','2'=>'Two','3' => 'Three', '4' => 'Four', '5' =&g
Read more

May 2021 updates

 Lots of work has been done since I last posted. Everything feels different, and gigs have been scheduled. It's time to get ready to play live again. Maiden Voyage We're playing a primarily hispanic audience show in a few weeks. New bass player is continuing to learn the songs, new guitar player keeps impressing me with his resolve, and as a band we feel ready for a couple hours of Maiden music. We're also playing a benefit for our lost blood brother in July, where we'll be playing the set list we did at our final show with him. Somehow, Live After Death seems fitting for that show, so that's what we're performing. We also have a special "something" planned for the first song which should hit everyone right in the feels. Pop Band We're currently using the name Hard Candy for this one. We're going to be playing a couple of benefit shows to get things started on stage. One is for our former drummer Dan and also the one with Maiden Voyage in Bill&
Read more

Been getting busy

It's been a while since I posted, so I thought it was time for an update. Maiden Voyage is starting to get busy. This summer saw quite a few shows and several benefits with us performing. We had our first show with us providing sound, which meant I had to buy a trailer. That was going to become necessary anyway just to continue moving our light show around, so it just worked out well. We played in Lincoln for the first time. Nothing earth shattering about playing another town about 60 miles from where we're based, but after that one show we immediately booked 2 more in Lincoln with minimal effort. Guess that first show is the most important one like they say... only one chance for that first impression. Speaking of 2 more shows with minimal effort, that's how most of our shows are happening now. We're not even looking for shows all that hard and are starting to have booking agencies and show promoters contacting us about being a headliner for some bands they'r
Read more