Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: mysqld-multi

mysqld-multi with first DB as Slave and second DB as Master

By adminPosted on September 15, 2022

Question : Yesterday, I setup mysqld-multi in my.cnf. It works fantastic, but there is still a further Problem. The first […]

How can I specify which MariaDB instance to launch in a Galera Cluster

By adminPosted on August 1, 2022

Question : I have several MariaDB servers, each with multiple instances running. I’m trying to figure out how would I […]

join to other table multiplied by loop foreign key in mysql

By adminPosted on November 18, 2021

Question : i have 2 table one node and relation and Second store buy each node. my code work fine […]

fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’

By adminPosted on August 2, 2021

Question : I’m getting the following error; Got fatal error 1236 from master when reading data from binary log: ‘Could […]

Secondary mysql instance runs but mysqld_multi reports it is “not running”

By adminPosted on April 6, 2021

Question : On my Ubuntu server, there are two mysql instances running at the same time. A default, normal mysql […]

In MySQL Multiple instance, default instance is running, second instance is not

By adminPosted on February 1, 2021

Question : I was made a setup to create multiple instances on the ubuntu machine. When I start mysql instances […]

fetching externally hosted db’s table from within the local mysql server

By adminPosted on November 7, 2020

Question : Let’s say we have a mysql database on localhost with table A and table B. Is it possible […]

fatal error 1236 from master when reading data from binary log: ‘Could not find first log file name in binary log index file’

By adminPosted on August 14, 2020

Question : I’m getting the following error; Got fatal error 1236 from master when reading data from binary log: ‘Could […]

MySQL 5.5.58 Installing Multiple Instances on RHEL7

By adminPosted on August 10, 2020

Question : I am Avinash. I am willing to install an additional MySQL instance on a UAT server for testing […]

Recent Posts

  • Should “Long Running with Low CPU” be expected for an SPROC that performs millions of INSERTS?
  • What’s the benefit of CROSS JOIN vs INNER JOIN in recursive CTE queries?
  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding