Managing SQL Drift: Ensuring Stability in Database Transitions
SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity.
Read moreThe agile software development lifecycle responsibility
The eXtreme Programming (XP) methodology places emphasis on a number of core principles for agile software development. These include (and are not limited to) the planning game, short and frequent iterations, testing, frequent refactoring, continuous integration, ownership and standards.
Read moreQ: Does MySQL support ACID? A: Yes
I was recently asked this question by an experienced academic at the NY Oracle Users Group event I presented at. Does MySQL support ACID? (ACID is a set of properties essential for a relational database to perform transactions , i.
Read moreDo you control your database outages?
Working with a client last week I noted in my analysis, “The mysql server was restarted on Thursday and so the [updated] my.cnf settings seems current”. This occurred between starting my analysis on Wednesday and delivering my findings on Friday.
Read moreUnderstanding the MySQL Release Cadence
Download PDF Presentation At the recent New York Oracle Users Group summer general meeting I gave a presentation to the Oracle community on the MySQL product release cycle. Details included:
Read moreUtilizing OpenStack Trove DBaaS for deployment management
Trove is used for self service provisioning and lifecycle management for relational and non-relational databases in an OpenStack cloud. Trove provides a RESTful API interface that is same regardless of the type of database.
Read moreAre you a responsible developer?
What is a good example of individual developer responsibility? Here is just one example. A developer downloads a copy of the core production database to their own development laptop. Why? Because it’s easy to work with real data, and it’s hard to consider building applicable test data that all engineers can utilize.
Read moreUnderstanding the DBaaS capability for your organization
As your organization transforms to embrace the wealth of digital information that is becoming available, the capability to store, manage and consume this data in any given format or product becomes an increasing burden for operations.
Read moreExpired MySQL passwords
I was surprised to find on one of my websites the message “Connect failed: Your password has expired. To log in you must change it using a client that supports expired passwords.
Read moreDigital transformation strategies
“The cosmos is complex, the cloud does not have to be”. This quote by Ben Amaba , Worldwide Executive at IBM Cloud, early in his presentation at the Performance without Limits 3.
Read moreUnderstanding the Oslo Libraries
Underpinning all of the OpenStack projects including Nova, Cinder, Keystone, Glance, Horizon, Heat, Trove, Murano and others is a set of core common libraries that provide a consistent, highly tested and compatible feature set.
Read moreare you running KVM or QEMU launched instances?
A recent operators mailing list thread asked this question regarding the OpenStack user survey results of April 2016 (See page 39). As I verified my own local multi-node devstack dedicated H/W environment with varying commands, I initially came across the following error (which later was found to be misleading).
Read moreUsing your devstack cloud
You have setup and installed devstack . Now what! The Horizon UI will allow you to administer your running cloud from a web interface. We are not going to discuss the web UI in this post.
Read moreRunning a devstack virtual machine with limited memory
If you have a system with only 4GB of RAM, you need to assign at least 2.5GB (2560M) to a virtual machine to install devstack . Even with this limited RAM there are times the devstack installation will fail.
Read moreDownloading and installing devstack
The following instructions assume you have a running Linux virtual machine that can support the installation of devstack to demonstrate a simple working OpenStack cloud. For more information about the preparation needed for this step, see these pre-requisite instructions:
Read more