Re: Two instances of MySQL
You can read more at my blog, if you want . On Tue, Apr 1, 2008 at 8:55 PM, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to create multiple instances of MySQL Database Server. I wanted it for Gentoo Linux is there a HowTo for configuring multiple instance of MySQL Database Server on Gentoo Linux Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Two instances of MySQL
Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to create multiple instances of MySQL Database Server. I wanted it for Gentoo Linux is there a HowTo for configuring multiple instance of MySQL Database Server on Gentoo Linux Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Two Instances
Christopher Chamber [EMAIL PROTECTED] wrote: Hi Everyone. My problem is that i want to create 2 instances of a sub-query. For Example: SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name = 'reviews' AND v2.sal = v1.sal ) v3 , v4 This query will gives an error as V4 is not allowed, i.e. not more than 1 instance of a sub-query can be created. Is there a way around this problem. I would not like to make this sub-query again to get another instance of it. I need it very much, and if anyone can give me a way to do it, i would be highly grateful. Can you please describe what you mean by an instance of a query? It's not clear to me. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Two Instances
Hi Everyone. My problem is that i want to create 2 instances of a sub-query. For Example: SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name = 'reviews' AND v2.sal = v1.sal ) v3 , v4 This query will gives an error as V4 is not allowed, i.e. not more than 1 instance of a sub-query can be created. Is there a way around this problem. I would not like to make this sub-query again to get another instance of it. I need it very much, and if anyone can give me a way to do it, i would be highly grateful. Thanks in advance. --- Christopher Chamber http://gem-hs.org/cc.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Two Instances
Hi Everyone. My problem is that i want to create 2 instances of a sub-query. For Example: SELECT DISTINCT V4.* FROM (SELECT v2.* FROM cell v1,cell v2 WHERE v1.name = 'reviews' AND v2.sal = v1.sal ) v3 , v4 This query will gives an error as V4 is not allowed, i.e. not more than 1 instance of a sub-query can be created. Is there a way around this problem. I would not like to make this sub-query again to get another instance of it. I need it very much, and if anyone can give me a way to do it, i would be highly grateful. Thanks in advance. Rahul Thathoo -- If real is characterized by what you see and what you can feel, then real is only electromagnetic impulses which run through you brain. -- Cheers! RAHUL THATHOO B.TECH(IT), 5th SEMESTER IIIT - ALLAHABAD PHONE: +91+532 2552505(ask for room 201) eHome: http://profile.iiita.ac.in/rthathoo_02 RYZE home: http://www.ryze.com/go/thathoo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my.ini file for two instances of MySql - need help
Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? Thank you! BID _ Check out the new MSN 9 Dial-up fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.ini file for two instances of MySql - need help
At 16:48 + 1/12/04, Rich Brant wrote: Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? This section of the MySQL Reference Manual describes the use of multiple servers: http://www.mysql.com/doc/en/Multiple_servers.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: my.ini file for two instances of MySql - need help
Here is an example of what I used: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location # basedir = c:/mysql/ # datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL safe-updates [isamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe user=xxx password= QueryInterval=5 Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] -Original Message- From: Rich Brant [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 10:48 AM To: [EMAIL PROTECTED] Subject: my.ini file for two instances of MySql - need help Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? Thank you! BID _ Check out the new MSN 9 Dial-up - fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: my.ini file for two instances of MySql - need help
Thanks, Chris, but how do I refer to the sencond instance of MySQL, the version 4? That's what's not clear to me. I did read the section in the manual, but it doesn't explain how to refer to seperate instances. THanks! From: Chris L. White [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: 'Rich Brant' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySql - need help Date: Mon, 12 Jan 2004 10:55:21 -0600 Here is an example of what I used: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location # basedir = c:/mysql/ # datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL safe-updates [isamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe user=xxx password= QueryInterval=5 Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] -Original Message- From: Rich Brant [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 10:48 AM To: [EMAIL PROTECTED] Subject: my.ini file for two instances of MySql - need help Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? Thank you! BID _ Check out the new MSN 9 Dial-up - fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Let the new MSN Premium Internet Software make the most of your high-speed experience. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: my.ini file for two instances of MySql - need help
Hello, What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? I install with mysqld-nt-max --install servicename servicename in those cases are MysQL40, MySQL41 and MySQL50 Those are the relevant rows: [mysqld] [mysql40] basedir = C:/mysql/4.0-tree/ datadir = C:/mysql/4.0-tree/data port= 3307 [mysql41] basedir = C:/mysql/4.1-tree datadir = C:/mysql/4.1-tree/data port= 3308 [mysql50] basedir = C:/mysql/5.0-tree datadir = C:/mysql/5.0-tree/data port= 3309 cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.ini file for two instances of MySql - need help
# If you specify no service name, the server uses the default service name of MySQL and the server reads options from the [mysqld] group in the standard option files. # If you specify a service name after the --install option, the server ignores the [mysqld] option group and instead reads options from the group that has the same name as the service. The server reads options from the standard option files. # If you specify a --defaults-file option after the service name, the server ignores the standard option files and reads options only from the [mysqld] group of the named file. http://www.mysql.com/doc/en/Multiple_Windows_servers.html and http://www.mysql.com/doc/en/Multiple_Windows_services.html It sounds like MySQL uses the service name to determine the section of the my.cnf file to pull its settings from. The service name can be set when using the --install option. Follow the second like for an example my.cnf file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: my.ini file for two instances of MySql - need help
Ok, Thanks Tobias! I'm all set. And I actually found the relevant info in the manual. Sorry for the bother, all. From: Tobias Asplund [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: 'Rich Brant' [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySql - need help Date: Mon, 12 Jan 2004 18:28:50 +0100 (CET) Hello, What do I need to add to the my.ini file? Can anyone post a typical setup of this as an example? I install with mysqld-nt-max --install servicename servicename in those cases are MysQL40, MySQL41 and MySQL50 Those are the relevant rows: [mysqld] [mysql40] basedir = C:/mysql/4.0-tree/ datadir = C:/mysql/4.0-tree/data port= 3307 [mysql41] basedir = C:/mysql/4.1-tree datadir = C:/mysql/4.1-tree/data port= 3308 [mysql50] basedir = C:/mysql/5.0-tree datadir = C:/mysql/5.0-tree/data port= 3309 cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Rethink your business approach for the new year with the helpful tips here. http://special.msn.com/bcentral/prep04.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Running two instances from one my.ini?
Hello, I have mysqld-max (3.23.51) running on a Windows 2000 machine. Is it possible to run another MySQL server alongside it, using the same my.ini file but set on a different port, e.g. with mysqld-max --standalone --console --port=3307 The reason I want to do this is to check changes to the my.ini file (adding binary logging) before I shutdown and restart the main MySQL server; I'd rather know it's going to work, than have to shut down and restart the main server multiple times if there are problems. I've tried this with a server on my localhost (it seems to work fine), but don't this is obviously running under different conditions, and the process might not be so smooth on a large, running server. Could you Cc any replies to [EMAIL PROTECTED], as our mail filter has prevented me from subscribing to this very useful list! Thanks in advance. Elliot Smith -- Web Development Engineer Corporate Web Team Information Services University of Birmingham email: [EMAIL PROTECTED] telephone: 0121 414 7108 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: setting up two instances of mySQL
Hi Chris, I am Tom, you know your manager, did you say that I am wrong!!! Just kidding :-). Well I cannot find any good reason for having two databases in two different instance. Do you have two Oracles or Microsoft SQL Server instances in the computer? Nope. The only reason when that is acceptable, is when you want to keep two version of the same database engine. Like having 3.23 and 4.0. Having two MySQL instances is going to complicate things making everything more difficult to maintain and install. Good Luck. --- Cal Evans [EMAIL PROTECTED] wrote: The pros are you can run them under separate user/group ids therefore you can make it much harder for someone with access to only one to get to the other's data. The cons are that you will have 2 copies running therefore it will take longer to maintain. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Chris Stefanick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 7:56 AM To: MySQL Support Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't see the point. Why not just have both databases running under the same instance of mySQL? Which brings me to my question. What are the pros and cons of setting up multiple instances of mySQL on the same machine? Thanks so much, CS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setting up two instances of mySQL
Hi, I don't want to get in the way, but I am experiencing similar issues. Here's the problem I'm trying to find a resolution to: We have one instance of MySQL (it was configured and installed once). This instance has one 'test' 'database', and one 'mysql' 'database'. The mysql database contains the grant tables. I want to create a few other 'databases'. One should be used for keeping recipies, for instance, and the other will contain the data I use for the electronic key card system I use in my house (for instance). Both databases run under the same 'instance'. The recipe database is updated frequently, because I am active in a cook's collective and we routinely update each other's recipies as we develop more refined ways of making the dishes. The key card database is not updated frequently, but is heavily accessed by several custom-made hardware devices. One day, a bug in the network protocol I use to connect the card swipe device to the database causes some of the data in the database to become corrupted in the key card database. This happens as I get home late at night after bar hopping, and I don't discover it until noon. The corruption involves data that was deleted, so I need to restore that database to just before midnight, using the full backup I wisely took at 8PM before going out to the bars, in conjunction with the update log which I have on a RAID5 device for protection. The problem is, that if I restore the database from the last cold backup, then apply the update log until midnight, I will lose all transactions that occurred against the recipe database between midnight and noon the next day! Oracle and SQL Server allow you to restore databases independently of one another. I cannot discern the method to do so in MySQL. Surely this is a common requirement? Is there an easy answer I have overlooked during my evaluation of the restore options? By the way, the above scenario assumes MyISAM table types. I understand from other postings that InnoDB can restrict the options even further. The obvious solution seems to be separate MySQL 'instances' for each database you want, so that the transaction logs are kept distinct from one another. If this is the preferred solution, I would be interested to hear how some production environments have been set up. Thanks! Josh Horton Francisco Reinaldo wrote: Hi Chris, I am Tom, you know your manager, did you say that I am wrong!!! Just kidding :-). Well I cannot find any good reason for having two databases in two different instance. Do you have two Oracles or Microsoft SQL Server instances in the computer? Nope. The only reason when that is acceptable, is when you want to keep two version of the same database engine. Like having 3.23 and 4.0. Having two MySQL instances is going to complicate things making everything more difficult to maintain and install. Good Luck. --- Cal Evans [EMAIL PROTECTED] wrote: The pros are you can run them under separate user/group ids therefore you can make it much harder for someone with access to only one to get to the other's data. The cons are that you will have 2 copies running therefore it will take longer to maintain. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Chris Stefanick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 7:56 AM To: MySQL Support Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't see the point. Why not just have both databases running under the same instance of mySQL? Which brings me to my question. What are the pros and cons of setting up multiple instances of mySQL on the same machine? Thanks so much, CS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA
RE: setting up two instances of mySQL
As Cal stated, there is actually a very important reason. MySQL is lacking in fine-grained security. I can give a user the ability to add databases. But can I give that user the ability to only drop databases he/she created? I sure haven't found any documented method. So, if you're in a large organization, and you don't have a certain level of trust between the groups within that organization, each group will need it's own instance of MySQL. Those instances could be on sererate physical machines (2 database servers), but sometimes that's not feasible (budget constraints, whatever). Now, CS's orginal question... it should be possible just to dump and load the tables from the vendor provided copy of mysql into your existing instance. You'll need to check version numbers though (if the vendor product isn't using a recent MySQL, you're probably SOL and will have to go with 2 instances). Mark R. Andrachek, Jr. Analyst I Federal Reserve Bank of Richmond [EMAIL PROTECTED] (804) 697-7971 Francisco Reinaldo [EMAIL PROTECTED] 06/13/2002 10:44 AM To: [EMAIL PROTECTED], Chris Stefanick [EMAIL PROTECTED], MySQL Support [EMAIL PROTECTED] cc: Subject:RE: setting up two instances of mySQL Hi Chris, I am Tom, you know your manager, did you say that I am wrong!!! Just kidding :-). Well I cannot find any good reason for having two databases in two different instance. Do you have two Oracles or Microsoft SQL Server instances in the computer? Nope. The only reason when that is acceptable, is when you want to keep two version of the same database engine. Like having 3.23 and 4.0. Having two MySQL instances is going to complicate things making everything more difficult to maintain and install. Good Luck. --- Cal Evans [EMAIL PROTECTED] wrote: The pros are you can run them under separate user/group ids therefore you can make it much harder for someone with access to only one to get to the other's data. The cons are that you will have 2 copies running therefore it will take longer to maintain. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Chris Stefanick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 7:56 AM To: MySQL Support Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't see the point. Why not just have both databases running under the same instance of mySQL? Which brings me to my question. What are the pros and cons of setting up multiple instances of mySQL on the same machine? Thanks so much, CS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
setting up two instances of mySQL
I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't see the point. Why not just have both databases running under the same instance of mySQL? Which brings me to my question. What are the pros and cons of setting up multiple instances of mySQL on the same machine? Thanks so much, CS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: setting up two instances of mySQL
The pros are you can run them under separate user/group ids therefore you can make it much harder for someone with access to only one to get to the other's data. The cons are that you will have 2 copies running therefore it will take longer to maintain. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Chris Stefanick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 7:56 AM To: MySQL Support Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't see the point. Why not just have both databases running under the same instance of mySQL? Which brings me to my question. What are the pros and cons of setting up multiple instances of mySQL on the same machine? Thanks so much, CS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setting up two instances of mySQL
Chris, Wednesday, June 05, 2002, 3:55:52 PM, you wrote: CS I have one product already using a mySQL database. We just inherited a new CS product (via an acquisition) that uses it's own mySQL database which we're CS going to stick on the same server. My manager wants me to setup a second CS instance of mySQL on the machine for the new product's database. I don't CS see the point. Why not just have both databases running under the same CS instance of mySQL? Which brings me to my question. What are the pros and CS cons of setting up multiple instances of mySQL on the same machine? In general you can't use more than one data dir for one MySQL server, but you can create another dir for your database and create a symlinks to this dir. CS Thanks so much, CS CS -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setting up two instances of mySQL
- Original Message - From: Chris Stefanick [EMAIL PROTECTED] To: MySQL Support [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 2:55 PM Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't see the point. Why not just have both databases running under the same instance of mySQL? Which brings me to my question. What are the pros and cons of setting up multiple instances of mySQL on the same machine? I read the reply about the ability to run under two different users. True. Plus the advantage would be that both administrators of the two products can each have full root-access to their MySQL server. That, to me, would be the main pro. But I cannot help but feel this is like running a separate instance of qpopper for each individual mailbox. It will shave an additional ~ 13-30 MB off your resources, and if you only take a few moments to set up the privilege system properly (removing anonymous users, making sure all users have passwords, etc), there should really be no concern for security. And be careful who you give the file privilege to. Most security holes really stem from an improper grasp of the privilege system. Like forgetting to specifically revoke privileges for a table when you delete that table, and not realizing the alter privilege may be used to subvert the privilege system by renaming tables, etc. But if you took care of those, I truly see no real security issue. Plus, if you start your server with the --safe-show-database option, SHOW DATABASES will only return those databases for which the user has some kind of privilege. More experienced users may be aware of nifty security holes that I am unaware of; but under normal circumstances, my preference is to not run a separate instance for each separate database. YMMV, as they say. - Mark System Administrator Asarian-host.org --- If you were supposed to understand it, we wouldn't call it code. - FedEx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php