This Log Buffer Edition covers some nifty blog posts from Oracle, SQL Server and MySQL.
Oracle:
There’s so many ways to proceed
To get the knowledge you need
One of the best
Stands out from the rest
COLLABORATE16 – indeed!
Why not be part of the show
By sharing the stuff that you know
Got something to say
For your colleagues each day
Call for papers –> let’s go
I believe many of you would agree that regardless of how insignificant you believe your corner of the Oracle technology may be, everyone has something to say. I attended my first show in Anaheim CA USA in 1990 and started presenting at shows the year after in Washington DC USA. It’s not hard to get over the hump, moving from I would love to present a paper at a show but I just don’t have the …
[Read more]Amazon has just released their RDS Migration Tool, and Pythian has recently undertaken training to use for our clients. I wanted to share my initial thoughts on the tool, give some background on its internals, and provide a walk-through on the functionality it will be most commonly used for.
There are many factors to consider when evaluating cloud service providers, including cost, performance, and high availability and disaster recovery options. One of the most critical and overlooked elements of any cloud offering though, is the ease of migration. Often, weeks are spent evaluating all of the options only to discover after the choice is made that it will take hours of expensive downtime to complete the migration, and that there is no good rollback option in the case of failure.
In order to reduce the friction inherent in the move to a DBaaS offering, Amazon has developed an RDS Migration tool. This is an in-depth look at this new …
[Read more]
I have now released version 1.2 of MyOraDump, my Oracle
data extraction tool. This version has one new feature, which is
transaction support for MySQL format exports which does speed up
loading data a lot! Trust me, it really does! Also I have fixed a
bug that did cause a crash at the end of the run, I have no idea
why this didn't show up before, but there you go and now it is
fixed.
MyOraDump 1.2 can be downloaded sourceforge, and as usual there is also a pdf only
download if you want to read up on the tool before using
it.
/Karlsson
MySQL Fabric: Setup Checklists
MySQL Fabric is an open-source solution released by the MySQL Engineering team at Oracle. It is an extensible and easy to use system for managing a MySQL deployment for Sharding and High-availability.
This handles machines, multiple servers in different platforms. The usability, recovery, stability of MySQL Fabric is much more required as it is a complete distributed system. The setup of MySQL fabric involves servers,database, group details, shard details. So we need to ensure the fabric setup using below checklists. Pre-Installation Checklist:
|
Pre-Install tasks |
|||
|
|
What to Do |
√ |
Comments |
|
1 … |
This Log Buffer Edition covers the top blog posts of the week from the Oracle, SQL Server and MySQL arenas.
Oracle:
Sun of database technologies is shining through the cloud technology. Oracle, SQL Server, MySQL and various other databases are bringing forth some nifty offerings and this Log Buffer Edition covers some of them.
Oracle:
Today I released version 1.1 of myoradump for download
from sourceforge. If you don't know what myoradump is,
this is a utility for exporting data from an Oracle database in
some relevant text format so that it can be imported to some
other database.
The main thing in version 1.1 is that I have added a whole bunch
of new output formats, so make it even easier to get your data
out of expensive Oracle and into something more effective. The
new formats supported are:
During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very useful. That was counter-intuitive for me as I’ve always expected the query cache to be such a bottleneck that response time is better when the query cache is turned off no matter what. That lead me to run a few experiments to better understand when the query cache can be helpful.
Some context
The query cache is well known for its contentions: a global mutex has to be acquired for any read or write operation, which means that any access is serialized. This was not an issue 15 years ago, but with today’s multi-core servers, such serialization is the best way to kill performance.
However from a performance …
[Read more]I want to take a moment to thank you for reading this blog. We are working very hard on cool tools for you to use with MySQL and we really enjoy spreading the news of these tools to you. With this in mind I wanted to update you on something that is changing. We are moving to a new blog home at http://insidemysql.com/. From this point on all new content will be posted on our new blog and we encourage each of you to update your bookmarks accordingly. Our aggregator at http://planet.mysql.com/ has already been updated.
Don' t worry! The old posts will still be here so your old bookmarks will still work. You can find our new Windows focused category at
…
[Read more]