Swimminginthought

A place for all things technical and my mind..

Menu
  • About Me / Hire Me
Menu

Category: MySql

Backups: a bit of insight and perspective.

Posted on May 10, 2012 by Percy Kwong

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…

Redundant Application and Database Infrastructures

Posted on May 10, 2012 by Percy Kwong

Most people don’t backup their databases, much less set up redundancy.  It’s an important thing to consider when your application / website just cannot go down. This article discusses what it will take to set up that type of redundancy and I will be following up with a document on how to do it in…

Fixing Live WordPress Install without downtime [Solved – A Solution]

Posted on May 8, 2012 by Percy Kwong

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…

EC2 with REAL Support

Posted on May 6, 2012 by Percy Kwong

Using Amazon’s EC2 infrastructure is a real pain in the butt.  It’s confusing and the documentation isn’t really all that helpful in many cases.  So I propose something simple.. Call it a shameless plug, but it’s about supporting the family. Sign up for EC2 through my eStore and you’ll get all the support you need. …

Mysql Tuning for the Novice to Expert

Posted on April 30, 2012 by Percy Kwong

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…

Is your website slow? Fix It.

Posted on March 21, 2012 by Percy Kwong

Today, almost everybody has a website.  Many are run on a Webserver called Apache.  It’s an amazing piece of software that is ironically free and incredibly secure (when configured properly). There are plenty of content management and publishing tools out there as well.  WordPress (my personal favorite), Drupal, Movable Type just to name a few. …

centos 5 squirrelmail change sqlpass plugin

Posted on March 12, 2012 by Percy Kwong

If you’ve had issues with getting the change_sqlpass plugin to work on squirrelmail, there are definitely quite a few mashinations of the system on how to get it to work on Centos 5.x So here’s how I got it to work.  Please keep in mind that the following matters. Your SQL Mail Table called users…

Website Slow? Here are a few tips.

Posted on February 29, 2012 by Percy Kwong

Ok.  So you have a slow website.  Depending on the architecture, there are a couple of different ways we can speed it up.  We need to remember that the technology you’re riding on is going to make a big difference. There are many factors that can make your website slow. Inefficient Code Large Graphics files…

Recommended Products I use these for all my clients.

Posted on February 1, 2012 by Percy Kwong

Supermicro Motherboards – They work well and have proven chipsets. 3Ware RAID Cards: They’re one of the best in the industry.  They work and I’ve never lost data with them. Remember to buy the battery backup option. Supermicro Cases: Talk about seriously over-engineered cases.  They cool well and are built to last. Quality beyond anything…

Posts pagination

  • Previous
  • 1
  • 2

Recent Posts

  • Kubernetes install gotcha on CentOS-7.x
  • Infrastructure as Code using AWS Cloudformation
  • Does SSL matter? It does and it’s not just web encryption.
  • Apache can’t serve the .well-known directory
  • Cloudy with a chance of Meatballs
  • Resurrection of the Blog
  • Encryption type Matters with Deep Packet Inspection – solved
  • Completely off topic.. Just a personal note.
©2026 Swimminginthought | Built using WordPress and Responsive Blogily theme by Superb