Does MySQL replication support Oracle11g Database as target? Or
we have to use Goldengate for that?
Thanks.
Read the original article at How to hire a developer that doesn’t suck
Strip by Randall Munroe; xkcd.com
First things first. This is not meant to be a beef against developers. But let’s not ignore the elephant in the living room that is the divide between brilliant code writers and the risk averse operations team.
It is almost by default that developers are disruptive with their creative coding while the guys in operations, those who deploy the code, constantly cross their fingers in the hope that application changes won’t tilt the machine. And when you’re woken up at 4am to deal with an outage or your sluggish site is costing millions in losses, the blame game and finger-pointing starts.
If you manage a startup …
[Read more]Read the original article at Book review – Trust Agents by Chris Brogan & Julien Smith
Stumbling onto 800-CEO-Read, and their top books feature, I found Brogan and Smith's work. Brogan's blog intrigued me enough so I walked down to the Strand here in NYC to pick up a copy.
What I found was an excellent introduction to the nebulous world of social media marketing, where you find all sorts of advice and suggestions on how to engage your target audience. If you're feeling like an ignoramus on matters of social media, Trust Agents is a great place to start and will give you ideas of how to 'humanize' your digital connections.
The authors illustrate the Trust Agent idea with Comcast Cares for example and how they engaged customers, and what …
[Read more]
I'll be doing the keynote at Cloud Tech Day here in Stockholm on tuesday. I'll
be speaking a bit about what Recorded Future is up to, about
Clouds at Amazon and what it is like, about databases, like MySQL
and MongoDB, in the Clouds and about Big Data in the Cloud!
Really big data in Mongo, in MySQL and the lot.
As usual, I will express my opinions in no uncertain terms. What
works? What doesn't work? What really should work, but which
doesn't! What is considered new and waay cool but what is really
some old technology that didn't use to work and has little chance
of working now. And stuff like that, you know what it's like and
maybe you even know what I am like :-)
Hope to see you on tuesday
/Karlsson
I will be speaking in the MySQL track of the UK Oracle User Group
conference on 5th December in Birmingham UK. The title of the
session is "Building Highly Available and Scalable, Real Time
Services with MySQL Cluster" - full details here.
I'm not a regular conference attendee, never mind speaker.
However I'm looking forward to meeting current and potential
MySQL users, and also attending some of the talks in the MySQL
and other tracks. Maybe I can learn something about RAC, or
Exadata?
If you are attending and want to talk about MySQL or MySQL
Cluster then please track me down and say hello.
Note that this is the first picture I have included in 3 years of
posts - maybe …
Thanksgiving is here and the circular chain of thankfulness is going on. Clients are thankful that they have applications, applications are thankful to their databases, database are thankful to their DBAs, and DBAs are thankful to clients. And they all are thankful that there is weekly Log Buffer Edition, of which the latest is Log [...]
It is no secret that bugs related to multithreading–deadlocks, data races, starvations etc–have a big impact on application’s stability and are at the same time hard to find due to their nondeterministic nature. Any tool that makes finding such bugs easier, preferably before anybody is aware of their existence, is very welcome.
Enter the Helgrind tool of the Valgrind dynamic analyzer suite. Now, Valgrind does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is relatively widely used for the MySQL server development: there is support for it in the MySQL Test Framework, DBQP, and the server source is properly annotated to get the most out of Memcheck. Not …
[Read more]Update: Thank you all for making this campaign a colossal success. We are extending this offer till Dec 2nd, 23:59 PST. Many corporate users requested us to extend the offer as they require time to get official approval. Pick your copy right now! Use coupon code blkfrdy11 to get 50% off.
–
Happy Thanksgiving!
Black Friday is back with a bang. Get a flat 50% discount on all Webyog products. Yes, you read it right, a flat fifty percent discount. Hurry, this offer expires Nov 28th Dec 2nd, 23:59 PST. Use coupon code blkfrdy11 to avail the discount on any purchase. Buy Now.
Still using SQLyog Community Edition?
Upgrade to the feature rich SQLyog Professional/Enterprise/Ultimate Edition. This offer is literally too good to pass up. …
[Read more]MySQL Workbench 5.2.36 is now out and brings a lot of improvements across the board, with special focus on the Query Editor. We’ll cover some of that here:
Redesigned Query Editor
-
- The log of executed commands and server responses is now always visible while resultset grids and the query editor can be resized according to your needs. Resultsets are also grouped in the same tab as the query editor that generated them.
- SELECT queries are now analyzed as in the old MySQL Query Browser tool and, if possible, its resultset can be edited in the grid. If the resultset cannot be edited, you can place the mouse over the ReadOnly label and view the reason.
- Improved snippets manager and editor, allows having snippets list always at hand, while editing can be done without disrupting work on the main query area.
The MySQL explain plan is a great tool to help developers and database administrators to improve the performance of specific queries happening against a database. It is very easy to use, but its output can be confusing, so I thought I'd show a very simple example.
Let's begin by looking at a table called recipes
mysql> desc recipes; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(400) | NO | MUL | NULL | | | description | text | YES | | NULL | | | category_id | int(11) | YES | MUL | NULL | | | chef_id | int(255) | NO | MUL | NULL | | | created | datetime | YES | | …[Read more]