Log on to your system as the Unix mysql user that the mysqld
server runs as.
Locate the .pid file that contains the server's process ID. The
exact location and name of this file depend on your distribution,
host name, and configuration. Common locations are
/var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/.
Generally, the file name has an extension of .pid and begins with
either mysqld or your system's host name.
You can stop the MySQL server by sending a normal kill (not kill
-9) to the mysqld process, using the path name of the .pid file
in the following command:
shell> kill `cat /mysql-data-directory/host_name.pid`
Note the use of backticks rather than forward quotes with the cat
command; these cause the output of cat to be substituted into the
kill command.
Create a text file and place the following statements in it.
Replace the password with the password …
Sun is launching systems with multisocket 6-core Opterons (Istanbul) today. Last week I got access to Sun Fire X4140 with 2 x 6-core Opterons with 36GB RAM. It is always great to see such a 1RU system packaged with so many x64 cores.
# psrinfo -vp The physical processor has 6 virtual processors (0-5) x86 (chipid 0x0 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz) Six-Core AMD Opteron(tm) Processor 8435 The physical processor has 6 virtual processors (6-11) x86 (chipid 0x1 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz) Six-Core AMD Opteron(tm) Processor 8435
I decided to take the system for a test drive with Olio. Olio is a Web 2.0 toolkit consisting on a web 2.0 event calendar application which can help stress a system. Depending on your favorite scripting language you …
[Read more]
Tungsten Replicator has built-in backup and
restore for MySQL! I checked in the final touches over the
weekend. Here's how to run a backup on a database and store it so
you can restore it later. If you leave off options, we use the
default back-up procedure and storage that you select when
setting up replication.
trepctl backup [-backup agent] [-storage agent] [-limit timeout]
And here's how to restore. If you leave off the options, we find
the latest backup in your default storage and load that.
trepctl restore [-uri backup_uri] [-limit timeout]
That's the syntax. Now here's what happens behind the scenes.
First Tungsten Replicator has a new BackupAgent plug-in that
implements backup procedures. We have a backup agent for each the
following types of backups for MySQL:
- Mysqldump - …
A quick blog post from the OSCON floor where I just finished a
3.5 hour tutorial on "Scaling a Web Application (mostly
PHP/MySQL)". To be honest I submitted this talk as a 45 min talk
and clicked the wrong button and ended up being handed a tutorial
which I think turned out to be a good thing. After all, we could
spend days and years talking about scaling.
One of my goals in this presentation wasn't just to talk about
tips and examples, but also talk about the general business of
scaling and creating scaling plans, scenario planning or capacity
planning. This I believe is almost always more important than
coming up with the small tips that fix a site when you have a
problem!
Thanks to Ronald Bradford for showing up for the last hour
of the presentation and helping out, it's good to have help and
from a knowledgeable expert as well :)
Slides are now …
Sun is launching systems with multisocket 6-core Opterons (Istanbul) today. Last week I got access to Sun Fire X4140 with 2 x 6-core Opterons with 36GB RAM. It is always great to see such a 1RU system packaged with so many x64 cores.
# psrinfo -vp The physical processor has 6 virtual processors (0-5) x86 (chipid 0x0 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz) Six-Core AMD Opteron(tm) Processor 8435 The physical processor has 6 virtual processors (6-11) x86 (chipid 0x1 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz) Six-Core AMD Opteron(tm) Processor 8435
I decided to take the system for a test drive with Olio. Olio is a Web 2.0 toolkit consisting on a web 2.0 event calendar application which can help stress a system. Depending on your favorite scripting language you …
[Read more]Sun is launching systems with multisocket 6-core Opterons (Istanbul) today. Last week I got access to Sun Fire X4140 with 2 x 6-core Opterons with 36GB RAM. It is always great to see such a 1RU system packaged with so many x64 cores.
# psrinfo -vp The physical processor has 6 virtual processors (0-5) x86 (chipid 0x0 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz) Six-Core AMD Opteron(tm) Processor 8435 The physical processor has 6 virtual processors (6-11) x86 (chipid 0x1 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz) Six-Core AMD Opteron(tm) Processor 8435
I decided to take the system for a test drive with Olio. Olio is a Web 2.0 toolkit consisting on a web 2.0 event calendar application which can help stress a system. Depending on your favorite scripting language you …
[Read more]I started my company about a year ago, but I’ve been doing consulting for a long time. In fact, my first job in the IT industry was working for a consulting firm. Before that, starting as far back as grade school, I was involved in a lot of volunteer civic and community service activities. I admire companies who get involved in their communities, or even outside of their communities, wherever help is needed.
As part of my business plan, I’ve put in place a policy of accepting one pro-bono consulting project per year. So far, I haven’t gotten any requests for free consulting work, so here’s my public shout out to let you know what types of services are available:
1. Speaking or Training. My specialties are things like advanced Linux administration and SQL, but I’m perfectly capable of delivering content for people who just need to know how the internet works, or want to …
[Read more]I started my company about a year ago, but I’ve been doing consulting for a long time. In fact, my first job in the IT industry was working for a consulting firm. Before that, starting as far back as grade school, I was involved in a lot of volunteer civic and community service activities. I admire companies who get involved in their communities, or even outside of their communities, wherever help is needed.
As part of my business plan, I’ve put in place a policy of accepting one pro-bono consulting project per year. So far, I haven’t gotten any requests for free consulting work, so here’s my public shout out to let you know what types of services are available:
1. Speaking or Training. My specialties are things like advanced Linux administration and SQL, but I’m perfectly capable of delivering content for people who just need to know how the internet works, or want to …
[Read more]
The fine folks at O'Reilly sent me reviewer copy of two books on
Erlang
-
-
Erlang Programming: A Concurrent Approach to
Software Development by Francesco Cesarini and Simon
Thompson
-
Programming Erlang: Software for a Concurrent
World by Joe Armstrong.
I am currently in the process of learning Erlang for a personal
project. These books both measures up to the high expectations I
have come to expect from Pragmatic Programmers Publishing and
from O'Reilly Books.
Erlang is a difficult language to "sell", and is a challenge to
learn.
Both books assume you have decently good programming skills, and
don't need your hand held too much …