Re: Master-master replication configuration...how?
Hi Craig and others, On Fri, Mar 27, 2009 at 4:16 PM, Craig Dunn li...@codenation.net wrote: blue.trapez...@gmail.com wrote: Hi I have 2 servers and I am trying to set up (for testing purposes) a master-master replication environment. I read the instructions in the manual for master-slave, but am not able to find any information on how to set up a master-master system. Can someone on this list point me to any documentation on this topic? What you are probably trying to achieve is bi-directional replication (arguably different from multi master but as close as you can get) - take a look at auto_increment_increment and auto_increment_offset, the idea is that all your primary keys use auto_increment integers and one master will be offset from the other (ie: server A uses 1,3,5,7,9...etc and server B uses 2,4,6,8...etc) so they never clash I am new to replication so please bear with me. What is the difference between 'multi-master'/'dual-master' and 'bi-directional replication'? I was under the impression they meant the same thing... Thanks.
RAID-10 perf numbers
Does anybody have any RAID-10 sysbench fileio numbers for random writes with any number of disks(4/6/8/12...) to compare with write cache(512,256,...) backed by BBU.. I really appreciate your nos.. or whats the decent requests/sec for pure rndwrs ?
MySQL University session on April 2: How to Create a Test Case
How to Create a Test Case http://forge.mysql.com/wiki/How_to_Create_a_Test_Case This Thursday (April 2nd, 14:00 UTC), Patrick Crews will give a MySQL University session on How to Create a Test Case. This is an updated session of a talk we had in 2007, but this time it will be recorded (slides and audio). Patrick is a database engineer who works in the server QA department, so test cases are his daily bread. For MySQL University sessions, point your browser to this page: http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session. Here's the schedule for the upcoming weeks: * April 2, 2009: How to Create a Test Case (updated session from 2007) (Patrick Crews) * April 9, 2009: No MySQL University session scheduled (due to upcoming Easter vacation in Europe) * April 16, 2009 (tentative): Going Nuts - How to write MySQL test cases in Perl (Luis Soares, Alfranio Correia, Serge Kozlov, Lars Thalmann) * April 23, 2009: No MySQL University session during MySQL Conference Expo 2009 * April 30, 2009: Testing Multiple Servers With MySQL Sandbox (Giuseppe Maxia) * May 7, 2009: MySQL Replication: Walk-through of the new 5.1 and 6.0 features (Lars Thalmann) * May 14, 2009: Programming Towards Multi-Core CPUs (Mikael Ronström) * May 21, 2009: No session scheduled * May 28, 2009: No session scheduled * May 28, 2009: Architecture of MySQL Backup (Lars Thalmann) * June 4, 2009: Boosting Performance With MySQL 5.1 Partitioning (Giuseppe Maxia) * June 11, 2009: Building MySQL Releases on Unix (Jörg Brühe) * June 18, 2009: Architecture of MySQL Backup (Lars Thalmann) * July 2 (tentative): Starring Sakila - a data warehouse mini-tutorial (Roland Bouman) The schedule is not engraved in stone at this point. Please visit http://forge.mysql.com/wiki/MySQL_University#Upcoming_Sessions for the up-to-date list. On that page, you can also find the starting time for many time zones. Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: stefan.h...@sun.com Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
SSL Connections
Hi, I'm trying to make connections ssl. I followed the MySQL guide and I've configured the server then I created a normal user, without the REQUIRE SSL. On the same server can connect with the only option: mysql --ssl-ca=cacert.pem -u Pluto -p but if I try to connect from another host, I must, forcibly, also specify the options: --ssl-cert=client-cert.pem --ssl-key=client-key.pem Why ?? The guide says that even from another host, on a normal user, you can use the only option: --ssl-ca but it is not, I am forced to certify the client. Something wrong? Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: dynamically splitting a table through one full table scan
Hi Kabel Yes, I did, it won't do the job for us. I didn't explain the whole usecase: we are dealing with a 50-billion row table which we want to split into 1-million-row tables, and then dynamically break each of these into smaller pieces in order to speed up n^2 near-neighbor joins. If we partition the 1 million row table from the very beginning, we will end up with unmanageable number of tables/files. thanks, Jacek Have you looked into MySQL partitioning? If you're using version 5.1, it might really help.. just partition the big table on chunk ID. http://dev.mysql.com/doc/refman/5.1/en/partitioning.html kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: SSL Connections
Hi Stefano, I'm guessing your remote (non-local) server is using a different user account than your local server. r...@localhost r...@% r...@somehost.com are all different users. If your remote host, or wildhost user account has the REQUIRE X509 flag (user must be certified) but your local one doesn't, that would explain it. What are your MySQL versions on both your server and remote client? What errors do you get on your client? Regards, Andy Stefano Elmopi wrote: Hi, I'm trying to make connections ssl. I followed the MySQL guide and I've configured the server then I created a normal user, without the REQUIRE SSL. On the same server can connect with the only option: mysql --ssl-ca=cacert.pem -u Pluto -p but if I try to connect from another host, I must, forcibly, also specify the options: --ssl-cert=client-cert.pem --ssl-key=client-key.pem Why ?? The guide says that even from another host, on a normal user, you can use the only option: --ssl-ca but it is not, I am forced to certify the client. Something wrong? Thanks Ing. Stefano Elmopi Gruppo Darco - Area ICT Sistemi Via Ostiense 131/L Corpo B, 00154 Roma cell. 3466147165 tel. 0657060500 email:stefano.elm...@sociale.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Data structure for matching for company data
Thanks, PB. I found that I cannot use FK for Myisam tables. Then, this kind of data structuring is no use at all for Mysiam tables. Is this correct? Date: Fri, 27 Mar 2009 09:54:47 -0500 From: peter.braw...@earthlink.net To: saeho...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: Data structure for matching for company data Choi 1. company (3 cols) - company id(pk), company name 2. industry (3 cols) - industry id(pk), industry, sub-industry 3. matching table (3 cols?) - match id(pk), company id(fk), industry id(fk)...? Yes, you've got it. In the matching (usually called bridging) table, any company or industry can appear multiple times, but no combo can appear more than once. PB http://www.artfulsoftware.com - ChoiSaehoon wrote: I'm a complete newbie, so please feel free to help me here! I simplified my problem as below: 1. Thousands of companies (i.e. company names) 2. 200 industries. Each company has tree-type(?) industry info. (Industry, Sub-industry. Say, each industry has 10 sub-industry information. (10X20)) The problem is one company can have 1,2,3... or 15 industries and/or sub-industries... (as in a real-life case) What would be a smart way create tables for this situation? (both company and industry must be searchable) (One rough thought (after having studying MySQL for 2 weeks now) is create 3 tables of 1. company (3 cols) - company id(pk), company name 2. industry (3 cols) - industry id(pk), industry, sub-industry 3. matching table (3 cols?) - match id(pk), company id(fk), industry id(fk)...? But, one company can have more than 1 industry info! Ah... Then, if that's the case, different match id same company id different industry id??) I'm stuck here! :( Any general advice would be appreciated... :) _ ???, ?? ??? Windows Live Hotmail! ?? ???! http://www.hotmail.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.11.30/2026 - Release Date: 03/27/09 07:13:00 _ MSN 메신저의 차세대 버전, Windows Live Messenger! http://windowslive.msn.co.kr/wlm/messenger/
RE: Data structure for matching for company data
Thanks for the resource! Arthur. SIC seems to be great for most industries, but not for high-tech industries. (e.g. it doesn't have Internet or software etc) Still a great tip, though. Thanks again! :) Date: Fri, 27 Mar 2009 19:13:51 -0500 Subject: Re: Data structure for matching for company data From: fuller.art...@gmail.com To: peter.braw...@earthlink.net CC: saeho...@hotmail.com; mysql@lists.mysql.com My esteemed friend, partner and co-author has laid it out perfectly for you. Just follow the instructions table-wise. One thing that may not be obvious from Peter's prescription is that you need to enter a bunch of rows into the industry table first, so that the foreign keys will make sense in the bridge table. But presumably this is not onerous. Over here we commonly use a table called SIC (standard industry codes) that has sub-industries etc. Whenever possible I try to use such standards rather than make up a new one. For example, there is the ISO country codes standard, which provides unique two and three letter codes for every country. Yes, thanks to politics, envy, revenge instinct etc. such country codes from time to time require updating, but I choose to stick with the ISO standards rather than rely on my self-invented one and all attendant hassles whenever a country commits seppukku. You might consider looking into the SIC code scheme before bothering to invent your own. You can download this from a number of sources and in a number of formats. Just Google SIC and you should get there. Hope this helps, Arthur _ 강력해진 보안성, 아웃룩을 닮아 편리해진 기능들로 무장한 Windows Live Hotmail! 지금 로그인해 보세요! http://www.hotmail.com
ATTN: OWNER/MODERATOR
Chuck Crayne (ccra...@crayne.org) has died. I am his widow. I cannot unsubscribe him from this list because I do not have his user name and password. Please remove him from your membership list. If you need to talk to me about this, my phone number is (707) 459-2623. Thank you very much!! -- -- Dian Crayne Willits, California * dcra...@crayne.org http://www.pacificsites.com/~ccrayne/dian.html * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ATTN: OWNER/MODERATOR
On Mon, Mar 30, 2009 at 19:45, Dian Crayne dcra...@crayne.org wrote: Chuck Crayne (ccra...@crayne.org) has died. I am his widow. I cannot unsubscribe him from this list because I do not have his user name and password. Please remove him from your membership list. If you need to talk to me about this, my phone number is (707) 459-2623. Dian, I'm truly, genuinely sorry for your loss. I read of Chuck's unsubscription from this world in February. He seemed like a brilliant and intriguing man. I'm sorry that I never had the chance to meet him. I've tried to help you out a bit by initiating an unsubscribe request from the list. In his inbox you should've received, a few moments ago, an email with instructions on how to complete the unsubscription. It also reminds me to download some of the software he wrote years ago onto my Linux machine. He had converted some old, old text-based adventure games from the original 5 1/4 floppy disks to hard drive images, and made them cross-platform compatible, among other things. And anyone who would go out of their way still, in this day and age, to go through Assembly code as a hobby truly deserves to be remembered. -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ 50% Off All Shared Hosting Plans at PilotPig: Use Coupon DOW1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Data structure for matching for company data
Choi, I found that I cannot use FK for Myisam tables. Then, this kind of data structuring is no use at all for Mysiam tables. Is this correct? You can use this structure with MyISAM tables. It will work fine except you won't have the advantage of database-level enforcement of foreign key constraints--do it with code. PB ChoiSaehoon wrote: Thanks, PB. Date: Fri, 27 Mar 2009 09:54:47 -0500 From: peter.braw...@earthlink.net To: saeho...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: Data structure for matching for company data Choi 1. company (3 cols) - company id(pk), company name 2. industry (3 cols) - industry id(pk), industry, sub-industry 3. matching table (3 cols?) - match id(pk), company id(fk), industry id(fk)...? Yes, you've got it. In the matching (usually called bridging) table, any company or industry can appear multiple times, but no combo can appear more than once. PB http://www.artfulsoftware.com - ChoiSaehoon wrote: I'm a complete newbie, so please feel free to help me here! I simplified my problem as below: 1. Thousands of companies (i.e. company names) 2. 200 industries. Each company has tree-type(?) industry info. (Industry, Sub-industry. Say, each industry has 10 sub-industry information. (10X20)) The problem is one company can have 1,2,3... or 15 industries and/or sub-industries... (as in a real-life case) What would be a smart way create tables for this situation? (both company and industry must be searchable) (One rough thought (after having studying MySQL for 2 weeks now) is create 3 tables of 1. company (3 cols) - company id(pk), company name 2. industry (3 cols) - industry id(pk), industry, sub-industry 3. matching table (3 cols?) - match id(pk), company id(fk), industry id(fk)...? But, one company can have more than 1 industry info! Ah... Then, if that's the case, different match id same company id different industry id??) I'm stuck here! :( Any general advice would be appreciated... :) _ ???, ?? ??? Windows Live Hotmail! ?? ???! http://www.hotmail.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.11.30/2026 - Release Date: 03/27/09 07:13:00 _ MSN ??? ??, Windows Live Messenger! http://windowslive.msn.co.kr/wlm/messenger/ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.11.32/2030 - Release Date: 03/30/09 08:40:00
Re: IN vs. OR on performance
On Sun, Mar 29, 2009 at 10:19 AM, Claudio Nanni claudio.na...@gmail.com wrote: An explain of the two statements yields the same plan, anybody knows if they are actually translated in the same plan? There is a difference. The IN list is sorted so lookups can be done as a binary search. A bunch of OR's just evaluates each condition one at a time until one matches. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Question!
Dear sir, I am young web developer using PHP Script in designing interactive website. I desire to include Mysql database on my websites. Please, how do I import, upload/export Mysql database to a website server after creating a Mysql user account and a particular database on my local machine? I will be very grateful if comprehensive response is granted to my question. Thank You. Efe Jarikre Nigeria
