블로그 " 공감 " : : ' MySQL ' 태그 의 글 목록 
 Total 293 , 883 
 ' MySQL ' 에 해당 되 는 글 5 건 
 2011 . 08 . 26 [ SSIS ] MySQL Data Transfer using Sql Server Integration Services ( SSIS ) 
 2010 . 09 . 29 MySQL Clustering Config 
 2010 . 09 . 29 MySQL Clustering on Ubuntu 
 2011 . 8 . 26 . 14 : 23 Brain Trainning / DataBase 
 [ SSIS ] MySQL Data Transfer using Sql Server Integration Services ( SSIS ) 
 SSIS 에서 MySQL 을 연결 해서 데이터 를 전송 하 면 몇 가지 문제 가 발생 합니다 . 
 그 중 하나 는 syntax 에러 . . 
 그리고 , shared memory error 인데 
 1 번 은 아래 와 같이 
 요렇게 해결 하 면 되 고 
 2 번 의 Shared memory error 의 경우 는 
 2008 의 경우 SP 2 이상 
 2008 R 2 의 경우 는 SP 1 이상 으로 Update 해 주 면 해결 됩니다 . 
 아래 는 원문 으로 참고 할 만 한 내용 입니다 . 
 by Jayaram Krishnaswamy | September 2009 | Microsoft PHP 
 There are a large number of posts on various difficulties experienced while transferring data from MySQL using Microsoft SQL Server Integration Services . While the transfer of data from MySQL to Microsoft SQL Server 2008 is not fraught with any blocking issues , transfer of data from SQL Server 2008 to MySQL has presented various problems . There are some workarounds suggested . In this article by Dr . Jay Krishnaswamy , data transfer to MySQL using SQL Server Integration Services will be described . 
 An ideal book and eBook for trainers who want to teach an introductory course in SQL Server Integration Services or , to those who want to study and learn SSIS in a little over two weeks . 
 Click on the Odbc Data Provider . As mentioned previously we will be using the System DSN MySQL _ Linkcreated earlier for the other article shown in the drop - down list of available ODBC DSN ' s . 
 CREATE TABLE From 2 k 8 ( 
 " Month " VARCHAR ( 10 ) , 
 " Temperature " DOUBLE PRECISION , 
 " RecordHigh " DOUBLE PRECISION 
 Click OK . Again you get the same error regarding syntax not being correct . Modify the Create Tablestatement further as shown . 
 CREATE TABLE From 2 k 8 ( 
 RecordHigh DOUBLE PRECISION 
 Click OK after the above modification . The table gets added to the ADO . NET Destination Manager Editor as shown . 
 [ SSIS . Pipeline ] Information : Execute phase is beginning . 
 [ ADO NET Destination 1 [ 165 ] ] Error : An exception has occurred during data insertion , 
 the message returned from the provider is : ERROR [ 42000 ] [ MySQL ] [ ODBC 5 . 1 Driver ] 
 corresponds to your MySQL server version for the right syntax to use near '" Id ", 
 " Month ", " Temperature ", " RecordHigh ") VALUES ( 1 , ' Jan ', 4 . 000000000 ' at line 1 
 [ SSIS . Pipeline ] Error : SSIS Error Code DTS _ E _ PROCESSINPUTFAILED . The ProcessInput 
 method on component " ADO NET Destination 1 " ( 165 ) failed with error code 0 xC 020844 B 
 while processing input " ADO NET Destination Input " ( 168 ) . The identified component 
 returned an error from the ProcessInput method . The error is specific to the component , 
 but the error is fatal and will cause the Data Flow task to stop running . There may 
 [ SSIS . Pipeline ] Information : Post Execute phase is beginning . 
 Start the MySQL Server and login to it . Run the following commands as shown in the next figure . By setting the mode to ' ANSI ' makes the syntax more standard like as MySQL can cater to clients using other SQL modes . This is why the above error is returned although the syntax itself appears correct . In fact a create statement run on command line to create a table directly on MySQL could not create a table and returned an error when SSIS was used to create the same table . 
 [ MSSQL ] DBCC MEMORYSTATUS ( 0 ) 
 [ SSIS ] Writing to a MySQL database from SSIS ( 0 ) 
 [ SSIS ] MySQL Data Transfer using Sql Server Integration Services ( SSIS ) ( 0 ) 
 [ MSSQL ] SQL Server 2008 R 2 SP 1 ( Service Pack 1 ) ( 0 ) 
 [ MSSQL ] How to troubleshoot the " Cannot generate SSPI context " error message ( 0 ) 
 [ SSIS ] Integration Services Data Types 참고 자료 . . ( 0 ) 
 TAG MySQL , ssis 
 2010 . 9 . 29 . 11 : 09 Brain Trainning / DataBase 
 MySQL Clustering Config 
 Filed under : Uncategorized | Tags : cluster , Clustering , MySQL | 
 I ’ ve had two positive comments to my previous post so I figured it was time to write an update regarding how my work has been going . 
 The MySQL clustered database is part of a large project I ’ ve been working on for the last 2 months . The basic server setup is two clustered JBoss 4 . 2 . 3 Application Servers running on top of two clustered MySQL 5 . 0 . 67 servers . There is a 3 rd Server which is a backup which currently only runs the MySQL manager ment console . I ’ ve noticed that even if there is high load on the 2 NDB data nodes , the Management console does not do much . 
 The four main servers run 2 Dual - Core AMD Opteron ( tm ) Processors with 8 gig of ram . 
 Even though alot of my work has been to rework my own code in order to optimize and improve it , alot of time has been spent looking for a configuration for the MySQL cluster that would cope with the load as I found that it was quite easy to kill the cluster in the beginning . 
 The config I am currently using is below and following are some results of the load testing I ’ ve been doing . 
 # Avoid using the swap 
 # ( 2 * DataMemory ) / 64 MB which is the LogFileSize for 5 . 0 
 # RedoBuffer of 32 M . If you get " out of redobuffer " then you can increase it but it 
 # more likely a result of slow disks . 
 # The default of 1200 was too low for initial tests . But the code has been improved alot 
 # so 12000 may be too high now . 
 Here are some numbers of what I ’ ve been able to get out of the MySQL cluster . One iteration of my code results in : 
 This might sound like a lot , but it is a service oriented application that relies on persistent JBoss queues and demands 100 % redundancy so even if the server dies , it will pickup where it died and does not loose any data . 
 My first benchmark was 10 000 iterations which is the current load I can expect on the application over the course of an hour i . e . 
 12 000 selects 
 10 000 inserts 
 10 000 updates 
 4 000 deletes 
 This took a total of 93 seconds producing just over 100 iterations per second . 
 The second test to really put the application and environment to the test was to run 100 000 iterations . This test completed in roughly 15 minutes producing around 110 iterations per second . This is about 10 x the load we ’ d expect to see during the course of one hour but it is nice to see the setup has the ability to grow quite a bit before we need more hardware . 
 I am currently working on setting up a third test which will run 100 000 iterations every hour for 10 hours producing 1 millions rows of data . 
 · I ’ m half way to being MySQL certified 
 · Oracle buying Sun , therefore adquiring MySQL ! !!!! 
 · Tips & Tricks from MySQL Experts 
 출처 : http : / / bieg . wordpress . com / 2008 / 10 / 06 / mysql - clustering - config / 
 TAG Cluster , Configuration , MySQL , ubuntu 
 2010 . 9 . 29 . 10 : 56 Brain Trainning / DataBase 
 MySQL Clustering on Ubuntu 
 Filed under : Clustering , MySQL , Uncategorized | 
 I spent some time getting MySQL clustering working with Ubuntu after reading a guide on Howto Forge . The guide however went into the details of compiling and installing MySQL from source so I ’ m creating this to show the steps needed to get it set up on a fresh Ubuntu installation . 
 For a correct setup you will need 3 machines . The first machine will serve as the management node , and the other two will be storage nodes . 
 At the time of writing , the current stable version of Ubuntu is 8 . 04 . 1 and the MySQL version that is installed is 5 . 0 . 51 
 During the configuration I log onto the machines and use the command 
 to gain permanent root access and saving myself from having to type sudo in front of every command . Use your own discretion . 
 Using apt this is straight forward . Just type the following command on all three machines to install MySQL server . 
 Once asked to , set the root password to the MySQL database . You ’ ll need to remember this one . Once MySQL server is installed we ’ ll proceed to configure the management node . 
 Create and edit the file / etc / mysql / ndb _ mgmd . cnf . Copy and paste the text bellow changing the ip addresses to match your setup as necessary . 
 Configuring the Storage Nodes 
 As you can see in the file we created in the previous step , the cluster will be using / var / lib / mysql - cluster on the storage machines . This path is created when you install MySQL server but they are owned by root . We want to create the backup directory and change ownership to mysql . 
 Now we ’ ll need to edit the MySQL configuration so that the storage nodes will communicate with the Management Node . 
 Search for [ mysqld ] and add the following . 
 Then scroll down to the bottom until you see [ MYSQL _ CLUSTER ] . Uncomment the line and edit so it looks like 
 The reason the connect string it found twice in the mysql file is because one is used by mysql server , and the other is used by the ndb data node app . Save the changes to the file . 
 Make sure you complete the changes on both data nodes . 
 Start the Management Node using 
 As you can see the management node is waiting for connections from the data nodes . 
 Start the Data Nodes 
 On the data nodes , issue the commands 
 Once they have started properly , the show command should display 
 Congratulations , your cluster is now setup . 
 Issue the following on both data nodes to create the test database . Since clustering is done on a table basis in MySQL we have to create the database manually on both data nodes . 
 Once this i done , on ONE of the data nodes , create a test table and add an entry . 
 | Tables _ in _ clustertest | 
 As you can see , the cluster is working . 
 Moving an existing database to the cluster 
 Now that we have the cluster working , we can easily change an existing database to be clustered . All you need to do is run the following command on each of the tables . 
 The table , and all it ’ s data will be copied to the datanodes and you can now access / change then through any nodes in the cluster . Very simple . 
 · How to fix forgotten MySql passwords in Ubuntu 
 · How to set or reset password mysql on Ubuntu 
 · Ebooks on MySQL 
 출처 : http : / / bieg . wordpress . com / 2008 / 08 / 03 / mysql - clustering - ubuntu / 
 TAG Cluster , MySQL , ubuntu , 우분투