Core Process Overview The fundamental procedure involves three sequential steps: Export the target database using the mysqldump utility. Compress the resulting SQL dump file. Secure transfer the compressed archive to a designated remote backup server. Security and Connectivity Considerations In typi...
IN and NOT IN Operators Use the IN operator to filter records matching any value in a specified list. Conversely, NOT IN excludes records matching values in the list. Retrieve records where supplier_id is 101 or 102: SELECT supplier_id, supplier_name FROM products WHERE supplier_id IN (101, 102); Re...
This article outlines the development of a homestay booking application for the Android platform. The system is designed to provide users with a mobile interface for browsing available accommodations, viewing announcements, and managing bookings. It serves three primary user roles: administrators, g...
This guide outlines multiple methods for installing MySQL on Ubuntu 16.04, covering APT repository, offline DEB bundle, and binary tarball installations. Installation Method Overview Before installation, consider the following: APT Installation: Simplest method using Ubuntu's package manager. Automa...
1. Project setup 1.1 Dependency Add MyBatis Spring Boot starter to pom.xml. <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.3.1</version> </dependency> 1.2 Data source configuratio...
Confgiuring multiple databases in a single Spring Boot application with MyBatis requires defining separate DataSource, SqlSessionFactory, and SqlSessionTemplate beans per database, and mapping each mapper package to the appropriate factory/template. Maven dependencies <dependencies> <depend...
Measure storage use in the Zabbix schema Identify which tables consume the most space before pruning. SELECT t.table_name AS tbl, ROUND((t.data_length + t.index_length) / 1024 / 1024, 2) AS size_mb FROM information_schema.tables AS t WHERE t.table_schema = 'zabbix' ORDER BY size_mb DESC; Large footp...
macOS Catalina (10.15) ships with Apache and several scripting languages preinstalled, but the following setup uses Nginx, Homebrew PHP 7.4, MySQL 8, and Redis. The default shell is zsh; commands assume ~/.zshrc for shell configuration. Terminal and IDE Install iTerm2 by dragging the app into /Appli...
Required dependencies application.properties: define two data sources and poooling Java configuration for both data sources MyBatis mappers for each data source Controller endpoints to verify both connecsions Sample project layout and test URLs Dependencies <!-- MySQL JDBC driver --> <depe...
When a replica halts because the SQL thread encounters an error, you can resume replication by skipping the problematic event(s). Two common approaches are available. Methods to Skip Errors 1) Skip a specific number of events Use SQL_SLAVE_SKIP_COUNTER to advance the SQL thread past N events. Skip o...