I promised folks I'd put up the PDF of the slides (~401K) from the Introduction to MySQL Cluster session at PHP Quebec. The PDF doesn't capture much of the detail, and none of the conversation that comes from questions raised but it does give a sense of what was covered.
I think the session was recorded, not sure how/when that is available. I think PHP Quebec produces a CD with all of the sessions in mp3. If it's generally available I'll post it here.
I like duplicate emails in the way that everybody is thinking. This is different.
Due to a bug in offlineimap i hit a little while ago, it’s managed to make copies (sometimes even two copies) of each email in certain folders. Now, this isn’t so bad as
a) email didn’t get lost
b) it’s just using extra disk, and disk is cheap.
but it is annoying when searching.
It’s also annoying because it’s decided to do this on folders such as INBOX/MySQL/bugs which contains an email for each change to a bug report even since I joined the company. That adds up to a lot of wasted inodes and disk blocks.
So, I’ve revived this project that I have in the back of my head of efficiently storing email in a database and being able to sync between instances of it.
This gives us some nice advantages. you can use replication to keep a backup of your email. You can put it in Cluster and have high …
[Read more]I haven't tagged my series of posts from PHP Quebec as MySQL because there's a lot of non-MySQL stuff that may or may not be of interest to MySQL folks. They are the previous seven posts in the "Technology" category for anyone that's interested.
A few items worthy of note for MySQL folks:
Being a CVS Version Control Person, I’ve had to learn Subversion as part of Open Source Contribution. Both MySQL and JMeter use SVN.
Steps for integration of SVN into Eclipse IDE. Refer to Subclipse for more information.
Installation of JMeter via SVN
We are now starting work on a new, specialized MySQL Certification: The Blackhole Certification. This certification will be an add-on to the MySQL DBA Certification, which is due to be released in it’s GA version in a few weeks (if you’re quick, you can still catch the much less expensive MySQL 5.0 Beta certifications).
The Blackhole certification will cover all administrative aspects of the Blackhole Storage Engine. To prepare candidates for the new certification, the MySQL training deparment will also be offering a 5-day training bootcamp. Please see the …
[Read more]Ben Forta is the author of several “Teach Yourself” books, among which you may be familiar with his Teach Yourself SQL in 10 Minutes (us; uk). His new book, MySQL Crash Course, (us; …
[Read more]
As I mentioned last week, I got a copy of Alex Davies
and Harrison Fiskâ??s book MySQL Clustering (us; uk). The book is not very big, and with some
14 stuck-in-an-airplane-seat hours available, I got a chance to
read through the remaining chapters.
It will be easy to claim that this is the book on MySQL
Cluster, but since it’s so far the only one in existence, I guess
I’ll have to reserve judgment on that …
To find a list of tables in a schema:
$ sqlcli -u TEST,TEST -d SYNCMANA "SELECT * FROM TABLES WHERE SCHEMANAME = 'TEST'"
To find a list of triggers on a table:
$ sqlcli -u DBSERVICE,SECRET -d SYNCMANA "SELECT * FROM TRIGGERS WHERE TABLENAME = 'T'"
To describe a table’s structure:
$ cat me && echo "-----" &&
loadercli -d SYNCMANA -u TEST,TEST -b ./me && echo "-----" &&
cat tabledef.txt
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'
-----
Loader protocol: '/home/cjcollier/.sdb/loader/log/loader.prt'
Loader packages: '/home/cjcollier/sdb/loader/packages'
User TEST connected to database SYNCMANA schema TEST on local host.
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'
Successfully executed
-----
//
CREATE TABLE "T"
(
"I" Integer NOT NULL,
"C" Varchar (32) UNICODE,
PRIMARY KEY ("I")
)
NO …[Read more]
Slides from my presentations at the PHP Québec Conference are below:
I will make the audio of the licensing session, along with a transcript, available as soon as possible.
Update:
[Read more]
... from Andrew that he doesn't find the time to maintain mysqldevelopment.com any longer and write MySQL
related blog articles :-(.
It would be too bad to let mysqldevelopment.com die, so I hope
that there's a way to keep it alive in some form or another. I
know that it's a huge amount of work for a single person to keep
such a site up to date, so maybe there's a way to integrate the
content into MySQL Forge or to create a Wiki to make it easy to
anybody who just has something interesting to contribute it. I
would also integrate it into the db4free.net project, if there's no other way.
Any rescue is better than letting it …