So many programmers make this mistake because they don’t seem to get it. It’s not your fault as a programmer / developer. It’s just that you’re not a DBA. You need to implement Connection pooling. It makes such a huge difference in the way your DB performance and app works it’s amazing. So here are…
Tag: database
Database Backed Web Applications Advice
Here’s the scenario. You’ve got a dedicated server running windows in a server farm (generic dedicated server provider). You have mysql + asp or php app running all on the same server. Raid 1 mirroring and 2 GB of ram. You have to have windows, because your application supports it. Sound Familiar? It’s a problem…
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,…
Redundant Application and Database Infrastructures
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]
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…
Is your website slow? Fix It.
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. …
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…