Linux
Setting up a Virtual IP address (VIP)
These instructions are for CentOS/Redhat Linux distributions. Identify your current NIC’s and IP addresses in use. $ /sbin/ifconfig eth0 Link encap:Ethernet HWaddr 00:30:48:98:9C:A6 inet addr:192.168.53.201 Bcast:192.168.53.255 Mask:255.255.255.0 inet6 addr: 0080::230:48ff:fe98:9ca6/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:6159779 errors:0 dropped:0 overruns:0 frame:0 TX packets:6137085 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:100 RX bytes:1158210510 (1.
Read moreGetting started with Gearman
Gearman is an open source generic framework for distributed processing. At OSCON 2009 I attended the Gearman: Build Your Own Distributed Platform in 3 Hours tutorial. While it’s very easy to install Gearman, and follow the first example, if you missed the all important additional PHP steps listed on just one slide you may be left with the “‘Class ‘GearmanClient’ not found” error.
Read moreSetting up sysbench with MySQL & Drizzle
Sysbench is a open source product that enables you to perform various system benchmarks including databases. Drizzles performs regression testing of every trunk revision with a branched version of sysbench within Drizzle Automation .
Read moreconfigure: error: mysql_config executable not found
If your compiling a product that includes a dependency of MySQL, you can easily get the error configure: error: mysql_config executable not found I generally don’t see this problem, because I use MySQL binary tar files, however if you use MySQL packages, such as Ubuntu, you can easily miss the required dependency.
Read moreUnderstanding Different MySQL Index Implementations
It is important to know and understand that while indexing columns in MySQL will generally improve performance, using the appropriate type of index can make a greater impact on performance.
Read moreWhat’s new in MySQL 5.4.1
Absolutely nothing? 5.4.0 was released with a change in the MySQL Binary distributions , delivering only 1 64bit Linux platform and two Sun Solaris platforms. This was officially announced on April 21 2009 however the 5.
Read moreWhat to do at 3:25am
Look at MySQL bug reports of course? Well actually I’m writing multiple blog posts, and I was confirming additional reference sources and links when I came across MySQL Bug #29847 – Large CPU usage of InnoDB crash recovery with a big buf pool.
Read moreNever let your binlog directory fill up
Recently with a client while running a number of disaster recovery tests I came across a nasty situation which was not part of the original plan and provided a far worse disaster situation then expected.
Read moreGetting wireless working on Ubuntu Macbook
I run Ubuntu 9.04 Januty on my Macbook. Previously installing Ubuntu 8.10, wireless worked automatically, for 9.04 it did not. This is what I did to fix it. Verify your Macbook is seeing the Broadcom controller.
Read moreKilling my softly with QUERY
The MySQL KILL command as the name suggests kills queries that are running. After identifying the Id using the SHOW PROCESSLIST command, the User of the connection/thread or a database user with SUPER privileges can execute KILL [id]; to remove the connection/thread.
Read moreInstalling Perl RRD module – RRDs.pm
Perform a quick check if the module is available. $ perl -MRRDs -le 'print q(ok!)' Can't locate RRDs.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.7/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.6/x86_64-linux-thread-multi /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.
Read moreVerifying MySQL Replication in action
There is a very simple test to show MySQL replication in action and to also better understand the basics of MySQL Replication. With a configured MySQL environment we can run the following test on your MySQL master, and monitor the MySQL slave.
Read moreThe value of multi insert values
Baron got a great amount of response from his 50 things to know before migrating Oracle to MySQL . I’m glad I invited him as a fellow MySQL colleague to my presentation to the Federal Government on Best Practices for Migrating to MySQL from Oracle and SQL Server for his inspiration.
Read more