If you’re in Enterprise IT, you’re going to hear one buzz-word a lot. The buzzword? 2-tier Architecture or 3-tier architecture. I like to refer to it as n-Tier architectures. So what exactly is it and what does it mean? A Tier in an architecture is simply the number of layers of an application or system…
Category: Databases
How Content Distribution Networks(CDN) Work and How they Benefit You
Content Distribution Networks (CDNs) are simply a network of servers located all over the world that will distribute your content faster, more reliably, and provide redundancy to your website or webhost. There are many benefits to having a CDN. The most important one is the ability to lower your server load and provide the customer…
Increasing Mysql performance significantly
For those of you who run mysql, there’s an issue that you have to look at. Like file systems, database tables get fragmented over time. There’s a simple fix for it, but you will need to execute one command to do it. Of course, you will need to have root access to your Mysql server,…
Backups: a bit of insight and perspective.
Many of us have backups. Many of us don’t. Here’s an interesting question though. Those of us that have backups. How many have actually tested them out to make sure they’re working? If you have, how often do you test them? Most people set up a backup solution and just let it run. They don’t…
Fixing Live WordPress Install without downtime [Solved – A Solution]
I love wordpress. It’s simple and very powerful. The only problem with it is the quality of the plugins and the constant upgrading. Like Microsoft Windows, sooner or later, something is going to break. Of course, I didn’t notice it until just recently. On my blog (This blog), the newsfeeds broke. I really don’t know…
Mysql Tuning for the Novice to Expert
Most people just install Mysql, use the defaults and call it a day. Unfortunately, for a select group of people with high traffic, this can cause problems. It all falls into the issue of performance. This can effect your website, applications, etc. I’ve seen this happen on numerous occasions, because people don’t bother to think…
EC2 Instances, the pitfalls and how to avoid them.
So I decided to take the plunge into moving my mailserver from Linode to EC2 considering it made more sense after doing some math. The reality is Linode is an excellent VPS host and I still have many machines with them (and highly recommend them), but the reality is at some point, it doesn’t become…
Automated Backups to Amazon S3. WordPress example explained here.
There are tons of Automated backup plugins for WordPress, but the reality is you’re assuming they work unless you’ve actually restored one of them. This article will explain how to do this without using anything fancy like a backup program. In fact, I just give you a few scripts and of course the old, trusty,…
So you don’t know your root password for mysql. Getting root control of your mysql server back without having to reset the password.
[singlepic id=57] This little tidbit is written for Redhat / CentOS, but with a little bit of work, the concepts and commands are easily modified for any flavor of linux. If you’re sitting on a LAMP stack and you’ve had a defection or just haven’t documented your passwords in a safe place, the easiest…
The Cloud or Regular Servers, a Technical and business comparison.
We all here about “The Cloud” today and Virtual Private Servers. The reality is 10 years ago, virtualization as a technology was still in it’s infancy. While it seemed like a good idea, the reality is, it wasn’t ready for prime time business. It was more of an exploration of technology, the next logical step;…