I’m going to deliver MySQL Training next week (May 21-24) in
London.
This is a rare opportunity as I do not personally deliver a lot
of Training, especially outside of US. There are still some
places left if you want to sign up.
You will also get a signed copy of High Performance MySQL 3rd edition as an attendee.
The MySQL Developer Tools team is announcing the next maintenance
release of it’s flagship product, MySQL Workbench, version
5.2.40.
This version contains more than 28 bug fixes applied over version
5.2.39.
MySQL Workbench 5.2 GA
• Data Modeling
• Query
• Administration
Please get your copy from our Download site.
Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.
http://dev.mysql.com/downloads/workbench/
Workbench Documentation can be found here.
http://dev.mysql.com/doc/workbench/en/index.html
Utilities Documentation can be found here.
…
The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench, version 5.2.40. This version contains more than 28 bug fixes applied over version 5.2.39.
MySQL Workbench 5.2 GA
• Data Modeling
• Query
• Administration
Please get your copy from our Download site.
Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.
http://dev.mysql.com/downloads/workbench/
Workbench Documentation can be found here.
http://dev.mysql.com/doc/workbench/en/index.html
Utilities Documentation can be found here.
…
A hardware, software or human failure can occur at any time. Are
you prepared?
Many organizations take a risk of serious data loss and system
downtime with inadequate procedures in place to support a
disaster recovery. This presentation covers the essentials of
MySQL backup and recovery options, identifying the necessary
tools for an effective strategy to support data resilience and
business continuity for your organization. MySQL has no one
single unbreakable backup solution, so it is important to
understand the impact of MySQL replication, storage engines,
configuration options for durability, hardware configuration and
the impact on locking and uptime for the various hot/warm/cold
options …
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and effective tool iiBench which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally built is long over, but still the tool serves well for benchmark purposes.
OK, let’s start off with the configuration details.
Configuration
First of all let me describe the EC2 instance type that I used.
EC2 Configuration
I chose m2.4xlarge instance as that’s the instance type with highest memory available, and memory is what really really matters.
High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute Units (8 virtual cores with 3.25 EC2 Compute …[Read more]
Dynamic Data Masking is an emerging technology that provides real-time data masking in changing environments, typically in production databases.
GreenSQL Dynamic Data Masking enables you to mask or randomize any sensitive information stored on MS SQL Server, MySQL and PostgreSQL databases.
When? Wednesday, May 23, 2012 (9:00 am PDT; 12:00 pm EST; 16:00 pm GMT; 19:00 pm GMT+3:00)
In this webinar, David Maman, GreenSQL Founder and CTO, will explain:
Tackling machine data on the ground to ensure successful operations for NASA in space
Issues addressed:
The Company: Southwest Research Institute (SwRI) is an independent, nonprofit applied research and development organization. The staff of more than 3,000 specializes in the creation and transfer of technology in engineering and the physical sciences. Currently, SwRI is part of an international team working on the NASA Magnetospheric Multiscale (MMS) mission. MMS is a Solar Terrestrial Probes mission comprising four identically …
[Read more]
We've recently seen some great announcements of MySQL Cluster
delivering amazing results for
both selects and updates. The posts (see related
articles below) are full of juicy technical details and proofs,
but today I'd like to change the perspective a bit. Let's
compare those figures with real-world data and imagine what could
be done. Please note that I'm not using any scientific method
here, just dreaming about the unlimited opportunities offered by
MySQL Cluster today.
| MySQL Cluster 7.2.7 -- 1B+ Writes per Minute |
Cluster can deliver 1B+ selects per minute with 8 nodes …
[Read more]Percona is glad to announce the release of Percona Server 5.5.23-25.3 on May 16, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.23, including all the bug fixes in it, Percona Server 5.5.23-25.3 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.5.23-25.3 milestone at Launchpad.
Bugs Fixed:
In MySQL Cluster there is a limiting factor in the receive
threads that limits our update performance to about 0.5M update
transactions per node group per second (usually 2 nodes per node
group). In MySQL Cluster 7.2.7 we have removed most of this
bottleneck and can now achieve 3x as many update transactions.
We're reaching about 1.5M updates per node group per second. On a
30-node configuration we achieved 19.5M update transactions per
second which corresponds to 1.17BN updates per minute. This means
we achieve almost linear increase of update performance all the
way to 30 data nodes.
The benchmarks were executed using the benchmark scripts
dbt2-0.37.50 available at dev.mysql.com, the benchmark program is
the flexAsynch program mentioned in some of my earlier blogs. We
used 8 LQH threads per data node.
