Log Buffer #319, A Carnival of the Vanities for DBAs
Circular Replication in MySQL
Replication is a hot topic in MySQL 5.6, and for good reason: There are many excellent features that make it a strong well-supported feature, from the new Global Transaction Identifiers (GTIDs), to simplified replication configuration and automated failover using MySQL Utilities (now available in alpha as a separate download (more...)
Learned a little bit about importing data from MySQL into HDFS using Sqoop
I have a chance to read a book - Hadoop Real-World Solutions Cookbook(Thank you ^______^). It pops up in my head, why I have never tested about Sqoop. As you know sqoop is a tool designed for efficiently transferring bulk data between Apache Hadoop and structured datastores such as (more...)
ipython-sql for multi-database comparisons
For my newest ipython-sql trick, I needed to compare some queries run across different databases. How hard would it be to get side-by-side results into tidy IPython Notebook output?
Not hard at all, it turns out, if you're willing to violate basic principles of human decency.
That's an itty-bitty image, (more...)
Log Buffer #318, A Carnival of the Vanities for DBAs
News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.
Oracle:
Log Buffer #317, A Carnival of the Vanities for DBAs
Reminders are an inevitable part of our personal and professional lives. Keep reminding of oneself about goals, priorities, and milestones is key to stay on top of things. This Log Buffer Edition is a reminder about all those not-to-be-missed blogs out there.
Oracle:
One of the developers was performing a (more...)
Log Buffer #316, A Carnival of the Vanities for DBAs
Just as information has become an integral part of technology, blogging has become an inseparable part of technology too. Database technologies are no exception and blogging in that arena is booming. This Log Buffer Edition is booming with some bombastic blog posts.
Oracle:
Arup Nanda asks. Application Design is the (more...)
Introduction to Deep Information Sciences and DeepDB
I talked Friday with Deep Information Sciences, makers of DeepDB. Much like TokuDB — albeit with different technical strategies — DeepDB is a single-server DBMS in the form of a MySQL engine, whose technology is concentrated around writing indexes quickly. That said:
- DeepDB’s indexes can help you with analytic queries; (more...)
Yet another UDF tutorial
Some time ago I wrote a blog post describing a way I use to verify MySQL Server bugs. But my job consists not only of bugs which can be verified just by passing SQL queries to the server.
One of such examples is UDF bugs.
MySQL User Reference Manual is (more...)
Log Buffer #315, A Carnival of the Vanities for DBAs
Like in love there is no precondition, there are no limits held when it comes to the labor of love called as blogging. Lovingly this Log Buffer edition brings you some more roses from database arena.
Oracle:
Marco Vigelini shares as how to duplicate a production database on a different (more...)
Converting InnoDB Tables to MySQL Cluster
If you're considering using MySQL Cluster, you might be tempted to try it out on one of your existing databases. MySQL Cluster 7.3 (available as a development release at the time of this post) supports foreign keys, so it seems sensible to try migrating an InnoDB database (more...)
MySQL Replication: Self-Healing Recovery with GTIDs and MySQL Utilities
MySQL 5.6 includes a host of enhancements to replication, enabling DevOps teams to reliably scale-out their MySQL infrastructure across commodity hardware, on-premise or in the cloud.
One of the most significant enhancements is the introduction of Global Transaction Identifiers (GTIDs) where the primary development motivation was:
- enabling (more...)
SQL Injection Risks
While I tried to deflect how you perform SQL Injection attacks against a MySQL procedure, my students requested that I post examples of what to do to avoid SQL injection, and what not to do to invite attacks. The best practice to avoid SQL injection attacks is too always bind (more...)
Running Out of Physical Disk Space
Problem: You've a large table (or two) in a database on a partition that's running out of space, and you want to see if you can move that table to another drive.
Solution: Well, several actually. No silver bullet, but several options, some with conditions and some that (more...)
MySQL 5.6 Replication: All That Is New, On-Demand
The new MySQL 5.6 GA release delivers a host of new capabilities to support developers releasing new services faster, with more agility, performance and security .
One of the areas with the most far-reaching set of enhancements is MySQL replication used by the largest web, mobile and social properties to (more...)
%sql to Pandas
After getting %sql magic for IPython working, my next big goal was to figure out how to get those results into Pandas.
Er, OK, not such a big goal. Even with zero Pandas experience, it took about five minutes of skimming the first page of documentation to figure out:
In (more...)
released: %sql magic for IPython
Inspired and informed by discussions with the IPython developers at PyCon 2013, I've released ipython-sql, a %sql magic for IPython.
With this, I really think the IPython Notebook will become the most amazing database tool ever. In fact, virtually every computing problem will become a lot more workable when (more...)
Extended Policy and MySQL
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 (more...)
Upcoming MySQL Events in Europe
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.
RSS