From https://fedoraproject.org/wiki/Test_Day:2013-04-30_MariaDB, this installment of Fedora’s Test Day focuses on the replacement of MySQL with MariaDB. If you’re a Fedora (or RHEL or CentOS user), do take a peek at the page and see if you can pitch in – it might be a little bit of work for you, but with great benefits in terms of getting the MariaDB performance and features, and specifically on the day the Fedora crowd have extra people on the case to track and address issues you might find, so it’s an ideal opportunity to upgrade on a development or test-prod environment!
Hey everybody!
The Percona Live MySQL Conference and Expo just wrapped up last week and we're looking to get some conference in review talk from everyone! Talk about your favorite sessions, new things you learned, and your overall opinion of the conference!
Hop online Wednesday at 12:00pm PDT (19:00 GMT) to join the discussion and share your experience from the 2013 Percona Live: MySQL Conference and Expo.
Be sure to watch this twitter search or this blog post get a link for the google hangout tomorrow!
Some talks that were specifically called out:
- Monitoring MySQL with OpenTSDB by Geoffrey Anderson
- …
Oracle Database has a feature which allows it to query millions
of rows in parallel while executing a join which has a big
fanout.
How important is it that a database server has a lot of
intra-query concurrency? Does it still make a lot of sense to run
an analytical query in parallel threads, on a single
machine?
While at Percona Live, there was a lot of talk about the future
of MySQL, and some even mentioned this as being part of the
future.
The reason for intra-query parallelism has always been to fill up
the pipeline to disk with lots of parallel queries. Indeed, this
pipe is thick and long - and if used, it'd better produce a lot
of data at once. Efficiency of CPU utilization is sacrificed to
achieve efficiency of a rotating disk drive.
Yet in DaaS world this all fails to make sense to me. In a cloud,
one execution unit is not one CPU, but one instance, and one
database instance equals to a …
Oracle Database has a feature which allows it to query millions
of rows in parallel while executing a join which has a big
fanout.
How important is it that a database server has a lot of
intra-query concurrency? Does it still make a lot of sense to run
an analytical query in parallel threads, on a single
machine?
While at Percona Live, there was a lot of talk about the future
of MySQL, and some even mentioned this as being part of the
future.
The reason for intra-query parallelism has always been to fill up
the pipeline to disk with lots of parallel queries. Indeed, this
pipe is thick and long - and if used, it'd better produce a lot
of data at once. Efficiency of CPU utilization is sacrificed to
achieve efficiency of a rotating disk drive.
Yet in DaaS world this all fails to make sense to me. In a cloud,
one execution unit is not one CPU, but one instance, and one
database instance equals to a …
Oracle is the most powerful DBMS in the world. However, Oracle's expensive and complex replication makes it difficult to build highly available applications or move data in real-time to data warehouses and popular databases like MySQL.
In this webinar you will learn how Continuent Tungsten solves problems with Oracle replication at a fraction of the cost of other solutions and with less
Hi Sanjay,
Meet was very good as your presentations. I liked the features of 5.6 and your enhanced explanation about the Performance Schema. Thanks for making this meet up at Oracle.
Last week Tokutek announced that they’re open-sourcing their TokuDB storage engine for MySQL. If you’re not familiar with TokuDB, it’s an ACID-compliant storage engine with a high-performance index technology known as fractal tree indexing. Fractal trees have a number of nice characteristics, but perhaps the most interesting is that they deliver consistently high performance under varying conditions, such as when data grows much larger than memory or is updated frequently. B-tree indexes tend to get fragmented over time, and exhibit a performance cliff when data doesn’t fit in memory anymore.
The MySQL community is excited about having access to TokuDB’s source code, and rightly so. TokuDB is, broadly speaking, aimed at the same category of use cases as Oracle’s InnoDB, …
[Read more]
I have worked as an architect in the MySQL/NDB world for more
than 20 years and I am still working at Oracle and I like it
here. Given all the FUD spread about MySQL I thought it might be
a good idea to spread the word about all the great things we're
doing to MySQL at Oracle.
#1 We are working on improving modularity in MySQL code
base
In the early days of MySQL the MySQL development had serious
issues with its development model. It was a model designed for a
small code base. I used to work at Ericsson which is developing
telecom switches that have systems with tens of millions lines of
code. Such large systems require modularity. The Ericsson
switches was developed with modularity built into the programming
language already since the 70's. Even with this modularity a
second level of modularity was required. The learnings from this
reengineering project that span over more than a decade has given
me valuable insights …
With this version, the source code is now freely available under the GPL License v2. For more details, see our blog here. Open source pioneer Mozilla has been using TokuDB to manage its MySQL-driven Datazilla Data cluster, an open-source system for managing and visualizing performance data.
Date: May 2nd
Time: 2 PM EST / 11 AM PST
REGISTER TODAY
In the past TokuDB has been free for evaluation; the new TokuDB Community Edition extends free use to deployed environments. With this release Tokutek is also planning on making available a TokuDB Enterprise Edition, which includes technical support, initial customer onboarding services, and advanced tools for backup and recovery.
We …
[Read more]The Percona Live MySQL Conference & Expo 2013 was April 22-25 in Santa Clara, California. This was Percona’s second year organizing the conference and we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the great comments such as this from Tom Krouper or this from John Goulah or this from Jeremy Tinley or this from SF MySQL Meetup).
There are so many people involved with putting on this event that it’s impossible to list them all. The conference would be …
[Read more]