Showing entries 1 to 10 of 143
10 Older Entries »
Displaying posts with tag: Technical Track (reset)
gh-ost hooks for better visibility

In this post I will show you how to leverage Github’s gh-ost hooks for greatly improving visibility of ongoing schema changes for your organization.

One of the potential uses of gh-ost hooks is to send status updates. I will present you with some examples of how to do that via email and Slack.

What are gh-ost hooks?

gh-ost has built-in support for hooks, i.e. external scripts with predefined names, that will be called by gh-ost at certain points of a schema change operation.

The complete list is available here, but the most useful gh-ost hooks for me are:

  • gh-ost-on-startup-hook
    • called at the start of a schema change operation
  • gh-ost-on-status-hook
    • ran …
[Read more]
Log Buffer #523: A Carnival of the Vanities for DBAs

This Log Buffer Edition touches upon various blog posts from Cloud, Oracle, SQL Server and MySQL.

Cloud:

Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)

Multiple APEX Workspaces in one Oracle Exadata Express Cloud account is now possible.

Setting up Oracle Event Hub (Apache Kafka) Cloud Service and Pub & Sub from local Node Kafka client.

AWS Adds 12 More …

[Read more]
Log Buffer #522: A Carnival of the Vanities for DBAs

This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.

Cloud:

Introducing managed SSL for Google App Engine

Using Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot Application

ClusterControl in the Cloud – All Our Resources

Monitoring Amazon Aurora Audit Events with Amazon CloudWatch

Integrating Teradata with Amazon …

[Read more]
Log Buffer #521: A Carnival of the Vanities for DBAs

While cloud technologies are roaring ahead in full force; the traditional RDBMS like Oracle, Microsoft SQL Server and MySQL are adapting pretty fast. This Log Buffer Edition covers blogs related to that and more.

Oracle:

Oracle JET Simple Table with Fake JSON Server

Every time any page is requested from your website by a human or another program or an automated bot, the event is tracked in a log file that is stored on the web server.

Gitora 2 enabled developers to manage database objects that support the CREATE OR REPLACE command, namely PACKAGES, PROCEDURES, FUNCTIONS, TRIGGERS, VIEWS, …

[Read more]
Log Buffer #520: A Carnival of the Vanities for DBAs

This Log Buffer covers Oracle, SQL Server and MySQL.

Oracle:

Create a Custom Authentication and Authorization Scheme in Oracle APEX

Diagnosing Listener Issues in RAC

What Are NULL pname entries in v$process?

SecureFile LOB – the empty table

Apache Spark for High Energy Physics Analysis, an Example

SQL Server:

[Read more]
Log Buffer #519: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:

Fix index corruption found using analyze table validate structure

Customizing a CoreOS image/iso: Ignition

12.2 New Feature: the FLEX ASM disk group part 4

An Important Change Is Coming for Application Express 5.2 (if you use the Mobile User Interface)

Creating an Oracle Database …

[Read more]
Log Buffer #518: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers from various blogs covering the technologies and news of Oracle, SQL Server and MySQL.

Oracle:

Storage Server: datasets, snapshots and performance

A Different Cause for enq: TM – contention

ODA X6-2M – How to create your own ACFS file system

Oracle New Version Numbering

[Read more]
Replicating from a higher to lower MySQL version

As we know, replication is only supported officially between consecutive major MySQL versions, and only from a lower version master to a higher version slave.

This means for example, the following scenario is supported:
5.6 master –> 5.7 slave

while these two scenarios are not supported:
5.5 master –> 5.7 slave
5.7 master –> 5.6 slave

That being said, in some contexts (e.g a MySQL upgrade) it can be valuable to be able to replicate from a master that is using a newer version of MySQL to an older version slave.

This could be used as part of a rollback strategy, and/or be needed in the case of upgrading a master-master replication topology.

The idea of the article is to provide you …

[Read more]
Replicating from a higher to lower MySQL version

As we know, replication is only supported officially between consecutive major MySQL versions, and only from a lower version master to a higher version slave.

This means for example, the following scenario is supported:
5.6 master –> 5.7 slave

while these two scenarios are not supported:
5.5 master –> 5.7 slave
5.7 master –> 5.6 slave

That being said, in some contexts (e.g a MySQL upgrade) it can be valuable to be able to replicate from a master that is using a newer version of MySQL to an older version slave.

This could be used as part of a rollback strategy, and/or be needed in the case of upgrading a master-master replication topology.

The idea of the article is to provide you …

[Read more]
Log Buffer #517: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:

Protecting Financial Data with Oracle WebCenter and Adobe LiveCycle

Oracle Forms 12c oracle.security.jps.JpsException Error after Database change

The Future of Content Management: Oracle Content & Experience Cloud

Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release …

[Read more]
Showing entries 1 to 10 of 143
10 Older Entries »