Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again
Hi, it happend again and I can't fix it, may be someone has a working solution and information on that: I installed the most recent mysql 5.6 community on a server and do get a lot of "errno: 24 - Too many open files". There are suggestions to increase the open_files_limit, change/add that to /etc/security/limits.conf and modify the systemd script by hand. Depending on how you start mysql (restart, or at systemboot time ...) the limit get set or not. Question: Is that may be a known bug or something? the old topic is here: http://grokbase.com/t/centos/centos/154x78377b/mysql-5-6-centos-7-and-errno-24-too-many-open-files Regards . Götz smime.p7s Description: S/MIME Cryptographic Signature
Precautions to not run out of disk space?
Hi, we recently had a software bug who wrote gigs of data to our database in a loop and finally filled the whole system. O.K. we could serverside use a separate partition/storage for the database directory, but I was wondering is mysql has a feature/option to set some sort of "minimum disk free" than stop writing and wait for a sysop to check? Would be nice, as other software can do this already Regards . Götz smime.p7s Description: S/MIME Cryptographic Signature
Best practice migrating mysql 4.1.x - 5.0.x with mixed innodb myisam tables
Hey, happy new year and I do have a question what might be the best way to migrate some different databases to a new central server. The question came up as I wanted to put our web CMS database on our newer master/slave mysql installation. We run red hat el 4 and 5 right now, so the source db is mysql 4.1.22 and the target is 5.0.77. I did a mysqldump (--create-options --default-character-set=utf8 -K -e --opt -q) on the source server and imported that dump on the new system, but all innodb tabels are converted to myisam. In the last time I focused on other topics than mysql, so may be somewone can explain to me or give me a link to some compressed doku on what happend and why?! The other question is, what might be the best way to migrate the 'old' database to a/the new system? This might be importand to, when switching to myslq 5.0 Dose the my.cnf options for innodb have to be identically? Thanks a lot for any hint or suggestion! Best regards . Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH Akademiehof 10 71638 Ludwigsburg www.filmakademie.de Eintragung Amtsgericht Stuttgart HRB 205016 Vorsitzende des Aufsichtsrats: Prof. Dr. Claudia Hübner Geschäftsführer: Prof. Thomas Schadt smime.p7s Description: S/MIME Cryptographic Signature
Re: how to setup replication - MySQL 5.0.x - Migration and new databases
Am 08.06.10 12:05, schrieb Rob Wultsch: On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator goetz.reini...@filmakademie.de wrote: Hi, we do have different LAMP systems and recently I started to put some mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x - 5.0.xx) MySQL 4.X is EOL. I strongly suggest not using it for new projects, if you have the option. If possible, MySQL 5.1 is recommended, Thanks, I'm aware of that. The 4.x servers are old and should be migrated to the recent redhat EL released mysql 5.0.x. I did this by exporting some databases with mysqldump and importing tham on the new server. Now I'd like to add a slave mysqlserver and so I started to read some docs from the web and manuals from addison-wesley but some questions do remain or occur. What is the best way to copy the databases from the master to the slave? I thought that I can shut down the master and copie the database directory to the slave and than go on with the config, restarting the servers, etc. Doing so, do I have to lock any InnoDB tables or anything else? (May be I missunderstand some docs...) Perhaps I am misunderstanding what you are doing, but shutting down the master instance will make it inaccessible until it is restarted. That would be no problem. Please read http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html . That document has the basics right, other than snapshoting. In terms of getting a snapshot, if you have a innodb only instance* (which is good idea), and can stop ddl commands, you can use mysqldump with the master-data and single-transaction flags in order to take a non-blocking dump suitable for replication use. For MyISAM only instances FLUSH TABLES WITH READ LOCK can be used. The easiest way to make a snapshot is to shut down the master instance and make a copy of the data files. When you restart the master make note of which binary log file it starts to write to. *Other than the mysql schema, of course. So far I only copied a few databases from the different servers to the new master. The second big question is: How to add new databases to the master after sucessfully running a master-slave-setup? Will the new database be copied/created on the slave automatically? Or do I have to create tham twice? New databases will be automatically created. Once you have the Master setup with binary logging you can inspect what it will have have the slave execute by using the mysqlbinlog command on the log files or the SHOW EVENT (http://dev.mysql.com/doc/refman/5.1/en/show-events.html) syntax. Thanks for your suggestion. I'll try that. Regards - Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH Akademiehof 10 71638 Ludwigsburg www.filmakademie.de Eintragung Amtsgericht Stuttgart HRB 205016 Vorsitzende des Aufsichtsrats: Prof. Dr. Claudia Hübner Geschäftsführer: Prof. Thomas Schadt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how to setup replication - MySQL 5.0.x - Migration and new databases
Hi, we do have different LAMP systems and recently I started to put some mysql databases on one, new master server. (RedHat, Fredora, MySQL 4.x - 5.0.xx) I did this by exporting some databases with mysqldump and importing tham on the new server. Now I'd like to add a slave mysqlserver and so I started to read some docs from the web and manuals from addison-wesley but some questions do remain or occur. What is the best way to copy the databases from the master to the slave? I thought that I can shut down the master and copie the database directory to the slave and than go on with the config, restarting the servers, etc. Doing so, do I have to lock any InnoDB tables or anything else? (May be I missunderstand some docs...) So far I only copied a few databases from the different servers to the new master. The second big question is: How to add new databases to the master after sucessfully running a master-slave-setup? Will the new database be copied/created on the slave automatically? Or do I have to create tham twice? Thanks for any comments and sugesstions. Best Regards, Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH Akademiehof 10 71638 Ludwigsburg www.filmakademie.de Eintragung Amtsgericht Stuttgart HRB 205016 Vorsitzende des Aufsichtsrats: Prof. Dr. Claudia Hübner Geschäftsführer: Prof. Thomas Schadt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
migrating a 32bit installation to a 64bit host - copy or export/import?
Hi, I plan to migrate a 32 bit MySQL installation to a 64bit host. (mysql-5.0.77) Both servers are RedHat EL 5.4 with the original mysql rpm. The simpel plan was to shut down mysql and than copy the db-files from /var/lib/mysql/ from host to host. Any suggestions? Or comments? Or should I export the dbs and than import tham? Best regards, Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH Akademiehof 10 71638 Ludwigsburg www.filmakademie.de Eintragung Amtsgericht Stuttgart HRB 205016 Vorsitzende des Aufsichtsrats: Prof. Dr. Claudia Hübner Staatsrätin für Demographischen Wandel und für Senioren im Staatsministerium Geschäftsführer: Prof. Thomas Schadt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Virtual servers, Raid 10 or Raid 01 - your opinions?
Hi, I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 GB RAM each. Right now, we do not have a lot of data in our databases (5 small LAMP servers), which should be consolidated. (The second Sun Fire X4170 will be the Webserver-Sun, the DB-Traffic will have his own gbit switch (Webserver-Sun - MySQL-Sun) ) There are more reads than writes. To simplify matters, I'd like to use virtual MySQL-Servers (Master and Slave) on the sun and use one large raid. Also I was thinking, to use one RAID 1 for the virtualisation-system and the other six harddisks for the virtual servers. What RAID would be the better choice? 10 or 01? What do you think? Thanks for any suggestions and best regards, Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH Akademiehof 10 71638 Ludwigsburg www.filmakademie.de Eintragung Amtsgericht Stuttgart HRB 205016 Vorsitzende des Aufsichtsrats: Prof. Dr. Claudia Hübner Staatsrätin für Demographischen Wandel und für Senioren im Staatsministerium Geschäftsführer: Prof. Thomas Schadt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: AW: Virtual servers, Raid 10 or Raid 01 - your opinions?
majk.sko...@eventim.de schrieb: -Ursprüngliche Nachricht- Von: Götz Reinicke - IT-Koordinator [mailto:goetz.reini...@filmakademie.de] Gesendet: Mittwoch, 25. November 2009 12:05 An: mysql@lists.mysql.com Betreff: Virtual servers, Raid 10 or Raid 01 - your opinions? Hi, Hi, I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 GB RAM each. Right now, we do not have a lot of data in our databases (5 small LAMP servers), which should be consolidated. (The second Sun Fire X4170 will be the Webserver-Sun, the DB-Traffic will have his own gbit switch (Webserver-Sun - MySQL-Sun) ) There are more reads than writes. To simplify matters, I'd like to use virtual MySQL-Servers (Master and Slave) on the sun and use one large raid. Putting the question a bit higher for better understanding. What RAID would be the better choice? 10 or 01? Generally RAID 10 is more robust and fault tolerant. Some things depending on the controller if it's smart or not. But rebuilding the raid in case of an error is much faster with RAID10. If you want to know more read http://www.pcguide.com/ref/hdd/perf/raid/levels/multXY-c.html Concl.: RAID 10 is a good choice! Thanks. Also I was thinking, to use one RAID 1 for the virtualisation-system and the other six harddisks for the virtual servers. It's not fully clear to me what you mean with virtual MySQL-Servers. I'll install Citrix Xen Server and than two or more virtual Redhat EL / Centos/ Servers on one SUN Fire server. (Next year I'll get some more physical servers for clustering/failover/loadbalance) So I'll use two disks for the xen server software and one raid 10 for the virtual machines. HTH! It did. Thanks. /Götz -- Götz Reinicke IT-Koordinator Tel. +49 7141 969 420 Fax +49 7141 969 55 420 E-Mail goetz.reini...@filmakademie.de Filmakademie Baden-Württemberg GmbH Akademiehof 10 71638 Ludwigsburg www.filmakademie.de Eintragung Amtsgericht Stuttgart HRB 205016 Vorsitzende des Aufsichtsrats: Prof. Dr. Claudia Hübner Staatsrätin für Demographischen Wandel und für Senioren im Staatsministerium Geschäftsführer: Prof. Thomas Schadt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org