PlanetMysql.ru — информация о СУБД MySQL

  Plug-in to Vegas The program focuses on key topics such as high availability, virtualization, security, business intelligence, Exadata, Cloud Computing and internals.  Recently added, we switched around the schedule to include the Thursday Deep Dive, Avoiding Downtime through the Maximum … Continue reading →
PlanetMySQL Voting: Vote UP / Vote DOWN

http://collaborate12.ioug.org

 

Double Down at COLLABORATE 12- The IOUG Forum with Two Ways to Save- and a Chance to Win! The user-driven Oracle event of the year is fast-approaching, and IOUG wants you to make youreducational experience a sure bet. Between hundreds of cutting-edge education sessions, workshops and legendary Oracle speakers, you’ll return from Las Vegas with valuable knowledge to transform into immediate results for your business. No need to go all in to attend- IOUG is sweetening the pot with ways for you to save big bucks and even pocket some cash while you’re at it. Register today for your chance to win a $200 American Express Gift Card!The deck is stacked at COLLABORATE 12 – The IOUG Forum in your favor. Register for the conference today with the priority code EM03 and be immediately entered for a chance to add a $200 AmEx Gift Card to your winnings for the week. Treat yourself to some fusion cuisine while in Vegas, catch a show on the strip, or just pocket the prize for a rainy day! Buy-in to the table at COLLABORATE 12-The IOUG Forum has never been more reasonable. Hotel rates are only going up from here on out, so book your room today to take advantage of the final day of ultra-reasonable rates!  How about adding more savings to the mix on your conference registration?Sign up for a seat at the table with IOUG before February 29 and be dealt a winning hand: save up to $500 on conference registration by booking ahead of the early bird, and we’ll even throw in a bonus, extra day of education($599 value)! Don’t miss your chance to to take advantage of these massive savings . Book your COLLABORATE 12 journey today! Guarantee your seat at the table today, and save by registering before the Early Bird Deadline! Registration rates start as low as $1,295* for members of IOUG. Resolve to give yourself a fantastic week of Oracle Education, and happy 2012! * Rate assumes hotel and group discount Boot Camp Information Housing Deep Dive Information IOUG Registration Benefits Exhibit at COLLABORATE 12 Session Schedule Want to sponsor a Deep Dive? Contact Jconlon@ioug.org for more information.

PlanetMySQL Voting: Vote UP / Vote DOWN

Current White Papers for the Oracle Professional

Zero Downtime Migration to Oracle Exadata using Oracle GoldenGate In this paper we will review Oracle GoldenGate’s capabilities and how it can be used to achieve zero downtime migration and consolidation to Oracle Exadata. We will provide high-level implementation steps for migration with GoldenGate and a customer case study example. You will also find a section that describes other use cases where you can leverage GoldenGate and Oracle Data Integration products for your Oracle Exadata implementations, including Data Warehouse Appliance Migration; Real-Time Data Warehouse Updates; Bulk Data Loading; Maximum Availability; OLTP; and SOA Integration. Spotlight on: MySQL & Oracle GoldenGate Oracle GoldenGate is known for its capabilities to offer real-time data integration for heterogeneous databases. This document describes the key use cases where MySQL users can leverage Oracle GoldenGate to achieve higher performance and lower TCO. Solutions featured include real-time data warehousing, operational reporting, and OLTP query offloading.Top 10 Reasons why MySQL Experts Switch to SchoonerSQL Learn the top 10 reasons why MySQL experts switch to SchoonerSQL and how it solves the common problems users face with MySQL. Managing the Rapid Rise in Data Growth: 2011 IOUG Survey on Database Manageability This report goes one step further – identifying the types of issues database professionals are grappling with in rapidly expanding data environments and then providing some recommended steps for getting ahead of the database management curve from the experts at the Independent Oracle Users Group: applicable industry-wide.

PlanetMySQL Voting: Vote UP / Vote DOWN

Welcome to Log Buffer. The weekly review of DBA industry news. Enjoy Log Buffer #199.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.

And, for inquiries about hosting or editing a future edition of Log Buffer on your own blog, send your query to the Log Buffer coordinator. (Please include the words “Log Buffer” in the subject.)

Kicking off this week are posts recommended by Gwen Shapira who also took a few minutes to share her production advice for developers.

Not strictly Oracle related, but fun story of how Catherine the Python-Oracle geek got hacked during her own presentation.

Dominic Brooks looked for upgrade tips and got some excellent advice.

Jonathan Lewis started a series about joins. Jonathan is the master of building clear and excellent test cases, and this post is a good example of this.

Pythian’s Singer Wang points out a post from Greg Baker, highlighting an announcement of proof that P is not equal to NP.

Baron Schwartz, on MySQL Performance Blog, shares sound advice on why you can’t rely on a replica for disaster recovery.

Ronald Bradford makes the case against using rpm packaging for MySQL.

Kerry Osborne is stunned by Exadata’s storage indexes as he does a little testing.

Willie Favero talks about parallelism improvements in DB2.

Leo Hsu and Regina Obe, on Postgres Journal, talk about starting PostgreSQL in windows without install.

In SQL Server news Linchea Shea says for performance impact, forget about sets and focus on loops.

And to close things off a last minute entry by Christo Kutrovsky – designing for Exadata, maximizing storage indexes use.

PlanetMySQL Voting: Vote UP / Vote DOWN

Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #198 is generously published by Sam DeFilippis, who manages Oracle Notes blogs, with latest postings on Oracle GoldenGate.

As always, if you’d like to host your own issue of Log Buffer, simply reach out to the Log Buffer coordinator.
Please enjoy Sam’s issue of Log Buffer #198.

PlanetMySQL Voting: Vote UP / Vote DOWN

Log Buffer #197 marks the middle of summer, and the fact that we’re a mere two weeks away from our 200th edition.

To begin this week’s reading, I’d like to highlight two Oracle blogs maintained by Sam J. DeFilippis: Oracle Notes, where he’s recently posted about troubleshooting GoldenGate and positioning a read of Extract/Replicat Trail file or Oracle redo log. Sam volunteered to host a future edition of Log Buffer (thanks, Sam!). You can too, by sending an email to the Log Buffer coordinator, we’re always looking for volunteer publishers.

Brad Hudson a points that PostgreSQL test servers have moved from Oracle to EnterpriseDB.

Marc Fielding posts Part 2 of his series A Grand Tour of Oracle Exadata. He’s also hosting a webinar on how to successfully implement Exadata, Aug. 11th.

Cary Millsap explains why thinking clearly is more important than being correct.

On PL/SQL Challenge, Steven Feuerstein and his readers try to figure out where to find a list of all the tables and debate what is a table these days.

Sheeri Cabral catches up on her blogging this week with posts datawarehousing best practices, comparing Oracle and MySQL. Part 1 covers introduction and power, and Part 2 talks about partitioning. Another, explains Pythian’s method for continuously verifying replication sync, and lastly is a farewell post, as Sheeri forks off…. Pythian wishes Sheeri all the best in her future pursuits.

Iggy Fernandez tries to decide whether to use correlated subquery or join in a query.

Always wanted to learn more about Google’s BigTable database, but find the google papers intimidating?
myNoSQL blog links to a slide-deck that makes it all clear.

Ronald Bradford outlines clear evidence that in the short to medium term Oracle will continue to promote and enhance MySQL, and invites readers to chime in to his discussion on will Oracle kill MySQL?

And, on a side note, Pythian is looking for senior systems administrators who have RedHat Linux administration experience in Australia & other international locations. Visit our candidate system to match your skills with all of our current openings or submit your resume.

For those in Canada – enjoy Civic holiday weekend.

PlanetMySQL Voting: Vote UP / Vote DOWN

Welcome to Log Buffer, the weekly roundup of database industry news.

For your reading pleasure this week we have Log Buffer #196:

Charles Hooper blogs about an in-depth investigation on what can cause Oracle to ignore a hint.

Doug Burns reminds his readers that there are only two weeks left to submit papers for UKOUG. The deadline is Aug. 2.

A while back Greg Rahn at Structured Data blog thought that the best way to get results out of Exadata is by changing your application to get the most out of Exadata. He was very happy to see that Pythian thinks the same. On the subject of Exadata and data warehousing, Greg posts this week on the core performance fundamentals of Oracle Data Warehousing – set processing vs row processing.

Jonathan Lewis links to instructions and explanations on how to switch to a different UNDO tablespace. It is trickier than it sounds and Jonathan provided additional traps to watch out for.

Jonathan also continues his fragmentation series with an explanation of table fragmentation and its causes.

Alex Fatkulin explains about ASM mirroring and disk partnership and why you may have less redundancy than you thought.

On the same subject, Jeremy Schneider of Ardent Performance blog explains about hot disks, raid and what it means for ASM mirroring.

Back to blogging after a recent trip to TechInsights 2010, Edwin Sarmiento answers questions on what needs to be done as part of the installation of a SQL Server 2008 R2 Failover Cluster on Windows Server 2008 R2. A number of things related to Windows Clustering need to be considered.

Willie Favero introduces the “IBM zEnterprise System”, on his blog Getting the Most out of DB2 for z/OS and System z.

On Join-fu! the Art of SQL blog, Jay Pipes talks about getting started developing Nova on Linux, as he’s involved in a new OpenStack project.

Peter Zaitsev, on MySQL Performance Blog, posts about estimating replication capacity so that replication load can be dealt with before slave is unable to catch up.

Paul Randal publishes his survey results around the purchase and use of SSIDs.

And, if you happen to be attending Oracle OpenWorld, register before July 30 to take advantage of early bird rates.

PlanetMySQL Voting: Vote UP / Vote DOWN

In line with my prediction from few days ago, Larry Ellison is announcing the new Database Machine — the new version is targeting OLTP workloads and is based on Sun hardware. Looks like I just got the date wrong. Oh well, now is the announcement, hype and demo is at the Oracle Open World and shipments are to start upon Oracle-Sun acquisition completion.

So what’s new in Exadata that I didn’t mention in the previous blog post? Ah, right — Sun FlashFire technology. It’s no surprise that the new OLTP version of Database Machine is boosting the IOPS (IO’s per second) capacity by introducing the flash drives. Nothing prevented Oracle to place flash disks into the original Exadata, not from technology perspective.

You should also know that Sun has been investing a lot in its Open Storage concept. This is very similar to what Oracle did with Exadata Server except that Sun initiative is a universal storage solution with ZFS in its core while Oracle Exadata is specialized for Oracle databases leveraging Oracle ASM. What does it tell me? Two leading companies have the opportunity to merge storage technologies. I’ll take that!

I might have underestimated Oracle on how quickly it can leverage Solaris SPARC for the database servers in the OLTP Database Machine (Mark, you might be right). SPARC platform has been an excellent fit for high throughput OLTP systems. Again, we already saw Larry’s commitment to develop SPARC technology so within a month, Sun customers’ mood should be rising higher and higher these days.

I will excuse myself for self-quoting from half a year ago:
… it does look like Sun failed to make money on a number of great technologies and products such as Solaris and Java. Why is another story — there were great deal of speculations from people who must know it much better than me. My conclusion is that IBM is a great money making machine while Sun is the technology making machine.

What about Oracle? Well, I think that so far they have excelled in both - money making and technology making. Isn’t that a wonderful combination?

I must say I’m excited to see that Oracle is picking up all the juicy pieces of Sun technologies and targets to make money on them and not sell them off in bits.

PlanetMySQL Voting: Vote UP / Vote DOWN

In my recent post on the EU antitrust regulators' probe into the Oracle Sun merger I did not mention an important class of stakeholders: the MySQL-based special purpose database startups. By these I mean:

• Kickfire


• Infobright


• Calpont


• ScaleDB

I think it's safe to say the first three are comparable in the sense that they are all analytical databases: they are designed for data warehousing and business intelligence applications. ScaleDB might be a good fit for those applications, but I think it's architecture is sufficiently different from the first three to not call it an analytical database.

For Kickfire and Infobright, the selling point is that they are offering a relatively cheap solution to build large data warehouses and responsive business intelligence applications. (I can't really find enough information on Calpoint pricing, although they do mention low total cost of ownership.) An extra selling point is that they are MySQL compatible, which may make some difference for some customers. But that compatibility is in my opinion not as important as the availability of a serious data warehousing solution at a really sharp price.

Now, in my previous post, I mentioned that the MySQL and Oracle RDBMS products are very different, and I do not perceive them as competing. Instead of trying to kill the plain MySQL database server product, Oracle should take advantage of a huge opportunity to help shape the web by being a good steward, leading ongoing MySQL development, and in addition, enable their current Oracle Enterprise customers to build cheap LAMP-based websites (with the possibility of adding value by offering Oracle to MySQL data integration).

For these analytical database solutions, things may be different though.

I think these MySQL based analytical databases really are competitive to Oracle's Exadata analytical appliance. Oracle could form a serious threat to these MySQL-based analytical database vendors. After the merger, Oracle would certainly be in a position to hamper these vendors by resticting the non-GPL licensed usage of MySQL.
In a recent ad, Oracle vouched to increase investments in developing Sun's hardware and operating system technology. And this would eventually put them in an even better position to create appliances like Exadata, allowing them to ditch an external hardware partner like HP (which is their Exadata hardware partner).

So, all in all, in my opinion the EU should definitely take a serious look at the dynamics of the analytical database market and decide how much impact the Oracle / Sun merger could have on this particular class of MySQL OEM customers. The rise of these relatvely cheap MySQL-based analytical databases is a very interesting development for the business intelligence and data warehousing space in general, and means a big win for customers that need affordable datawarhousing / business intelligence. It would be a shame if it would be curtailed by Oracle. After the merger, Oracle sure would have the means and the motive, so if someone needs protection, I think it would be these MySQL-based vendors of analytical databases.

As always, these are just my musing and opinions - speculation is free. Feel free to correct me, add applause or point out my ignorance :)
PlanetMySQL Voting: Vote UP / Vote DOWN

OK. It’s not often that I make predictions these days but this was on my mind for a while so here we go. Mind you, I don’t have any confirmed insider information so it’s based on some assumptions, my perspective on Oracle-Sun acquisition and some vibes I can feel in the air.

The rumors are that Oracle Exadata v2 and Oracle Database Machine v2 are going to be announced within few weeks and my take is that it’s going to happen at the Oracle Open World. I don’t think it comes as a surprise to anyone that it will be configured with Oracle Database 11g Release 2.

Moving on to predictions and speculations…

Oracle Database Machine — beyond data-warehousing

Oracle Database Machine will not be targeting ultimately data warehouse environments — it will attack OLTP applications and marketed extensively for consolidated environments. “Old” HP Oracle Database Machine was an ideal consolidation vehicle but there were few design elements incompatible with OLTP and consolidated environments. For example, very thin communication pipe with the external world — no way enough traffic could enter (and leave). Have you paid attention to what Oracle did in 11g Release 2 with its Grid Infrastructure component and how well it now can truly manage the grid including database, storage and application tiers? 11g Release 2 delivered inside Oracle Database Machine v2 — this is the ultimate answer to data-center consolidation… the ultimate data-center consolidation appliance.

Oracle Database Machine — truly Oracle hardware

Did you see the title is missing something? You would if you compare it carefully with the year old entry — “HP” is missing! Yes, I believe that Oracle Database Machine v2 will be delivered on Sun hardware.

The exact figures are not published but Oracle claims that adoption of HP Oracle Database Machine is high. If Oracle makes Database Machine available for generic use and data-centers consolidation (those are very “popular” projects now for our customers) then demand will surge immensely and Oracle will need to meet supply. Of course, Oracle could let HP pocket quite a bit of cash but why not leave it all for themselves?

Oracle is committed to Sun hardware if you didn’t notice.

Why on earth would Oracle continue to use HP hardware for it’s Database Machine v2? This is rather highly improbable and the natural choice is… Sun Oracle Database Machine!

I reckon that Sun Oracle Database Machine (or simply Oracle Database Machine) will be still based on the same x86 architecture and not SPARC. Oracle Exadata software is generic and will run on Oracle Enterprise Linux on any x86 platform (it even runs inside a virtual machine if one wants to play with it). So the only work left is to polish and integrate components flawlessly as it’s been done with HP hardware.

The step to introduce SPARC platform is not huge — Solaris on SPARC is still one of the most stable platforms that Oracle Database runs on. What’s left is to make Solaris SPARC playing nicely with InfiniBand and Oracle’s DDP (Direct Data Placement) protocol. I don’t think Oracle could go as far as having it implemented it on SPARC platform already now but I think that database servers can easily be running on SPARC in the future as well as Linux x86_64 while Exadata Storage Server will most likely stay on Linux.

As a summary, I want to quote what I said back in April:
What Oracle intends to do now is to keep all those new acquired products, continue development while work heavily on integration solutions. Integration products and services is where Oracle will find its new direct revenue stream.

Comments are most welcome as usual.

PlanetMySQL Voting: Vote UP / Vote DOWN