Multi Tb migration using mydumper
In this post I will explain how to transfer a multi terabyte size database between two MySQL...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management (98)
Ansible and AWS automation
Overview The goal was to create and manage a MySQL RDS instance and learn how to control AWS...
Understanding MySQL Isolation levels: repeatable-read
Isolation levels are a rare subject in MySQL literature. The documentation provides a terse...
Change of database passwords through OEM
Once in a while passwords for system database accounts should be changed due to different...
Oracle E-Business Suite and Java Web Start. Finally!
Great things always happen overnight. That's probably the case for European Oracle Apps DBAs in the...
Cloning Oracle grid infrastructure using Ansible
Sometimes your organization may decide to move to new hardware, to new data center and you, as an...
Simple steps to perform opatch maintenance with Ansible
Like the Universe, IT growth seems to be infinite, we always have more environments, more servers,...
Azure SQL managed instance: new member of the family!
SQL Server is one of Microsoft's strongest enterprise software products. Both in terms of revenue...
Error ORA-01033 after doing a switchover in a 12.1 RAC environment
The other day I did a switchover in a RAC environment , which went pretty smooth , but after doing...
Using transportable tablespaces with partitioned tables
Overview In this post I will explain how to transfer a partitioned table using transportable...
