In this month’s Database Journal article we write about Replication Pitfalls with MySQL.
Replication is fairly straightforward to setup, however your slave databases can get out of sync, or throw errors. We investigate some of the reasons why, and help you identify those before they come back to bite you!
Oct 9
Posted by Sean Hull in databasejournal | No Comments
If you’re interested in getting started with Oracle’s AWR facility, roughly the new statspack that’s built in, and easier to use, take a look at this new article over at Database Journal.
If you’re already building LAMP applications (linux/apache/mysql/php), and you’re looking to port them to Oracle, or you’re new to this technology stack, and you want to use Oracle as your database, this article is for you. We cover the basics of gettings started, and where to look for more information.
In our latest database journal piece, we cover some useful Oracle-supplied pl/sql stored procedures to help you instrument and debug your code, dump metadata descriptions of your database objects (a la MySQL dump –no-rows) and much more.
Take a look at DBA Insider – Useful PL/SQL Packages.
What is ASM, and why do we need it? In this piece, we cover the impetus for it’s creation, and what you can do with it. Oracle Automatic Storage Management
If you’ve ever wanted to write scripts to talk to your database, perhaps to perform a routine maintenance operation, or to build a more full-fledged application, you may have considered Perl. It’s a flexible language, with a huge collection of prebuilt modules, and components to choose from.
In this May article over at databasejournal.com, we give you an insiders introduction to the goodness that is Perl + Oracle: Programming, Perl + Oracle.
Oracle Indexing – What, Where, When?
This piece was published in April over at databasejournal.com. In it we discuss some of the myriad different index types available to you in Oracle, and try to sift through to the most important ones.
In March 2008, we published this article over at Database Journal: Create a Database Manually – When & Why?
In Oracle you have the option to use the GUI database creation assistant tool, or you can script the process. We discuss how to do this manually, when you may want to, and hopefully learn a few new things along the way.
Our two part article on migrating a MySQL database to Oracle features in Database Journal in January and February of this year. Take a look and please post your comments!
The second in a series of two articles on Oracle security was features over at Database Journal back in December 2007. Take a look at Eight Ways To Hack Oracle Part 2.
You are currently browsing the archives for the databasejournal category.
Arclite theme by digitalnature | powered by WordPress