MySQL
Performance schema hands-on – part 1
innodb_io_capacity and innodb_io_capacity_max tuning
How to online refresh BI tables with minimum impact to end users
StreamSets Data Collector replication with Oracle, MySQL and JSON
Table of contents
- Preamble
- StreamSets Data Collector installation
- StreamSets Data Collector source Oracle database configuration
- StreamSets Data Collector Oracle to Oracle replication
- StreamSets Data Collector Oracle to JSON file generation
- StreamSets Data Collector Oracle to MySQL replication
-
Errors encountered
- JDBC_52 - Error starting LogMiner
- JDBC_44 - Error while getting changes due to error: java.sql.SQLRecoverableException: Closed Connection: getBigDecimal
- ORA-01291: missing logfile
- JDBC_16 - Table '' does not exist or PDB is incorrect. Make sure the correct PDB was specified
- JDBC_00 - Cannot connect to specified database: com.zaxxer.hikari.pool.PoolInitializationException: Exception during pool initialization: The server time zone value 'CEST' is unrecognized or represents more than one time zone.
- Establishing SSL connection without server's identity verification is not recommended
- JdbcGenericRecordWriter - No parameters found for record with ID
- References