This might be acceptable for some workloads, such as data warehouses, which feature bulk loading. They don’t have high transactional write rates.
This hopefully will also be mitigated somewhat by MySQL 5.6 group commit, at least for parallel workloads.
Also, you can get true synchronous replication that is WAN friendly using XtraDB cluster, because Galera replication happens in parallel.
Over the past few weeks since joining SkySQL as CEO, I have been meeting with team members to learn more about each person's views on the company, our customers and the industry. The team has done an amazing job since this company of original MySQLers re-emerged onto the scene more than a year and a half ago. We now have over 300 customers globally with very high satisfaction on the quality of services provided. July has for me been all about understanding the unique company culture and heritage from MySQL, and how we as a team can capitalize on our strengths to solve the challenges that our customers face while increasing the attractiveness of the MySQL ecosystem and community.
…
[Read more]I presented a webinar today about SQL Injection, to try to clear up some of the misconceptions that many other blogs and articles have about this security risk. You can register for the webinar even now that I’ve presented it, and you’ll be emailed a link to the recording, which will be available soon.
During my webinar, a number of attendees asked some good questions, and I wasn’t able to answer them all before the hour was up. Here are the questions and my answers.
Tobin C. asked:
Q: Does the use of Parameters (particulary OdbcParameter
class in .NET) qualify as an appropriate security mechanism for
normal WHERE interpolation? Or should the input be validated
before creating a parameter?
Yes, the OdbcParameter class should be safe. The OdbcParameter abstracts query …
[Read more]Read the original article at Opportunity a day – career risk at bay
Free Agent. Stress Test. Avoid Sameness
As the globalization juggernaut rolls on, it continues to create more Detroits. Skills and perspectives quickly become obsolete.
What to do in the face of such change?
Small fires prevent the big burn
So there’s your quick answer. Get the book if you want more!
Some related material: why is it so hard to find a mysql dba?.
Consulting 101 Guide – Finding …
Today’s Dilbert asks how long to train a technical writer to become a Database Analyst. The answer? 45 minutes!
Right now there is a big shortage of MySQL DBAs. Recently at OSCON, I asked a group how do we best develop new DBAs. The consensus was to train Linux administrators. For the past year I have been working on The Proper Care and Feeding of a MySQL Database for Linux Administrators and will work to expand it in hopes it will become a good starting place for those wanting to add MySQL DBAs skills to their professional arsenal. Please let me know what you have found that works in this area for your situation so we can get more MySQL DBAs.
And there will be a Dallas MySQL Users Group Meeting (or the Dallas Oracle Users Group MySQL Special Interest Group) On Tuesday Septermber 4th …
[Read more]
This is just a quick notice that there is a new version of the
JSON import tool available now. The main thing in it is that it
fixes an iddues with threadinig that caused a threaded load (and
this is the default) to hang of there was an error or the import
was interrupted. Also, there are some minor fixes and also a
runtime status printing, available by sending a SIGUSR1 signal to
the process, feature is available.
Download from sourceforge.
Cheers
/Karlsson
Earlier this week we pushed to Github the seventh iteration of
Twitter MySQL. Here are some of the highlights.
Bugs Fixed
Functionality Added or Changed
…[Read more]Like others we were not satisfied with the fix for a bug in MySQL which caused the query cache and partitioning to not work reliably together. The bug, in simple terms, was that if the query cache was enabled and you used partitioned tables and if a partitioned table was using a transactional engine like InnoDB or XtraDB, the query cache could, under certain circumstances, return incorrect results.
Returning incorrect results is a definite, high-priority bug. However, the upstream fix was to disable all caching of queries from …
[Read more]Introduction
"Improving MySQL performance using Hadoop" was the talk which I and Manish Kumar gave at Java One & Oracle Develop 2012, India. Based on the response and interest of the audience, we decided to summarize the talk in a blog post. The slides of this talk can be found here. They also include a screen-cast of a live Hadoop system pulling data from MySQL and working on the popular 'word count' problem.
MySQL and Hadoop have been popularly considered as 'Friends with benefits' and our talk was aimed
at showing how!
The benefits of MySQL to developers are the speed, reliability,
data integrity and …