Skip to main content

Tools and Services

Nimbuz provides a comprehensive set of tools and services to support your application infrastructure. Currently, our platform supports databases and management tools to enhance your development and production environments.

Supported Tools​

Nimbuz currently supports the following tools:

  1. CloudBeaver - Database administration tool
  2. PostgreSQL - Relational database
  3. MySQL - Popular relational database
  4. MongoDB - NoSQL document database

Accessing Tools​

Tool Information​

Each tool provides detailed information including:

  • View Details: Brief introduction and tool overview
  • Name: Unique identifier for the tool instance
  • Status: Current operational status
  • Host: URL to access the tool interface
  • Port: Port number the tool is running on

Available Actions​

For each installed tool, you can perform:

  • View: Display detailed tool information and configuration
  • Edit: Modify the tool's configuration and settings
  • Delete: Permanently remove the tool and all associated data

CloudBeaver​

CloudBeaver is a web-based database administration tool that provides an interface for managing your databases.

Installation Configuration​

Name

  • Enter a unique name for your CloudBeaver instance
  • Use descriptive names for easy identification
  • Follow your organization's naming conventions

Instance Type

  • Select an appropriate instance type from the supported options
  • Consider your expected usage and performance requirements
  • Available options: femto, pico, nano, micro, small, medium, large, extra large, 2x large

Features​

  • Web-based database management interface
  • Support for multiple database types
  • User-friendly administration tools
  • SQL query execution environment

Use Cases​

  • Database administration and management
  • SQL query development and testing
  • Database schema visualization
  • Data browsing and editing

PostgreSQL Database​

PostgreSQL is a powerful, open-source relational database management system.

Installation Configuration​

Name

  • Enter a unique name for your PostgreSQL instance
  • Choose a descriptive name that identifies the database purpose

Root User Password

  • Set a strong password for the root user account
  • Root user has administrative access to the database
  • Follow security best practices for password creation

Postgres User Password

  • Set a password for the default PostgreSQL user
  • This user is used for standard database operations
  • Should be different from the root password

Persistence Size

  • Specify the amount of persistent storage allocated to the database
  • Value should be between 1 and 3 GB
  • Consider your data storage requirements and growth projections

Replicas

  • Set the number of database instances for load balancing or high availability
  • Higher replica counts provide better availability and read performance
  • Consider your availability requirements and traffic patterns

Features​

  • ACID compliance and reliability
  • Advanced SQL features
  • Extensible with custom functions and data types
  • Strong consistency and data integrity

Management​

  • PostgreSQL databases can be viewed and managed through CloudBeaver
  • Direct connection via database clients
  • Command-line access for advanced administration

MySQL Database​

MySQL is one of the world's most popular relational database management systems.

Installation Configuration​

Name

  • Choose a unique name for your MySQL tool instance
  • Use clear, descriptive naming conventions

Root Password

  • Set a secure root password for MySQL
  • Root provides full administrative access to the database
  • Essential for database management and security

Primary Persistence Size

  • Specify the amount of persistent storage in GB
  • Allocated for storing your database data
  • Plan for current needs and future growth

Instance Type

  • Choose appropriate instance type based on resource needs
  • Consider CPU and memory requirements for your workload
  • Balance performance needs with cost considerations

Custom Database

  • Enter a name for a custom database to be created during initialization
  • Optional: Can be created later if not specified during setup
  • Useful for organizing application-specific data

Custom User

  • Define a user who will have access to the custom database
  • Provides restricted access compared to root user
  • Follow principle of least privilege for security

Custom Password

  • Set a password for the custom user specified above
  • Should be different from root password
  • Use strong password practices

Features​

  • High performance and reliability
  • Wide platform support
  • Extensive community and documentation
  • ACID compliance

Management​

  • MySQL databases can be viewed and managed through CloudBeaver
  • phpMyAdmin interface available for web-based management
  • Command-line tools for advanced administration

MongoDB Database​

MongoDB is a popular NoSQL document database designed for scalability and flexibility.

Installation Configuration​

Name

  • Enter a unique name for your MongoDB instance
  • Choose names that reflect the database purpose

Root Password

  • Set a password for the MongoDB root user
  • Root user has administrative privileges
  • Essential for cluster management and security

Replica Set Key

  • Provide a shared secret for authenticating communication
  • Used between members of the MongoDB replica set
  • Critical for replica set security and operation

Persistence Size

  • Specify the amount of persistent storage in GB
  • Allocated to the MongoDB database
  • Consider document storage requirements and indexing needs

Instance Type

  • Choose instance type based on CPU, memory, and performance requirements
  • MongoDB benefits from adequate RAM for working set
  • Consider read/write patterns and concurrent connections

Features​

  • Document-oriented data model
  • Horizontal scalability
  • Flexible schema design
  • Rich query language

Management​

  • MongoDB Compass for graphical interface
  • Command-line tools for administration
  • RESTful APIs for programmatic access

Database Management with CloudBeaver​

Accessing Databases​

PostgreSQL and MySQL databases can be viewed and managed through the CloudBeaver URL provided after installation.

Benefits of CloudBeaver Integration​

  • Unified interface for multiple database types
  • Web-based access from anywhere
  • No need for separate database client installations
  • Consistent user experience across database platforms

CloudBeaver Features​

  • SQL Editor: Write and execute SQL queries
  • Data Browser: View and edit table data
  • Schema Management: Create and modify database schemas
  • User Management: Manage database users and permissions
  • Export/Import: Data migration and backup capabilities

Best Practices​

Instance Sizing​

  • Development: Use smaller instances (nano, micro) for development and testing
  • Staging: Use medium instances to simulate production loads
  • Production: Use larger instances (large, extra large) for production workloads

Security​

  • Use strong, unique passwords for all database users
  • Implement network security groups to control access
  • Regularly update and patch database systems
  • Use different credentials for different environments

Storage Planning​

  • Plan storage capacity based on data growth projections
  • Consider backup storage requirements
  • Monitor storage usage and plan for scaling
  • Implement data retention policies

High Availability​

  • Use multiple replicas for critical databases
  • Distribute replicas across availability zones
  • Implement proper backup and recovery procedures
  • Test disaster recovery processes regularly

Monitoring and Maintenance​

Performance Monitoring​

  • Monitor database performance metrics
  • Track query performance and optimization opportunities
  • Monitor resource utilization (CPU, memory, disk)
  • Set up alerts for performance thresholds

Backup and Recovery​

  • Implement automated backup schedules
  • Test backup restoration procedures
  • Maintain backup retention policies
  • Consider cross-region backup replication

Maintenance Tasks​

  • Regular database optimization and maintenance
  • Index maintenance and optimization
  • Log rotation and cleanup
  • Security updates and patches

Troubleshooting​

Common Issues​

Connection Problems​

  • Verify network connectivity and security groups
  • Check database service status
  • Validate connection credentials
  • Review firewall and port configurations

Performance Issues​

  • Monitor resource utilization
  • Analyze slow query logs
  • Review indexing strategies
  • Consider instance sizing adjustments

Storage Issues​

  • Monitor storage utilization
  • Plan for storage expansion
  • Review data retention policies
  • Consider archiving old data

Integration with Applications​

Connection Configuration​

  • Use environment variables for database connection strings
  • Implement connection pooling for better performance
  • Use appropriate database drivers for your application
  • Configure proper timeout and retry settings

Security Best Practices​

  • Use SSL/TLS for database connections
  • Implement proper authentication and authorization
  • Use connection strings with appropriate privileges
  • Regularly rotate database credentials

Next Steps​

With your tools and services configured:

  1. Monitor your infrastructure - Track performance and usage
  2. Manage resources effectively - Optimize costs and performance
  3. Implement best practices - Follow recommended procedures
  4. Set up team access - Configure user permissions

Support​

Need help with tools and services?

  • Email: tools@nimbuz.cloud
  • Live Chat: Available 24/7 in your dashboard
  • Documentation: Comprehensive database guides
  • Video Tutorials: Database setup and management tutorials
  • Database Support: Specialized database assistance available