Here is some pointers to my MySQL conference slides.
Here is the presentation on MySQL 5.5 Performance and
Scalability improvements
here
Here is the presentation on the MySQL 5.5 Performance
and Scalability benchmarks
here
Apr
13
2010
Apr
13
2010
I have noticed a definite increase in NoSQL buzz over the last few months. This is partly confirmed by Google Trends, this service shows data relating to how search topics rank:
The last couple of months has seen a dramatic rise in both the number of searches and also the number of news items relating to NoSQL.
But the traditionalists need not yet fret, interest in NoSQL is yet but a blip on the data management radar, as demonstrated by this compairson between NoSQL and MySQL search rankings:
I will be interesting to see how the dynamics of this change
throughout 2010 though.
Related articles by Zemanta …
Apr
13
2010
Done! Here are the slides:
And video:
Apr
13
2010
The MySQL Conference and Expo started with me and Lars Thalmann doing the replication tutorial. Unfortunately, we cannot at this time distribute the slides (please watch the replication tutorial page at the conference site), but there is a replication tutorial package for easy setup of server to play around with—including some sample scripts—and a paper that both explains how the package can be used as well as giving some example setups.
- The software package can be downloaded from the forge and requires Perl at least version 5.6.0 to execute.
- The article can can also be …
Apr
13
2010
The performance work I was involved in in 5.5 had its few moments
of fame today. However, if you looked carefully at the graphs on
Edward's slides, you'd seen that 200% gains come from workloads
where MySQL performance would previously simply deteriorate (128
threads and more). The good news is that we didn't just fix the
high-thread-count results, but significantly increased peak
performance, reached at 32-64 threads. I'm sure community will
figure this out, and post independent benchmarks. The results are
excellent in any case.
Too bad Edward left without taking any questions, the whole thing
looked a bit rushed.
Apr
13
2010
We are happy to announce the new and exciting replication
features in the MySQL 5.5.3 development release.
If you are at the MySQL User Conference, you are most welcome to
join the "New Replication Features" talk at 2pm today where these
will be presented in more detail.
- Semi-sync replication plugin - you can now have improved resilience of the overall replication by having a master server to wait for the slave server to collect and persist events in the relay log on a per transaction basis. As a consequence, by the time the user commits a transaction there is a guarantee that the events are already written to one or more slaves relay logs. This feature is provided as a plugin and using it is as easy as installing the plugin and enabling it.
- Slave fsync tuning - you can now fine tune relay logs and {master|relay-log}.info fsyncs operations so that corruption is much less likely …
Apr
13
2010
Dear Community,
Today we are pleased to announce the release 10 of Percona Server with XtraDB storage engine.
Since the previous release 9.1 there are following changes
- MySQL 5.1.45 as a basis for the release
- I_S SYS_TABLES
- New patch page_size_and_expand_log. It allows to change InnoDB pages size to 4K or 8K. Also InnoDB log files now can be bigger 4G
- New patch innodb-fast-checksum. It adds new faster checksum algorithm used in InnoDB tables
- New supported platforts are added. The full list includes
(karmic is new):
- CentOS 5 (x86_64 and i386)
- CenOS 4 (x86_64 and i386)
- Debian lenny (x86_64 and i386)
- Debian etch (x86_64 and i386)
- Ubuntu Karmic (x86_64 and i386)
- Ubuntu Jaunty (x86_64 and i386) …
Apr
13
2010
600 new customers for SugarCRM. James Gosling leaves Oracle. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
# SugarCRM added nearly 600 customers in the first quarter of 2010.
# James Gosling resigned from Oracle.
# VMware’s SpringSource acquired Rabbit Technologies and its RabbitMQ messaging software.
# EnterpriseDB hired Sun’s former MySQL VP Karen Tegan Padir as vice president of products and marketing.
# …
[Read more]
Apr
13
2010
We’re proud to announce Beta 8 of MySQL Workbench 5.2.
Since beta 7 we have fixed additional bugs as well as put in some
improvements requested by the community so we decided to pack up
another release for you to check out. This Beta includes fixes
for 35 bugs (P1 – 1, P2 – 10 , P3 – 24)
Also we have added new HUD-style (FADE IN) UI elements to show wait-times while WB is setting up connections (currentlz windows only, will be added to linux/mac in next release).
Additionally we have added Connection-/Instance-sorting, now you can go to the connection/instance manager and sort using up/down buttons.
For more on these new features check out http://wb.mysql.com
A big “thank you” to all the people who have been testing MySQL Workbench 5.2 alphas and betas and taking the time to file bugs and provide valuable feedback. We have fixed many bugs since last release and worked on some other details as …
[Read more]
Apr
13
2010
Everybody at the MySQL Conference & Expo 2010 who is interested in MySQL Workbench, please feel free to join me for an in-depth presentation about the current MySQL Workbench 5.2 product and future plans. Looking forward to see you there!
Follow this link to the Conference Schedule for time and coordinates.
For everybody who could not joins us at the MySQL Conference & Expo this year I have uploaded the slides below. I included a lot of tips & tricks in the presentation. So even if you are not able to see the live demo, taking a look at the slides might still be a good idea.
MySQL_Conference2010_MySQL_Workbench_V3.pdf
Enjoy!