This is a good read, claiming: "Relational Databases Aren't
Dead. Heck, They're Not Even Sleeping", http://readwrite.com/2013/03/26/relational-databases-far-from-dead.
A key quote:
"While not comprehensive, the uses for NoSQL databases center
around the acquisition of fast-growing data or data that does not
easily fit within uniform structures."
There were 2 parts in the statement about NoSQL's uses. I'll
start with the latter:
"data that does not easily fit within uniform structures"
- NoSQL is probably the right choice, hmm although I always
encourage thinking and architecting in advance. And also online
structure changes do exist in the RDBMS world and recently in
MySQL: …
Friends,
I want to remind you to let us know if you would like to come for the dinner at Pedro’s on Tuesday April, 23.
Actually, ALL of you should come!
Pedro’s is asking us to have a better idea of the number of participants, so please go to this page “MySQL Community Dinner at Pedro’s 2013” and subscribe.
We want to have all of you enjoy the evening with us. Subscribe & come!
Introduced in 5.6.6, connection attributes haven’t been mentioned in any of the many overviews of new 5.6 features that I’ve seen. You might not have even known they exist – there’s not really a “feature page” in the documentation that tells you what this is all about. The best documentation is found in the description of the PERFORMANCE_SCHEMA tables which expose these connection attributes:
As of MySQL 5.6.6, application programs can provide key/value
connection attributes to be passed to the server at connect time,
using the mysql_options() and mysql_options4() C API functions. The
Performance …
Continuent, along with Amazon Web Services and HP, is proud to be a Diamond Plus Sponsor of the year's premiere event for MySQL's rich and diverse ecosystem. Hear and meet 90+ expert MySQL speakers in 100+ sessions, including these eleven (11) talks by our Continuent Tungsten clustering and replication experts:
Monday, April 22
Using Tungsten Replicator to solve replication problems, by
As the press release says: “Come have a (free) beer with Monty: SkySQL & MariaDB’s 2nd Annual MySQL & Cloud Database Solutions Day”!
“Are you planning on being in Santa Clara for Percona Live: MySQL Conference and Expo in April? If so, don’t let the learning and networking stop on Thursday!
We invite you to join SkySQL & MariaDB for our 2nd Annual MySQL® & Cloud Database Solutions Day, Friday, April 26, 2013 at the Hyatt Regency Santa Clara. This event will be taking place directly after the Percona Live event.
During this free one-day event, you will receive hands-on training and consulting on MySQL and MariaDB database solutions from the experts at SkySQL, MariaDB, and their partners.”
Speakers will include Big Data, Analytics and Cloud experts, as well as SkySQL customers and MariaDB users. Including:
Monty Widenius – MariaDB
Yoshinori Matsunobu – Facebook
Seppo Jaakola …
In a previous post I explained how to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER = n for a simple reason, it doesn’t work anymore if you are using MySQL GTID. Then the question is:
Is there any easy way to skip a single transaction?
There is! Injecting empty transactions. Let’s imagine that the replication in slave server is not working because of an error:
Last_SQL_Error: Error 'Duplicate entry '4' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t VALUES(NULL,'salazar')' Retrieved_Gtid_Set: …[Read more]
As alway with new technology there is always different approaches regarding the adoption. You can try to use the bleeding edge features or start with a very standard configuration. My personal advise to new users is to start with the most basic configuration.
This allow you to get familiar with the fundamentals : - how [...]
Any secure system needs to be configured correctly to best serve the needs of users and the business. Previously, I've covered AppArmor and MySQL, and more recently SELinux and MySQL. To round out a healthy trio on running MySQL in environments with mandatory access control, Glenn Faden has written a post on Oracle Solaris Extended Policy and MySQL.
Extended Policy is a feature of Solaris that allows you to assign named privileges on resources—such as ports and files—to services. I'm not hugely familiar with Extended Policy (or Solaris for that matter), but according to Glenn it's similar to SELinux …
[Read more]Update – the recording of this webinar is now available here.
This Wednesday (27th March) Mat Keep and I will be presenting a free, live webinar on MySQL 5.6 Replication. You need to register here ahead of the webinar – worth doing even if you can’t attend as you’ll then be sent a link to the replay when it’s available. We’ll also have some of the key MySQL replication developers on-line to answer your questions and so it’s also a great chance to get some free consultancy
Details….
Join this session to learn how the new …
[Read more]Oracle's MySQL team in Europe is very busy running or participating to a number of events during the upcoming couple of months.
Join us to learn about the latest developments and get all your questions answered!
More events will be scheduled worldwide and listed on our
events page.
MySQL User Group meeting, Stockholm,
Sweden
April 10
…
[Read more]