MySQL Enterprise Server With InnoDB For Mission-critical Data?
However recently the company I work for has the requirement to upgrade their database system. The data here really is mission-critical and we can't afford to loose any of it, and we need 24-7 uptime, with good performance (we have lots of clients so there'll be heavy load), any downtime will cost us.
What I'd like to hear is peoples own experiences with MySQL Enterprise, good or bad, and if it's up to the job.
Looking around the net I've seen lots of supposed expert DBAs saying that there's no argument; you should go with one of the "big 3", these being DB2, Oracle or MSSQL. However I get the feeling Oracle and DB2 would be a massive task to configure, and MSSQL - well it runs on Windows, we can't have any downtime no matter how good people say it is these days.
So my idea was; InnoDB on 3 servers - a master and 2 replication slaves, with one slave off-site down a 10Mb line (wide enough pipe?). We use the on-site slave to run our daily backups, and point our reporting web sites at it too. the off site is for worst-case scenario disaster recovery.
How much would we be better off spending more £ on one of the "big 3"? Would our data be safer on these? Would we get better performance with these? Is there a better model I could use for the MySQL setup?
View Complete Forum Thread with Replies
Related Forum Messages:
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
Integrating Mysql, @mail, And Suse Linux Enterprise Server 9
I have recently received a admin job at a small web hosting company (small) and the current platform is windows and I will be responsible for creating a linux based platform and eventually moving all information over to linux form the windows setup. The idea is like this run Suse Linux Enterprise Server 9 using 2 web server running apache, 2 email servers using @mail, and having 2 front end servers with 4 storage nodes clustered. This company also has some custom database query programs to retrieve information. I might be in a tad over my head at this point, but that is ok there isnt an immediate rush on integration. I am looking for any other admins that might be able to offer any opions regarding this basic setup or that might have this setup and offer any suggestions concerning the actual construction of this type of platform.
View Replies !
Foreign Keys Without Using InnoDB? (Server Disabled InnoDB - Any Way To Link Tables?)
I guess this is a two-part question: 1) Is there any way to use foreign keys (and enforce them) without storing them in InnoDB? My hosted server vendor has disabled InnoDB access across the board because it requires remote access (not quite sure I understand the why) and they only want people to edit through their online GUI.... 2) If there's absolutely no way to link tables without using InnoDB, would anyone recommend a good hosting service that allows it? Tech support for readyhosting said there's no way any shared server service is going to allow this, but since it's a HUGE part of the functionality of relational databases,
View Replies !
Configuring MYSQL Enterprise Monitor
I was given the setup files for configuring the MYSQL Enterprise Monitor with dashboard for testing in Local. 1. I have installed MYSQL Server to my localhost [Windows]. MYSQL SERVER Version: 5.0.50sp1a-enterprise-gpl-nt. 2. I have installed the MYSQL Network Monitor to my local system [Windows] With all options like admin login, agent and other details. But my doubt is how to set my MYSQL DB Server for regular monitoring using the MYSQL Enterprise Monitor. I.e I just want to know about the Server setting like how to add my localhost server to the Mysql Enterprise Monitor. We have a Enterprise Subscription but as iam just a developer i dont have the login id so can i get help from here?
View Replies !
MySQL View Points From Enterprise DBAs
One of our companies clients has asked us about redoing one of their highly profitable web applications in PHP and MySQL (The had an outside consultant recommend it). Their current application is built in C#.NET and SQL and is not currently clustered or load-balanced. They want to rebuild it as they have learned a lot about what they want since the original design and they know they need to make significant changes to the application to get the new features they are after and also address functionality that their current customers don't like. The company contacted the original .NET author (who also happens to be an experienced Microsoft SQL DBA) to see about redoing the applciation in PHP and MySQL and the author panned MySQL and stated that their own company had attempted to migrate one of their applications to MySQL and that from his perspectives there were many things that causes A GREAT DEAL of extra DBA overhead. I was hoping that more experienced DBAs using MySQL would be able to confirm or deny some of the Microsoft SQL DBAs claims - I have never worked with anything except MySQL and I have not used it for very long or even very often, so I am unable to successfully evaluate the claims. By no means do I want to get into 'down with Microsoft' thread here. Here are his claims:You can not centralize stored procedures for multiple databases. If you do you have to open up a whole lot of permissions that expose the system too much?The use of stored procedures and triggers is really complicated and you have to get down to a very low level of coding to understand, create or edit them, which makes the DBA's job harder and even once experienced more time-consuming?It lacks quite a few advanced features that Microsoft SQL has (he didn't cite which ones)?The upgrade path (of MySQL) is not standardizes so features that worked in version x are not guaranteed to work in version x.5 or y?There is no standardized way to backup and restore the databases and between the different methods there is a lack of compatibility. This means that backing up a MySQL database in one way - say for example MySQLdump and trying to restore it using phpMyAdmin or the MySQL administrator will not work.For those of you that have worked with different Databases do you think that MySQL is as easy to administrate and update as other Databases and even more specifically Microsoft SQL?
View Replies !
CRITICAL: Mysqldump
I am using version 4.1.10a and noticed a really big problem. When I encryped sensitive data using AES_ENCRYPT and then performed a routine mysqldump for backup purposes, the resulting dump file does not preserve many of the encrypted characters properly. AES_ENCRYPT is unusable if system admins cannot back up their tables reliably.
View Replies !
I Have Some Critical Problem About .myd, .myi
My database usually generate many #SQL_xxx_xxx.myd and .myi everyday on random time. But sometime after they are created ,they will disappear in few second. Sometime they are permanent store in my disk (/MY_DATA) I have many SELECT *,dayofmonth(xxx) ... I mostly use INNODB in my database, How does they create .myd , .myi?
View Replies !
Critical Error
I want to install phpbb forums but i need a database so , i install mysql and now when i try to install phpbb this is the error i get Warning: mysql_connect(): Access denied for user 'localhost'@'localhost' (using password: YES) in c:program filesapache groupapachehtdocsforumdbmysql4.php on line 48 Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in c:program filesapache groupapachehtdocsforumdbmysql4.php on line 330 Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in c:program filesapache groupapachehtdocsforumdbmysql4.php on line 331 phpBB : Critical Error
View Replies !
A Very Critical Problem
In one of my projects, we have two servers, say A and B. Now server B will be a replica of server A. If at any point of time server A goes down at that moment server B will be up. We have to provide a solution so that whenever server A goes down, automatically server A will be up. So at any point of time our site will be not down. To do this whenever we perform a database (mysql) operation in server A, we need to do the same thing in server B also. That means we have to perform inter server database communication. We have already made our site in server A. It's now only that the client has told us about the concept of server B. Can any one give some light how to manage this situation. FYI we are using php5, mysql5 and linux operating system.
View Replies !
MySQL Client Crashes With Segmentation Fault On Red Hat Linux Enterprise IA64
I have an IA64 Red Hat Linux Enterprise Edition system and I tried to install the binaries recommended on MySQL. However, when I run the mysql client, I get simply: Segmentation fault. So I tried to do a basic source compile, which went fine, but when I run mysql client, I get this: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 to server version: 4.1.12 Segmentation fault When I try the flags recommended by MySQL (--with-extra-charsets=complex among others), the make test fails on ucs_binlog - something to do with charsets I believe? The mysql user, group etc. are all set up. Strangely, the mysql client works in batch mode so if you make a file that reads: SHOW DATABASES; Then type: mysql < commandfile It'll display Database mysql test Without any faults.... Anyone any ideas or suggestions?
View Replies !
Split Innodb Data File Into Smaller Data Files
we configured innodb configuration with default my.ini settings. now data file is increased more than 40 GB.After that we come to know that we need keep the settings like below #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend so that it will keep on creating 2GB data files. Now how we can change the settings and splitting the data file of 40 gb please.
View Replies !
Innodb And Server Date
I have an innodb database running a week now. I have noticed that the time of my linux server is not the correct (about 9 minutes ahead). I was wondering if by synchronizing my server's clock with an ntp, I would confuse any innodb logs, because the correct time would be set 9 minutes earlier from the current incorrect time.
View Replies !
MySQL Enterprise And MySQL Monitor
I'm trying to figure out the actual benefits of the MySQL Enterprise subscription service, which includes MySQL Monitor, a so-called "Virtual DBA Assistant". Has anyone used any of the four service levels of the MySQL Enterprise subscription service? The MySQL site has a lot of glossy marketing info and happy testimonials, but I'm still trying to determine if it makes sense for a small business (i.e., not a mega corporation) to invest anywhere from $695 to $4,9995 for the service. Has anyone used MySQL Monitor? Does it live up to the claim of being a "Virtual DBA Assistant"?
View Replies !
InnoDB & Multiple Mysqld's On 1 Server
i've been weighing the pros and cons of running multiple concurrent mysqld's on one server, to have better control over what databases are on what physical disks. System: 4 processor sun box running solaris with eighteen 36Gb drives. The situation is that i have a bunch of databases on one server that can all be classified as either external use or internal use. The internal use databases are consistently hit pretty hard, and we want this to have minimal impact on the external use databases. Currently we're using 64 index MyISAM tables, and with carefully choosing mount points for various physical devices, we have the databases separated as we want them. It is my understanding that with InnoDB, all tables are put into the configured InnoDB file(s) together, which would violate what i am trying to accomplish. The only solution i have come up with to control the physical location of InnoDB databases is to run multiple mysqld servers, each one with its InnoDB files on the desired device. Has anyone experienced any success or failure with this sort of configuration?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
View Replies !
MyISAM On Master And InnoDB On Slave Server
Is this possible to have a MyISAM table on master server and change its storage engine (to InnoDB) on slave server in a replication environment? If this is possible, what should I consider before changing MyISAM to InnoDB on slave server? Here is the table structure:
View Replies !
InnoDB: Right For Write-heavy Table? Server Tuning?
I've decided to merge 4500 identical tables into one. They were previously partitioned with one table per user of the system, but I'm imagining I may not need to do this anymore for this particular table. I'd like to do so to reduce the number of files in this database's directory (currently over 15,000), to reduce backup complexity, and maybe improve performance. That's where I'm still unsure. This is the summary table for W3Counter with fields website_id, date, unique_visits, return_visits, page_views. The website_id and date uniquely identify each row. It is a write-heavy table (probably more than 99% INSERT/UPDATE compared to SELECT). I may be making things up, but I believe I remember InnoDB showing superior performance for this type of table. I'd imagine row-level locking would decrease lock contention when being hit by dozens of threads concurrently -- queries trying to update different rows would be allowed since that row isn't locked, unlike MyISAM where the entire table is locked by each query. Merging all the tables into this one would mean starting with about 1.5 million rows and growing about 4500 per day. So what do you think? Is InnoDB the right way to go for this table? Should I expect better performance than MyISAM for the inserts/updates? Should I expect the same or better performance on SELECTs that SUM() those counts over various date ranges, and sometimes group by WEEK(), MONTH() or YEAR() on the date column? I'm not sure whether the primary key is sufficient for that type of query, if a key on just the website_id would help those, or what. Any opinions? My other reason for this thread is to get some pointers on tuning the server variables for InnoDB tables. There's much less written about this than those mainly applicable to MyISAM tables. Which are most important for a table like this? Right now no other tables will be InnoDB as the rest benefit greatly from MyISAM-specific features (like prefix compression on indexes and maintenance of row counts).
View Replies !
ERR: Data (not Date) From SQL Server To MySQL
How do I get data from my tables in SQL Server into my tables in mySQL. I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center).
View Replies !
I Want To Make Transfer Data Between MySQL Server To MySQL Local .
I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux ) ::::: Apache .. ::::: Linux PC Client = ::::: Window ::::: MySQL run localhost ( for window ) How i transfer data from mysql server to mysql local .? Caz i don't want to connect via 3306 port .. Can i use others way?
View Replies !
Merging Data On Remote MySql Server
I've been tasked with installing the table structure from the master database onto a remote MySQL server. The remote server will accept data and periodically, merge/dump the data to the master server. I need help with the merge/dump issue. This doesn't sound like a replication (where two database servers are made to look identical) issue but 'merge' doesn't soud right either.
View Replies !
Retrieving Data From Non-MySQL Server Via ODBC
I'm investigating using MySQL instead of the dreaded Access to retrieve logged information from a process control system. Is there a way to use ODBC to get rows INTO MySQL? All I can find in the manual is how to set up MySQL as an ODBC server for other applications. The control system is configured as an ODBC server, and Access will connect to it, but hangs and dies when I try to retrieve data.
View Replies !
Accessing Data On An SQL-Server By Using MySQL-Select
is it possible to access data located in a SQL-Server-Database by using a MySQL SELECT-Statement? I know that on an I can use a qurey like the following SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:Financeaccount.xls";User ID=Admin;Password=;Extended properties=Excel 5.0') on an MS-SQL-Server and search for something similar in MySQL.
View Replies !
Transforming Sql Server Data Base To Mysql One ..
I have an sql server Database Backup , I got it from My client who wants to rebuild his site with php-mysql . What i want to do is to transform the sql server backup to MYsql one without losing any data .. I want to do this without Loading the sql server on my PC ... i tried many tools but it requires a pre-installed version of sql server to connect to .. I have the sql server bckup file with the name website.bak
View Replies !
Enterprise Manager
I'm looking for a GUI manager tool like MSSQL Enterprise Manager for MySQL (free, if possible). I'm using XP. I'm especially interested in a GUI for creating views in which I can graphically manage INNER and OUTER join between objects Does anyone know a tool like the one I just described in my dream
View Replies !
Restore InnoDB Data
In my Mysql database there is sometihng that doesn't work. With MySQLFront I have all my InnoDB tables with this comment: "Can't open file: 'certificatetype.InnnoDB'. (errno: 1)" and in my loog files I read: 031215 15:33:53 InnoDB error: Cannot find table test/certificatetype from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database?
View Replies !
InnoDB Data Recovery
I was running a MySQL instance with 800MB of data consisting of both InnoDB and MyISAM tables in multiple databases. This evening the server crashed. I have the data files, ibdata and ib_logfile. When i try to recover the data i get the following message. C:Program FilesMySQLMySQL Server 5.0in>mysqld-nt --defaults-file=..my.ini --standalone --console --innodb_force_recovery=3 080626 6:13:46 InnoDB: Error: page 1 log sequence number 0 862485692 InnoDB: is in the future! Current system log sequence number 0 862458387. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: for more information. 080626 6:13:46 InnoDB: Error: page 2 log sequence number 0 862512184 InnoDB: is in the future! Current system log sequence number 0 862458387. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: for more information. 080626 6:13:46 InnoDB: Error: page 6 log sequence number 0 862514392 InnoDB: is in the future! Current system log sequence number 0 862458387. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: for more information. 080626 6:13:46 InnoDB: Error: page 5805 log sequence number 0 862514392 InnoDB: is in the future! Current system log sequence number 0 862458387. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: for more information. 080626 6:13:46 InnoDB: Error: page 5804 log sequence number 0 862514314 InnoDB: is in the future! Current system log sequence number 0 862458387. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: for more information. 080626 6:13:46 InnoDB: Error: page 8 log sequence number 0 862512291 InnoDB: is in the future! Current system log sequence number 0 862458387. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html InnoDB: for more information......
View Replies !
Recover InnoDB Data
I'm running a fudforum and originally had MySQL setup to create InnoDB tables by default. I somehow got the idea that I should have the tables default to MyISAM so I changed my.ini to do that. I then ran an update on my fudforum. The update apparently recreated most of the tables. So now the tables are MyISAM where before they were InnoDB. Now they are also devoid of data! It appears as though the IBdata1 file still exists in the MySQL InnoDB Datafiles directory. I don't know if that's relevant or not. Is there ANYTHING I can do to get that data back into my tables? I tried changing a couple back to InnoDB but that didn't seem to help.
View Replies !
Copy/move Mysql Data From Local Machine To Remote Server Database
I have an website that is host on web server and here have a database that have only one table name is "user" Table fields are: name Id no email phone And I am using same site in my local machine. I always use my local machine for data entry and everyday end of the day I want to transfer data by clicking one button from my local machine database table to my remote server website database table. How can I transfer data from my local machine database table to my remote server website database table.
View Replies !
InnoDB Data File Is Growing
My ibdata1 file is growing. Do I need to worry about that ? I am guessing it will automatically delete old data to fit the size, correct ? Also how do I limit the growth size. I tried to put max:2000M , but since my Innodb is crashing and can't restart mysql I removed the whole my.cnf file all together to fix the crash. So now I am not sure how I can prevent the growth of InnoDB. Code: ....
View Replies !
Cannot Browse Data In InnoDB Tables
At present, I am using MySQL version 5.0.20 which I update via my spring application. Inside my configuration file I recently changed from: <property name="dialect">org.hibernate.dialect.MySQLMyISAMDialect</property> to <property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>. I did this because I wanted my transactions to rollback if they were not commited properly. However the problem I am now having is that I cant view the data inside my InnoDB tables (via my phpMyAdmin page). Whenever I click on the 'browse' button I get the following message: "MySQL returned an empty result set". However, I know data is inside the tables because the 'browse' button is not dissabled. If there is no data in the tables the button become dissabled.
View Replies !
Community To Enterprise Upgrade Path
We are a start-up business which has decided to use MySQL Community version but as we grow we dread the thought of redoing everything when we are ready for the Enterprise version. Is/will there be a utility/program that will simplify this process?
View Replies !
Deleted InnoDB Data Files, How Can I Recover Them?
I was meddling with InnoDB configuration and since MySQL was complaining about the new settings because it needed to create new "ibdata" files, I deleted them thinking it would grab the existing database and add the tables on it. Now my DB is corrupted and, while I can see it exists (using phpMyAdmin), there seems to be no tables in it. What can I do? Do I have to re-create my DB manually?
View Replies !
Data From SQL Server
How do I get data from my tables in SQL Server into my tables in mySQL I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center)
View Replies !
Data From 1 Server To Another
i have 2 databases -- one a replica of the other. but they're on different servers. how's that for a twist?what i want to do is copy data from one table to another. how do i go about doing that when they're on different servers?
View Replies !
Data From Other Server
ther are two PC: PC1 and PC2 both have Mysql DB i want to select data from PC2 DB and insert to PC1 DB. how to write the command and any syntax??
View Replies !
Lost Connection To MySQL Server During Query (LAMP Server)
I recently installed an ubuntu LAMP server for my website and upon trying a script that uses a mysql database (which I set up the tables via phpmyadmin) and I get this error: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/tanner/Desktop/bot/DoctorWho/db_connect.php on line 4 I've searched the forums and I've gotten no answers. Anyone know the answer?
View Replies !
Copying Data To Server?
i have some database elsewhere than the server, and i'd like to use this db on the mysql system, but can i just copy some mysql databases to the server's data folder? (do i have to "create database..."?)
View Replies !
|
TRACKER
