My faithful readers, please spare 10 mins of your time, and read
Baron's excellent post: https://vividcortex.com/blog/2014/04/30/why-mysql
Nuff said.
Since I can't really shut up, and only if you do like my (humble)
take on this, I could say in short:
Every technology/platform/framework I choose, will end up
surprising me, limiting me for things can be done easily, and
throw many painful challenges at me if and when I need to do
things that are closer to the platform's "edges". This is true
for everything including Rails, JEE, Hibernate, MongoDB,
MySQL.
I've learned that the more mature, generically-capable,
transparent and ecosystem-rich a solution is - the less painful
surprises for me in the worst timings - and more successful I am
in my job.
If you did not read my first blog post about Mark Callaghan’s (@markcallaghan) benchmarks as documented in his blog, Small Datum, you may want to skim through it now for a little context.
——————-
On March 11th, Mark, a former Google and now Facebook database guru, published an insertion rate benchmark comparing MySQL outfitted with the InnoDB storage engine with two NoSQL alternatives — basic MongoDB and …
[Read more]MySQL adopts a very different approach to 'NoSQL' than other databases. With the memcached plugin, MySQL provides the speed and high availability benefits of a standard 'NoSQL' database solution, while mitigating many of the drawbacks to this approach.
A traditional memcached application bypasses the SQL layer entirely, and stores all its data in memory. This makes data access extremely fast, but there is a risk that the data will disappear in the event of a system problem.
The MySQL memcached plugin for InnoDB also bypasses the SQL and optimization layers, resulting in excellent performance. It goes further, writing key-value data directly to InnoDB tables. The result is fast data access while retaining the advantages provided by the existing relational database infrastructure, such as the ability to run complex queries with SQL, maintain data integrity, provide real-time analytics to the business, and work …
[Read more]After a four year hiatus, my participation in last week’s Percona Live MySQL Users conference marked my official return to the MySQL Community and Ecosystem. As with earlier renditions this year’s “UC” was very well attended with a healthy mix of familiar faces and new blood, all coming together to discuss, present and explore the boundaries of the most popular and widely used open source database on the planet. There were many good, informative keynote and technical sessions, BoFs and the exhibit hall was packed most of the operating hours with those interested in what the MySQL ecosystem is up to. I also found it very refreshing that Oracle was among the most active in presenting useful technical content around their current and future MySQL open source product releases. All in all, this year’s UC was very well done and as a Percona employee my …
[Read more]“Many tools now exist to run database software without installing software. From vagrant boxes, to one click cloud install, to a cloud service that doesn’t require any installation, developer ease of use has always been a path to storage platform success.”–Brian Bulkowski.
The fifth interview in the “Big Data: three questions to “ series of interviews, is with Brian Bulkowski, Aerospike co-founder and CTO.
RVZ
Q1. What is your current product offering?
Brian Bulkowski: Aerospike
is the first in-memory NoSQL database optimized for flash or
solid state drives (SSDs).
In-memory for speed and NoSQL for scale. Our approach to memory
is unique – we have built our own file system to access …
Anders Karlsson wrote about Some myths on Open Source, the way I see it a
few days ago. Anders' article is mostly focused on
exploding the idea that open source magically creates high
quality code. It is sad to say you do not have to look very
far to see how true this is.
While I largely agree with Anders' points, there is far more that
could be said on this subject, especially on the benefits of open
source. I love working on open source software. Here are three
reasons that are especially important to me.
1.) Open source is a great way to disseminate technology to
users. In the best cases, it is this easy to get open
source products up and running:
$ sudo apt-get install software-i-want-to-use
A lot of software companies ( …
I like the image of this city of Mesa Verde. It’s fascinating to see how ancient cities were built, especially as an inhabitant of one of the worlds largest cities today, New York. I’m a long time relational database guy. I worked at scores of dot-coms in the 90′s as an old-guard Oracle DBA, and […]
The USA's health care exchange site, healthcare.gov, has had well-publicized initial woes.
The New York Times has said one of the problems was the government's choice of DBMS, namely MarkLogic. A MarkLogic employee has said that "If the exact same processes and analysis were applied to a LAMP stack or an Oracle Exa-stack, the results would have likely been the same."
I don't know why he picked Exastack for comparison, but I too have wondered whether things would have been different if the American government had chosen a LAMP component (MySQL or MariaDB) as a DBMS, instead of MarkLogic.
What is MarkLogic?
The company is a software firm founded in 2001 based in San Carlos California. It has …
[Read more]Or I could place in the title – “Yes, we done it!”
After reaching 500K QPS in Read-Only on SQL queries, it was natural to expect a much higher performance level from InnoDB Memcached Plugin which is by-passing all SQL related layers.. However the story is not simple, and yet far from finished
While for today we have already our first “preview” results showing that we’re able to reach over 1,000,000 Query/sec level with the latest MySQL 5.7 code:
click here to read the full article..
Economist says that Physics suggest that storms will get worse as the planet warms. Typhoon Haiyan in Philippines, bush-fires in Australia, floods in China, and extreme unpredictable weather across the planet is a sober reminder. Good news is that technology and awareness is rising, and so is the data. Database technologies are playing their part to intelligently store that data and enabling the stakeholders to analyze and get meaningful results to predict and counter the extreme conditions. This Log Buffer Edition appreciates these efforts.
Big Data:
Big Data Tools that You Need to Know About – Hadoop & NoSQL.
Dave Stokes is …
[Read more]