Configuration Management
Managing change – at the application data, software configuration or OS configuration level – directly contributes to a system's stability. To make informed decisions and to alleviate performance risk, you need to manage these configurations, as well as track changes and their impact on overall system performance.
Pythian understands the entire database stack intimately and can monitor and manage change effectively. We manage multiple combinations of applications across many operating environments and industries. We know the features and the parameters; together with our experience, we have the insight to know what works best and where.
Benefits: Configuration Management
- Database stability
- Optimal use of system resources
- Consistency across your entire environment
- Tracking the impact of changes to obtain ROI on changes
- Accountability
- Cost savings
Services Provided under Configuration Management
- High availability, business continuity, secure and scalable configurations based on our best practices and industry standards;
- Planned approach to upgrades, regular updates and on-off bug fixes;
- Proper auditing where all changes are recorded and made easily available, thereby allowing application behavior changes to be mapped to any configuration change;
- Professional project management handled by certified project managers;
- Assessments of the state of your configuration;
- Establishment of a configuration management process in your organization.
Database Features
We have extensive experience in Oracle, Oracle Apps, MySQL and SQL Server.
When it comes to database configuration management, we know how to get the most from the features such as:
- Oracle: RAC, ASM, Replication (Streams / Materialized Views / NetApp), Resource Manager, Data Guard / Standby, Grid Control, init/database parameters.
- Oracle Apps: Architecture review, best practices, Concurrent Manager strategy, patching strategy, cloning strategy, Apps purging jobs, supporting applications (e.g., ADI, Discoverer), tailored monitoring for Apps components (Concurrent Manager queues, Workflow Mailer, Apps scheduled jobs, etc.).
- MySQL: Replication architectures for: load balancing, consistent backups, disaster recovery, minimizing downtime during long offline operations (including upgrades and performance tuning), MySQL Cluster, MySQL Proxy.
- SQL Server: Best Practices Analyzer, Windows Clustering, Address Windowing Extension (AWE), 32/64 bit, database mirroring, replication, peer-to-peer replication (P2P), log shipping, SSIS/DTS, Reporting Services, Analysis Services, indexed views, table partitioning, parallelism, SQL Server configuration options, database options, trace flags, instant file initialization, lock pages in memory, large VLFs, tempdb configuration, backup and data compression, performance data collection, data encryption, data auditing.