One of the questions I receive the most is: “What version of Plesk works with MySQL 5?
By setting a certain bash environment variable, you can limit which commands are kept in the .
Installing new hardware may mean that new kernel need to be loaded when your server boots up.
If you have a new Plesk installation and the following option is greyed out in Server -> Mail:
I’ve just reviewed the stats for MySQLTuner, and it crossed the 5,000 download mark last week!
Using Linux kernel 3.
I stumbled upon this peculiar bounce message recently while working on a server:
You may catch this error when you attempt to start dovecot on a Red Hat Enterprise Linux 5.
If you’ve used newer versions of Horde with Plesk, you have probably noticed the news feed that runs down the left side of the screen.
A new version of MySQLTuner was released tonight to correct some bugs found within revision 26.
After a couple of weeks, my MySQL replication series has come to a close.
As some subversion users may have noticed, revision 23 of MySQLTuner was released quietly on Sunday.
There’s a few final configuration options that may help the performance of your slave MySQL servers.
If you want to make a DBA nervous, just let them know that they need to upgrade MySQL servers that are replicating in a production environment.
While many people might find replicating over an external network to be an odd concept, it does have some uses.
On some occasions, MySQL replication can break down if an statement comes from the master that makes no sense to the slave.
In a perfect world, slaves will contain the same data as the master at all times.
I just received a note yesterday that MySQLTuner was added to Debian’s package list for the sid release.
If you have a master with multiple slaves, you can get some performance and save money on hardware by splitting data horizontally among your servers.
An often overlooked benefit of MySQL replication is the ability to make reliable backups without affecting the integrity of the MySQL data.
Although performance is a much larger benefit of replication, it provides some redundancy for your application as well.
MySQL replication can increase performance by allowing developers to spread queries over two servers.
One of the topics I receive the most questions about is MySQL replication.
·20 words·1 min
I’d like to wish everyone a Happy New Year and I hope it is a great 2008 for you all!
MySQL replication may sound complicated, but it can be done easily.
·38 words·1 min
I’m taking a little bit of time off for Christmas, but I’ll be adding new posts on December 31st.
I spoke to a customer recently who was concerned about their Red Hat Enterprise Linux 2.
I stumbled upon a server running Plesk 8.
MySQLTuner revision 22 is available today.
Thanks to Oden Eriksson at Mandriva, MySQLTuner is now packaged into an RPM for easier installations on Mandriva Linux.
After I was asked to create a stored procedure on a MySQL 5.
There’s a few issues with PHP 5.
One of my biggest beefs with Plesk’s e-mail handling is the lack of server-side filtering.
There may be some situations where you want to encrypt FTP traffic with SSL certificates rather than using SFTP with SSH.
·25 words·1 min
In the US, we celebrate Thanksgiving today.
If your system abruptly loses power, or if a RAID card is beginning to fail, you might see an ominous message like this within your logs:
Apparently, a recent Red Hat Enterprise Linux update for ES3, 4 and 5 caused some Perl applications to throw errors like these:
A few days ago, I stumbled upon a server running qmail with qmail-scanner.
By default, Red Hat Enterprise Linux 4 sets the default character set in Apache to UTF-8.
I found myself wrestling with a server where the Plesk interface suddenly became unavailable without any user intervention.
·302 words·2 mins
I’ve received a lot of IM’s and e-mails from friends and readers of this blog about the Rackspace outages on November 11th and 12th.
Create a strong CSR and private key
I’ve updated MySQLTuner to revision 20 tonight, and it has the following improvements:
·76 words·1 min
I’ve struggled at times to get a decent-looking terminal on my desktop, and I believe I’ve found a good one.
·45 words·1 min
I’ve been on a bit of a vacation lately, and that’s why there’s been a lack of updates.
Here’s a pretty weird kernel panic that I came across the other day:
A few days ago, I began to install a group of packages with up2date, and the person next to me was surprised that up2date even had this functionality.
I’ve revamped a few of the recommendations in MySQLTuner, and revision 19 is now available tonight!
If you’re using Plesk 8.
When you dump table data from MySQL, you may end up pulling a large chunk of data and it may exceed the MySQL client’s max_allowed_packet variable.