ServerBuddy

https://serverbuddy.app/docs
Admin
ServerBuddy is a visual management platform for deploying and monitoring Docker containers for...
Tokens:6,217
Snippets:133
Trust Score:6.4
Update:4 months ago
Show doc for...
Tokens:
Raw
### Check Docker Installation

Source: https://serverbuddy.app/docs/deploy-mysql-docker-container-visual-monitoring-guide

Verify if Docker or Podman is installed on your server.

```bash
docker --version
# or
podman --version

```

--------------------------------

### Create Table via HTTP

Source: https://serverbuddy.app/docs/deploy-clickhouse-docker-container-visual-monitoring-guide

Example of creating a table in ClickHouse using a curl command to the HTTP interface.

```bash
curl -u admin:YourSecurePassword123! 'http://localhost:8123/' -d 'CREATE TABLE test (id UInt32) ENGINE = Memory'
```

--------------------------------

### ClickHouse Performance Queries

Source: https://serverbuddy.app/docs/deploy-clickhouse-docker-container-visual-monitoring-guide

A collection of useful SQL queries to check system metrics, query logs, table sizes, active queries, database statistics, and memory usage within ClickHouse.

```sql
-- System metrics
SELECT * FROM system.metrics LIMIT 10;

-- Query log
SELECT query, query_duration_ms FROM system.query_log ORDER BY event_time DESC LIMIT 10;

-- Table sizes
SELECT table, formatReadableSize(sum(bytes)) as size FROM system.parts GROUP BY table;

-- Active queries
SELECT query_id, user, query FROM system.processes;

-- Database statistics
SELECT name, engine, total_rows, total_bytes FROM system.tables WHERE database = currentDatabase();

-- Memory usage
SELECT metric, value FROM system.metrics WHERE metric LIKE '%Memory%';

```

--------------------------------

### Execute Authenticated Query via HTTP

Source: https://serverbuddy.app/docs/deploy-clickhouse-docker-container-visual-monitoring-guide

Execute a query via the HTTP interface with basic authentication.

```bash
# With authentication
curl -u admin:YourSecurePassword123! 'http://localhost:8123/?query=SELECT+1'

```

--------------------------------

### Execute Query via HTTP

Source: https://serverbuddy.app/docs/deploy-clickhouse-docker-container-visual-monitoring-guide

Send a query to the ClickHouse HTTP interface using standard input.

```bash
# Execute query via HTTP
echo "SELECT count() FROM system.tables" | curl 'http://localhost:8123/' --data-binary @-

```

--------------------------------

### MySQL Performance Queries

Source: https://serverbuddy.app/docs/deploy-mysql-docker-container-visual-monitoring-guide

Run SQL queries within the MySQL container to check performance metrics.

```sql
SHOW STATUS LIKE 'Threads_connected';
SHOW PROCESSLIST;
SHOW GLOBAL STATUS LIKE 'Slow_queries';

```

--------------------------------

### Redis Performance Queries

Source: https://serverbuddy.app/docs/deploy-redis-docker-container-visual-monitoring-guide

Runs internal Redis commands to retrieve memory, stats, client, and database size information.

```bash
INFO memory
INFO stats
INFO clients
DBSIZE

```

--------------------------------

### Backup CedarDB Database

Source: https://serverbuddy.app/docs/deploy-cedardb-docker-container-visual-monitoring-guide

Uses the pg_dump utility to create a backup of the CedarDB database.

```bash
# Using standard PostgreSQL tools
pg_dump -h localhost -p 5432 -U postgres database_name > backup.sql

```

--------------------------------

### RabbitMQ Diagnostic Commands

Source: https://serverbuddy.app/docs/deploy-rabbitmq-docker-container-visual-monitoring-guide

A collection of diagnostic commands for RabbitMQ, including cluster status, connections, channels, memory usage, users, and virtual hosts.

```bash
# Check cluster status
docker exec -it production-rabbitmq rabbitmqctl cluster_status

# List connections
docker exec -it production-rabbitmq rabbitmqctl list_connections

# List channels
docker exec -it production-rabbitmq rabbitmqctl list_channels

# Check memory usage
docker exec -it production-rabbitmq rabbitmqctl status | grep memory

# List users
docker exec -it production-rabbitmq rabbitmqctl list_users

# List virtual hosts
docker exec -it production-rabbitmq rabbitmqctl list_vhosts

```

--------------------------------

### CedarDB Performance Queries

Source: https://serverbuddy.app/docs/deploy-cedardb-docker-container-visual-monitoring-guide

A set of SQL queries to check performance metrics within the CedarDB (PostgreSQL) database.

```sql
-- Database size
SELECT pg_database_size(current_database());

-- Active connections
SELECT count(*) FROM pg_stat_activity;

-- Table statistics
SELECT * FROM pg_stat_user_tables;

-- Current queries
SELECT pid, query, state FROM pg_stat_activity WHERE state != 'idle';

-- Database statistics
SELECT * FROM pg_stat_database WHERE datname = current_database();

```

--------------------------------

### List RabbitMQ Queues and Messages

Source: https://serverbuddy.app/docs/deploy-rabbitmq-docker-container-visual-monitoring-guide

Executes the 'rabbitmqctl list_queues' command to display queue names, message counts, and consumer counts.

```bash
docker exec -it production-rabbitmq rabbitmqctl list_queues name messages consumers

```

--------------------------------

### Connect to CedarDB from Host Machine

Source: https://serverbuddy.app/docs/deploy-cedardb-docker-container-visual-monitoring-guide

Connects to the CedarDB instance running in a Docker container from the host machine using the PostgreSQL client.

```bash
# From host machine
PGPASSWORD=YourSecurePassword123! psql -h localhost -p 5432 -U postgres

```

--------------------------------

### MongoDB Performance Queries

Source: https://serverbuddy.app/docs/deploy-mongodb-docker-container-visual-monitoring-guide

A collection of mongosh commands to retrieve performance and status information from a MongoDB instance.

```javascript
// Show database statistics
db.stats()

// Check current operations
db.currentOp()

// View server status
db.serverStatus()

// Check connection count
db.serverStatus().connections

// View collection statistics
db.collection.stats()

```

--------------------------------

### Connect to ClickHouse Container via Client

Source: https://serverbuddy.app/docs/deploy-clickhouse-docker-container-visual-monitoring-guide

Execute the ClickHouse client within a running container to interact with the database.

```bash
docker exec -it production-clickhouse clickhouse-client --user admin --password

```

--------------------------------

### Connect to MySQL Container

Source: https://serverbuddy.app/docs/deploy-mysql-docker-container-visual-monitoring-guide

Execute commands inside the running MySQL container to interact with the database.

```bash
docker exec -it production-mysql mysql -u root -p

```

--------------------------------

### Connect to ClickHouse via HTTP Interface

Source: https://serverbuddy.app/docs/deploy-clickhouse-docker-container-visual-monitoring-guide

Access the ClickHouse HTTP interface for basic queries, including version check.

```bash
curl -u admin:YourSecurePassword123! 'http://localhost:8123/?query=SELECT+version()'

```

--------------------------------

### Connect to CedarDB Container (Custom User)

Source: https://serverbuddy.app/docs/deploy-cedardb-docker-container-visual-monitoring-guide

Connects to the running CedarDB container using a custom user (e.g., 'cedar_admin') via the PostgreSQL client.

```bash
docker exec -it production-cedardb psql -U cedar_admin

```

--------------------------------

### Connect to Redis Container

Source: https://serverbuddy.app/docs/deploy-redis-docker-container-visual-monitoring-guide

Executes the redis-cli command inside the running Redis container.

```bash
docker exec -it production-redis redis-cli

```

--------------------------------

### Connect to MongoDB Container

Source: https://serverbuddy.app/docs/deploy-mongodb-docker-container-visual-monitoring-guide

Executes the mongosh command within the running MongoDB container to connect to the database.

```bash
docker exec -it production-mongodb mongosh -u admin -p

```

--------------------------------

### Connect to CedarDB Container (Default User)

Source: https://serverbuddy.app/docs/deploy-cedardb-docker-container-visual-monitoring-guide

Connects to the running CedarDB container using the default 'postgres' user via the PostgreSQL client.

```bash
docker exec -it production-cedardb psql -U postgres

```

--------------------------------

### RabbitMQ CLI Status

Source: https://serverbuddy.app/docs/deploy-rabbitmq-docker-container-visual-monitoring-guide

Executes the 'rabbitmqctl status' command inside the running RabbitMQ container to check its status.

```bash
docker exec -it production-rabbitmq rabbitmqctl status

```
Tokens:
Raw