Please find a nice article by Djoni Darmawikarta here. He gives a nice step-by-step tutorial on how to use MySQL Workbench to create a simple model and then use the Forward Engineering functionality to create the actual database schema.
If you have written such a tutorial yourself or plan to write one, please drop us a email at workbench@mysql.com and we will be happy to feature you on our official Workbench Blog!
I want to get opinions from outside of my daily circle of people on the best server hardware to use for MySQL. I remember from the conference somebody (Pipes?) mentioning a particular Dell server with multiple disk RAID10 that could supposedly be had for about $6k but I completely misplaced the model number (Frank, did you get my email?).
I know that a multi-disk RAID array with a bunch of fast disks (15k RPM?) is probably the most important method of improving performance, followed by the amount of RAM, so I'm trying to find the best combination/balance of the two. However, server prices on the Internet range so much that I don't even know where to begin to tell a good deal from a bad one. I don't think SSDs can play a role here, because we …
[Read more]In this post I shall show you how you can set up a MySQL community server on your Solaris installation.
Some useful information:
You will need the following tools:
In this post I shall show you how you can set up a MySQL community server on your Solaris installation.
Some useful information:
You will need the following tools:
We run an internally developed AMP benchmark to understand the
performance characteristics of the AMP stack on various
platforms.
We did some comparisons of the AMP stack in Cool Stack 1.2 with the one in Cool Stack 1.3. We didn't see any signficant difference in performance in the Apache/PHP tier between the two versions. However, there is a dramatic improvement in performance in the MySQL tier using Cool Stack 1.3. Cool Stack 1.2 shipped with MySQL 5.0.45 and 1.3 now has MySQL 5.1.24.
The graph below shows the CPU utilization on the MySQL system at different load levels :
MySQL 5.1 is 4x more efficient than 5.0.45 ! There are improvements in the Query Cache and query optimization in MySQL 5.1, but at this point we are doing more analysis to understand the reasons for the dramatic performance increase. Here is another graph that shows the network …
[Read more]
We run an internally developed AMP benchmark to understand the
performance characteristics of the AMP stack on various
platforms.
We did some comparisons of the AMP stack in Cool Stack 1.2 with the one in Cool Stack 1.3. We didn't see any signficant difference in performance in the Apache/PHP tier between the two versions. However, there is a dramatic improvement in performance in the MySQL tier using Cool Stack 1.3. Cool Stack 1.2 shipped with MySQL 5.0.45 and 1.3 now has MySQL 5.1.24.
The graph below shows the CPU utilization on the MySQL system at different load levels :
MySQL 5.1 is 4x more efficient than 5.0.45 ! There are improvements in the Query Cache and query optimization in MySQL 5.1, but at this point we are doing more analysis to understand the reasons for the dramatic performance increase. Here is another graph that shows the network …
[Read more]
It's finally here. Before you download the release, please do read the documentation. It's over a month late, but
hopefully the features will compensate for the delay.
Almost every single component in the stack has been upgraded. Two
new packages, CSKpython and CSKnginx have been added. And yes -
the python package does include mod_python too.
You can read about the full list of changes in the Changelog.
ruby
Significant changes have been made to the ruby package. In addition to the upgrade to ruby1.8.6p114, we include a number of gems, notably mysql, postgres and mongrel. It should also be easy to install any new gem …
[Read more]
It's finally here. Before you download the release, please do read the documentation. It's over a month late, but
hopefully the features will compensate for the delay.
Almost every single component in the stack has been upgraded. Two
new packages, CSKpython and CSKnginx have been added. And yes -
the python package does include mod_python too.
You can read about the full list of changes in the Changelog.
ruby
Significant changes have been made to the ruby package. In addition to the upgrade to ruby1.8.6p114, we include a number of gems, notably mysql, postgres and mongrel. It should also be easy to install any new gem …
[Read more]Netbeans 6.1 was released recently which includes PostgreSQL JDBC driver. It had been a while since I had done programming as a developer, so I decided to take it for a test drive to refresh my programming skills with it. Well here is the resulting demo application:
Remember it is just a demonstration application. It requires your client (laptop or desktop ip address) to be trusted in pg_hba.conf ip adddress in order to work with your database.
Update on Sept 30,2008: Added a new dialog box which includes option for password and also the new L&F called nimbus (JRE6u10 recommended). Here is a quick screenshot:
MemProxy 0.1 is out! It has taken me a
while, but I have finally gotten around to releasing the code
that I credited with saving us during a Yahoo! mention. It is a caching proxy
"server" that uses memcached for storing the cache. I put
server in quotes because it is really just a PHP script that
handles the caching and talking to the application servers.
Apache and other HTTP servers already do a good job talking HTTP
to a vast myriad of clients. I did not see any reason to
reinvent the wheel. Here are some of the features that make
it different from anything I could find:
