Am 01.06.2017 um 00:01 schrieb Matthew Black:
I DON'T RUN SYSTEMD, so that's not an option. At all. Why is that so hard to
grasp?
then just clone the sysvinit script as i have done years ago before
syetemd on dozens of machines without ever touch mysqld_multi - why is
that
. Several people
pointed me toward the right direction but their answers were incomplete. It was
ultimately Oracle support that answered my question, for which I am most
appreciative.
> they don't behave anything different if you have a single server
Really? With mysqld_multi, each mys
e a real-world example.
they don't behave anything different if you have a single server,
mysqld_multi or just a dozen mysqld instances started directly with
systemd and "Can anyone provide a simple example of how to edit
/etc/my.cnf file and command line steps necessary for creating
Original Message-
From: shawn l.green [mailto:shawn.l.gr...@oracle.com]
Sent: Saturday, May 20, 2017 10:57 AM
To: mysql@lists.mysql.com
Subject: Re: mysqld_multi
Hello Matthew,
On 5/19/2017 12:19 PM, Matthew Black wrote:
> I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an a
Hello Matthew,
On 5/19/2017 12:19 PM, Matthew Black wrote:
I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging
5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each
database on its own TCP Port 33xx. I'm having trouble creating a databa
e and instance are identical?
> I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to
> replace an aging 5.1 system running on RHEL 5. We run
> mysqld_multi with multiple instances, each database on its
> own TCP Port 33xx. I'm having trouble creating a database
> on
He means a database, not a schema. Instance would have been clearer as
terminology goes, admittedly, but in a MySQL context the two are identical.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
l@lists.mysql.com
Subject: Re: mysqld_multi
Am 19.05.2017 um 18:19 schrieb Matthew Black:
I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging
5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each
database on its own TCP Port 33xx. I'm havi
.@thelounge.net]
Sent: Friday, May 19, 2017 9:27 AM
To: mysql@lists.mysql.com
Subject: Re: mysqld_multi
Am 19.05.2017 um 18:19 schrieb Matthew Black:
> I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging
> 5.1 system running on RHEL 5. We run mysqld_multi wi
Am 19.05.2017 um 18:19 schrieb Matthew Black:
I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging
5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each
database on its own TCP Port 33xx. I'm having trouble creating a database on
th
I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging
5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each
database on its own TCP Port 33xx. I'm having trouble creating a database on
the new server in a multi environment.
Can anyone pr
ose Julian Buda"
mailto:jb...@noticiasargentinas.com>> wrote:
Hi, i have a server acting as a replication distribution
master(taking from the real master), with several mysql instances
(instance 1,instance 2...) with mysqld_multi script, and many
replication filter
Hi, i have a server acting as a replication distribution master(taking
from the real master), with several mysql instances (instance 1,instance
2...) with mysqld_multi script, and many replication filters just to
avoid using bandwidth to the remote datacenters with useless data.
It's wo
Hi,
I try to use !includedir directive with mysqld_multi for load other option
files but nothing is loaded by mysql.
In the default my.cnf, I have only the includedir directive for my
configuration directory :
!includedir /etc/my.cnf.d
And in /etc/my.cnf.d/mysql3306.cnf I have
=127.0.0.1
skip-name-resolve
For start/stop
==
-bash-3.1# cat /opt/MySQL5129start.sh
/opt/MySQL5129/bin/mysqld_multi start 5129
-bash-3.1# cat /opt/MySQL5129stop.sh
/opt/MySQL5129/bin/mysqld_multi stop 5129
-bash-3.1# cat
Thanks, Prabhat! You're very right, but did you read the questions I asked?
From: Prabhat Kumar
To: Nitin Mehta
Cc: mysql@lists.mysql.com
Sent: Tue, May 11, 2010 11:54:22 AM
Subject: Re: starting multiple instances with mysqld_multi
Hi,
You ca
to/log/file/for/server2
(other options here)
then you could start the separate instances of mysqld as follows:
shell> mysqld --defaults-extra-file=/etc/my.server1.cnf
shell> mysqld --defaults-extra-file=/etc/my.server2.cnf
about *mysqld_multi*
> *mysqld_multi*
> mysqld_multi [ op
Hi,
I am exploring multiple instances with MySQL which will be running using the
same set of binaries (single MySQL base). Two things which I'm not able to work
out are -
1. Why mysqld_multi stop doesn't work? Well, I know why it
doesn't because there is nothing i
We are using mysqld_multi to start three instances, the command /usr/
bin/mysqld_multi --config-file=/etc/my.cnf start 1-3 works just fine.
But when I tried to put that in rc.local only 3306 would start. Ok
fine.
So I created 3 scripts that I put in /etc/init.d called mysqld1, 2,
and 3
I am trying to get a few instances of mysql running at boot time - and
I have come across the command mysqld_multi. Seems to have a lot of
documentation about kicking those off via command line - but not much
on setting it up to start at boot. anyone have any insight into this?
Either using
multi_admin account by executing the following
commands for each server:
shell> mysql -u root -S /tmp/mysql.sock -p
Enter password:
mysql> GRANT SHUTDOWN ON *.*
-> TO 'multi_admin'@'localhost' IDENTIFIED BY 'multipass';
The username/password goes in your my.cnf
Dear all,
I am running the official mysql rpms on a sles 9 box, and I am running
multiple versions of mysql servers on different ports. The problem I
am facing is that when i run
mysqld_multi start
it starts the servers up fine but when i do the reverse :
mysqld_multi stop ,
it doesn't
Hello.
Check the --no-log option for mysqld_multi to see it's messages on your
console. What is in servers' error logs?
PRASHANT N <[EMAIL PROTECTED]> wrote:
> hi
>
> as per the online manual, i have configured mysql and able to run the server
> as mysql
hi
as per the online manual, i have configured mysql and able to run the server as
mysqld_safe. but if i want to run mysqld_multi with the following configuration
it doesnt work... the config file is like
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql
> I have successfully configured mysqld_multi to have mysql 4.1.11 and
> 5.0.3 beta running on the same machine:
>
I would like to see how you configured mysqld_multi to do that, if you could
send me the information off list I'd appreciate it.
> # mysqld_multi start &
>
Greetings,
I have successfully configured mysqld_multi to have mysql 4.1.11 and
5.0.3 beta running on the same machine:
# mysqld_multi start &
# exit
% mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld4 is running
MySQL server from group: mysqld5 is running
%
How
I now have multiple installations running on the same machine, and am also using
mysqld_multi. However, even though it's working, there's one thing I don't
understand. Why does the [mysqld_multi] section have to contain the pointers to
mysqld and mysqladmin? It seems to me
You can use mysqld_multi to run different versions of MySQL on the same
Server. You can run 4.0.x, 4.1.x and 5.0.x and manage these with
mysqld_multi.
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/9/04 4:43 PM
Subject: mysqld_multi & different server versions
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: sean c peters [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 09, 2004 1:43 PM
> To: [EMAIL PROTECTED]
> Subject: mysqld_multi & different server versions
>
> So am i
In my ongoing quest to get upgraded to 4.1.3 beta (yes the version I'm
upgrading to keeps changing), i have been reading about mysqld_multi to
manage multiple server instances on the same machine.
But, from what i've read, it appears that this is for running multiple
instances o
Hi,
Can someone tell me how I can use mysqld_multi to have one RPM installation
of MySQL(default with RedHat9) to run multiple mysqlds?
Thanks
-Minuk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Date: Wed, 14 Apr 2004 13:26:10 -0400
To: [EMAIL PROTECTED]
From: "Pingouin Team" <[EMAIL PROTECTED]>
Subject: mysqld_multi
Message-Id: <[EMAIL PROTECTED]>
Hi,
I need help. I have my old mysql server running in my web server and I
can't stop it for make the test of t
ample:
[mysqld_multi]
mysqld = /home/benoit/mysql/bin/safe_mysqld
mysqladmin = /home/benoit/mysql/bin/mysqladmin
user = multi_admin
password = multipass
[mysqld2]
socket = /home/benoit/tmp/mysql.sock
port = 3310
pid-file = /home/benoit/mysql/var/pingouin.pid
datadir= /home/b
Hello all,
I would like to run diverent MySQL-Daemons on the same Linux machine, so
I use mysqld_multi to start the different processes.
The Config looks right to me, I have different Database Directorys,
Pid-Files, Ports, IDs usw. and different Socket-Files and all over it
seems to work.
But
I am trying to execute mysqld_multi script in unix. But it's giving me following error
"WARNING! my_print_defaults command not found. Please make sure you have this command
available and in your path. The command is available from the latest MySQL
distribution."
I have th
Good morning:
What is the proper method of creating ibdata files with mysqld_multi?
Using mysqld_multi the second server started, but just created one
ibdata file instead of four, which I have indicated in the second servers'
my.cnf file located in its data dir.
Also, I was unable t
I try to set up multiple daemons on the same with different
versions and
I can’t get it working has anybody a example file so I
can test if I can get it working.
I have attached my file
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Why does only the [mysqld2] start see attached file
Does anybody have a my.cnf file for 3.23.58 since I can’t
get it started with InnoDB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have two different versions running 3.23 & 4.0
If I wanna configure the section [mysqld_multi] how can the machine
automatic boot with two different mysqld since 3.23 uses safe_mysqld
Mysqld= /usr/local/bin/mysqld_safe ( and not for 3.23 safe_mysqld)
Mysqladmin = /usr/local
Hi,
I have an odd problem with mysqld_multi.
I am trying to set up several MySQL servers on my new development server,
for testing purposes.
I currenty have only one, 4.0.9, just want to get this one going first.
However, when I try to start mysqld_multi, it seems it does not recognise
the
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them.
Thanks Anticipated,
Iulian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
mysqld_multi doesn't start the two groups from my.cnf if I give the start
command immediately after stopping them.
How can I safely start the groups with mysqld_multi anytime (including
immediately after stopping them)?
Thanks Anticipated,
Iulian
--
MySQL General Ma
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them. It will start only one group.
I'm working on Linux RedHat 9 MySQL 4.0.14.
How can I solve this problem, please?
Thanks Anticipated,
Iulian
--
MySQL General Mailing Lis
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them.
Thanks Anticipated,
Iulian
.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to run 3.23.43 and 4.0.13 on the same server?
I don't see anything in the documentation that should prohibit this as
long as the installations are in different directories, use different
sockets/ports and data directories.
Can this be done utilizing mysqld_multi and if s
Hello,
Has anyone had success using the mysqld_multi startup script at boot on Solaris
8? I can start mysqld manually, but not automatically at boot time. Any help
or advice is apprciated.
Thanks a lot,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Thu, 7 Nov 2002, Chris Raymer wrote:
> Yes, that is what I meant. Thank you for the clarification and response.
> Any ideas on maximizing *server* performance besides the usual db-specific
> optimizations like indexing? If not too much trouble, could you give me a
> brief explanation why I wo
äinen" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>
Cc: "Raymer, Chris" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 12:42 AM
Subject: Re: mysqld_multi
On Wed, 6 Nov 2002, Paul DuBois wrote:
> At 13:22 -0600
On Wed, 6 Nov 2002, Paul DuBois wrote:
> At 13:22 -0600 11/6/02, Raymer, Chris wrote:
> >Any opinions on running mysqld_multi? Our architecture, X-serve,
> >2GBs RAM,Dual Procs, 480 GB stogage as "Master" MySQL server
> >replicated to a less impressive server. S
At 13:22 -0600 11/6/02, Raymer, Chris wrote:
Any opinions on running mysqld_multi? Our architecture, X-serve,
2GBs RAM,Dual Procs, 480 GB stogage as "Master" MySQL server
replicated to a less impressive server. Seems logical to separate
the "heavy-hitter" dbs to their ow
Any opinions on running mysqld_multi? Our architecture, X-serve, 2GBs RAM,Dual Procs,
480 GB stogage as "Master" MySQL server replicated to a less impressive server. Seems
logical to separate the "heavy-hitter" dbs to their own "servers" and take more
advan
How much CPU per mysqld_multi user would be needed?
I work for an ISP and would like to give 100 users a mysqld each
How do a calculate the CPU's I would need?
Thanks
Simon
Hoping to give MySQL to all?
-
Before po
> sql,query
> Is there any option to do this on a windows version?
> All the documentation ( and from what I see of the
> installation of the =
> windows version ) leads me to believe there is not
>
> Luc
>
>
-
Before posti
ile the
servers with different TCP/IP ports and socket files so they are not both
listening to the same TCP/IP port or socket file.
See section 4.7.3 mysqld_multi, program for managing multiple MySQL
servers."
This leads me to believe that I can use mysqld_multi to start instances of
both
54 matches
Mail list logo
