While MySQL is a popular and widely used database product, there are some default features and settings which can be foreign in comparison with other commercial RDBMS products such as Oracle. In this discussion, Ronald Bradford will discuss some of the MySQL defaults that are not what you may expect. These include understanding the concept of storage engines, and the default non-transactional state, how silent data truncations occur which affect your data, ideal practices for date management, and the MySQL transaction isolation options. These are all critical to clearly understand and implement correctly for data integrity and consistency. He will cover in-depth topics including SQL_MODE and the recommended best …
[Read more]
Apr
13
2012
Apr
12
2012
Determining the Query Execution Plan (QEP) of an SQL statement is the primary analysis tool for DBAs. Understanding how to interpret the information from the EXPLAIN command and what additional commands and tools exist to add supplementary information are essential skills that will be used daily in production operations.
The MySQL EXPLAIN QEP is significantly different from an Oracle QEP and Oracle DBAs need to understand and learn the most appropriate way to understand and navigate this information to effective …
[Read more]
Mar
31
2012
After 15 years of slide show technology, I thought that we need to change the way we do presentations. And since I am advocating radical changes, I will eat my own dog food and be the first to present a MySQL session using 3D technology.
Since watching Avatar a few years ago, I thought that using this technology would make my presentations truly amazing. However, two years ago a 3d projector was prohibitively expensive. Now, instead, it is affordable, and fits in my briefcase!
What I needed, though, was a compelling reason for using 3d vs. traditional presentations. And I found it. As I have mentioned recently, I am working with the coolest replication technology on earth. Explaining this technology is often challenging. While regular replication …
[Read more]
Feb
15
2012
Default MySQL security sucks. There is no super user privilege protection, or tight filesystem security. What are the essentials for any initial MySQL installation? What is the minimum an Oracle DBA should understand and undertake for a neglected MySQL system? The MySQL privilege system provides several levels of data protection when implemented correctly, however this is rarely used. The most common user permission implementation creates several security and auditing risks? What are your MySQL user permissions, and how can developers exploit them? There are ways to secure communications within a MySQL topology, approaches to managing exposed public facing data collection via the BLACKHOLE storage engine, …
[Read more]
Dec
18
2011
The slides of my talk on B+Tree Indexes and InnoDB are now
available for download. This slide was presented during Percona
Live London 2011. You can download the slides from here.
There are many other interesting and informative talks that were
presented during Percona Live London 2011, and I think you should
definitely check them out, if you haven't. They are available
here.
The post Slides of my talk on B+Tree Indexes and InnoDB appeared first on ovais.tariq.
Oct
26
2011
With the recent cyber attacks and breaches with data from large organizations including Sony, is your MySQL data safe? What are the best practices for securing and administering your MySQL environment? In this presentation we will cover the essential steps for better MySQL security. We will also cover the different installation and administration tasks necessary to ensure your data is managed.
Presenter: Ronald Bradford
Schedule: Insight Out DB Showcase. October 2011 …
Oct
24
2011
I'm now in London for the Percona Live conference! Come see me at 1:30 tomorrow tuesday October 24 and
hear about running databases, BIG databases, in a cloud
environment. MongoDB, Sphinx, MySQL what have you, all running in
a Amazon EC2 environment. Lots of data,, lots of resources, lots
of disks! And lots of fun!
/Karlsson
Oct
18
2011
I will be a speaker at Percona Live - London 2011, and I am looking
forward to the event, which is packed with great content. A
whopping 40 session of MySQL content, plus 3 keynotes and 14
tutorials. It's enough to keep every MySQL enthusiast busy.
Continuent speakers will be particularly busy, as between me
and Robert Hodges, we will be on stage four times
on Tuesday, October 25th.
|
Oct
08
2011
Learn how the experts would design and architect a MySQL system to able to scale seamlessly. This presentation covers the necessary principles including:
- System Architecture
- Data Availability
- Best Practices
- Being proactive
- Preparing for a disaster
- Planning for success
Presenter: Ronald Bradford
You can view the video from SF MySQL Meetup – September 2010. View …
[Read more]
Sep
02
2011
In my last post, I provided a short review of what I have been working on in the past few months since I joined the Oracle Linux team. Now it's time for a summary of upcoming events! Looking forward, I already have a few more things lined up:
I'll attend and speak at the Oracle OpenWorld 2011 conference in San Francisco in October. I have a joint session with Chris Mason titled Overview: New Features in Oracle Linux 6 where we'll cover the latest developments. I have another joint presentation with my colleague Rob Young from the MySQL product …
[Read more]