Questions tagged [mysqld-multi]
The mysqld-multi tag has no usage guidance.
9 questions
1
vote
2
answers
422
views
Advice: Should i use multiple physical databases or one physical database and several logical ones
We are creating a web application that will be used by companies as their business application every day, each company will have many employees and a lot of data.
Is it wise for each company to have ...
- 11
2
votes
1
answer
3k
views
fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
I'm getting the following error;
Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
I've tried setting this up on 3 ...
- 23
0
votes
1
answer
302
views
Secondary mysql instance runs but mysqld_multi reports it is "not running"
On my Ubuntu server, there are two mysql instances running at the same time.
A default, normal mysql instance
A secondary mysql instance running with mysqld_multi.
The command sudo service mysql ...
2
votes
1
answer
345
views
How can I specify which MariaDB instance to launch in a Galera Cluster
I have several MariaDB servers, each with multiple instances running. I'm trying to figure out how would I bootstrap a Galera cluster but specify which instance I want to launch i.e:
node1, 2, and 3 ...
- 23
0
votes
1
answer
182
views
MySQL 5.5.58 Installing Multiple Instances on RHEL7
I am Avinash.
I am willing to install an additional MySQL instance on a UAT server for testing purposes. I am using MySQL Community Server 5.5.58 installed on RHEL7.2.
I am going through the MySQL ...
- 226
2
votes
1
answer
373
views
join to other table multiplied by loop foreign key in mysql
i have 2 table one node and relation and Second store buy each node. my code work fine but when sum multiple buy for each node result multiplied by number of purchases .
table nodes
+-------------+--...
- 149
1
vote
2
answers
5k
views
In MySQL Multiple instance, default instance is running, second instance is not
I was made a setup to create multiple instances on the ubuntu machine. When I start mysql instances mysqld1 is running but mysqld2 is not running.
root@ubuntu:/var/lib# mysqld_multi report
Reporting ...
vellaidurai
3
votes
1
answer
526
views
mysqld-multi with first DB as Slave and second DB as Master
Yesterday, I setup mysqld-multi in my.cnf. It works fantastic, but there is still a further Problem.
The first DB on socket 1 running as Slave from a other server. The second one from socket 2 ...
3
votes
1
answer
2k
views
fetching externally hosted db's table from within the local mysql server
Let's say we have a mysql database on localhost with table A and table B.
Is it possible to fetch details from a 3rd party mysql server to which we have login info and which allows external access?
...
aQuestion