I presented on "Creating powerful web applications using
GlassFish, MySQL and NetBeans/Eclipse" as the first talk of
FISL 10 yesterday. The room was only partial full being the first
talk of FISL but got packed towards the middle so that was
exciting. The slides are available here.
The key message is that NetBeans and Eclipse provide a seamless development/deployment
environment for GlassFish.
The several demos shown in the talk are explained at:
|
I just found out but Sang has been teaching a series of 1-day free training sessions on JavaFX, MySQL and GlassFish. The full list is at his JavaPassion Site but by now there are only 3 days left, so check it out and signup if you are interested and available. |
Mark Leith, on of the MySQL Support Team managers wrote some time ago a very nice utility I use often called Statpack.
My use of Statpack is very simple. Take two snaphots of SHOW GLOBAL STATUS and compare to produce a text based version of the statistics.
Over time I’ve grown to love it’s simplicity, but notice a number of shortcomings. Being open source there is always the ability to modify, improve and give back. This post is more about detailing those little annoyances that I’d like to improve, or see improved. It is also a means to collate points into one location that I often forget about over time.
I welcome any input, and specifically help in this open source venture.
Here is my wish list that I can currently remember. I do plan to action, time permitting.
|
FISL stands for "Forum Internacional Software Livre" in the
Portuguese language and means "International Free Software
Forum" in the English language. The punch line is "A
technologia que liberta" and means "The technology that
liberates". This is the biggest event about free software in America and was attended by 7417 participants in 2008. |
Just like "Freedom of Speech" is a basic human right, "Freedom of
Software" is a basic right for the technology evolution. GlassFish gives you the
freedom:
|
FISL stands for "Forum Internacional Software Livre" in the
Portuguese language and means "International Free Software
Forum" in the English language. The punch line is "A
technologia que liberta" and means "The technology that
liberates". This is the biggest event about free software in America and was attended by 7417 participants in 2008. |
Just like "Freedom of Speech" is a basic human right, "Freedom of
Software" is a basic right for the technology evolution. GlassFish gives you the
freedom:
|
FISL stands for "Forum Internacional Software Livre" in the
Portuguese language and means "International Free Software
Forum" in the English language. The punch line is "A
technologia que liberta" and means "The technology that
liberates". This is the biggest event about free software in America and was attended by 7417 participants in 2008. |
Just like "Freedom of Speech" is a basic human right, "Freedom of
Software" is a basic right for the technology evolution. GlassFish gives you the
freedom:
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.
Oracle will always be a more featured product then MySQL. There are however features that MySQL has that Oracle does not. While I’ve got a draft of a list of my own, I have several hundred incomplete drafts.
One of these features I was able to demonstrate to a client is the ability to have multiple VALUES clauses for a single INSERT statement. For example.
INSERT INTO t1(c1) VALUES (1), (2), (3), (4), (5);
…
[Read more]Recently I came across another configuration option I’d not heard of before. I profess to not know them all, however I do know when I find something unusual. If you are a beginner DBA, learn what is normal and expected, and identify what is out of the normal, investigate, research and question if necessary.
I gave away a MySQL Administrator’s Book based on seeing a configuration with safe-show-database, an option I’d not seen before, and then requesting people giving basic configuration options in that situation.
The latest is max_tmp_tables. So, what does the manual say for this option. I quote:
The maximum number of temporary tables a client can keep open at the same …
[Read more]
If you are using the following versions of MySQL Cluster:
MySQL Cluster 6.3.17 - SHOW
TABLES can drop tables...
MySQL Cluster 6.3.18 - the above wasn't really fixed (fixed in
6.3.20)
MySQL Cluster 6.3.19 - the above wasn't really fixed (fixed in
6.3.20)
MySQL Cluster 6.3.21 - regression, pulled back because of
this.
If you are on any of these versions - then upgrade!
The latest source and binary release is MySQL Cluster 6.3.24.
I have been working recently with Matt Yonkovit to get Waffle Grid cloud enabled with Amazon Web Services (AWS).
An initial version of Waffle Grid Cream - Version 0.5 release is now available.
We have elected to create one AMI for now, that is ready to be configured as either a MySQL Server, a memcached server, or as in the following example both. For this first version, we have also not configured MySQL or memcache, but rather provide a virgin Waffle Grid ready server for developers to experiment and benchmark with.
Future releases will include custom AMI’s and the automated ability to register new memcached servers with the Waffle Grid enabled MySQL server.
Instance Creation
We assume you have created an …
[Read more]