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 so hard
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 mysqld daemon listens on a separa
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 a new
database running on, for ex
.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 aging
> 5.1 system running on RH
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 database
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 the new se
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:
: 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 having trouble creating a database
]
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 with multiple ins
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
the new
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 provide
ulian Buda"
<jb...@noticiasargentinas.com <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, an
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 working
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
/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 [ options] {start| stop| report} [ server_id
with mysqld_multi
Hi,
You can run multiple instances on the same host and specify configuration
options either by adding the options as arguments on the command line, or by
storing them in configuration files.
for example, from the command line:
shell mysqld --port 3306 --log=/path/to/server1/log
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 grp_id doesn't work? Well, I know why it
doesn't because there is nothing in the script
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 under a [mysqld_multi] section.
Atle
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 n
it starts the servers up fine but when i do the reverse :
mysqld_multi stop n,
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 mysqld_safe. but if i want to run
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
# exit
% mysqld_multi report
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
%
However, I
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 that it should
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
In my
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 of the same
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 correct in thinking that i wont
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 the new version (3.28 to 4.0). I
have
:
[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/benoit
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
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 the laterst MySQL
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 to log
I try to set up multiple daemons on the same with different
versions and
I cant 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 cant
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/bin
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
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 List
For list
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 Mailing
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 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 so
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
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 would
[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 11/6/02, Raymer, Chris wrote:
Any opinions on running mysqld_multi
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
advantage of the server's resources.
Chris
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 own servers and take more
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. Seems logical to separate
the heavy-hitter
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 posting
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 posting,
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 3.22.32 and 3.23.47. However
54 matches
Mail list logo