RE: Converting Mysql to mysql cluster
> -Original Message- > From: Kevin Peterson [mailto:qh.res...@gmail.com] > Sent: 27 March 2013 06:58 > To: mysql@lists.mysql.com > Subject: Converting Mysql to mysql cluster > > Hi, > > My site is using mysql and PHP, now for the scale purpose want to > introduce mysql-cluster. Few questions are - 1. Do I need to change > any code which is written in PHP. The answer is "yes and no". There's a good chance that your application will work fine with MySQL Cluster without any changes *but* there are a few gotchas such as: - the current GA version of MySQL Cluster (7.2) doesn't implement Foreign Keys (coming in Cluster 7.3) - (ignoring BLOBs) rows cannot be larger than 13 Kb - no geo-spatial indexes - no full-text search A good place to get more information is http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/ . That guide also gives you some advice on scenarios where you *shouldn't* use MySQL Cluster. In addition, as you should expect, to get the best performance out of MySQL Cluster you may want to tweak your schema and/or application - you can get lots of tips from http://www.mysql.com/why-mysql/white-papers/guide-to-optimizing-performance-of-the-mysql-cluster/ > 2. What are the steps to convert mysql to mysql-cluster. Basically, you need to backup your database (mysqldump), load it into a MySQL Server that's part of your Cluster (use http://www.clusterdb.com/mysql-cluster/auto-installer-labs-release/) to get your first Cluster up and running and then issue ALTER TABLE ENGINE=ndb; > > Appreciate the help. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Show ROUTINE body, not PROCEDURE
2013/03/27 08:01 +0200, Dotan Cohen Actually, it is the user that I am logged in as that created the function. That is why I find it hard to believe that one needs root / admin access to see its definition. And that user set DEFINER other than itself, and that worked??? That takes SUPER. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MOSSCon in Louisville in May! Submit your proposal this week!
You are invited to be a speaker/presenter at MOSSCon. Preparations are in full swing for the very first Midwest Open Source Software Conference (MOSSCon), to be held in Louisville on May 18-19. Your help in spreading the word and helping us fill out our schedule of presentations and workshops would be appreciated. This is going to be a great networking event for the whole region! Louisville is in such a central location, it can draw from a very wide area. We have a great venue: the University of Louisville's Student Activities Center, with several large halls, a number of smaller meeting rooms, and plenty of exhibit space available for groups and businesses to make their presence known. We are working on a broadly based "Open" theme, that can include open source hardware, open data, etc., as well as the full gamut of open source software. We already have some super presentations lined up. But there are still plenty of pieces that need to come together. Right now we are concentrating on filling out our schedule with more presentations and workshops. And soliciting sponsors. If you're involved with Open Source (or open anything) you definitely want to be a part of this. I encourage you to consider speaking or doing a presentation or workshop on a subject in your area of interest and/or expertise. Check out the conference website at http://mosscon.org/. Click on "Be a Speaker" for details on submitting your proposal. But get to it! The deadline for submitting your preliminary proposal is this Friday, March 29! http://mosscon.org/ Spread the word and submit your proposal! Thanks, John Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
*.index files in MySQL Data directory
What are the *.index files in the MySQL Data directory? I notice a new one is created every time that MySQL is stopped and restarted. My Data directory is not in the default location so does that have anything to do with it? Thanks, Sandra Arnold Data Warehouse Administrator MartinFederal Consulting Consultant to Oak Ridge National Laboratories Computational Data Analytics Group Data Architectures Team Building 5100, M/S 6173 OAK RIDGE TN 37831-6173 (865)241-1530
Re: *.index files in MySQL Data directory
Am 27.03.2013 19:53, schrieb Arnold: > What are the *.index files in the MySQL Data directory? I notice a new one > is created every time that MySQL is stopped and restarted. My Data directory > is not in the default location so does that have anything to do with it? maybe a "ls -lha" of a sample would be nice never seen one of them from MySQL 3.x to 5.5 nor with MariaDB, indexes are .MYI signature.asc Description: OpenPGP digital signature
RE: *.index files in MySQL Data directory
There are files beginning with 1.. The sequence number is 01 to 15. A new file is created every time MySQL is restarted. The 1.index file contains a list of these files. One thing that I have done is when I was hardening the security we stopped MySQL and moved the data directory to a directory called /var/lib/db/mysql. I changed the datadir variable in the my.cnf file to point to this directory. This was to be sure that our data directory was not on the same partition as our SYSTEM or the Log partitions. Everything is working fine except I have the files mentioned above. Thanks, Sandra Arnold Data Warehouse Administrator MartinFederal Consulting Consultant to Oak Ridge National Laboratories Computational Data Analytics Group Data Architectures Team -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Wednesday, March 27, 2013 3:14 PM To: mysql@lists.mysql.com Subject: Re: *.index files in MySQL Data directory Am 27.03.2013 19:53, schrieb Arnold: > What are the *.index files in the MySQL Data directory? I notice a new one > is created every time that MySQL is stopped and restarted. My Data directory > is not in the default location so does that have anything to do with it? maybe a "ls -lha" of a sample would be nice never seen one of them from MySQL 3.x to 5.5 nor with MariaDB, indexes are .MYI -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: *.index files in MySQL Data directory
sound like files of a replication slave or master and that is why you should post details and folder-listings in the first posting to hep understand waht you are speaking about [root@srv-rhsoft:~]$ ls /data/db/mysql-srv/ | grep bin -rw-rw 1 mysql mysql 12M 2013-03-22 19:44 bin.01 -rw-rw 1 mysql mysql 14M 2013-03-23 13:36 bin.02 -rw-rw 1 mysql mysql 153M 2013-03-27 20:33 bin.03 -rw-rw 1 mysql mysql 102 2013-03-23 13:38 bin.index [root@srv-rhsoft:~]$ cat /data/db/mysql-srv/bin.index /mnt/data/db/mysql-srv/bin.01 /mnt/data/db/mysql-srv/bin.02 /mnt/data/db/mysql-srv/bin.03 [root@srv-rhsoft:~]$ cat /etc/my.cnf | grep bin log-bin = /mnt/data/db/mysql-srv/bin.log log-bin-index = /mnt/data/db/mysql-srv/bin.index Am 27.03.2013 20:25, schrieb Arnold: > There are files beginning with 1.. The sequence number is > 01 to 15. A new file is created every time MySQL is restarted. The > 1.index file contains a list of these files. One thing that I have done is > when I was hardening the security we stopped MySQL and moved the data > directory to a directory called /var/lib/db/mysql. I changed the datadir > variable in the my.cnf file to point to this directory. This was to be sure > that our data directory was not on the same partition as our SYSTEM or the > Log partitions. Everything is working fine except I have the files mentioned > above. > > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Wednesday, March 27, 2013 3:14 PM > To: mysql@lists.mysql.com > Subject: Re: *.index files in MySQL Data directory > > > > Am 27.03.2013 19:53, schrieb Arnold: >> What are the *.index files in the MySQL Data directory? I notice a new one >> is created every time that MySQL is stopped and restarted. My Data >> directory is not in the default location so does that have anything to do >> with it? > > maybe a "ls -lha" of a sample would be nice > > never seen one of them from MySQL 3.x to 5.5 nor with MariaDB, indexes are > .MYI signature.asc Description: OpenPGP digital signature