It's been almost two months since I have posted anything on the
Scale-Out Blog, as our entire team has been heads-down working on
Tungsten. We now have a number of accomplishments
that are worth writing articles about. Item one on that list is
community builds for Tungsten clusters.
Tungsten community builds offer a bone-simple process to check
out and build Tungsten clustering software. The result is a fully
integrated package that includes replication, management,
monitoring, and SQL routing. The community builds work for MySQL
5.0 and 5.1 and also allow you to set up basic replication from
MySQL to Oracle.
Community builds do not include much logic for autonomic
management, including automated failover and sophisticated rules
that keep databases up and running rain or shine. Those and other
features like floating IP address support are part of the …
Gartner has released a few days ago the Top 10 Strategic Technologies for 2010 list. Here
you can see the wordle cloud:
While I don't want to spend time talking about the usual
suspects (Cloud, Green, Mobile and Virtualization) I wish to
share my thoughts on two topics: Advanced Analytics and
Reshaping the Data Center.
Advanced Analytics
I'm not surprised that a branch of Business Intelligence is still
in the list after years of top priority amongst CIOs. Business
Intelligence is one of the fields that I love and it's promise is
to transform in gold everything it touches, like …
See the OurDelta blog for details of this release. RHEL/CentOS packages also coming.
You can now apt-get your way to MariaDB 5.1, courtesy of OurDelta and in close cooperation with Monty Program Ab. To get started, simple follow the info on the Debian and Ubuntu pages.
Quick overview
- For MariaDB we use different repository directories to ensure that you can’t accidentally upgrade or revert major versions without you explicitly choosing to do so.
- At this point we have Ubuntu Hardy, Intrepid, Jaunty and Karmic for you, as well as Debian 4 (Lenny). Etch (Debian 4) is waiting on a small fix (thanks to Antony Curtis for helping with that).
- The package names start with mariadb*, except …
So we have gone through over 200 revisions for Kontrollbase version 2.0.1 and the team is internally discussing which new features and current open tickets should be added and/or addressed for the 2.0.2 milestone release. Here is your chance to push your ideas and wants into the next major release. So, before shooting off [...]
Over and over I see customers that don't understand what
int(11) really means. Their confusion is
understandable. Many know what defining a char(10)
means (a fixed-sized character string that allows up to 10
characters). However, ints are different.
First of all, there are 5 types of integer. They are all fixed
size.
| Type | # of bytes |
| tinyint | 1 |
| smallint | 2 |
| mediumint | 3 |
| int | 4 |
| bigint | 8 |
As you can see from the chart, an int is
always 4 bytes. That can store signed numbers …
Tokutek is pleased to announce the general availability of TokuDB for MySQL, version 2.2.0. This version offers several improvements:
- Better multi-core load balancing for concurrent workloads.
- Faster bulk loading performance.
- Enhanced diagnostics for easier tuning and troubleshooting.
- Fixed all known bugs.
About TokuDB
TokuDB for MySQL is a storage engine built with Tokutek’s Fractal Tree technology. TokuDB provides near seamless compatibility for MySQL applications. Tables can be individually defined to use TokuDB, MyISAM, InnoDB or other MySQL-compliant storage engines. Data is loaded, inserted, and queried using standard MySQL commands, with no restrictions or special requirements. Our Fractal Tree technology indexes up to 50 times faster than traditional database technologies, enabling near …
[Read more]Tokutek is pleased to announce the general availability of TokuDB for MySQL, version 2.2.0. This version offers several improvements:
-
- Better multi-core load balancing for concurrent
workloads.
- Faster bulk loading performance.
- Enhanced diagnostics for easier tuning and
troubleshooting.
- Fixed all known bugs.
About TokuDB
TokuDB for MySQL is a storage engine built with Tokutek’s Fractal Tree technology. TokuDB provides near seamless compatibility for MySQL applications. Tables can be individually defined to use TokuDB, MyISAM, InnoDB or other MySQL-compliant storage engines. Data is loaded, inserted, and queried using standard MySQL commands, with no restrictions or special requirements. Our Fractal Tree technology indexes up to 50 times faster than …
[Read more]End of the week notice to let everyone know that Kontrollbase 2.0.1 revision 206 is now available for download. Effectively the same issues have been addressed as in the previous post about rev-205 but now you don’t have to use subversion as the tar.gz file is available. As usual you can find the download here: [...]
Topics for this podcast:
*-DoD memo and official use and consideration of open
source
*EnterpriseDB updates its Postgres Plus Server, gets Red Hat
investment
*Latest in Linux from Canonical’s Ubuntu and Red Hat Enterprise
Linux, Deltacloud
*Roundup of Oracle-Sun-MySQL developments and perspectives
iTunes or direct download (25:30, 5.8 MB)