Dave Stokes posted earlier that the official list of MySQL
Certified will be going away. There has been a MySQL
Certified Professionals LinkedIn group for almost 2 years
now. It's community managed by myself and Dave, and is open to
all MySQL Certified DBAs & Developers, as well as recruiters &
hiring managers.
-- Mark
mark@thetajoin.com
http://www.thetajoin.com - The Drupal Hosting &
Performance CompanyMySQL DBA & Programming Blog by Mark
Schoonover
Drizzle is one
of the really great pieces of technology to emerge from the MySQL
diaspora--a lightweight, scalable, and pluggable database for web
applications. I am therefore delighted that Marcus Erikkson has published a patch to
Tungsten that allows replication from MySQL to
Drizzle. He's also working on implementing Drizzle-to-Drizzle
support, which will be very exciting.
Marcus has submitted the patch to us and I have reviewed the
code. It's quite supportable, so I plan to integrate it as soon
as we are done with our next Tungsten release, which will post
around 5 November. You will be able to build and run it using our
new …
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]