>
Thursday - July 19, 2007Installing MySQL on OS X 10.4 TigerThis article details how to setup MySQL 4.1 or
later on Mac OS X Tiger 10.4.x. Additionally it tells you how to add java
support and configure MySQL so that all new database tables use the InnoDB
transaction-safe database engine instead of the default MyISAM engine. This is
essential if you are writing applications with technologies such as WebObjects
that automatically utilize the ACID commit or rollback capabilities of a
transaction-safe database.
Tuesday - July 17, 2007Monitoring and Resetting MySQL ReplicationOK, so you have a nice replication setup, but how
do you know it is actually working, and what do you do when it stops? This short
article shows how to check and quickly fix replication that has stopped. This
procedure takes 2 minutes and can be done remotely on the command
line.
Monday - March 12, 2007Compiling MySQL from SourceOK, I just upgraded to a MacBook Pro Core 2 Duo.
Generally the binary distributions are easier to work with, but I need SSL
connections capability, so I have to compile from source to have that feature
included. Her is how...........
Monday - March 12, 2007I Really Like MySQLI really like MySQL. I definitely would recommend
it for any enterprise database beginner with the only caveat being that you
should configure your /etc/my.cnf paying attention to using innodb as the
default table engine.....
Tuesday - November 21, 2006Building MySQL From Source with SSL Secure Connections SupportI needed SSL connection feature for secure
offsite replication. The prebuilt binaries do not include the SSL option, so I
had to build MySQL from source with the SSL option....
Friday - November 03, 2006MySQL Backup and Maintenance StrategyThis is a description of a simple backup strategy
for MySQL. At the time of this writing, we were using MySQL version 4.1.21 in a
master-slave replication configuration, described in a previous
article . The replication setup forms a basis for the backup strategy
and makes backup very easy while providing 24/7 planned uptime on the master
MySQL server.
Thursday - November 02, 2006MySQL built-in helpWhen I was upgrading from 4.0 to 4.1 I noticed
the internal 'mysql' database had tables of reference data. This allows clients
to get help directly from the server instead of browsign the online docs at
mysql.com. This is convenient when you are not connected to the
internet.....
Monday - October 30, 2006Setup XServe G5 with 10.4 Client as MySQL ServerWell, the new Quad Xeon 64-bit Intel XServes are
shipping November 2006, so there are deals to be found on PowerPC XServes on
eBay. We needed another XServe to add to our few G4 XServes, so we decided to
get the fastest machine we could on eBay and use it as our dedicated MySQL
server instead of the G4. We got a good deal on a cluster Dual 2.0 GHz G5 on
eBay recently. It came with 10.3 Panther Server, but we want to use Tiger and I
don't want to pay $499 for OS X Server Tiger right now (I'll wait a year when
they are going to be $149 long after Leopard Server has shipped). So we are
going to use Tiger 10.4 client on this headless G5 XServe. This article
documents some of the details in getting this set up......
Friday - October 27, 2006"Setting up a MySQL Replication Slave" Revisited for MySQL 4.1Ah well, since my first article on this, MySQL
has had multiple version changes and I have gained more experience in using
MySQL. (Off topic...... I really like the fact that I am stuck in everything
from MySQL server config/support thru Apache thru WebObjects/Java development,
deployment and administration ...... never a dull day in the job!). Here is my
"new improved" process for setting up a replication master-slave configuration
using MySQL 4.1.21. These instructions will definitely not work for version
4.0.XX and earlier and may not work for some earlier versions of 4.1. Earlier
version incompatabilities are mostly related to the parameters used in
mysqldump.
This article assumes a basic knowledge of unix (cd, ssh, scp, mkdir, chown) and a basic knowledge of mysql (mysqld, mysql, mysqldump, mysqladmin) Sunday - September 17, 2006First-time install of MySQL 4.1 on OS X Tiger ServerJust the notes for the installation steps on a
clean OS X Tiger Server 10.4.7 setup.
Thursday - May 11, 2006Export CSV file from MySQL with headings in first rowA tip posted by Heywood in the MySQL
manual on how to export headings in your CSV export....
Wednesday - May 11, 2005Monitoring MySQL Performance Using Log FilesMySQL has a number of different log files. Learn
more here . This
article details how I set them up on my servers.
Wednesday - April 20, 2005Copying specific tables from one database to anotherThis assumes you are copying tables from one
database on one server to another database on a different server...
Thursday - April 14, 2005MySQL on OS X ServerI do not run the Apple pre-cooked MySQL on OS X
Server. I always install the MySQL AB OS X Binaries and update when I want. I
don't want Apple OS X Server software updates updating the MySQL server
binaries. Bruce Dembecki at liveworld.com gave this tip on cleanly integrating
the MySQL binaries into OS X Server....
Thursday - February 24, 2005Comparing the Structure of two Versions of a DatabaseIf you are actively doing local development on
your Powerbook or Desktop and you need to upgrade a production database to the
same structure before you redeploy your revised web application, it may be
useful to first compare database structures using this simple
tip....
Thursday - January 06, 2005Table and Column Name Auto CompletionThe MySQL command line provides auto completion
of table and column names. For some reason mine stopped working for the first
time ever since I started using MySQL 18 months ago. The fix......
Thursday - December 23, 2004Copying a MySQL Database From One Machine to AnotherCopying a database from one server to another is
relatively simple in MySQL......
Monday - November 01, 2004Resyncing Broken MySQL ReplicationMy replication stopped working after we lost
power due to faulty Uninterruptable Power Supply on the slave while it was
replicating a massive 70 million record LOAD DATA INFILE from the Master. I
decided the simplest strategy here was to reset the replication process and copy
the master databases to the slave and start replication again. The whole process
took about 15 minutes, 10 of which the master was down while I copied the files
across the gigabit network to the
slave.
These instructions apply to simple case of one slave replicating from one master. These instructions are brief since I was busily resyncing while typing them, so excuse the brevity! Here is the steps involved (By the way, both master and slave were running OS X 10.3.5 Server, MySQL 4.0.20) [Revised 12/17/04] Thursday - June 24, 2004Setting up a MySQL Replication SlaveFor the last year I had avoided this because I
expected it would be hard. But replication is really is not that hard after all
.... and it makes backing up very easy avoiding special scripts, sql dumps, etc.
as well as providing peace of mind for unrecoverable hard drive failure of your
master server knowing that you have a perfect recent if not exact copy of ALL
databases on the slave.
Tuesday - June 22, 2004 |
|