This is a nice blog post from Asher Feldman, Site Architect, Wikipedia on how Wikipedia Adopts MariaDB. If you’re using English or German Wikipedia, or using Wikidata, you’re currently being served by MariaDB 5.5.
Apr
22
2013
Apr
22
2013
3Ci processes over a billion transactions a month. More than 100 million unique U.S. consumers have engaged with a business through our platform. All that activity creates massive amounts of data. The Data Team at 3Ci is responsible for keeping our offerings running at optimal performance and for making sense of our data. They manage MySQL [...] …
[Read more]
Apr
22
2013
If you are a MySQL support customer, the recent release of My Oracle Support (MOS) 6.5 has some features which may interest you (if you’re not a customer, this post likely won’t interest you). MOS 6.5 was introduced on 06 April, and with it came the ability to opt in to receive service request (SR) update details via email. This was a feature some MySQL Support customers missed after the migration to MOS. Thanks to feedback from MySQL Support customers and others with similar needs, this feature has now been implemented. Because email is an inherently insecure delivery mechanism, not all customers will wan this, and the feature requires customers to explicitly opt in before SR update content is sent via email. Coupled with the MOS Mobile interface, Support customers have a number of flexible ways to access and manage SRs.
The second major enhancement is the ability to …
[Read more]
Apr
22
2013
Percona is glad to announce the release of Percona XtraBackup 2.1.0 for MySQL beta on April 22, 2013. Downloads are available from our download site here. For this BETA release, we will not be making APT and YUM repositories available, just base deb and RPM packages
This is an BETA quality release and is not intended for production. If you want a high quality, generally available release, the current stable version should be used (currently 2.0.6 in the 2.0 series at the time of writing).
This release contains all of the features and bug fixes in …
[Read more]
Apr
22
2013
Even frequent visitors to bugs.mysql.com can sometimes miss the little note in the bottom right corner of each page:
Page generated in 0.017 sec. using MySQL 5.6.11-enterprise-commercial-advanced-log
That text changed this past weekend, going from MySQL Enterprise
5.6.10 to 5.6.11. But more importantly, the collection of
MyISAM tables which support the bugs system were also converted
to InnoDB. There’s a little story to tell here about eating
this particular helping of dogfood which also amplifies changelog comments, so here it is:
We like to keep bugs.mysql.com on a current release of MySQL, and
we started looking to upgrade from 5.5.27 shortly after GA.
In doing so, …
Apr
22
2013
MySQL replication enables data to be
replicated from one MySQL database server (the master) to one or
more MySQL database servers (the slaves). However, imagine the
number of use cases being served if the slave (to which data is
replicated) isn't restricted to be a MySQL server; but it can be
any other database server or platform with replication events
applied in real-time!
This is what the new Hadoop Applier empowers you to
do.
An example of such a slave could be a data warehouse system such
as Apache
Hive, which uses HDFS as a data store. If you have a Hive
metastore associated with HDFS(Hadoop Distributed File System), the Hadoop
Applier can populate Hive tables in real time. Data is …
Apr
22
2013
This is a follow up post, describing the implementation details
of Hadoop Applier, and steps to configure and install it.
Hadoop Applier integrates MySQL with Hadoop providing the
real-time replication of INSERTs to HDFS, and hence can be
consumed by the data stores working on top of Hadoop. You can
know more about the design rationale and per-requisites in the
previous post.
Design and Implementation:
Hadoop Applier replicates rows inserted into a table in MySQL to
the Hadoop Distributed File System(HDFS). It uses an API provided by libhdfs,
a C library to manipulate files in HDFS.
The library comes pre-compiled with Hadoop distributions. It
connects to the MySQL master (or read …
Apr
22
2013
Enabling Real-Time MySQL to HDFS Integration
Batch processing delivered by Map/Reduce remains central to Apache Hadoop, but as the pressure to gain competitive advantage from “speed of thought” analytics grows, so Hadoop itself is undergoing significant evolution. The development of technologies allowing real time queries, such as Apache Drill, Cloudera Impala and the Stinger Initiative are emerging, supported by new generations of resource management with Apache YARN
To support this growing emphasis on real-time operations, we are releasing a new …
[Read more]
Apr
22
2013
MySQL Conference & Expo
2013
LIVE BLOG!
This year again, the MySQL Conference and Expo, hosted by
Percona, smells like a wonderful event.
I haven’t the chance to attend this event but I would like to
share with you the soul of this one.
I’ll try to share latest news, tweets and slides from the event
in this live post.
Stay tuned and come back!
Breaking news!
- LATEST : See you next year!
- MySQL 5.7 is coming… : http://bit.ly/11zENgT
- SkySQL Merges With MariaDB : http://bit.ly/15DRtHL
- Wikipedia adopts MariaDB : …
Apr
22
2013
We discuss INFORMATION_SCHEMA with plenty of examples on useful queries. In this week's Ear Candy, we talk about resident versus virtual memory on Linux, and in At the Movies has a video about MongoDB.
Events
DB Hangops in
May will be Wed May 8th and 22nd noon pacific time.
Upcoming MySQL tech tours